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

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

Now we need to add some triggers to manage the Descriptive Flexfield. We are going to call the standard package to define the Descriptive Flexfield when a user enters the form. We are also going to add a WHEN-NEW-ITEM-INSTANCE trigger on the DESC_FLEX item to automatically pop up the DFF when a user navigates to the item. We will perform the following tasks:
Adding a WHEN-NEW-FORM-INSTANCE event
Adding a WHEN-NEW-ITEM-INSTANCE event
Testing the form
Before we add the code to the WHEN-NEW-FORM-INSTANCE trigger we will write the code in the PER_SOCIETIES package to define the Descriptive Flexfield and then call the procedure from the trigger.
To add a WHEN-NEW-FORMS-INSTANCE trigger, perform the following steps:
1. In Forms Developer navigate to Program Units | PER_SOCIETIES | Package Spec.
2. Add a new procedure by adding the following code:
PROCEDURE DESC_FLEX(event VARCHAR2);
3. Now open the PER_SOCIETIES...
Change the font size
Change margin width
Change background colour