Implementing DFF in Form consist of two steps Process. The first steps consist of designing the table structure and registration and step 2 consist of enabling in the form.
Steps 1:
Define DFF fields in the custom tables
ATTRIBUTE1รข€¦ATTRIBUTE15 and ATTRIBUTE_CATEGORY are the normal fields used for DFF
Register the table with Oracle AOL
Register the DFF with Oracle AOL
For this you have to login into application with :
Application Developer -> Flex Field -> Descriptive -> Register
Then you should specify the name of the DFF (Say BTL_AR_DFF) and specify the associated table.
Step 2:
window.google_render_ad();
Create DFF fields in the custom form
1. Create a form based on the custom table
Copy TEMPLATE form has example descriptive flexfield which we can use
Use the TEXT_ITEM_DESC_FLEX property class
Attach ENABLE_LIST_LAMP_LOV for the field
2. Create a non-base table text item in the block with property class TEXT_ITEM_DESC_FLEX3. Make sure that DFF is mapped to fields (ATTRIBUTE) of the table and is enabled.
Next is to call Flexfield Routines to add DFF built-ins in the form to invoke DFF.
This consist of these steps:
1. Write, a form level trigger WHEN-NEW-FORM-INSTANCE to invoke the DFF as
FND_DESCR_FLEX.DEFINE(Block => ‘Name of the DFF block’,Field => ‘BTL_DFF’,Appl_short_name => ‘AR’,Desc_flex_name => ‘BTL_AR_DFF’,Title => ‘BPL AR More Info’ );
2. Write, block level triggers PRE-QUERY and POST-QUERY as
FND_FLEX.EVENT(’PRE-QUERY’);
FND_FLEX.EVENT(’POST-QUERY’);
FND_FLEX.EVENT(’Pre-Query’);
FND_FLEX.EVENT(’When-Validate-Record’);
FND_FLEX.EVENT(’Post-Query’);
FND_FLEX.EVENT(’When-New-Item-Instance’);
FND_FLEX.EVENT(’Pre-Insert’);
FND_FLEX.EVENT(’When-Validate-Item’);
FND_FLEX.EVENT(’Pre-Update ‘);
Sunday, March 1, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment