[Home] [Help]
272:
273: end if;
274:
275: --Bug 7255366 nissubra---
276: update ad_snapshots set snapshot_update_date = sysdate
277: where snapshot_id in (p_snapshot_id, p_global_snapshot_id);
278:
279: commit;
280:
294: end if;
295:
296: select s.appl_top_id, aat.applications_system_name, aat.name
297: into l_appl_top_id, l_apps_sys_nm, l_at_name
298: from ad_snapshots s, ad_appl_tops aat
299: where s.appl_top_id = aat.appl_top_id
300: and s.snapshot_id = p_snapshot_id;
301:
302: begin
452: ran_snapshot_flag,
453: creation_date, last_updated_by, created_by, last_update_date
454: )
455: select
456: ad_snapshots_s.nextval, l_release_id,
457: p_global_appl_top_id, 'GLOBAL_VIEW',
458: sysdate, sysdate,
459: l_snapshot_type, 'Created from Current View Snapshots',
460: 'N',
518: end if;
519:
520: select snapshot_id
521: bulk collect into l_cv_ids
522: from ad_snapshots s, ad_appl_tops at1
523: where s.appl_top_id = at1.appl_top_id
524: and at1.applications_system_name = p_apps_system_name
525: and at1.appl_top_type = 'R'
526: and at1.active_flag = 'Y'
735: --
736:
737: select ss.snapshot_id
738: into l_preseeded_snapshot_id
739: from ad_snapshots ss, -- seeded
740: ad_appl_tops ats -- seeded
741: where ss.appl_top_id = ats.appl_top_id
742: and ss.snapshot_type = 'B'
743: and ss.snapshot_name like '*PRESEEDED*'||p_release_name||'%'
874: 'EXPLICIT', 'IMPLICIT'),
875: decode(min(decode(success_flag, 'N', 1, 2)), 1, 'N', 'Y')
876: from ad_snapshot_bugfixes
877: where snapshot_id in (select snapshot_id
878: from ad_snapshots s, ad_appl_tops at1
879: where s.appl_top_id = at1.appl_top_id
880: and at1.applications_system_name = p_apps_system_name
881: and at1.appl_top_type = 'R'
882: and s.snapshot_type = l_current_snapshot_type
1270:
1271: /* Get Global snapshot ID for this Applications System */
1272:
1273: select snapshot_id into l_global_snapshot_id
1274: from ad_snapshots s, ad_appl_tops t
1275: where s.snapshot_type = l_global_snapshot_type and
1276: s.snapshot_name = 'GLOBAL_VIEW' and
1277: s.appl_top_id = t.appl_top_id and
1278: t.applications_system_name = l_apps_system_name;
1878: ' new files in the curr-vw snapshot');
1879: end if;
1880:
1881: select count(*) into l_snapshot_count
1882: from ad_snapshots s, ad_appl_tops t
1883: where s.snapshot_type = l_current_snapshot_type and
1884: s.appl_top_id = t.appl_top_id and
1885: t.applications_system_name = l_apps_system_name;
1886:
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
2183: from ad_snapshots s, ad_appl_tops a
2184: where s.snapshot_type = l_current_snapshot_type
2185: and s.appl_top_id = a.appl_top_id
2186: and a.applications_system_name = l_apps_system_name
2187: and nvl(a.active_flag,'Y') = 'Y'
2195:
2196: end if;
2197:
2198: --Bug 7255366 nissubra---
2199: update ad_snapshots set last_update_date = sysdate,
2200: snapshot_update_date = sysdate
2201: where snapshot_id in (l_snapshot_id, l_global_snapshot_id);
2202:
2203: commit;
2361:
2362: begin
2363: select ss.snapshot_id, ss.release_id
2364: into l_preseeded_snapshot_id, l_preseeded_rlse_id
2365: from ad_snapshots ss, -- seeded
2366: ad_appl_tops ats -- seeded
2367: where ss.appl_top_id = ats.appl_top_id
2368: and ss.snapshot_type = 'B'
2369: and ss.snapshot_name like '*PRESEEDED*'||l_rlse_nm||'%'
2403: if l_curr_vw_snapshot_id = -1 then
2404:
2405: -- create new CV through pressed.
2406:
2407: select ad_snapshots_s.nextval into l_curr_vw_snapshot_id from dual;
2408:
2409: insert into ad_snapshots
2410: (
2411: snapshot_id,
2557: end if;
2558:
2559: p_return_code := G_INSTANTIATED_SNAPSHOT; -- Instantiated Snapshot
2560:
2561: select ad_snapshots_s.nextval into l_curr_vw_snapshot_id from dual;
2562:
2563: insert into ad_snapshots
2564: (
2565: snapshot_id,