APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on V$PARAMETER

Line 3326: FROM v$parameter

3322: -- Get the Location for the Log file
3323: SELECT decode(substr(value,1,instr(value,',') -1),
3324: null ,value ,
3325: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3326: FROM v$parameter
3327: WHERE name = 'utl_file_dir';
3328:
3329:
3330: log_file (lv_filename , '============================================================================================================================================================================================================================');

Line 3517: FROM v$parameter

3513:
3514: SELECT decode(substr (value,1,instr(value,',') -1) ,
3515: null ,value ,
3516: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3517: FROM v$parameter
3518: WHERE name = 'utl_file_dir';
3519:
3520: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3521: utl_file.put_line(v_myfilehandle,text_to_write);