[Home] [Help]
245:
246: end if;
247:
248: --Bug 7255366 nissubra---
249: update ad_snapshots set snapshot_update_date = sysdate
250: where snapshot_id in (p_snapshot_id, p_global_snapshot_id);
251:
252: commit;
253:
267: end if;
268:
269: select s.appl_top_id, aat.applications_system_name, aat.name
270: into l_appl_top_id, l_apps_sys_nm, l_at_name
271: from ad_snapshots s, ad_appl_tops aat
272: where s.appl_top_id = aat.appl_top_id
273: and s.snapshot_id = p_snapshot_id;
274:
275: begin
416: ran_snapshot_flag,
417: creation_date, last_updated_by, created_by, last_update_date
418: )
419: select
420: ad_snapshots_s.nextval, l_release_id,
421: p_global_appl_top_id, 'GLOBAL_VIEW',
422: sysdate, sysdate,
423: 'G', 'Created from Current View Snapshots',
424: 'N',
473: end if;
474:
475: select snapshot_id
476: bulk collect into l_cv_ids
477: from ad_snapshots s, ad_appl_tops at1
478: where s.appl_top_id = at1.appl_top_id
479: and at1.applications_system_name = p_apps_system_name
480: and at1.appl_top_type = 'R'
481: and at1.active_flag = 'Y'
677: --
678:
679: select ss.snapshot_id
680: into l_preseeded_snapshot_id
681: from ad_snapshots ss, -- seeded
682: ad_appl_tops ats -- seeded
683: where ss.appl_top_id = ats.appl_top_id
684: and ss.snapshot_type = 'B'
685: and ss.snapshot_name like '*PRESEEDED*'||p_release_name||'%'
815: 'EXPLICIT', 'IMPLICIT'),
816: decode(min(decode(success_flag, 'N', 1, 2)), 1, 'N', 'Y')
817: from ad_snapshot_bugfixes
818: where snapshot_id in (select snapshot_id
819: from ad_snapshots s, ad_appl_tops at1
820: where s.appl_top_id = at1.appl_top_id
821: and at1.applications_system_name = p_apps_system_name
822: and at1.appl_top_type = 'R'
823: and s.snapshot_type = 'C'
1193:
1194: /* Get Global snapshot ID for this Applications System */
1195:
1196: select snapshot_id into l_global_snapshot_id
1197: from ad_snapshots s, ad_appl_tops t
1198: where s.snapshot_type = 'G' and
1199: s.snapshot_name = 'GLOBAL_VIEW' and
1200: s.appl_top_id = t.appl_top_id and
1201: t.applications_system_name = l_apps_system_name;
1801: ' new files in the curr-vw snapshot');
1802: end if;
1803:
1804: select count(*) into l_snapshot_count
1805: from ad_snapshots s, ad_appl_tops t
1806: where s.snapshot_type = 'C' and
1807: s.appl_top_id = t.appl_top_id and
1808: t.applications_system_name = l_apps_system_name;
1809:
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
2105: from ad_snapshots s, ad_appl_tops a
2106: where s.snapshot_type = 'C'
2107: and s.appl_top_id = a.appl_top_id
2108: and a.applications_system_name = l_apps_system_name
2109: and nvl(a.active_flag,'Y') = 'Y'
2117:
2118: end if;
2119:
2120: --Bug 7255366 nissubra---
2121: update ad_snapshots set last_update_date = sysdate,
2122: snapshot_update_date = sysdate
2123: where snapshot_id in (l_snapshot_id, l_global_snapshot_id);
2124:
2125: commit;
2271:
2272: begin
2273: select ss.snapshot_id, ss.release_id
2274: into l_preseeded_snapshot_id, l_preseeded_rlse_id
2275: from ad_snapshots ss, -- seeded
2276: ad_appl_tops ats -- seeded
2277: where ss.appl_top_id = ats.appl_top_id
2278: and ss.snapshot_type = 'B'
2279: and ss.snapshot_name like '*PRESEEDED*'||l_rlse_nm||'%'
2313: if l_curr_vw_snapshot_id = -1 then
2314:
2315: -- create new CV through pressed.
2316:
2317: select ad_snapshots_s.nextval into l_curr_vw_snapshot_id from dual;
2318:
2319: insert into ad_snapshots
2320: (
2321: snapshot_id,
2467: end if;
2468:
2469: p_return_code := G_INSTANTIATED_SNAPSHOT; -- Instantiated Snapshot
2470:
2471: select ad_snapshots_s.nextval into l_curr_vw_snapshot_id from dual;
2472:
2473: insert into ad_snapshots
2474: (
2475: snapshot_id,