APPS.AD_PATCH_HIST_MIGR_PKG dependencies on AD_RELEASES

Line 73: AD_RELEASES_PVT.CreateRelease

69: raise_application_error(-20000, 'Invalid release - '||
70: G_CURRENT_RELEASE);
71: end if;
72:
73: AD_RELEASES_PVT.CreateRelease
74: (
75: p_major_version => to_number(substr(G_CURRENT_RELEASE, 1, l1-1)),
76: p_minor_version => to_number(substr(G_CURRENT_RELEASE, l1+1, l2-l1-1)),
77: p_tape_version => to_number(substr(G_CURRENT_RELEASE, l2+1, l3-l2)),

Line 486: from ad_releases

482: if p_record_against_rlse is not null then
483: begin
484: select release_id
485: into G_REC_ALL_PTCHS_ON_RLSE_ID
486: from ad_releases
487: where major_version = p_maj_v
488: and minor_version = p_min_v
489: and to_char(major_version)||'.'||to_char(minor_version)||'.'||
490: to_char(tape_version) = p_record_against_rlse;

Line 563: from ad_releases

559: if p_record_against_rlse is null then
560: begin
561: select release_id
562: into l_rec_this_ptch_on_rlse_id
563: from ad_releases
564: where major_version = p_maj_v
565: and minor_version = p_min_v
566: and tape_version = p_tap_v;
567: exception when no_data_found then

Line 580: from ad_releases

576: else
577: begin
578: select release_id
579: into l_upd_to_rlse_id
580: from ad_releases
581: where major_version = p_upd_to_maj_v
582: and minor_version = p_upd_to_min_v
583: and tape_version = p_upd_to_tap_v;
584: