APPS.FND_FILE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105

   /* Bug 2446909: Delete corrupted filenames from fnd_temp_files */
   select filename, lpad(filename, 7, '0')
     into base_orig, BASE

     from fnd_temp_files
     where type = 'P' and rownum = 1
     for update of filename;

Line: 113

   delete from fnd_temp_files
     where filename = base_orig;

Line: 116

   delete from fnd_temp_files
     where filename = BASE;

Line: 126

	 select lpad(to_char(fnd_temp_files_s.nextval), 7, '0')
	   into BASE
	   from sys.dual;

Line: 202

      select translate(ltrim(value),',',' ')
        into TEMP_UTL
        from v$parameter
       where name = 'utl_file_dir';

Line: 208

        select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
          into TEMP_DIR
          from dual ;

Line: 516

   insert into fnd_temp_files (filename, type)
     values (BASE, 'P');