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