APPS.AD_FILE_UTIL dependencies on AD_SNAPSHOTS

Line 1525: update ad_snapshots set last_update_date = sysdate

1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1522: raise;
1523: end;
1524:
1525: update ad_snapshots set last_update_date = sysdate
1526: where snapshot_id = snp_id;
1527:
1528: --
1529: --

Line 2448: from ad_snapshots s, ad_appl_tops t

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;

Line 2506: insert into ad_snapshots

2502: where appl_top_type = 'G' and
2503: name = 'GLOBAL' and
2504: applications_system_name = p_apps_system_name;
2505:
2506: insert into ad_snapshots
2507: (
2508: snapshot_id, release_id, appl_top_id, snapshot_name,
2509: snapshot_creation_date,
2510: snapshot_update_date,

Line 2519: select ad_snapshots_s.nextval, l_release_id,

2515: last_updated_by,
2516: created_by,
2517: last_update_date
2518: )
2519: select ad_snapshots_s.nextval, l_release_id,
2520: l_appl_top_id,
2521: 'GLOBAL_VIEW',
2522: sysdate,
2523: sysdate,

Line 2532: from ad_snapshots s

2528: 5,
2529: 5,
2530: sysdate
2531: from dual where not exists(select 'Already exists'
2532: from ad_snapshots s
2533: where s.appl_top_id = l_appl_top_id
2534: and s.snapshot_type = l_global_snapshot_type
2535: and s.snapshot_name = 'GLOBAL_VIEW');
2536:

Line 2539: from ad_snapshots s

2535: and s.snapshot_name = 'GLOBAL_VIEW');
2536:
2537: /* Get Global snapshot ID for this Applications Sytem Name */
2538: select s.snapshot_id into l_global_snapshot_id
2539: from ad_snapshots s
2540: where s.snapshot_type = l_global_snapshot_type and
2541: s.snapshot_name = 'GLOBAL_VIEW' and
2542: s.appl_top_id = l_appl_top_id;
2543:

Line 2606: ad_snapshots snap,

2602: snapshot_id, ' ',
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

Line 2848: ad_snapshots snap,

2844: (patch_run_id)
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