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

Line 510: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';

506: begin
507:
508: if p_wipe_out_temp_table_at_start then
509: execute immediate
510: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';
511: end if;
512:
513: if (p_is_run_flow = TRUE)
514: then

Line 566: 'insert into ad_snapshot_files_temp '||

562: end if;
563:
564:
565: l_str1 :=
566: 'insert into ad_snapshot_files_temp '||
567: '( '||
568: 'snapshot_file_id, file_id, update_source_id, update_type, '||
569: 'inconsistent_flag, containing_file_id, file_version_id, '||
570: 'dest_file_id, file_type_flag '||

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 637: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');

633: commit;
634: end if;
635:
636: if p_gather_stats then
637: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');
638: end if;
639:
640: end get_max_fil_vers_over_appltops;
641:

Line 780: insert into ad_snapshot_files

776:
777:
778: /* Instantiate preseeded files information to GLOBAL_VIEW */
779:
780: insert into ad_snapshot_files
781: (
782: snapshot_file_id,
783: snapshot_id, file_id, containing_file_id,
784: file_version_id,

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 804: and not exists (select /+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) /

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
807: where sf2.snapshot_id = l_global_snapshot_id
808: and sf2.file_id = sf.file_id

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 928: insert into ad_snapshot_files

924:
925: -- Now insert files into actual table
926: -- Bug 3863707, changed the query not to select duplicate rows. 09/01/2004, cbhati.
927:
928: insert into ad_snapshot_files
929: (
930: snapshot_file_id, snapshot_id,
931: file_id, containing_file_id, file_version_id,
932: dest_file_id, file_type_flag,

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 956: ad_snapshot_files_temp

952: max(dest_file_id) dest_file_id,
953: decode(max(decode(file_type_flag,'M',1,'N',0,2)),
954: 1,'M',0,'N',null) file_type_flag
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

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 1825: insert into ad_snapshot_files

1821: put_line('Inserting new files in the curr-vw snapshot');
1822: end if;
1823:
1824: -- insert new files
1825: insert into ad_snapshot_files
1826: (
1827: snapshot_file_id,
1828: snapshot_id,
1829: file_id,

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 1898: insert into ad_snapshot_files

1894: end if;
1895:
1896: /* insert new files into Global current view snapshot */
1897:
1898: insert into ad_snapshot_files
1899: (
1900: snapshot_file_id, snapshot_id, file_id, containing_file_id,
1901: file_version_id, dest_file_id, file_type_flag,
1902: update_source_id, update_type,

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 2068: delete from ad_snapshot_files

2064:
2065: if nvl(l_deleted_ru_file_ids.last, 0) > 0 then
2066:
2067: forall i in l_deleted_ru_file_ids.first..l_deleted_ru_file_ids.last
2068: delete from ad_snapshot_files
2069: where snapshot_id = l_snapshot_id and
2070: file_id = l_deleted_ru_file_ids(i);
2071:
2072: if G_DEBUG then

Line 2110: from ad_snapshot_files_temp;

2106: cursor crec is
2107: select file_id, dest_file_id, file_type_flag,
2108: file_version_id, containing_file_id,
2109: inconsistent_flag
2110: from ad_snapshot_files_temp;
2111: begin
2112:
2113: open crec;
2114:

Line 2127: update /+ INDEX(SF AD_SNAPSHOT_FILES_U2) /

2123: limit rows;
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),

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 2461: insert into ad_snapshot_files

2457: and sb2.bugfix_id = sbs.bugfix_id);
2458:
2459: l_snapshot_bugs_inserted := sql%rowcount;
2460:
2461: insert into ad_snapshot_files
2462: (
2463: snapshot_file_id,
2464: snapshot_id, file_id, containing_file_id,
2465: file_version_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 2491: and not exists (select /+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) /

2487: -- (sf.server_type_web_flag = l_server_type_web_flag
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) =

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));