APPS.AD_FILE_UTIL dependencies on AD_FILES_S

Line 185: 'last_updated_by) select ad_files_s.nextval, '||

181: ad_file_util.error_buf := 'load_file_info('||
182: 'insert into ad_files '||
183: '(file_id, app_short_name, subdir, filename, '||
184: 'creation_date, created_by, last_update_date, '||
185: 'last_updated_by) select ad_files_s.nextval, '||
186: 'temp.asn, temp.dir, temp.fname, temp.edate, 5, '||
187: 'temp.edate, 5 '||
188: 'from (select distinct t.app_short_name asn, '||
189: 't.subdir dir, t.filename fname, '||

Line 198: select ad_files_s.nextval,

194: begin
195: insert into ad_files
196: (file_id, app_short_name, subdir, filename,
197: creation_date, created_by, last_update_date, last_updated_by)
198: select ad_files_s.nextval,
199: temp.asn, temp.dir, temp.fname,
200: temp.edate, 5, temp.edate, 5
201: from
202: (select distinct

Line 285: 'last_updated_by) select ad_files_s.nextval, '||

281: ad_file_util.error_buf := 'load_file_info('||
282: 'insert into ad_files '||
283: '(file_id, app_short_name, subdir, filename, '||
284: 'creation_date, created_by, last_update_date, '||
285: 'last_updated_by) select ad_files_s.nextval, '||
286: 'temp.asn, temp.dir, temp.fname, temp.edate, 5, '||
287: 'temp.edate, 5 '||
288: 'from (select distinct t.dest_apps_short_name asn, '||
289: 't.dest_subdir dir, t.dest_filename fname, '||

Line 299: select ad_files_s.nextval,

295: begin
296: insert into ad_files
297: (file_id, app_short_name, subdir, filename,
298: creation_date, created_by, last_update_date, last_updated_by)
299: select ad_files_s.nextval,
300: temp.asn, temp.dir, temp.fname,
301: temp.edate, 5, temp.edate, 5
302: from
303: (select distinct

Line 1896: select ad_files_s.nextval,

1892: (file_id,
1893: app_short_name,
1894: subdir, filename,
1895: creation_date, created_by, last_update_date, last_updated_by)
1896: select ad_files_s.nextval,
1897: temp.FILE_APPS_SHORT_NAME asn,
1898: temp.file_subdir dir, temp.filename fname,
1899: sysdate,5,sysdate,5
1900: from

Line 1937: select ad_files_s.nextval,

1933: --
1934: insert into ad_files
1935: (file_id, app_short_name, subdir, filename,
1936: creation_date, created_by, last_update_date, last_updated_by)
1937: select ad_files_s.nextval,
1938: temp.ldr_app_short_name asn,
1939: temp.ldr_subdir dir, temp.ldr_filename fname,
1940: sysdate, 5, sysdate, 5
1941: from

Line 1986: ad_files_s.nextval,

1982: filename,
1983: creation_date, last_update_date, last_updated_by, created_by
1984: )
1985: select
1986: ad_files_s.nextval,
1987: temp.dest_apps_short_name,
1988: temp.dest_subdir,
1989: temp.dest_filename,
1990: sysdate, sysdate, 5, 5