APPS.WRITE_AUDIT dependencies on V$PARAMETER

Line 8: TEMP_UTL v$parameter.value%type;

4: g_file_type utl_file.file_type;
5: g_IL_fein varchar2(10);
6: g_file_name varchar2(30);
7: TEMP_DIR varchar2(255);
8: TEMP_UTL v$parameter.value%type;
9:
10: procedure open(p_reportname in varchar2) is
11: l_applcsf varchar2(2000);
12: l_per_top varchar2(2000);

Line 33: from v$parameter

29: begin
30:
31: select translate(ltrim(value),',',' ')
32: into TEMP_UTL
33: from v$parameter
34: where name = 'utl_file_dir';
35:
36: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
37: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)