APPS.AD_FILE_UTIL dependencies on AD_SNAPSHOTS_S

Line 1459: update ad_snapshots set last_update_date = sysdate

1455: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1456: raise;
1457: end;
1458:
1459: update ad_snapshots set last_update_date = sysdate
1460: where snapshot_id = snp_id;
1461:
1462: --
1463: --

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 2439: select ad_snapshots_s.nextval, l_release_id,

2435: last_updated_by,
2436: created_by,
2437: last_update_date
2438: )
2439: select ad_snapshots_s.nextval, l_release_id,
2440: l_appl_top_id,
2441: 'GLOBAL_VIEW',
2442: sysdate,
2443: sysdate,

Line 2452: from ad_snapshots s

2448: 5,
2449: 5,
2450: sysdate
2451: from dual where not exists(select 'Already exists'
2452: from ad_snapshots s
2453: where s.appl_top_id = l_appl_top_id
2454: and s.snapshot_type = 'G'
2455: and s.snapshot_name = 'GLOBAL_VIEW');
2456:

Line 2459: from ad_snapshots s

2455: and s.snapshot_name = 'GLOBAL_VIEW');
2456:
2457: /* Get Global snapshot ID for this Applications Sytem Name */
2458: select s.snapshot_id into l_global_snapshot_id
2459: from ad_snapshots s
2460: where s.snapshot_type = 'G' and
2461: s.snapshot_name = 'GLOBAL_VIEW' and
2462: s.appl_top_id = l_appl_top_id;
2463: