Firing Sequence Of Form triggers

Introduction
This document lists the order in which triggers fire in Oracle Forms 4.5:

• The first column, Action, describes the function to be performed (e.g. deleting a record).
• The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed.
• 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.

Runform	Pre-Logon	Form
	On-Logon	Form
	Post-Logon	Form
	Pre-Form	Form
	When-Create-Record	Block
	Pre-Block	Block
	Pre-Record	Block
	Pre-Text-Item	Item
	When-New-Form-Instance	Form
	When-New-Block-Instance	Block
	When-New-Record-Instance	Block
	When-New-Item-Instance	Item
Enter Query	Post-Text-Item	Item
	Post-Record	Block
	When-Clear-Block	Block
	When-New-Record-Instance	Block
	When-New-Item-Instance	Item
Execute Query After Enter Query	Pre-Query	Block
	Pre-Select	Block
	On-Select	Block
	When-Clear-Block	Block
	Post-Select	Block
	On-Fetch	Block
	On-Close	Form
	When-Clear-Block	Block
Execute Query Without Enter Query	Post-Text-Item	Block
	Pre-Query	Block
	Pre-Select	Block
	On-Select	Block
	Post-Select	Block
	On-Fetch	Block
	On-Close	Form
	When_Create_Record	Block
	Pre-Record	Block
	Pre-Text-Item	Item
	When-New-Record-Instance	Block
	When-New-Item-Instance	Item
Exit	Post-Text-Item	Item
	Post-Record	Block
	Post-Block	Block
	Post-Form	Form
	On-Rollback	Form
	Pre-Logout	Form
	On-Logout	Form
	Post-Logout	Form
Next Block and Previous Block	Post-Text-Item	Item
	Post-Record	Block
	Post-Block	Block
	When-Create-Record	Block
	Pre-Block	Block
	Pre-Record	Block
	Pre-Text-Item	Block
	When-New-Block-Instance	Block
	When-New-Record-Instance	Block
	When-New-Item-Instance	Form
Create Record	Post-Change	Block
	When-Validate-Item	Block
	Post-Text-Item	Block
	When-Validate-Record	Block
	Post-Record	Block
	Post-Block	Block
	On-Savepoint	Form
	Pre-Commit	Form
	Pre-Insert	Block
	On-Insert	Form
	Post-Insert	Block
	Post-Forms-Commit	Form
	On-Commit	Form
	Post-Database-Commit	Form
	Pre-Block	Block
	Pre-Record	Block
	Pre-Text-Item	Block
	When-New-Item-Instance	Form
Update Record	When-Database-Record	Block
	Post-Change	Block
	When-Validate-Item	Block
	Post-Text-Item	Block
	When-Validate-Record	Block
	Post-Record	Block
	Post-Block	Block
	On-Savepoint	Form
	Pre-Commit	Form
	Pre-Update	Block
	On-Update	Block
	Post-Update	Block
	Post-Forms-Commit	Form
	On-Commit	Form
	Post-Database-Commit	Form
	Pre-Text-Item	Block
	When-New-Item-Instance	Form
Delete Record	On-Lock	Block
	When-Remove-Record	Block
	Post-Change	Block
	Post-Change	Block
	Post-Change	Block
	Post-Change	Block
	Post-Change	Block
	Post-Change	Block
	Post-Change	Item
	Post-Query	Block
	Post-Text-Item	Block
	Post-Record	Block
	Pre-Record	Block
	Pre-Text-Item	Block
	When-New-Record-Instance	Block
	When-New-Item-Instance	Form