APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_RELEASES

Line 439: select release_id into l_release_id from ad_releases

435: and name = 'GLOBAL'
436: and applications_system_name = p_apps_system_name;
437:
438: /* Get the release id */
439: select release_id into l_release_id from ad_releases
440: where to_char(major_version) || '.' ||
441: to_char(minor_version) || '.' ||
442: to_char(tape_version) = (select release_name
443: from fnd_product_groups

Line 668: from ad_releases

664:
665: begin
666:
667: select release_id into l_release_id
668: from ad_releases
669: where major_version||'.'||minor_version||'.'||tape_version = p_release_name;
670:
671:
672: if (p_is_run_flow = TRUE)

Line 821: from ad_snapshots ads, ad_releases adr

817: if l_global_snapshot_id <> -1 then
818:
819: begin
820: select 'x' into l_dummy
821: from ad_snapshots ads, ad_releases adr
822: where ads.release_id = adr.release_id
823: and ads.snapshot_id = l_global_snapshot_id
824: and adr.major_version = ( select distinct major_version from ad_releases
825: where release_id = l_release_id );

Line 824: and adr.major_version = ( select distinct major_version from ad_releases

820: select 'x' into l_dummy
821: from ad_snapshots ads, ad_releases adr
822: where ads.release_id = adr.release_id
823: and ads.snapshot_id = l_global_snapshot_id
824: and adr.major_version = ( select distinct major_version from ad_releases
825: where release_id = l_release_id );
826:
827: exception when no_data_found then
828: l_dummy := null;

Line 1233: AD_RELEASES_PVT.CreateRelease

1229: raise_application_error(-20000, 'Invalid release - '||
1230: l_curr_rlse_nm);
1231: end if;
1232:
1233: AD_RELEASES_PVT.CreateRelease
1234: (
1235: p_major_version => to_number(substr(l_curr_rlse_nm, 1, l1-1)),
1236: p_minor_version => to_number(substr(l_curr_rlse_nm, l1+1, l2-l1-1)),
1237: p_tape_version => to_number(substr(l_curr_rlse_nm, l2+1, l3-l2)),

Line 2307: from ad_releases

2303: select to_char(major_version)||'.'||
2304: to_char(minor_version)||'.'||
2305: to_char(tape_version)
2306: into l_rlse_nm
2307: from ad_releases
2308: where release_id = p_release_id;
2309:
2310: -- Fail if appl-top in question is invalid
2311:

Line 2526: from ad_snapshots ads, ad_releases adr

2522: if l_curr_vw_snapshot_id <> -1 then
2523:
2524: begin
2525: select 'x' into l_dummy
2526: from ad_snapshots ads, ad_releases adr
2527: where ads.release_id = adr.release_id
2528: and ads.snapshot_id = l_curr_vw_snapshot_id
2529: and adr.major_version = ( select distinct major_version from ad_releases
2530: where release_id = p_release_id );

Line 2529: and adr.major_version = ( select distinct major_version from ad_releases

2525: select 'x' into l_dummy
2526: from ad_snapshots ads, ad_releases adr
2527: where ads.release_id = adr.release_id
2528: and ads.snapshot_id = l_curr_vw_snapshot_id
2529: and adr.major_version = ( select distinct major_version from ad_releases
2530: where release_id = p_release_id );
2531:
2532: exception when no_data_found then
2533: l_dummy := null;