APPS.AP_ACCTG_DATA_FIX_PKG dependencies on V$PARAMETER

Line 26: l_file_location v$parameter.value%type;

22: P_File_Location OUT NOCOPY VARCHAR2) IS
23:
24: l_log_file VARCHAR2(30);
25: l_out_file VARCHAR2(30);
26: l_file_location v$parameter.value%type;
27: No_Utl_Dir EXCEPTION;
28: l_date VARCHAR2(30);
29: l_message VARCHAR2(500);
30:

Line 42: FROM v$parameter

38:
39: SELECT decode(instr(value,','),0,value,
40: SUBSTR (value,1,instr(value,',') - 1))
41: INTO l_file_location
42: FROM v$parameter
43: WHERE name = 'utl_file_dir';
44:
45: IF l_file_location IS NULL THEN
46: RAISE No_Utl_Dir;