APPS.FND_FILE dependencies on FND_TEMP_FILES

Line 105: /* Bug 2446909: Delete corrupted filenames from fnd_temp_files */

101: base_orig varchar2(12);
102: BASE varchar2(12);
103: PRAGMA AUTONOMOUS_TRANSACTION;
104: begin
105: /* Bug 2446909: Delete corrupted filenames from fnd_temp_files */
106: select filename, lpad(filename, 7, '0')
107: into base_orig, BASE
108:
109: from fnd_temp_files

Line 109: from fnd_temp_files

105: /* Bug 2446909: Delete corrupted filenames from fnd_temp_files */
106: select filename, lpad(filename, 7, '0')
107: into base_orig, BASE
108:
109: from fnd_temp_files
110: where type = 'P' and rownum = 1
111: for update of filename;
112:
113: delete from fnd_temp_files

Line 113: delete from fnd_temp_files

109: from fnd_temp_files
110: where type = 'P' and rownum = 1
111: for update of filename;
112:
113: delete from fnd_temp_files
114: where filename = base_orig;
115:
116: delete from fnd_temp_files
117: where filename = BASE;

Line 116: delete from fnd_temp_files

112:
113: delete from fnd_temp_files
114: where filename = base_orig;
115:
116: delete from fnd_temp_files
117: where filename = BASE;
118:
119: commit;
120:

Line 126: select lpad(to_char(fnd_temp_files_s.nextval), 7, '0')

122:
123: exception
124: when OTHERS then
125: if (Sql%NotFound) then
126: select lpad(to_char(fnd_temp_files_s.nextval), 7, '0')
127: into BASE
128: from sys.dual;
129: end if;
130:

Line 234: -- log the temp file info in fnd_temp_files table

230:
231: end if;
232:
233: -- CAUTION: for NT, we can ignore this area for NT
234: -- log the temp file info in fnd_temp_files table
235:
236: if UTL_FILE_DELAY > 0 then
237: if IS_OPEN('LOG') = 0 then
238: TEMP_UTL := TEMP_DIR || '/' || LOG_FNAME;

Line 516: insert into fnd_temp_files (filename, type)

512: procedure RELEASE_NAMES(P_LOG in varchar2, P_OUT in varchar2) is
513: BASE varchar2(12);
514: begin
515: BASE := substr(P_LOG, 2, 7);
516: insert into fnd_temp_files (filename, type)
517: values (BASE, 'P');
518:
519: end RELEASE_NAMES;
520: