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_SYS_SNAPSHOTS_PKG dependencies on AD_FILES

Line 1216: from ad_files f

1212: -- *suspicion* is true. %% Need NT testing to really verify)
1213: begin
1214: select f.file_id
1215: into l_apps_zip_f_id
1216: from ad_files f
1217: where f.filename = 'apps.zip'
1218: and f.app_short_name = 'AU'
1219: and f.subdir = 'java';
1220: exception when no_data_found then

Line 1221: insert into ad_files

1217: where f.filename = 'apps.zip'
1218: and f.app_short_name = 'AU'
1219: and f.subdir = 'java';
1220: exception when no_data_found then
1221: insert into ad_files
1222: (
1223: file_id,
1224: app_short_name, subdir, filename,
1225: creation_date, last_update_date, last_updated_by, created_by

Line 1229: ad_files_s.nextval,

1225: creation_date, last_update_date, last_updated_by, created_by
1226: )
1227: values
1228: (
1229: ad_files_s.nextval,
1230: 'AU', 'java', 'apps.zip',
1231: sysdate, sysdate, 5, 5
1232: ) returning file_id into l_apps_zip_f_id;
1233: end;

Line 1237: put_line('Ensuring that lib.a files exist in AD_FILES...');

1233: end;
1234:
1235: if G_DEBUG then
1236: put_line('apps.zip file-id is '||to_char(l_apps_zip_f_id));
1237: put_line('Ensuring that lib.a files exist in AD_FILES...');
1238: end if;
1239:
1240: -- Note: assumes that app-short-names are indeed APP-SHORT-NAMES, and not
1241: -- prod-abbrs, as they used to be some time back.

Line 1244: insert into ad_files

1240: -- Note: assumes that app-short-names are indeed APP-SHORT-NAMES, and not
1241: -- prod-abbrs, as they used to be some time back.
1242:
1243: -- for all the various Unix's
1244: insert into ad_files
1245: (
1246: file_id,
1247: app_short_name,
1248: subdir,

Line 1253: ad_files_s.nextval,

1249: filename,
1250: creation_date, last_update_date, last_updated_by, created_by
1251: )
1252: select -- for all the various Unix's
1253: ad_files_s.nextval,
1254: a.application_short_name,
1255: 'lib',
1256: 'lib'||decode(a.application_short_name, 'SQLGL', 'gl',
1257: 'SQLAP', 'ap',

Line 1266: from ad_files f2

1262: sysdate, sysdate, 5, 5
1263: from fnd_application a
1264: where not exists (select
1265: 'lib.a already exists'
1266: from ad_files f2
1267: where f2.filename = 'lib'||
1268: decode(a.application_short_name,
1269: 'SQLGL', 'gl',
1270: 'SQLAP', 'ap',

Line 1279: put_line('Done ensuring that lib.a files exist in AD_FILES...');

1275: and f2.subdir = 'lib'
1276: and f2.app_short_name = a.application_short_name);
1277:
1278: if G_DEBUG then
1279: put_line('Done ensuring that lib.a files exist in AD_FILES...');
1280: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1281: put_line('Ensuring that st.lib files exist in AD_FILES...');
1282: end if;
1283:

Line 1281: put_line('Ensuring that st.lib files exist in AD_FILES...');

1277:
1278: if G_DEBUG then
1279: put_line('Done ensuring that lib.a files exist in AD_FILES...');
1280: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1281: put_line('Ensuring that st.lib files exist in AD_FILES...');
1282: end if;
1283:
1284: -- for NT
1285: insert into ad_files

Line 1285: insert into ad_files

1281: put_line('Ensuring that st.lib files exist in AD_FILES...');
1282: end if;
1283:
1284: -- for NT
1285: insert into ad_files
1286: (
1287: file_id,
1288: app_short_name,
1289: subdir,

Line 1294: ad_files_s.nextval,

1290: filename,
1291: creation_date, last_update_date, last_updated_by, created_by
1292: )
1293: select
1294: ad_files_s.nextval,
1295: a.application_short_name,
1296: 'lib',
1297: decode(a.application_short_name, 'SQLGL', 'gl',
1298: 'SQLAP', 'ap',

Line 1307: from ad_files f2

1303: sysdate, sysdate, 5, 5
1304: from fnd_application a
1305: where not exists (select
1306: 'st.lib already exists'
1307: from ad_files f2
1308: where f2.filename = decode(a.application_short_name,
1309: 'SQLGL', 'gl',
1310: 'SQLAP', 'ap',
1311: 'OFA', 'fa',

Line 1319: put_line('Done ensuring that st.lib files exist in AD_FILES...');

1315: and f2.subdir = 'lib'
1316: and f2.app_short_name = a.application_short_name);
1317:
1318: if G_DEBUG then
1319: put_line('Done ensuring that st.lib files exist in AD_FILES...');
1320: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1321: end if;
1322:
1323:

Line 1401: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

1397: max(afv.translation_level), max(prba.dest_file_id),
1398: max(prba.file_type_flag)
1399: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1400: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1401: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1402: where pr.patch_run_id = t.patch_run_id
1403: and pr.appl_top_id = :at_id
1404: and t.action_code = :pr_id_act_cd
1405: and pr.patch_run_id = prb.patch_run_id

Line 1475: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

1471: afv.version_segment9 desc, afv.version_segment10 desc,
1472: afv.translation_level desc nulls last) as r1
1473: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1474: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1475: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1476: where pr.patch_run_id = t.patch_run_id
1477: and pr.appl_top_id = :at_id
1478: and t.action_code = :pr_id_act_cd
1479: and pr.patch_run_id = prb.patch_run_id

Line 1527: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||

1523:
1524: l_from_where :=
1525: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||
1526: 'ad_patch_run_bugs prb, ad_patch_run_bug_actions prba, '||
1527: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||
1528: 'where pr.patch_run_id = t.patch_run_id '||
1529: 'and pr.appl_top_id = :at_id '||
1530: 'and t.action_code = :pr_id_act_cd '||
1531: 'and pr.patch_run_id = prb.patch_run_id '||

Line 1693: from ad_files f

1689: ad_patch_hist_snaps_temp t
1690: set t.clib_arch_file_id =
1691: (
1692: select f.file_id
1693: from ad_files f
1694: where f.app_short_name = translate(t.app_short_name, 'A#', 'A')
1695: and f.subdir = 'lib'
1696: and f.filename = decode(
1697: lower(substr(t.filename, instr(t.filename,'.',-1),