Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, August 11, 2011

Formas Global and system variables

System Variables

  • FORM_STATUS - Indicates whether the form status is NEW,QUERY or CHANGED
  • BLOCK_STATUS - Indicates whether the block status is NEW,QUERY or CHANGED
  • RECORD_STATUS - Indicates whether the record status is NEW,INSERT,QUERY or CHANGED
  • CURSOR_BLOCK - Returns the name of the block where the cursor is located
  • CURSOR_RECORD - Returns the number of the record where the cursor is located
  • CURSOR_ITEM - Returns the name of the block and item as block.item
  • CURSOR_VALUE - Returns the value of the item where the cursor is located
  • LAST_RECORD - Indicates whether the current record is the last record in a block's list of records.
  • MESSAGE_LEVEL - Assign a value to the SYSTEM.MESSAGE_LEVEL as :System.Message_Level := value;
    The legal values for SYSTEM.MESSAGE_LEVEL are 0, 5, 10, 15, 20,and 25.
  • CURRENT_DATETIME - Represents the operating system date as DD-MON-YYYY HH24:MM:SS

Global Variables

  • A global variable is a Form Builder variable whose value is accessible to triggers and subprograms in any module that is active during the current session.
  • A global variable stores a character string of up to 255 characters in length.Global variables are not formally declared the way PL/SQL local variables are.
  • Initialize a global variable the first time you assign a value to it. :GLOBAL.my_var:= 'Y' ;
  • To destroy a global variable and release its memory, use the ERASE built-in procedure.. Erase('GLOBAL.my_var');

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect