Oracle Form Triggers and their Uses

Trigger Name	Trigger Description
Post-Block	This Trigger Fires during the Leave the Block process.
Post-Delete	This Trigger Fires just after a record is deleted from the database. It tires once for each row that is  deleted from the database during the commit process.
Post-Form	This Trigger Fires when a form is exited.
Post-Forms-Commit	This Trigger fires If there are records in the form that have been marked as inserts, updates, or deletes, the Post-Forms-Commit trigger fires after these changes have been written to the database but before Oracle Forms issues the database Commit to finalize the transaction. If the operator or the application initiates a Commit when there are no records in the form have been marked as inserts, updates, or deletes, Oracle Forms fires the Post-Forms-Commit trigger immediately, without posting changes to the database.
Post-Insert	This Trigger Fires just after a record is inserted into the database. It fires once for each record that is inserted into the database during the commit process.
Post-Query	This Trigger Fires each time Oracle Forms fetches a record into a block.
Post-Record	This Trigger Fires whenever the focus moves from one record to another.
Post-Text-Item	This Trigger Fires when the input focus moves from a text item to any other item.
Post-Update	This Trigger Fires just after a record is updated in the database. It fires once for each row that is updated in the database during the commit process.
Pre-Block	This Trigger Fires during navigation from one block to another.
Pre-Commit	This Trigger Fires after Oracle Forms determines that there are inserts, updates, or deletes in the form to post or commit. The trigger does not fire when there is an attempt to commit, but validation determines that there are no changed records in the form.
Pre-Delete	This Trigger Fires just before a record is deleted from the database. It fires once for each record that is marked for delete. Note: Oracle Forms creates a Pre-Delete trigger automatically for any master-detail relation that has the Master Deletes property set to Cascading.
Pre-Form	This Trigger Fires at form startup.
Pre-Insert	This Trigger Fires just before a record is inserted into the database. It fires once for each record that is marked for insert.
Pre-Query	This Trigger Fires just before Oracle Forms constructs and issues the SELECT statement to identify rows that match the query criteria.
Pre-Record	This Trigger Fires during navigation to a different record.
Pre-Text-Item	This Trigger Fires during navigation from an item to a text item.
Pre-Update	This Trigger Fires just before a record is updated in the database. It fires once for each record that is marked for update.
When-Button-Pressed	This Trigger Fires when an operator selects a button, either by way of a key, or by clicking with a mouse.
When-Checkbox-Changed	This Trigger Fires whenever an operator changes the state of a check box, either by clicking with the mouse, or through keyboard interaction.
When-Clear-Block	This Trigger Fires just before Oracle Forms clears the data from the current block. Note that the When-Clear-Block trigger does not fire when Oracle Forms clears the current block during the CLEAR_FORM event.
When-Create-Record	This Trigger Fires whenever Oracle Forms creates a new record.
When-List-Activated	This Trigger Fires when an operator double-clicks on an element in a list item that is displayed as a T-list.
When-List-Changed	This Trigger Fires when an operator selects a different element in a list item or de-selects the currently selected element. In addition, if a When-List-Changed trigger is attached to a combo box style list item, it fires each time the operator enters or modifies entered text.
When-New-Block-Instance	This Trigger Fires after navigation to an item, when Oracle Forms is ready to accept input in a block that is different than the block that previously had input focus.
When-New-Form-Instance	This Trigger Fires at form start-up. This trigger does not fire when control returns to a calling form from a called form. In a multiple-form application, this trigger does not fire when focus changes from one form to another.
When-New-Item-Instance	This Trigger Fires when the input focus moves to an item.
When-New-Record-Instance	This Trigger Fires when the input focus moves to an item in a record that is different than the record that previously had input focus.
When-Radio-Changed	This Trigger Fires when an operator selects a different radio button in a radio group, or de-selects the currently selected radio button, either by clicking with the mouse, or by way of keyboard selection commands.
When-Remove-Record	This Trigger Fires whenever the operator or the application clears or deletes a record.
When-Validate-Item	This Trigger Fires as the last part of item validation for items with the New or Changed validation status.
When-Validate-Record	This Trigger Fires Fires as the last part of record validation for records with the New or Changed validation status.
When-Window-Closed	This Trigger Fires Fires when an operator closes a window using a window-manager specific Close command.