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: -
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
Hi Dayakar,
ReplyDeleteWhat you’re saying is absolutely correct Navigational Triggers Firing Sequence In Oracle Forms, but this isn’t the exact situation everywhere. Where most smart folk work on a project - why can’t you do this the Boss asks :).
I would much appreciate to get a sample of data travelling via these steps.
Source data to Staging server(tables) then PLSQL for data cleansing and transferring them to tbl_cleanABC or tbl_error_ABC. Checking the accuracy of data and finally PLSQL for loading to data warehouse.
Follow my new blog if you interested in just tag along me in any social media platforms!
Gracias
Irene Hynes
Hello There,
ReplyDeleteI learnt so much in such little time about Navigational Triggers Firing Sequence In Oracle Forms . Even a toddler could become smart reading of your amazing articles.
I have requirement like
select COL1,Col2 from A
minus
Select COL1,COL2 from B;
both tables have 50+ millions record so I want to automate a job which will execute this query for 1millions records for one time and then again 1 millions for second time...like loop and store output in record type.
But nice Article Mate! Great Information! Keep up the good work!
Kind Regards,
Preethi.