Trigger Execution Sequence in Oracle Forms

Introduction

This document lists the order in which triggers fire in Oracle Forms 4.5:
 o  The first column, Action, describes the function to be performed
    (e.g. deleting a record).
 o  The second column, Trigger Firing Order, describes the order
    in which triggers fire after a function is performed.
 o  The third column, Level, describes the level (form, block, item)
    at which the trigger fires.  This was accomplished by creating a form
    with all the triggers invoked.  If a trigger could fire at all levels,
    it was included at all levels.  Such a trigger fires at the lowest level
    at which it is defined.

Key triggers and triggers which fire via buttons or check boxes are
not included.

This bulletin does not cover every contingency and covers only the
most commonly used actions.

Action                 Trigger Firing Order                    Level
------                 --------------------                    -----
Runform                 1.  Pre-Logon                          Form
                        2.  On-Logon                           Form
                        3.  Post-Logon                         Form
                        4.  Pre-Form                           Form
                        5.  When-Create-Record                 Block
                        6.  Pre-Block                          Block
                        7.  Pre-Record                         Block
                        8.  Pre-Text-Item                      Item
                        9.  When-New-Form-Instance             Form
                        10. When-New-Block-Instance            Block
                        11. When-New-Record-Instance           Block
                        12. When-New-Item-Instance             Item

***********
Enter Query             1.  Post-Text-Item                     Item
                        2.  Post-Record                        Block