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_SNAPSHOT_FILES_S

Line 589: 'from ad_snapshot_files sf, ad_file_versions afv ';

585: 'afv.version_segment5 desc, afv.version_segment6 desc, '||
586: 'afv.version_segment7 desc, afv.version_segment8 desc, '||
587: 'afv.version_segment9 desc, afv.version_segment10 desc, '||
588: 'afv.translation_level desc nulls last) as r '||
589: 'from ad_snapshot_files sf, ad_file_versions afv ';
590:
591: if p_limit_to_candidate_files then
592: l_str2 :=
593: ', ad_patch_hist_snaps_temp t ' ||

Line 793: ad_snapshot_files_s.nextval,

789: server_type_node_flag, server_type_web_flag,
790: dest_file_id, file_type_flag
791: )
792: select
793: ad_snapshot_files_s.nextval,
794: l_global_snapshot_id, file_id, containing_file_id,
795: file_version_id,
796: update_source_id, update_type,
797: sysdate, sysdate, 5, 5,

Line 802: from ad_snapshot_files sf

798: p_cur_appl_top_id, 'N',
799: server_type_admin_flag, server_type_forms_flag,
800: server_type_node_flag, server_type_web_flag,
801: dest_file_id, file_type_flag
802: from ad_snapshot_files sf
803: where snapshot_id = l_preseeded_snapshot_id
804: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
805: 'Already exists'
806: from ad_snapshot_files sf2

Line 806: from ad_snapshot_files sf2

802: from ad_snapshot_files sf
803: where snapshot_id = l_preseeded_snapshot_id
804: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
805: 'Already exists'
806: from ad_snapshot_files sf2
807: where sf2.snapshot_id = l_global_snapshot_id
808: and sf2.file_id = sf.file_id
809: and nvl(sf2.containing_file_id, -1) =
810: nvl(sf.containing_file_id, -1));

Line 939: ad_snapshot_files_s.nextval, l_global_snapshot_id,

935: update_source_id, update_type,
936: creation_date, last_update_date, created_by, last_updated_by
937: )
938: select
939: ad_snapshot_files_s.nextval, l_global_snapshot_id,
940: t.file_id, t.containing_file_id, t.file_version_id,
941: t.dest_file_id, t.file_type_flag,
942: decode(l_count_appltops, 1, p_cur_appl_top_id, null),
943: decode(l_count_appltops, 1, 'N', null),

Line 959: from ad_snapshot_files sf2

955: from
956: ad_snapshot_files_temp
957: group by file_id) t
958: where not exists (select 'Already exists'
959: from ad_snapshot_files sf2
960: where sf2.snapshot_id = l_global_snapshot_id
961: and sf2.file_id = t.file_id
962: and nvl(sf2.containing_file_id, -1) =
963: nvl(t.containing_file_id, -1)

Line 1843: ad_snapshot_files_s.nextval,

1839: irep_gathered_flag,
1840: last_patched_date
1841: )
1842: select
1843: ad_snapshot_files_s.nextval,
1844: l_snapshot_id,
1845: t.file_id,
1846: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1847: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1862: from ad_snapshot_files sf

1858: from ad_patch_hist_snaps_temp t
1859: where t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1860: L_ARCH_AZIP_ACT_CD)
1861: and not exists (select 'Already exists'
1862: from ad_snapshot_files sf
1863: where sf.snapshot_id = l_snapshot_id
1864: and sf.file_id = t.file_id
1865: and ((sf.containing_file_id is null and
1866: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1907: ad_snapshot_files_s.nextval,

1903: creation_date, last_update_date, last_updated_by,
1904: created_by, appl_top_id, inconsistent_flag
1905: )
1906: select
1907: ad_snapshot_files_s.nextval,
1908: l_global_snapshot_id, -- Global Snapshot ID here
1909: t.file_id,
1910: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1911: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1926: from ad_snapshot_files sf

1922: where
1923: t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1924: L_ARCH_AZIP_ACT_CD)
1925: and not exists (select 'Already exists'
1926: from ad_snapshot_files sf
1927: where sf.snapshot_id = l_global_snapshot_id
1928: and sf.file_id = t.file_id
1929: and ((sf.containing_file_id is null and
1930: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1962: update ad_snapshot_files sf

1958:
1959: -- update existing files if higher version, or if dest_file_id
1960: -- or file_type_flag is different (Current View)
1961:
1962: update ad_snapshot_files sf
1963: set
1964: (sf.file_version_id, sf.update_source_id,
1965: sf.dest_file_id, sf.file_type_flag, sf.irep_gathered_flag) =
1966: (select t.file_version_id, t.patch_run_id,

Line 2128: ad_snapshot_files sf

2124:
2125: if file_id_list.count > 0 then
2126: forall j in file_id_list.first.. file_id_list.last
2127: update /*+ INDEX(SF AD_SNAPSHOT_FILES_U2) */
2128: ad_snapshot_files sf
2129: set sf.last_update_date = sysdate,
2130: sf.last_updated_by = 5,
2131: sf.file_version_id = file_version_id_list(j),
2132: sf.update_source_id = -1,

Line 2172: delete from ad_snapshot_files sf

2168:
2169: if nvl(l_deleted_ru_file_ids.last, 0) > 0 then
2170:
2171: forall i in l_deleted_ru_file_ids.first..l_deleted_ru_file_ids.last
2172: delete from ad_snapshot_files sf
2173: where sf.snapshot_id = l_global_snapshot_id and
2174: sf.file_id = l_deleted_ru_file_ids(i)
2175: and not exists
2176: (

Line 2178: from ad_snapshot_files sf1

2174: sf.file_id = l_deleted_ru_file_ids(i)
2175: and not exists
2176: (
2177: select 'Exists in the curr vw of some appltop'
2178: from ad_snapshot_files sf1
2179: where sf1.file_id = l_deleted_ru_file_ids(i)
2180: and nvl(sf1.containing_file_id, -1) = nvl(sf.containing_file_id, -1)
2181: and sf1.snapshot_id in (
2182: select s.snapshot_id

Line 2471: ad_snapshot_files_s.nextval,

2467: creation_date, last_update_date, last_updated_by, created_by,
2468: dest_file_id, file_type_flag
2469: )
2470: select
2471: ad_snapshot_files_s.nextval,
2472: l_curr_vw_snapshot_id, file_id, containing_file_id,
2473: file_version_id,
2474: update_source_id, update_type,
2475: sysdate, sysdate, 5, 5,

Line 2477: from ad_snapshot_files sf

2473: file_version_id,
2474: update_source_id, update_type,
2475: sysdate, sysdate, 5, 5,
2476: dest_file_id, file_type_flag
2477: from ad_snapshot_files sf
2478: where sf.snapshot_id = l_preseeded_snapshot_id
2479:
2480: -- Added for bug 3947949
2481: -- and ((sf.server_type_admin_flag = l_server_type_admin_flag

Line 2492: 'Already exists' from ad_snapshot_files sf2

2488: -- and l_server_type_web_flag = 'Y')
2489: -- )
2490:
2491: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
2492: 'Already exists' from ad_snapshot_files sf2
2493: where sf2.snapshot_id = l_curr_vw_snapshot_id
2494: and sf2.file_id = sf.file_id
2495: and nvl(sf2.containing_file_id, -1) =
2496: nvl(sf.containing_file_id, -1));