Advertisement
badrulme

WHEN-TAB-PAGE-CHANGED (Forms-Trigger)

Aug 1st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.71 KB | None | 0 0
  1. WHEN-TAB-PAGE-CHANGED
  2. ====================
  3. BEGIN
  4.         :SYSTEM.MESSAGE_LEVEL:=5;
  5.         IF :SYSTEM.TAB_NEW_PAGE = 'PG_CONFIG' THEN
  6.             GO_BLOCK('IN_CONFIG');
  7.             EXECUTE_QUERY;     
  8.         ELSIF :SYSTEM.TAB_NEW_PAGE = 'PG_STYPE' THEN
  9.             GO_BLOCK('IN_STYPE1');
  10.             EXECUTE_QUERY;
  11.  
  12.         ELSIF :SYSTEM.TAB_NEW_PAGE =  'PG_ITEMSUPPLIER' THEN
  13.             GO_BLOCK('IN_SUPPLIER1');
  14.             EXECUTE_QUERY;
  15.             P_SUPPLIER_LIST_ITEM;
  16.         ELSIF :SYSTEM.TAB_NEW_PAGE =  'PG_SUPPLIER_BANK' THEN
  17.             P_TREEPOP;
  18.         ELSIF :SYSTEM.TAB_NEW_PAGE =  'PG_ATTACHMENT_TYPE' THEN
  19.             GO_BLOCK('IN_INVOICE_DOCUMENT');
  20.             EXECUTE_QUERY;         
  21.            
  22.             GO_BLOCK('SL_DOCTYPE');
  23.             EXECUTE_QUERY;         
  24.            
  25.         END IF;
  26.         :SYSTEM.MESSAGE_LEVEL:=0;
  27. EXCEPTION
  28.     WHEN OTHERS THEN NULL;
  29. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement