APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_RELEASES

Line 403: select release_id into l_release_id from ad_releases

399: and name = 'GLOBAL'
400: and applications_system_name = p_apps_system_name;
401:
402: /* Get the release id */
403: select release_id into l_release_id from ad_releases
404: where to_char(major_version) || '.' ||
405: to_char(minor_version) || '.' ||
406: to_char(tape_version) = (select release_name
407: from fnd_product_groups

Line 620: from ad_releases

616:
617: begin
618:
619: select release_id into l_release_id
620: from ad_releases
621: where major_version||'.'||minor_version||'.'||tape_version = p_release_name;
622:
623: begin
624: select snapshot_id into l_global_snapshot_id

Line 762: from ad_snapshots ads, ad_releases adr

758: if l_global_snapshot_id <> -1 then
759:
760: begin
761: select 'x' into l_dummy
762: from ad_snapshots ads, ad_releases adr
763: where ads.release_id = adr.release_id
764: and ads.snapshot_id = l_global_snapshot_id
765: and adr.major_version = ( select distinct major_version from ad_releases
766: where release_id = l_release_id );

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

761: select 'x' into l_dummy
762: from ad_snapshots ads, ad_releases adr
763: where ads.release_id = adr.release_id
764: and ads.snapshot_id = l_global_snapshot_id
765: and adr.major_version = ( select distinct major_version from ad_releases
766: where release_id = l_release_id );
767:
768: exception when no_data_found then
769: l_dummy := null;

Line 1156: AD_RELEASES_PVT.CreateRelease

1152: raise_application_error(-20000, 'Invalid release - '||
1153: l_curr_rlse_nm);
1154: end if;
1155:
1156: AD_RELEASES_PVT.CreateRelease
1157: (
1158: p_major_version => to_number(substr(l_curr_rlse_nm, 1, l1-1)),
1159: p_minor_version => to_number(substr(l_curr_rlse_nm, l1+1, l2-l1-1)),
1160: p_tape_version => to_number(substr(l_curr_rlse_nm, l2+1, l3-l2)),

Line 2227: from ad_releases

2223: select to_char(major_version)||'.'||
2224: to_char(minor_version)||'.'||
2225: to_char(tape_version)
2226: into l_rlse_nm
2227: from ad_releases
2228: where release_id = p_release_id;
2229:
2230: -- Fail if appl-top in question is invalid
2231:

Line 2436: from ad_snapshots ads, ad_releases adr

2432: if l_curr_vw_snapshot_id <> -1 then
2433:
2434: begin
2435: select 'x' into l_dummy
2436: from ad_snapshots ads, ad_releases adr
2437: where ads.release_id = adr.release_id
2438: and ads.snapshot_id = l_curr_vw_snapshot_id
2439: and adr.major_version = ( select distinct major_version from ad_releases
2440: where release_id = p_release_id );

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

2435: select 'x' into l_dummy
2436: from ad_snapshots ads, ad_releases adr
2437: where ads.release_id = adr.release_id
2438: and ads.snapshot_id = l_curr_vw_snapshot_id
2439: and adr.major_version = ( select distinct major_version from ad_releases
2440: where release_id = p_release_id );
2441:
2442: exception when no_data_found then
2443: l_dummy := null;