APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_BUGS

Line 492: -- for the existence of bug_number in AD_BUGS

488: -- Check for the existence of BUG_NUMBER, BASELINE in Snapshot tables for global snapshot.
489: -- If found then set output status as 'APPLIED'
490: -- msailoz bug#5505349
491: -- If baseline is not provided or patch is baseline independent only search
492: -- for the existence of bug_number in AD_BUGS
493:
494: IF ( length(trim(p_baseline)) = 0 OR p_baseline = 'R12') THEN
495:
496: SELECT count(SNAPSHOT_BUG_ID) INTO l_count

Line 499: (SELECT bug_id FROM AD_BUGS

495:
496: SELECT count(SNAPSHOT_BUG_ID) INTO l_count
497: FROM ad_snapshot_bugfixes
498: WHERE bugfix_id in
499: (SELECT bug_id FROM AD_BUGS
500: WHERE bug_number = to_char(p_bug_number)
501: AND ARU_RELEASE_NAME = p_release)
502: AND snapshot_id in
503: (SELECT snapshot_id

Line 518: (SELECT bug_id FROM AD_BUGS

514:
515: SELECT count(SNAPSHOT_BUG_ID) INTO l_count
516: FROM ad_snapshot_bugfixes
517: WHERE bugfix_id in
518: (SELECT bug_id FROM AD_BUGS
519: WHERE bug_number = to_char(p_bug_number)
520: AND baseline_name = adj_baseline
521: AND ARU_RELEASE_NAME = p_release)
522: AND snapshot_id in