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

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

We are going to create a program unit within the form to write code that will handle various tasks within the form. We will be performing the following in the coming recipe:
Creating a new package to handle database transactions
Adding triggers to capture transactional events on a block
Creating triggers to set the WHO columns
We are now going to create a package to handle the database transaction for the PER_SUBS block. The package name will be PER_SUBS as it will manage the transactions for the PER_SUBS block.
To create the package specification, perform the following steps:
1. In Forms Developer navigate to Program Units.
2. Click the + on the left-hand toolbar to create a new package specification.
3. In the Name field type PER_SUBS.
4. Select Package Spec as shown in the following screenshot and click OK:
5. In the PL/SQL Editor we need to add four procedures as follows:
6. Compile the package specification...
Change the font size
Change margin width
Change background colour