APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on V$PARAMETER

Line 341: FROM v$parameter

337: -- Modified by Brathod for SQL Literals
338: lv_name := 'utl_file_dir';
339: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
340: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location
341: FROM v$parameter
342: WHERE name = lv_name;
343:
344: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location, v_log_file_name ,'A');
345: UTL_FILE.PUT_LINE(v_myfilehandle, '********* Start TdsTemp_AfterInsert_Trg ('||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS') ||') *********');