eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_FILE_UTIL dependencies on AD_FILES

Line 117: -- Imports file information from ad_check_file_temp to ad_files

113: -- Procedure
114: -- load_file_info
115: --
116: -- Purpose
117: -- Imports file information from ad_check_file_temp to ad_files
118: --
119: -- Only creates rows that don't already exist.
120: --
121: -- Processes all rows in ad_check_file_temp with active_flag='Y'.

Line 145: -- process ad_files

141: procedure load_file_info
142: is
143: begin
144: --
145: -- process ad_files
146: --
147:
148: --
149: -- get file_id from ad_files

Line 149: -- get file_id from ad_files

145: -- process ad_files
146: --
147:
148: --
149: -- get file_id from ad_files
150: --
151: -- set junk to null to free up space in row and avoid row chaining
152: --
153: ad_file_util.error_buf := 'load_file_info('||

Line 156: 'from ad_files f '||

152: --
153: ad_file_util.error_buf := 'load_file_info('||
154: ' update ad_check_file_temp t '||
155: 'set t.file_id = (select f.file_id '||
156: 'from ad_files f '||
157: 'where f.app_short_name = t.app_short_name '||
158: 'and f.subdir = t.subdir '||
159: 'and f.filename = t.filename), '||
160: 't.junk = null '||

Line 165: (select /+ INDEX(F AD_FILES_U2) / f.file_id

161: 'where nvl(t.active_flag,''N'') = ''Y'';):(';
162: begin
163: update ad_check_file_temp t
164: set t.file_id =
165: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
166: from ad_files f
167: where f.app_short_name = t.app_short_name
168: and f.subdir = t.subdir
169: and f.filename = t.filename),

Line 166: from ad_files f

162: begin
163: update ad_check_file_temp t
164: set t.file_id =
165: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
166: from ad_files f
167: where f.app_short_name = t.app_short_name
168: and f.subdir = t.subdir
169: and f.filename = t.filename),
170: t.junk = null

Line 179: -- add new entries in ad_files

175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
176: raise;
177: end;
178: --
179: -- add new entries in ad_files
180: --
181: ad_file_util.error_buf := 'load_file_info('||
182: 'insert into ad_files '||
183: '(file_id, app_short_name, subdir, filename, '||

Line 182: 'insert into ad_files '||

178: --
179: -- add new entries in ad_files
180: --
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, '||

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 195: insert into ad_files

191: 'ad_check_file_temp t where t.file_id is null '||
192: ' and nvl(t.active_flag,''N'') = ''Y'') temp;):(';
193:
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,

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 221: '(select f.file_id from ad_files f '||

217: -- add file_id for new entries
218: --
219: ad_file_util.error_buf := 'load_file_info('||
220: 'update ad_check_file_temp t set t.file_id = '||
221: '(select f.file_id from ad_files f '||
222: 'where f.app_short_name = t.app_short_name '||
223: 'and f.subdir = t.subdir '||
224: 'and f.filename = t.filename) '||
225: 'where t.file_id is null '||

Line 231: (select /+ INDEX(F AD_FILES_U2) / f.file_id

227:
228: begin
229: update ad_check_file_temp t
230: set t.file_id =
231: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
232: from ad_files f
233: where f.app_short_name = t.app_short_name
234: and f.subdir = t.subdir
235: and f.filename = t.filename)

Line 232: from ad_files f

228: begin
229: update ad_check_file_temp t
230: set t.file_id =
231: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
232: from ad_files f
233: where f.app_short_name = t.app_short_name
234: and f.subdir = t.subdir
235: and f.filename = t.filename)
236: where t.file_id is null

Line 251: -- get dest_file_id from ad_files

247: -- to file_id entries (i.e., first update, then insert and finally update)
248: --
249:
250: --
251: -- get dest_file_id from ad_files
252: --
253:
254: ad_file_util.error_buf := 'load_file_info('||
255: ' update ad_check_file_temp t '||

Line 257: 'from ad_files f '||

253:
254: ad_file_util.error_buf := 'load_file_info('||
255: ' update ad_check_file_temp t '||
256: 'set t.dest_file_id = (select f.file_id '||
257: 'from ad_files f '||
258: 'where f.app_short_name = t.dest_apps_short_name '||
259: 'and f.subdir = t.dest_subdir '||
260: 'and f.filename = t.dest_filename) '||
261: 'where nvl(t.active_flag,''N'') = ''Y'';):(';

Line 265: (select /+ INDEX(F AD_FILES_U2) / f.file_id

261: 'where nvl(t.active_flag,''N'') = ''Y'';):(';
262: begin
263: update ad_check_file_temp t
264: set t.dest_file_id =
265: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
266: from ad_files f
267: where f.app_short_name = t.dest_apps_short_name
268: and f.subdir = t.dest_subdir
269: and f.filename = t.dest_filename)

Line 266: from ad_files f

262: begin
263: update ad_check_file_temp t
264: set t.dest_file_id =
265: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
266: from ad_files f
267: where f.app_short_name = t.dest_apps_short_name
268: and f.subdir = t.dest_subdir
269: and f.filename = t.dest_filename)
270: where nvl(t.active_flag,'N') = 'Y';

Line 278: -- add new entries in ad_files

274: raise;
275: end;
276:
277: --
278: -- add new entries in ad_files
279: --
280:
281: ad_file_util.error_buf := 'load_file_info('||
282: 'insert into ad_files '||

Line 282: 'insert into ad_files '||

278: -- add new entries in ad_files
279: --
280:
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, '||

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 296: insert into ad_files

292: ' and t.dest_filename is not null '||
293: ' and nvl(t.active_flag,''N'') = ''Y'') temp;):(';
294:
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,

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 325: '(select f.file_id from ad_files f '||

321: --
322:
323: ad_file_util.error_buf := 'load_file_info('||
324: 'update ad_check_file_temp t set t.dest_file_id ='||
325: '(select f.file_id from ad_files f '||
326: 'where f.app_short_name = t.dest_apps_short_name'||
327: 'and f.subdir = t.dest_subdir '||
328: 'and f.filename = t.dest_filename) '||
329: 'where t.dest_file_id is null '||

Line 336: (select /+ INDEX(F AD_FILES_U2) / f.file_id

332:
333: begin
334: update ad_check_file_temp t
335: set t.dest_file_id =
336: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
337: from ad_files f
338: where f.app_short_name = t.dest_apps_short_name
339: and f.subdir = t.dest_subdir
340: and f.filename = t.dest_filename)

Line 337: from ad_files f

333: begin
334: update ad_check_file_temp t
335: set t.dest_file_id =
336: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
337: from ad_files f
338: where f.app_short_name = t.dest_apps_short_name
339: and f.subdir = t.dest_subdir
340: and f.filename = t.dest_filename)
341: where t.dest_file_id is null

Line 352: -- done processing ad_files

348: raise;
349: end;
350:
351: --
352: -- done processing ad_files
353: --
354:
355: end load_file_info;
356:

Line 362: -- Imports file information from ad_check_file_temp to ad_files and

358: -- Procedure
359: -- load_file_version_info
360: --
361: -- Purpose
362: -- Imports file information from ad_check_file_temp to ad_files and
363: -- ad_file_versions.
364: --
365: -- Only creates rows that don't already exist.
366: --

Line 394: -- process ad_files

390: procedure load_file_version_info
391: is
392: begin
393: --
394: -- process ad_files
395: --
396: begin
397: ad_file_util.load_file_info;
398: exception

Line 586: -- Imports file information from ad_check_file_temp to ad_files,

582: -- Procedure
583: -- load_checkfile_info
584: --
585: -- Purpose
586: -- Imports file information from ad_check_file_temp to ad_files,
587: -- ad_file_versions, and ad_check_files.
588: --
589: -- Only creates rows in ad_files and ad_file_versions that don't
590: -- already exist. In ad_check_files, it creates rows that don't already

Line 589: -- Only creates rows in ad_files and ad_file_versions that don't

585: -- Purpose
586: -- Imports file information from ad_check_file_temp to ad_files,
587: -- ad_file_versions, and ad_check_files.
588: --
589: -- Only creates rows in ad_files and ad_file_versions that don't
590: -- already exist. In ad_check_files, it creates rows that don't already
591: -- exist and also updates existing rows if the version to load is higher
592: -- than the current version in ad_check_files.
593: --

Line 624: -- process ad_files and ad_file_versions

620: procedure load_checkfile_info
621: is
622: begin
623: --
624: -- process ad_files and ad_file_versions
625: --
626: ad_file_util.error_buf := 'load_checkfile_info(';
627: begin
628: ad_file_util.load_file_version_info;

Line 893: -- Imports file information from ad_check_file_temp to ad_files and

889: -- Procedure
890: -- load_patch_onsite_vers_info
891: --
892: -- Purpose
893: -- Imports file information from ad_check_file_temp to ad_files and
894: -- ad_file_versions.
895: --
896: -- Only creates rows that don't already exist.
897: --

Line 930: -- process ad_files

926: procedure load_patch_onsite_vers_info
927: is
928: begin
929: --
930: -- process ad_files
931: --
932:
933: ad_file_util.load_file_info;
934:

Line 1305: -- process ad_files and ad_file_versions

1301: --
1302: --
1303: begin
1304: --
1305: -- process ad_files and ad_file_versions
1306: --
1307: begin
1308: ad_file_util.load_file_version_info;
1309: exception

Line 1316: -- get contain_file_id from ad_files

1312: ad_file_util.error_buf||sqlerrm||')';
1313: raise;
1314: end;
1315: --
1316: -- get contain_file_id from ad_files
1317: --
1318: -- The containing files are already inserted into ad_files
1319: -- by the procedure load_file_version_info so we are
1320: -- guaranteed to get the file_id from ad_files.

Line 1318: -- The containing files are already inserted into ad_files

1314: end;
1315: --
1316: -- get contain_file_id from ad_files
1317: --
1318: -- The containing files are already inserted into ad_files
1319: -- by the procedure load_file_version_info so we are
1320: -- guaranteed to get the file_id from ad_files.
1321: --
1322: -- done processing ad_files

Line 1320: -- guaranteed to get the file_id from ad_files.

1316: -- get contain_file_id from ad_files
1317: --
1318: -- The containing files are already inserted into ad_files
1319: -- by the procedure load_file_version_info so we are
1320: -- guaranteed to get the file_id from ad_files.
1321: --
1322: -- done processing ad_files
1323: --
1324: --

Line 1322: -- done processing ad_files

1318: -- The containing files are already inserted into ad_files
1319: -- by the procedure load_file_version_info so we are
1320: -- guaranteed to get the file_id from ad_files.
1321: --
1322: -- done processing ad_files
1323: --
1324: --
1325: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||
1326: 'select file_version_id,check_sum,file_size, '||

Line 1821: -- Add new entries in ad_files

1817: --
1818: --
1819: commit;
1820: --
1821: -- Add new entries in ad_files
1822: --
1823: insert into ad_files
1824: (file_id,
1825: app_short_name,

Line 1823: insert into ad_files

1819: commit;
1820: --
1821: -- Add new entries in ad_files
1822: --
1823: insert into ad_files
1824: (file_id,
1825: app_short_name,
1826: subdir, filename,
1827: creation_date, created_by, last_update_date, last_updated_by)

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 1842: 'x' from ad_files fl

1838: AD_PATCH_HIST_TEMP t
1839: ) temp
1840: where not exists (
1841: select
1842: 'x' from ad_files fl
1843: where
1844: fl.filename = temp.filename
1845: and fl.subdir = temp.file_subdir
1846: and fl.app_short_name = temp.file_apps_short_name

Line 1855: from ad_files f

1851: --
1852: update AD_PATCH_HIST_TEMP t
1853: set t.file_id =
1854: (select f.file_id
1855: from ad_files f
1856: where
1857: f.filename = t.filename
1858: and f.subdir = t.file_subdir
1859: and f.app_short_name = t.file_apps_short_name);

Line 1864: -- Add new entries in ad_files for Loader files

1860: --
1861: --
1862: commit;
1863: --
1864: -- Add new entries in ad_files for Loader files
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)

Line 1866: insert into ad_files

1862: commit;
1863: --
1864: -- Add new entries in ad_files for Loader files
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,

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 1883: 'x' from ad_files fl

1879: AD_PATCH_HIST_TEMP t
1880: ) temp
1881: where not exists (
1882: select
1883: 'x' from ad_files fl
1884: where
1885: fl.filename = temp.ldr_filename
1886: and fl.subdir = temp.ldr_subdir
1887: and fl.app_short_name = temp.ldr_app_short_name

Line 1896: from ad_files f

1892: --
1893: update AD_PATCH_HIST_TEMP t
1894: set t.loader_data_file_id =
1895: (select f.file_id
1896: from ad_files f
1897: where
1898: f.filename = t.ldr_filename
1899: and f.subdir = t.ldr_subdir
1900: and f.app_short_name = t.ldr_app_short_name)

Line 1907: -- Add new entries in ad_files for the destination files

1903: --
1904: commit;
1905:
1906: --
1907: -- Add new entries in ad_files for the destination files
1908: --
1909: insert into ad_files
1910: (
1911: file_id,

Line 1909: insert into ad_files

1905:
1906: --
1907: -- Add new entries in ad_files for the destination files
1908: --
1909: insert into ad_files
1910: (
1911: file_id,
1912: app_short_name,
1913: subdir,

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

Line 1936: 'dest file already exists' from ad_files f

1932: and t.dest_filename is not null
1933: ) temp
1934: where not exists (
1935: select
1936: 'dest file already exists' from ad_files f
1937: where
1938: f.filename = temp.dest_filename
1939: and f.subdir = temp.dest_subdir
1940: and f.app_short_name = temp.dest_apps_short_name);

Line 1947: (select /+ INDEX(F AD_FILES_U2) / f.file_id

1943: -- Get the Destination file_id into the staging table
1944: --
1945: update AD_PATCH_HIST_TEMP t
1946: set t.dest_file_id =
1947: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
1948: from ad_files f
1949: where f.app_short_name = t.dest_apps_short_name
1950: and f.subdir = t.dest_subdir
1951: and f.filename = t.dest_filename);

Line 1948: from ad_files f

1944: --
1945: update AD_PATCH_HIST_TEMP t
1946: set t.dest_file_id =
1947: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
1948: from ad_files f
1949: where f.app_short_name = t.dest_apps_short_name
1950: and f.subdir = t.dest_subdir
1951: and f.filename = t.dest_filename);
1952: --