[Home] [Help]
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
347:
348: end backfill_bugs_from_patch_hist;
349:
350:
351: -- Creates just the top level info (ad_appl_tops and ad_snapshots)
352: procedure get_create_global_view_header
353: (
354: p_apps_system_name varchar2,
355: p_global_appl_top_id out nocopy number,
360: begin
361:
362: select nvl(count(*), 0)
363: into p_count_appltops
364: from ad_appl_tops
365: where applications_system_name = p_apps_system_name
366: and active_flag = 'Y';
367:
368: /* Create a dummy appl_top called 'GLOBAL' (inactive) */
366: and active_flag = 'Y';
367:
368: /* Create a dummy appl_top called 'GLOBAL' (inactive) */
369:
370: insert into ad_appl_tops
371: (
372: appl_top_id, name, applications_system_name, appl_top_type,
373: description,
374: server_type_admin_flag, server_type_forms_flag,
376: creation_date, created_by, last_update_date, last_updated_by,
377: active_flag
378: )
379: select
380: ad_appl_tops_s.nextval, 'GLOBAL', p_apps_system_name, 'G',
381: 'Created for Global View Snapshot',
382: null, null,
383: null, null,
384: sysdate, 5, sysdate, 5,
384: sysdate, 5, sysdate, 5,
385: 'N'
386: from dual
387: where not exists (select 'Already exists'
388: from ad_appl_tops t
389: where t.name = 'GLOBAL'
390: and t.appl_top_type = 'G'
391: and t.applications_system_name = p_apps_system_name);
392:
393: /* Get ID of above GLOBAL appl_top */
394:
395: select appl_top_id
396: into p_global_appl_top_id
397: from ad_appl_tops
398: where appl_top_type = 'G'
399: and name = 'GLOBAL'
400: and applications_system_name = p_apps_system_name;
401:
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'
626: where snapshot_name ='GLOBAL_VIEW'
627: and snapshot_type= 'G'
628: and appl_top_id = (
629: select appl_top_id
630: from ad_appl_tops
631: where appl_top_type = 'G'
632: and name = 'GLOBAL'
633: and applications_system_name = p_apps_system_name
634: );
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||'%'
686: and ats.name = '*PRESEEDED*'
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'
1187: put_line('Curr-vw snapshotid is '||to_char(l_snapshot_id));
1188: end if;
1189:
1190: select applications_system_name into l_apps_system_name
1191: from ad_appl_tops where appl_top_id = p_appl_top_id;
1192:
1193:
1194: /* Get Global snapshot ID for this Applications System */
1195:
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'
2231:
2232: begin
2233: select nvl(applications_system_name, '1 UNKNOWN 1'), name
2234: into l_apps_sys_nm, l_at_name
2235: from ad_appl_tops
2236: where appl_top_id = p_appl_top_id
2237: and appl_top_type = 'R';
2238: exception when no_data_found then
2239: raise_application_error(-20000,
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||'%'
2280: and ats.name = '*PRESEEDED*'
2340: -- nvl(at1.server_type_node_flag, 'N'), nvl(at1.server_type_web_flag, 'N')
2341: -- into
2342: -- l_server_type_admin_flag, l_server_type_forms_flag,
2343: -- l_server_type_node_flag, l_server_type_web_flag
2344: -- from ad_appl_tops at1
2345: -- where at1.appl_top_id = p_appl_top_id;
2346:
2347: -- Bugs
2348: