DBA Data[Home] [Help]

APPS.FND_FILE dependencies on V$PARAMETER

Line 277: from v$parameter

273: -- use first entry of utl_file_dir as the TEMP_DIR
274: -- if there is no entry then do not even construct file names
275: select translate(ltrim(value),',',' ')
276: into TEMP_UTL
277: from v$parameter
278: where name = 'utl_file_dir';
279:
280: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
281: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)