DBA Data[Home] [Help]

APPS.FND_FILE dependencies on V$PARAMETER

Line 204: from v$parameter

200: -- use first entry of utl_file_dir as the TEMP_DIR
201: -- if there is no entry then do not even construct file names
202: select translate(ltrim(value),',',' ')
203: into TEMP_UTL
204: from v$parameter
205: where name = 'utl_file_dir';
206:
207: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
208: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)