-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle E-Business Suite R12 Core Development and Extension Cookbook
By :

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
Creating a program unit package body
Creating ON-INSERT, ON-UPDATE, ON-DELETE
, and ON-LOCK
triggers
Creating PRE-INSERT
and PRE-UPDATE
triggers to set the WHO columns
We have created a sequence as we need to generate a unique SOCIETY_ID
before...
Change the font size
Change margin width
Change background colour