APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on V$PARAMETER

Line 3507: FROM v$parameter

3503: -- Get the Location for the Log file
3504: SELECT decode(substr(value,1,instr(value,',') -1),
3505: null ,value ,
3506: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3507: FROM v$parameter
3508: WHERE name = 'utl_file_dir';
3509:
3510:
3511: log_file (lv_filename , '============================================================================================================================================================================================================================');

Line 3698: FROM v$parameter

3694:
3695: SELECT decode(substr (value,1,instr(value,',') -1) ,
3696: null ,value ,
3697: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3698: FROM v$parameter
3699: WHERE name = 'utl_file_dir';
3700:
3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3702: utl_file.put_line(v_myfilehandle,text_to_write);