[Home] [Help]
2444: end if;
2445:
2446: /* Compute total number of current view snapshots available */
2447: select count(*) into l_snapshot_count
2448: from ad_snapshots s, ad_appl_tops t
2449: where s.snapshot_type = l_current_snapshot_type and
2450: s.snapshot_name = 'CURRENT_VIEW' and
2451: s.appl_top_id = t.appl_top_id and
2452: t.applications_system_name = p_apps_system_name;
2460: where applications_system_name =
2461: p_apps_system_name);
2462:
2463: /* Create a dummy Appl_top called 'GLOBAL' */
2464: insert into ad_appl_tops
2465: (
2466: appl_top_id, name, applications_system_name, appl_top_type,
2467: description,
2468: server_type_admin_flag,
2475: last_updated_by,
2476: active_flag
2477: )
2478: select
2479: ad_appl_tops_s.nextval,
2480: 'GLOBAL', /* APPL_TOP type is 'G' */
2481: p_apps_system_name,
2482: 'G',
2483: 'Created for Global View Snapshot',
2490: sysdate,
2491: 5,
2492: 'N' /* ACTIVE_FLAG is set to 'N'. (Refer CONCURRENT_SESSIONS) */
2493: from dual where not exists(select 'Already exists'
2494: from ad_appl_tops t
2495: where t.name = 'GLOBAL' and
2496: t.appl_top_type = 'G' and
2497: t.applications_system_name = p_apps_system_name);
2498:
2497: t.applications_system_name = p_apps_system_name);
2498:
2499: /* Get 'GLOBAL' APPL_TOP_ID */
2500: select appl_top_id into l_appl_top_id
2501: from ad_appl_tops
2502: where appl_top_type = 'G' and
2503: name = 'GLOBAL' and
2504: applications_system_name = p_apps_system_name;
2505:
2603: ' ',' ',' ',
2604: sysdate
2605: from
2606: ad_snapshots snap,
2607: ad_appl_tops atp,
2608: ad_releases ar,
2609: fnd_product_groups fpg
2610: where
2611: atp.appl_top_id=snap.appl_top_id and
2845: select
2846: snapshot_id
2847: from
2848: ad_snapshots snap,
2849: ad_appl_tops atp,
2850: ad_releases ar,
2851: fnd_product_groups fpg
2852: where
2853: atp.appl_top_id=snap.appl_top_id and