Skip to main content

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);

Comments

  1. UnknownJanuary 5, 2021 at 5:59 PM

    APP_SPECIAL.ENABLE('EDIT.DELETE', PROPERTY_OFF); is not working

    ReplyDelete

Post a Comment

Popular posts from this blog

Xdoxslt XML Publisher RTF Important Syntax’s     1.        To convert CASE of a tag to UPPER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     2.        To convert CASE of a tag to LOWER case      xdoxslt:convert_case(.//MATERIALTYPE,'UPPER')     3.        Syntax for CONTAIN      contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT MEMO’)     4.        Syntax for NOT CONTAIN      not(contains(xdoxslt:convert_case(.//REFERENCE_ID,'UPPER'),'WSC'))     5.        CHOOSE-WHEN-OTHERWISE Syntax     <?choose:?><?when: contains(xdoxslt:convert_case(.//MATERIALTYPE,'UPPER'),’IC CREDIT       MEMO’)?><?’Interco Credit Memo’?><?end when?><?otherwis...
Post a Comment
Read more

Oracle Forms - How to Enable Folder Functionality in Custom Forms

How to Enable Folder Functionality in Custom Forms   Follow following steps to enable Folder Functionality in Custom Form or if you want to export column heading in export file along with data: Attach APPFLDR Library APPFLDR can be found in $AU_TOP/Res/Plsql directory on server where forms are residing. Reference STANDARD_FOLDER Object Groups STANDARD_FOLDER Object group can be referenced from APPSTAND form which resides in $AU_TOP/Res/US. This will also copies the dependent objects required for object group. Create <BLOCKNAME>_RECORD_COUNT parameter Create <BLOCKNAME>_RECORD_COUNT parameter where BLOCKNAME is the name of the block containing columns to be displayed. Data Type should be Number and Put default Value of 2. Canvas You need two canvas- one content and one stacked. Let us name content canvas as PROJECT_FOLDER and stacked canvas as PROJECT_STACK. Both the canvas have same window. Windows Create One Window. Name it PROJECT_FOLDER with view name ...
Post a Comment
Read more