APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_BUGS

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

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

Line 498: (SELECT bug_id FROM AD_BUGS

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

Line 511: (SELECT bug_id FROM AD_BUGS

507:
508: SELECT count(SNAPSHOT_BUG_ID) INTO l_count
509: FROM ad_snapshot_bugfixes
510: WHERE bugfix_id in
511: (SELECT bug_id FROM AD_BUGS
512: WHERE bug_number = to_char(p_bug_number)
513: AND baseline_name = p_baseline
514: AND ARU_RELEASE_NAME = p_release)
515: AND snapshot_id =