Follow us: Connect on YouTube 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 :

3 comments:

  1. Hi Dayakar,

    What 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

    ReplyDelete
  2. Hello There,

    I 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.

    ReplyDelete
  3. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete