[Home] [Help]
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
374:
375: end backfill_bugs_from_patch_hist;
376:
377:
378: -- Creates just the top level info (ad_appl_tops and ad_snapshots)
379: procedure get_create_global_view_header
380: (
381: p_apps_system_name varchar2,
382: p_is_run_flow boolean,
396: end if;
397:
398: select nvl(count(*), 0)
399: into p_count_appltops
400: from ad_appl_tops
401: where applications_system_name = p_apps_system_name
402: and active_flag = 'Y';
403:
404: /* Create a dummy appl_top called 'GLOBAL' (inactive) */
402: and active_flag = 'Y';
403:
404: /* Create a dummy appl_top called 'GLOBAL' (inactive) */
405:
406: insert into ad_appl_tops
407: (
408: appl_top_id, name, applications_system_name, appl_top_type,
409: description,
410: server_type_admin_flag, server_type_forms_flag,
412: creation_date, created_by, last_update_date, last_updated_by,
413: active_flag
414: )
415: select
416: ad_appl_tops_s.nextval, 'GLOBAL', p_apps_system_name, 'G',
417: 'Created for Global View Snapshot',
418: null, null,
419: null, null,
420: sysdate, 5, sysdate, 5,
420: sysdate, 5, sysdate, 5,
421: 'N'
422: from dual
423: where not exists (select 'Already exists'
424: from ad_appl_tops t
425: where t.name = 'GLOBAL'
426: and t.appl_top_type ='G'
427: and t.applications_system_name = p_apps_system_name);
428:
429: /* Get ID of above GLOBAL appl_top */
430:
431: select appl_top_id
432: into p_global_appl_top_id
433: from ad_appl_tops
434: where appl_top_type ='G'
435: and name = 'GLOBAL'
436: and applications_system_name = p_apps_system_name;
437:
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'
684: where snapshot_name ='GLOBAL_VIEW'
685: and snapshot_type= l_global_snapshot_type
686: and appl_top_id = (
687: select appl_top_id
688: from ad_appl_tops
689: where appl_top_type = 'G'
690: and name = 'GLOBAL'
691: and applications_system_name = p_apps_system_name
692: );
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||'%'
744: and ats.name = '*PRESEEDED*'
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
1264: put_line('Curr-vw snapshotid is '||to_char(l_snapshot_id));
1265: end if;
1266:
1267: select applications_system_name into l_apps_system_name
1268: from ad_appl_tops where appl_top_id = p_appl_top_id;
1269:
1270:
1271: /* Get Global snapshot ID for this Applications System */
1272:
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'
2311:
2312: begin
2313: select nvl(applications_system_name, '1 UNKNOWN 1'), name
2314: into l_apps_sys_nm, l_at_name
2315: from ad_appl_tops
2316: where appl_top_id = p_appl_top_id
2317: and appl_top_type = 'R';
2318: exception when no_data_found then
2319: raise_application_error(-20000,
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||'%'
2370: and ats.name = '*PRESEEDED*'
2430: -- nvl(at1.server_type_node_flag, 'N'), nvl(at1.server_type_web_flag, 'N')
2431: -- into
2432: -- l_server_type_admin_flag, l_server_type_forms_flag,
2433: -- l_server_type_node_flag, l_server_type_web_flag
2434: -- from ad_appl_tops at1
2435: -- where at1.appl_top_id = p_appl_top_id;
2436:
2437: -- Bugs
2438: