Oracle E-Business Suite R12 Core Development and Extension Cookbook

Adding insert, update, and delete events

Now that we have created the forms objects, it is time to start adding some code. We need to add code to perform inserts, updates, and deletes. As we have based the form on views, we need to trigger the events and then we need to write code to call database procedures to transact data. There are four triggers we need to create on each block where we need to perform transactions. In this example, the only block where we want to do any transactions is the PER_SOCIETIES block. When we insert data, we will also need to increment a sequence number for the SOCIETY_ID column. We will need to perform the following tasks to trigger and code database transactions within our form:

• Creating a program unit package specification ...