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(p_ebr_flow boolean default false)
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 959: -- Imports file information from ad_check_file_temp to ad_files and

955: -- Procedure
956: -- load_patch_onsite_vers_info
957: --
958: -- Purpose
959: -- Imports file information from ad_check_file_temp to ad_files and
960: -- ad_file_versions.
961: --
962: -- Only creates rows that don't already exist.
963: --

Line 996: -- process ad_files

992: procedure load_patch_onsite_vers_info
993: is
994: begin
995: --
996: -- process ad_files
997: --
998:
999: ad_file_util.load_file_info;
1000:

Line 1371: -- process ad_files and ad_file_versions

1367: --
1368: --
1369: begin
1370: --
1371: -- process ad_files and ad_file_versions
1372: --
1373: begin
1374: ad_file_util.load_file_version_info;
1375: exception

Line 1382: -- get contain_file_id from ad_files

1378: ad_file_util.error_buf||sqlerrm||')';
1379: raise;
1380: end;
1381: --
1382: -- get contain_file_id from ad_files
1383: --
1384: -- The containing files are already inserted into ad_files
1385: -- by the procedure load_file_version_info so we are
1386: -- guaranteed to get the file_id from ad_files.

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

1380: end;
1381: --
1382: -- get contain_file_id from ad_files
1383: --
1384: -- The containing files are already inserted into ad_files
1385: -- by the procedure load_file_version_info so we are
1386: -- guaranteed to get the file_id from ad_files.
1387: --
1388: -- done processing ad_files

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

1382: -- get contain_file_id from ad_files
1383: --
1384: -- The containing files are already inserted into ad_files
1385: -- by the procedure load_file_version_info so we are
1386: -- guaranteed to get the file_id from ad_files.
1387: --
1388: -- done processing ad_files
1389: --
1390: --

Line 1388: -- done processing ad_files

1384: -- The containing files are already inserted into ad_files
1385: -- by the procedure load_file_version_info so we are
1386: -- guaranteed to get the file_id from ad_files.
1387: --
1388: -- done processing ad_files
1389: --
1390: --
1391: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||
1392: 'select file_version_id,check_sum,file_size, '||

Line 1889: -- Add new entries in ad_files

1885: --
1886: --
1887: commit;
1888: --
1889: -- Add new entries in ad_files
1890: --
1891: insert into ad_files
1892: (file_id,
1893: app_short_name,

Line 1891: insert into ad_files

1887: commit;
1888: --
1889: -- Add new entries in ad_files
1890: --
1891: insert into ad_files
1892: (file_id,
1893: app_short_name,
1894: subdir, filename,
1895: creation_date, created_by, last_update_date, last_updated_by)

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

1906: AD_PATCH_HIST_TEMP t
1907: ) temp
1908: where not exists (
1909: select
1910: 'x' from ad_files fl
1911: where
1912: fl.filename = temp.filename
1913: and fl.subdir = temp.file_subdir
1914: and fl.app_short_name = temp.file_apps_short_name

Line 1923: from ad_files f

1919: --
1920: update AD_PATCH_HIST_TEMP t
1921: set t.file_id =
1922: (select f.file_id
1923: from ad_files f
1924: where
1925: f.filename = t.filename
1926: and f.subdir = t.file_subdir
1927: and f.app_short_name = t.file_apps_short_name);

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

1928: --
1929: --
1930: commit;
1931: --
1932: -- Add new entries in ad_files for Loader files
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)

Line 1934: insert into ad_files

1930: commit;
1931: --
1932: -- Add new entries in ad_files for Loader files
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,

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

1947: AD_PATCH_HIST_TEMP t
1948: ) temp
1949: where not exists (
1950: select
1951: 'x' from ad_files fl
1952: where
1953: fl.filename = temp.ldr_filename
1954: and fl.subdir = temp.ldr_subdir
1955: and fl.app_short_name = temp.ldr_app_short_name

Line 1964: from ad_files f

1960: --
1961: update AD_PATCH_HIST_TEMP t
1962: set t.loader_data_file_id =
1963: (select f.file_id
1964: from ad_files f
1965: where
1966: f.filename = t.ldr_filename
1967: and f.subdir = t.ldr_subdir
1968: and f.app_short_name = t.ldr_app_short_name)

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

1971: --
1972: commit;
1973:
1974: --
1975: -- Add new entries in ad_files for the destination files
1976: --
1977: insert into ad_files
1978: (
1979: file_id,

Line 1977: insert into ad_files

1973:
1974: --
1975: -- Add new entries in ad_files for the destination files
1976: --
1977: insert into ad_files
1978: (
1979: file_id,
1980: app_short_name,
1981: subdir,

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

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

2000: and t.dest_filename is not null
2001: ) temp
2002: where not exists (
2003: select
2004: 'dest file already exists' from ad_files f
2005: where
2006: f.filename = temp.dest_filename
2007: and f.subdir = temp.dest_subdir
2008: and f.app_short_name = temp.dest_apps_short_name);

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

2011: -- Get the Destination file_id into the staging table
2012: --
2013: update AD_PATCH_HIST_TEMP t
2014: set t.dest_file_id =
2015: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
2016: from ad_files f
2017: where f.app_short_name = t.dest_apps_short_name
2018: and f.subdir = t.dest_subdir
2019: and f.filename = t.dest_filename);

Line 2016: from ad_files f

2012: --
2013: update AD_PATCH_HIST_TEMP t
2014: set t.dest_file_id =
2015: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
2016: from ad_files f
2017: where f.app_short_name = t.dest_apps_short_name
2018: and f.subdir = t.dest_subdir
2019: and f.filename = t.dest_filename);
2020: --