trigger?
An On-insert trigger replaces the default SQL*Forms processing for handling inserted records during transaction posting. It fires once for each row that is marked for insertion into the database. An On-insert Trigger fires during the Post and Commit Transactions event. Specifically it fires after the Pre-insert trigger and before the Post-insert trigger.