APPS.AD_FILE_UTIL dependencies on AD_APPL_TOPS

Line 2368: from ad_snapshots s, ad_appl_tops t

2364: begin
2365:
2366: /* Compute total number of current view snapshots available */
2367: select count(*) into l_snapshot_count
2368: from ad_snapshots s, ad_appl_tops t
2369: where s.snapshot_type = 'C' and
2370: s.snapshot_name = 'CURRENT_VIEW' and
2371: s.appl_top_id = t.appl_top_id and
2372: t.applications_system_name = p_apps_system_name;

Line 2384: insert into ad_appl_tops

2380: where applications_system_name =
2381: p_apps_system_name);
2382:
2383: /* Create a dummy Appl_top called 'GLOBAL' */
2384: insert into ad_appl_tops
2385: (
2386: appl_top_id, name, applications_system_name, appl_top_type,
2387: description,
2388: server_type_admin_flag,

Line 2399: ad_appl_tops_s.nextval,

2395: last_updated_by,
2396: active_flag
2397: )
2398: select
2399: ad_appl_tops_s.nextval,
2400: 'GLOBAL', /* APPL_TOP type is 'G' */
2401: p_apps_system_name,
2402: 'G',
2403: 'Created for Global View Snapshot',

Line 2414: from ad_appl_tops t

2410: sysdate,
2411: 5,
2412: 'N' /* ACTIVE_FLAG is set to 'N'. (Refer CONCURRENT_SESSIONS) */
2413: from dual where not exists(select 'Already exists'
2414: from ad_appl_tops t
2415: where t.name = 'GLOBAL' and
2416: t.appl_top_type = 'G' and
2417: t.applications_system_name = p_apps_system_name);
2418:

Line 2421: from ad_appl_tops

2417: t.applications_system_name = p_apps_system_name);
2418:
2419: /* Get 'GLOBAL' APPL_TOP_ID */
2420: select appl_top_id into l_appl_top_id
2421: from ad_appl_tops
2422: where appl_top_type = 'G' and
2423: name = 'GLOBAL' and
2424: applications_system_name = p_apps_system_name;
2425:

Line 2518: ad_appl_tops atp

2514: ' ',' ',' ',
2515: sysdate
2516: from
2517: ad_snapshots snap,
2518: ad_appl_tops atp
2519: where
2520: atp.appl_top_id=snap.appl_top_id and
2521: atp.applications_system_name=p_applications_sys_name and
2522: nvl(atp.active_flag,'Y') = 'Y' and

Line 2743: ad_appl_tops atp

2739: select
2740: snapshot_id
2741: from
2742: ad_snapshots snap,
2743: ad_appl_tops atp
2744: where
2745: atp.appl_top_id=snap.appl_top_id and
2746: atp.applications_system_name=p_applications_sys_name and
2747: nvl(atp.active_flag,'Y') = 'Y' and