APPS.AD_PA_SUBMIT_REQUEST dependencies on AD_PM_PATCHES

Line 645: -- Patchlist contains the set of unique patch_id from ad_pm_patches tables

641: pos := 1;
642: l_bugnum := 0;
643: l_baseline := '';
644: -- Append a ',' to the patch list if it has some patches.
645: -- Patchlist contains the set of unique patch_id from ad_pm_patches tables
646: lPatchList := trim(pPatchList);
647: if (length(lPatchList) > 1) then
648: lPatchList := concat(lPatchList, ',');
649: end if;

Line 660: FROM ad_pm_patches

656: lPatchList := substr(lPatchList, pos+1);
657: --buglist(count1) := to_number(bugno);
658: SELECT bug_number, baseline
659: INTO l_bugnum, l_baseline
660: FROM ad_pm_patches
661: WHERE patch_id = patchid;
662:
663: l_rec.bug_number := l_bugnum;
664: l_rec.baseline := l_baseline;