- Register the Table
- Register the DFF
- Define the Segments
- Normal Form Development
- Change the properties of Attribute1,2,3.. columns Visible to No
- Change the properties of Attribute_Category,
- Sub Class to TEXT_ITEM_DESC_FLEX
- LOV to ENABLE_LIST_LAMP
- Validate from List to No
- Database Item to No
- In Program Unit create Package Spec and Body
- Package Spec:
- procedure xxdff_proc(event varchar2);
- Package Body:
- procedure xxdff_proc(event varchar2)
begin
if event = 'WHEN-NEW-FORM-INSTANCE' then
FND_DESCR_FLEX.DEFINE(BLOCK => 'XXDFF,
FIELD => 'Attribute_category',
appl_short_name=>'FND',
DESC_FLEX_NAME='XXDFF');
end if;
end;
- Triggers,
- WHEN-NEW-FORM-INSTANCE
- PACKAGE_NAME.XXDFF_PROC('WHEN-NEW-FORM-INSTANCE');
- WHEN-NEW-ITEM-INSTANCE
- FND_FLEX.EVENT('WHEN-NEW-ITEM-INSTANCE');
No comments:
Post a Comment