APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_PA_ANAL_RUN_BUG_PREREQS

Line 370: -- Insert the pre-req data in ad_pa_anal_run_bug_prereqs

366: WHERE analysis_run_id = p_analysis_run_id
367: AND bug_number = p_bug_number
368: AND baseline = p_baseline;
369:
370: -- Insert the pre-req data in ad_pa_anal_run_bug_prereqs
371: debugPrint ('PREREQ CNT:'|| ghashRequires.COUNT);
372:
373: IF(ghashRequires.COUNT > 0) THEN
374: l_tmpVar := ghashRequires.FIRST; -- get subscript of first element

Line 379: DELETE FROM ad_pa_anal_run_bug_prereqs

375: WHILE l_tmpVar IS NOT NULL LOOP
376: debugPrint ('Pre-req is '|| l_tmpVar ||' Level: '|| ghashRequires(l_tmpVar));
377:
378: IF (p_overwrite) THEN
379: DELETE FROM ad_pa_anal_run_bug_prereqs
380: WHERE analysis_run_bug_id = l_analysis_run_bug_id
381: AND prereq_te_abbr = l_tmpVar;
382: END IF;
383:

Line 384: INSERT INTO ad_pa_anal_run_bug_prereqs

380: WHERE analysis_run_bug_id = l_analysis_run_bug_id
381: AND prereq_te_abbr = l_tmpVar;
382: END IF;
383:
384: INSERT INTO ad_pa_anal_run_bug_prereqs
385: (analysis_run_bug_id, prereq_te_abbr, prereq_te_level,
386: created_by, creation_date, last_updated_by , last_update_date)
387: SELECT l_analysis_run_bug_id,
388: l_tmpVar ,

Line 396: ( SELECT 'x' FROM ad_pa_anal_run_bug_prereqs

392: p_user_id,
393: sysdate
394: FROM DUAL
395: WHERE NOT EXISTS
396: ( SELECT 'x' FROM ad_pa_anal_run_bug_prereqs
397: WHERE analysis_run_bug_id = l_analysis_run_bug_id
398: AND prereq_te_abbr = l_tmpVar
399: );
400: