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 472: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';

468: begin
469:
470: if p_wipe_out_temp_table_at_start then
471: execute immediate
472: 'truncate table ' || G_UN_FND || '.ad_snapshot_files_temp';
473: end if;
474:
475: select snapshot_id
476: bulk collect into l_cv_ids

Line 521: 'insert into ad_snapshot_files_temp '||

517: end if;
518:
519:
520: l_str1 :=
521: 'insert into ad_snapshot_files_temp '||
522: '( '||
523: 'snapshot_file_id, file_id, update_source_id, update_type, '||
524: 'inconsistent_flag, containing_file_id, file_version_id, '||
525: 'dest_file_id, file_type_flag '||

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

540: 'afv.version_segment5 desc, afv.version_segment6 desc, '||
541: 'afv.version_segment7 desc, afv.version_segment8 desc, '||
542: 'afv.version_segment9 desc, afv.version_segment10 desc, '||
543: 'afv.translation_level desc nulls last) as r '||
544: 'from ad_snapshot_files sf, ad_file_versions afv ';
545:
546: if p_limit_to_candidate_files then
547: l_str2 :=
548: ', ad_patch_hist_snaps_temp t ' ||

Line 592: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');

588: commit;
589: end if;
590:
591: if p_gather_stats then
592: fnd_stats.gather_table_stats(G_UN_FND, 'ad_snapshot_files_temp');
593: end if;
594:
595: end get_max_fil_vers_over_appltops;
596:

Line 721: insert into ad_snapshot_files

717:
718:
719: /* Instantiate preseeded files information to GLOBAL_VIEW */
720:
721: insert into ad_snapshot_files
722: (
723: snapshot_file_id,
724: snapshot_id, file_id, containing_file_id,
725: file_version_id,

Line 734: ad_snapshot_files_s.nextval,

730: server_type_node_flag, server_type_web_flag,
731: dest_file_id, file_type_flag
732: )
733: select
734: ad_snapshot_files_s.nextval,
735: l_global_snapshot_id, file_id, containing_file_id,
736: file_version_id,
737: update_source_id, update_type,
738: sysdate, sysdate, 5, 5,

Line 743: from ad_snapshot_files sf

739: p_cur_appl_top_id, 'N',
740: server_type_admin_flag, server_type_forms_flag,
741: server_type_node_flag, server_type_web_flag,
742: dest_file_id, file_type_flag
743: from ad_snapshot_files sf
744: where snapshot_id = l_preseeded_snapshot_id
745: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
746: 'Already exists'
747: from ad_snapshot_files sf2

Line 745: and not exists (select /+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) /

741: server_type_node_flag, server_type_web_flag,
742: dest_file_id, file_type_flag
743: from ad_snapshot_files sf
744: where snapshot_id = l_preseeded_snapshot_id
745: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
746: 'Already exists'
747: from ad_snapshot_files sf2
748: where sf2.snapshot_id = l_global_snapshot_id
749: and sf2.file_id = sf.file_id

Line 747: from ad_snapshot_files sf2

743: from ad_snapshot_files sf
744: where snapshot_id = l_preseeded_snapshot_id
745: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
746: 'Already exists'
747: from ad_snapshot_files sf2
748: where sf2.snapshot_id = l_global_snapshot_id
749: and sf2.file_id = sf.file_id
750: and nvl(sf2.containing_file_id, -1) =
751: nvl(sf.containing_file_id, -1));

Line 867: insert into ad_snapshot_files

863:
864: -- Now insert files into actual table
865: -- Bug 3863707, changed the query not to select duplicate rows. 09/01/2004, cbhati.
866:
867: insert into ad_snapshot_files
868: (
869: snapshot_file_id, snapshot_id,
870: file_id, containing_file_id, file_version_id,
871: dest_file_id, file_type_flag,

Line 878: ad_snapshot_files_s.nextval, l_global_snapshot_id,

874: update_source_id, update_type,
875: creation_date, last_update_date, created_by, last_updated_by
876: )
877: select
878: ad_snapshot_files_s.nextval, l_global_snapshot_id,
879: t.file_id, t.containing_file_id, t.file_version_id,
880: t.dest_file_id, t.file_type_flag,
881: decode(l_count_appltops, 1, p_cur_appl_top_id, null),
882: decode(l_count_appltops, 1, 'N', null),

Line 895: ad_snapshot_files_temp

891: max(dest_file_id) dest_file_id,
892: decode(max(decode(file_type_flag,'M',1,'N',0,2)),
893: 1,'M',0,'N',null) file_type_flag
894: from
895: ad_snapshot_files_temp
896: group by file_id) t
897: where not exists (select 'Already exists'
898: from ad_snapshot_files sf2
899: where sf2.snapshot_id = l_global_snapshot_id

Line 898: from ad_snapshot_files sf2

894: from
895: ad_snapshot_files_temp
896: group by file_id) t
897: where not exists (select 'Already exists'
898: from ad_snapshot_files sf2
899: where sf2.snapshot_id = l_global_snapshot_id
900: and sf2.file_id = t.file_id
901: and nvl(sf2.containing_file_id, -1) =
902: nvl(t.containing_file_id, -1)

Line 1748: insert into ad_snapshot_files

1744: put_line('Inserting new files in the curr-vw snapshot');
1745: end if;
1746:
1747: -- insert new files
1748: insert into ad_snapshot_files
1749: (
1750: snapshot_file_id,
1751: snapshot_id,
1752: file_id,

Line 1766: ad_snapshot_files_s.nextval,

1762: irep_gathered_flag,
1763: last_patched_date
1764: )
1765: select
1766: ad_snapshot_files_s.nextval,
1767: l_snapshot_id,
1768: t.file_id,
1769: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1770: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1785: from ad_snapshot_files sf

1781: from ad_patch_hist_snaps_temp t
1782: where t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1783: L_ARCH_AZIP_ACT_CD)
1784: and not exists (select 'Already exists'
1785: from ad_snapshot_files sf
1786: where sf.snapshot_id = l_snapshot_id
1787: and sf.file_id = t.file_id
1788: and ((sf.containing_file_id is null and
1789: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1821: insert into ad_snapshot_files

1817: end if;
1818:
1819: /* insert new files into Global current view snapshot */
1820:
1821: insert into ad_snapshot_files
1822: (
1823: snapshot_file_id, snapshot_id, file_id, containing_file_id,
1824: file_version_id, dest_file_id, file_type_flag,
1825: update_source_id, update_type,

Line 1830: ad_snapshot_files_s.nextval,

1826: creation_date, last_update_date, last_updated_by,
1827: created_by, appl_top_id, inconsistent_flag
1828: )
1829: select
1830: ad_snapshot_files_s.nextval,
1831: l_global_snapshot_id, -- Global Snapshot ID here
1832: t.file_id,
1833: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1834: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1849: from ad_snapshot_files sf

1845: where
1846: t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1847: L_ARCH_AZIP_ACT_CD)
1848: and not exists (select 'Already exists'
1849: from ad_snapshot_files sf
1850: where sf.snapshot_id = l_global_snapshot_id
1851: and sf.file_id = t.file_id
1852: and ((sf.containing_file_id is null and
1853: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1885: update ad_snapshot_files sf

1881:
1882: -- update existing files if higher version, or if dest_file_id
1883: -- or file_type_flag is different (Current View)
1884:
1885: update ad_snapshot_files sf
1886: set
1887: (sf.file_version_id, sf.update_source_id,
1888: sf.dest_file_id, sf.file_type_flag, sf.irep_gathered_flag) =
1889: (select t.file_version_id, t.patch_run_id,

Line 1991: delete from ad_snapshot_files

1987:
1988: if nvl(l_deleted_ru_file_ids.last, 0) > 0 then
1989:
1990: forall i in l_deleted_ru_file_ids.first..l_deleted_ru_file_ids.last
1991: delete from ad_snapshot_files
1992: where snapshot_id = l_snapshot_id and
1993: file_id = l_deleted_ru_file_ids(i);
1994:
1995: if G_DEBUG then

Line 2032: from ad_snapshot_files_temp;

2028: cursor crec is
2029: select file_id, dest_file_id, file_type_flag,
2030: file_version_id, containing_file_id,
2031: inconsistent_flag
2032: from ad_snapshot_files_temp;
2033: begin
2034:
2035: open crec;
2036:

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

2045: limit rows;
2046:
2047: if file_id_list.count > 0 then
2048: forall j in file_id_list.first.. file_id_list.last
2049: update /*+ INDEX(SF AD_SNAPSHOT_FILES_U2) */
2050: ad_snapshot_files sf
2051: set sf.last_update_date = sysdate,
2052: sf.last_updated_by = 5,
2053: sf.file_version_id = file_version_id_list(j),

Line 2050: ad_snapshot_files sf

2046:
2047: if file_id_list.count > 0 then
2048: forall j in file_id_list.first.. file_id_list.last
2049: update /*+ INDEX(SF AD_SNAPSHOT_FILES_U2) */
2050: ad_snapshot_files sf
2051: set sf.last_update_date = sysdate,
2052: sf.last_updated_by = 5,
2053: sf.file_version_id = file_version_id_list(j),
2054: sf.update_source_id = -1,

Line 2094: delete from ad_snapshot_files sf

2090:
2091: if nvl(l_deleted_ru_file_ids.last, 0) > 0 then
2092:
2093: forall i in l_deleted_ru_file_ids.first..l_deleted_ru_file_ids.last
2094: delete from ad_snapshot_files sf
2095: where sf.snapshot_id = l_global_snapshot_id and
2096: sf.file_id = l_deleted_ru_file_ids(i)
2097: and not exists
2098: (

Line 2100: from ad_snapshot_files sf1

2096: sf.file_id = l_deleted_ru_file_ids(i)
2097: and not exists
2098: (
2099: select 'Exists in the curr vw of some appltop'
2100: from ad_snapshot_files sf1
2101: where sf1.file_id = l_deleted_ru_file_ids(i)
2102: and nvl(sf1.containing_file_id, -1) = nvl(sf.containing_file_id, -1)
2103: and sf1.snapshot_id in (
2104: select s.snapshot_id

Line 2371: insert into ad_snapshot_files

2367: and sb2.bugfix_id = sbs.bugfix_id);
2368:
2369: l_snapshot_bugs_inserted := sql%rowcount;
2370:
2371: insert into ad_snapshot_files
2372: (
2373: snapshot_file_id,
2374: snapshot_id, file_id, containing_file_id,
2375: file_version_id,

Line 2381: ad_snapshot_files_s.nextval,

2377: creation_date, last_update_date, last_updated_by, created_by,
2378: dest_file_id, file_type_flag
2379: )
2380: select
2381: ad_snapshot_files_s.nextval,
2382: l_curr_vw_snapshot_id, file_id, containing_file_id,
2383: file_version_id,
2384: update_source_id, update_type,
2385: sysdate, sysdate, 5, 5,

Line 2387: from ad_snapshot_files sf

2383: file_version_id,
2384: update_source_id, update_type,
2385: sysdate, sysdate, 5, 5,
2386: dest_file_id, file_type_flag
2387: from ad_snapshot_files sf
2388: where sf.snapshot_id = l_preseeded_snapshot_id
2389:
2390: -- Added for bug 3947949
2391: -- and ((sf.server_type_admin_flag = l_server_type_admin_flag

Line 2401: and not exists (select /+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) /

2397: -- (sf.server_type_web_flag = l_server_type_web_flag
2398: -- and l_server_type_web_flag = 'Y')
2399: -- )
2400:
2401: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
2402: 'Already exists' from ad_snapshot_files sf2
2403: where sf2.snapshot_id = l_curr_vw_snapshot_id
2404: and sf2.file_id = sf.file_id
2405: and nvl(sf2.containing_file_id, -1) =

Line 2402: 'Already exists' from ad_snapshot_files sf2

2398: -- and l_server_type_web_flag = 'Y')
2399: -- )
2400:
2401: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
2402: 'Already exists' from ad_snapshot_files sf2
2403: where sf2.snapshot_id = l_curr_vw_snapshot_id
2404: and sf2.file_id = sf.file_id
2405: and nvl(sf2.containing_file_id, -1) =
2406: nvl(sf.containing_file_id, -1));