COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.

DO_KEY(\'commit_form\') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn\'t exist it does the same as COMMIT_FORM.

Oracle Application Developer Guide says:

Replace COMMIT with do_key(\'commit_form\'), This routine raises the exception FORM_TRIGGER_FAILURE if there is an invalid record.

Sequence of Trigger Fire while Committing

•  KEY-Commit
•  Pre-Commit
•  Pre/On/Post Delete
•  Pre/On/Post Update
•  Pre/On/Post Insert
•  On-Commit
•  Post Database Commit