APPS.AP_ACCTG_DATA_FIX_PKG dependencies on V$PARAMETER

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

11: P_File_Location OUT NOCOPY VARCHAR2) IS
12:
13: l_log_file VARCHAR2(30);
14: l_out_file VARCHAR2(30);
15: l_file_location v$parameter.value%type;
16: No_Utl_Dir EXCEPTION;
17: l_date VARCHAR2(30);
18: l_message VARCHAR2(500);
19:

Line 31: FROM v$parameter

27:
28: SELECT decode(instr(value,','),0,value,
29: SUBSTR (value,1,instr(value,',') - 1))
30: INTO l_file_location
31: FROM v$parameter
32: WHERE name = 'utl_file_dir';
33:
34: IF l_file_location IS NULL THEN
35: RAISE No_Utl_Dir;