Trigger Firing sequence:This is most important thing to understand in Oracle D2K Forms When you open a form following triggers are executed
First Logon Triggers are fired:1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON
After that Pre Triggers:4. PRE-FORM
5. PRE-BLOCK
6. PRE-TEXT
After that WHEN-NEW Triggers:
7. WHEN-NEW-FORM-INSTANCE
8. WHEN-NEW-BLOCK-INSTANCE
9. WHEN-NEW-ITEM-INSTANCE
After that ITEM Level Triggers:After this focus is on the first item of the Block. If you type some data and press the tab key following trigger will fire in sequence
10.KEY-NEXT-ITEM (This trigger is present on the item level).
11.POST-CHANGE (This trigger is present on the item level).
12.WHEN-VALIDATE-ITEM (This trigger is present on the item level).
13.POST-TEXT-ITEM (This trigger is present on the item level).
14.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).
Now focus will go the next item present on the form.
If there are no further items present on the screen them if we enter data and press tab key then only KEY-NEXT-ITEM is fired. Now suppose we close the form then the item level triggers are fired.
POST TRIGGERS :
15.POST-BLOCK
16.POST-FORM
Thanks
Amar Alam
First Logon Triggers are fired:1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON
After that Pre Triggers:4. PRE-FORM
5. PRE-BLOCK
6. PRE-TEXT
After that WHEN-NEW Triggers:
7. WHEN-NEW-FORM-INSTANCE
8. WHEN-NEW-BLOCK-INSTANCE
9. WHEN-NEW-ITEM-INSTANCE
After that ITEM Level Triggers:After this focus is on the first item of the Block. If you type some data and press the tab key following trigger will fire in sequence
10.KEY-NEXT-ITEM (This trigger is present on the item level).
11.POST-CHANGE (This trigger is present on the item level).
12.WHEN-VALIDATE-ITEM (This trigger is present on the item level).
13.POST-TEXT-ITEM (This trigger is present on the item level).
14.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).
Now focus will go the next item present on the form.
If there are no further items present on the screen them if we enter data and press tab key then only KEY-NEXT-ITEM is fired. Now suppose we close the form then the item level triggers are fired.
POST TRIGGERS :
15.POST-BLOCK
16.POST-FORM
Thanks
Amar Alam
5 comments:
I have read your blog and i got a very useful and knowledgeable information from your blog.
Oracle fusion procurement training
Really Good blog post about trigger firing sequence.provided a helpful information.I hope that you will post more updates like this.
Digital marketing company in Chennai
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.
i really like this blog.And i got more information's from this blog.thanks for sharing!!!!
SEO Company in Chennai
SEO makes a good effect on business and help businessman to grow their business. It helps in making traffic in seo field.
Online Marketing Services
Best SEO Services in Bangalore
affordable seo packages in india
Post a Comment