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 ...

Get Oracle E-Business Suite R12 Core Development and Extension Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.