DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on V$PARAMETER

Line 287: FROM v$parameter

283: -- Modified by Brathod for SQL Literals
284: lv_name := 'utl_file_dir';
285: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
286: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location
287: FROM v$parameter
288: WHERE name = lv_name;
289:
290: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
291: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start TdsTemp_AfterInsert_Trg ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');