1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Forms Triggers On Different Levels

Discussion in 'Other Development Tools' started by sabyasachi, Oct 12, 2009.

  1. sabyasachi

    sabyasachi Active Member

    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    65
    Block Processing Triggers:

    When-Create-Record: Perform an action whenever Form Builder attempts to create a new record in a block. For example, to set complex, calculated, or data-driven default values that must be specified at runtime, rather than design time.

    When-Clear-Block: Perform an action whenever Form Builder flushes the current block; that is, removes all records from the block.

    When-Database-Record: Perform an action whenever Form Builder changes a record's status to Insert or Update, thus indicating that the record should be processed by the next COMMIT_FORM operation

    When-Remove-Record : Perform an action whenever a record is cleared or deleted. For example, to adjust a running total that is being calculated for all of the records displayed in a block.

    When-New-Block-Instance: Perform an action immediately after the input focus moves to an item in a block other than the block that previously had input focus.

    When-New-Record-Instance :Perform an action immediately after the input focus moves to an item in a different record. If the new record is in a different block, fires after the When-New-Block-Instance trigger, but before the When-New-Item-Instance trigger.

    When-New-Item-Instance: Perform an action immediately after the input focus moves to a different item. If the new item is in a different block, fires after the When-New-Block-Instance trigger.

    On-Delete: Replace the default Form Builder processing for handling deleted records during transaction posting.

    On-Insert : Replace the default Form Builder processing for handling inserted records during transaction posting.

    On-Lock: Replace the default Form Builder processing for locking rows in the database.

    On-Logon: Replace the default Form Builder processing for connecting to ORACLE, especially for a form that does not require a database connection or for connecting to a non-ORACLE data source.

    On-Logout: Replace the default Form Builder processing for logout from ORACLE.

    On-Update: Replace the default Form Builder processing for handling updated records during transaction posting.

    Post-Database-Commit: Augment default Form Builder processing following a database commit.

    Post-Delete: Audit transactions following the deletion of a row from the database.

    Post-Forms-Commit: Augment the default Form Builder commit statement prior to committing a transaction.

    Post-Insert Audit transactions following the insertion of a row in the database.

    Post-Update Audit: transactions following the updating of a row in the database.

    Pre-Commit: Perform an action immediately before the Post and Commit Transactions process, when Form Builder determines that there are changes in the form to post or to commit.

    Pre-Delete: Manipulate a record prior to its being deleted from the database during the default Post and Commit Transactions process; for example, to prevent deletion of the record if certain conditions exist.

    Pre-Insert: Manipulate a record prior to its being inserted in the database during the default Post and Commit Transactions process.

    Pre-Update:Validate or modify a record prior to its being updated in the database during the default Post and Commit Transactions process.

    Pre-Form: Perform an action just before Form Builder navigates to the form from "outside" the form, such as at form startup.

    Pre-Block :Perform an action before Form Builder navigates to the block level from the form level.

    Pre-Record :Perform an action before Form Builder navigates to the record level from the block level.

    Pre-Text-Item :Perform an action before Form Builder navigates to a text item from the record level.

    Post-Text-Item: Manipulate an item when Form Builder leaves a text item and navigates to the record level.

    Post-Record: Manipulate a record when Form Builder leaves a record and navigates to the block level.

    Post-Block: Manipulate the current record when Form Builder leaves a block and navigates to the form level.

    Post-Form: Perform an action before Form Builder navigates to "outside" the form, such as when exiting the form.

    When-New-Form-Instance: Perform an action at form start-up. (Occurs after the Pre-Form trigger fires).

    When-New-Block-Instance: Perform an action immediately after the input focus moves to an item in a block other than the block that previously had input focus.

    When-New-Record-Instance : Perform an action immediately after the input focus moves to an item in a different record. If the new record is in a different block, fires after the When-New-Block-Instance trigger, but before the When-New-Item-Instance trigger.

    When-New-Item-Instance: Perform an action immediately after the input focus moves to a different item. If the new item is in a different block, fires after the When-New-Block-Instance trigger.

    When-Validate-Item: Augment default validation of an item.

    When-Validate-Record : Augment default validation of a record.