Oracle Forms -- Important Syntaxes

1. To get the enabled property of the item
APP_ITEM_PROPERTY.GET_PROPERTY('CONTROL.FILTER_HOLD_RECORDS',ENABLED)

2. Disable Attachment for this Block in WHEN-NEW-BLOCK-INSTANCE
 APP_SPECIAL.ENABLE('ATTACHMENTS', PROPERTY_OFF);

3. Default Where / Default Order By
Set_block_property('XWII_MATL_DISP_HOLDS_V', Default_where, Lc_query);
Set_block_property('XWII_MATL_DISP_HOLDS_V', order_by, Lc_query);

4. Visual Attribute
   a. Define Visual Attribute for eg 'XWII' where you can set Colour
 b. SET_ITEM_INSTANCE_PROPERTY('block.item_name',CURRENT_RECORD,VISUAL_ATTRIBUTE ,'XWII');

4. Visual Attribute for Record
APP_RECORD.HIGHLIGHT('XWII');
Where 'XWII' is the visual attribute where you can set Colour.

5. Initiliaze SPECIAL Menu
app_special.instantiate ('SPECIAL1', GET_GROUP_CHAR_CELL ('SPECIAL_MENU.SPECIAL_MENU_ITEM', 1), '', TRUE, '');

6. execute_trigger('SPECIAL25');

7. Enable/ Disable Standard Menus
      app_special.ENABLE ('FILE.NEW', property_off);
      app_special.ENABLE ('EDIT.CLEAR', property_off);
      app_special.ENABLE ('EDIT.DUPLICATE', property_off);
      app_special.ENABLE ('EDIT.DELETE', property_off);
8.  Enable/ Disable Custom  Menus
app_special.ENABLE ('SPECIAL1', property_on);