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 1828: select ad_files_s.nextval,

1824: (file_id,
1825: app_short_name,
1826: subdir, filename,
1827: creation_date, created_by, last_update_date, last_updated_by)
1828: select ad_files_s.nextval,
1829: temp.FILE_APPS_SHORT_NAME asn,
1830: temp.file_subdir dir, temp.filename fname,
1831: sysdate,5,sysdate,5
1832: from

Line 1869: select ad_files_s.nextval,

1865: --
1866: insert into ad_files
1867: (file_id, app_short_name, subdir, filename,
1868: creation_date, created_by, last_update_date, last_updated_by)
1869: select ad_files_s.nextval,
1870: temp.ldr_app_short_name asn,
1871: temp.ldr_subdir dir, temp.ldr_filename fname,
1872: sysdate, 5, sysdate, 5
1873: from

Line 1918: ad_files_s.nextval,

1914: filename,
1915: creation_date, last_update_date, last_updated_by, created_by
1916: )
1917: select
1918: ad_files_s.nextval,
1919: temp.dest_apps_short_name,
1920: temp.dest_subdir,
1921: temp.dest_filename,
1922: sysdate, sysdate, 5, 5