DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on V$PARAMETER

Line 112: from v$parameter

108: Begin
109: Select DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
110: Value,SUBSTR (value,1,INSTR(value,',') -1))
111: INTO lv_utl_location
112: from v$parameter
113: where name = 'utl_file_dir';
114:
115: lv_myfilehandle := UTL_FILE.FOPEN(lv_utl_location, lv_log_file_name ,'A');
116: UTL_FILE.PUT_LINE(lv_myfilehandle, '********* Start ja_in_ap_aida_after_trg('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');