DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on V$PARAMETER

Line 425: from v$parameter

421: Begin
422: Select DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
423: Value,SUBSTR (value,1,INSTR(value,',') -1))
424: INTO lv_utl_location
425: from v$parameter
426: where name = 'utl_file_dir';
427:
428: lv_myfilehandle := UTL_FILE.FOPEN(lv_utl_location, lv_log_file_name ,'A');
429: UTL_FILE.PUT_LINE(lv_myfilehandle, '********* Start ja_in_ap_aida_after_trg('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');