DBA Data[Home] [Help]

APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_TRACKABLE_ENTITIES

Line 119: FROM ad_trackable_entities)

115: abbreviation abbr,
116: NVL(used_flag, 'Y') used_flag,
117: NVL(load_flag, 'N') load_flag,
118: codelevel te_level
119: FROM ad_trackable_entities)
120: LOOP
121: ghashLevel(rec.abbr) := rec.te_level;
122: ghashIfUsed(rec.abbr) := rec.used_flag;
123: ghashIfLoad(rec.abbr) := rec.load_flag;

Line 592: FROM ad_trackable_entities

588: BEGIN
589:
590: SELECT baseline
591: INTO l_te_baseline
592: FROM ad_trackable_entities
593: WHERE abbreviation = l_te_abbr;
594:
595: -- if the patch is not generic and doesn't match with the baseline
596: -- on customer instance then error out

Line 621: ad_trackable_entities ate

617: nvl(appei.baseline,0) intr_baseline,
618: nvl(ate.codelevel,0) curr_level,
619: nvl(appei.te_level,0) intr_level
620: FROM ad_pa_patch_entity_info appei,
621: ad_trackable_entities ate
622: WHERE appei.te_abbr = ate.abbreviation(+)
623: AND appei.patch_id = l_patch_id)
624: LOOP
625: debugPrint (rec.te_abbr ||' BASELINE (current,intr) ('|| rec.curr_baseline||', '||rec.intr_baseline