Custom Form with DFF

  • 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)
                                   IS
                                   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