Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Friday, 24 February 2017

Navigational Triggers Firing Sequence In Oracle Forms


Navigational triggers: -
These triggers fires when control navigating into the form or out the form, navigating between blocks. Navigating between blocks and navigating between items.

     Triggers firing from top to bottom.

PRE_LOGON - Fires before connecting to database.

ON_LOGON - At the time of connecting data base.

POST_LOGON -  After connecting to data base.

PRE_FORM - Before going to load or appearing the form.

PRE_BLOCK - Before appearing block.

PRE_RECORD - Before appearing record.

PRE_ITEM - Before appearing item.

WHEN_NEW_FORM_INSTANCE -  At the time of appearing form.

WHEN_NEW_BLOCK_INSTANCE -  At the time of appearing block.

WHEN_NEW_RECORD_INSTANCE -  At the time of appearing record.

WHEN_NEW_ITEM_INSTANCE - At the time of appearing item.

KEY_NEXT_ITEM - It fires when pressed tab key.

WHEN_VALIDATE_ITEM - Before leaving item.

WHEN_VALIDATE_RECORD - Before leaving record.

POST_RECORD - After leaving from the record.

POST_BLOCK - After leaving a block.

POST_FORM - After leaving form.

POST_FORM_COMMIT - After leaving from (to save the record).

PRE_LOGOUT -  Fire before disconnecting from data base.

ON_LOGOUT -  At the time disconnecting from data base.

POST_LOGOUT - After disconnecting from data base.

Triggers firing when navigating between blocks: -


Triggers firing when navigating between blocks

1.     KEY_NEXT_ITEM
2.     WHEN_VALIDATE_ITEM
3.     WHEN_VALIDATE_RECORD
4.     POST_RECORD
5.     POST_BLOCK
6.     PRE_BLOCK
7.     PRE_RECORD
8.     PRE_ITEM
9.     WHEN_NEW_BLOCK_INSTANCE
10.  WHEN_NEW_RECORD_INSTANCE
11.   WHEN_NEW_ITEM_INSTANCE

Triggers firing when navigating between RECORDS: -

1.      KEY_NEXT_ITEM
2.     WHEN_VALIDATE_ITEM
3.     WHEN_VALIDATE_RECORD
4.     POST_RECORD
5.     PRE_RECORD
6.     PRE_ITEM
7.     WHEN_NEW_RECORD_INSTANCE
8.     WHEN_NEW_ITEM_INSTANCE


Triggers firing when navigating between FIELDS: -


1.      KEY_NEXT_ITEM
2.     WHEN_VALIDATE_ITEM
3.     PRE_ITEM
4.     WHEN_NEW_ITEM_INSTANCE

Triggers writing at the different levels: -

   Form level

1.     PRE_LOGON
2.     ON_LOGON
3.     POST_LOGON
4.     PRE_FORM
5.     POST_FORM
6.     POST_FORM_COMMIT
7.     PRE_LOGOUT
8.     ON_LOGOUT
9.     POST_LOGOUT

   Block level triggers

1.     PRE_BLOCK
2.     PRE_RECORD
3.     PRE_ITEM
4.     WHEN_NEW_BLOCK_INSTANCE
5.     WHEN_NEW_RECORD_INSTANCE
6.     WHEN_VALIDATE_RECORD
7.     POST_RECORD
8.     POST_BLOCK

   Query triggers

1.     PRE_SELECT
ON_SELECT
POST_SELECT
2.     PRE_INSERT
ON_INSERT
POST_INSERT
3.     PRE_DELETE
ON_DELETE
POST_DELETE
4.     PRE_UPDATE
ON_UPDATE
POST_UPDATE
     Item level triggers

1.     PRE_ITEM
2.     WHEN_NEW_ITEM_INSTANCE
3.     WHN_VALIDATE_ITEM
4.     KEY TRIGGERS
5.     MOUSE TRIGGERS









                                                                                     
Share this article :

0 comments:

Post a Comment