APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on AD_PA_ANAL_RUN_BUG_CODELEVELS

Line 405: -- Insert the introducing codelevel/baseline data in ad_pa_anal_run_bug_codelevels

401: l_tmpVar := ghashRequires.NEXT(l_tmpVar);
402: END LOOP;
403: END IF;
404:
405: -- Insert the introducing codelevel/baseline data in ad_pa_anal_run_bug_codelevels
406: IF (ghashLevelIntr.COUNT > 0) THEN
407: debugPrint ('Introducing :'|| ghashLevelIntr.COUNT );
408: l_tmpVar := ghashLevelIntr.FIRST; -- get subscript of first element
409:

Line 414: DELETE FROM ad_pa_anal_run_bug_codelevels

410: WHILE l_tmpVar IS NOT NULL LOOP
411: debugPrint ('Introducing for '|| l_tmpVar || ' Level: '|| getValueFromHash(l_tmpVar, ghashLevelIntr)||' Baseline:'||getValueFromHash(l_tmpVar, ghashBaselineIntr) );
412:
413: IF (p_overwrite) THEN
414: DELETE FROM ad_pa_anal_run_bug_codelevels
415: WHERE analysis_run_bug_id = l_analysis_run_bug_id
416: AND intr_te_abbr = l_tmpVar;
417: END IF;
418:

Line 422: INSERT INTO ad_pa_anal_run_bug_codelevels

418:
419: l_tmpLevel := getValueFromHash(l_tmpVar, ghashLevelIntr);
420: l_tmpBaseline := getValueFromHash(l_tmpVar, ghashBaselineIntr);
421:
422: INSERT INTO ad_pa_anal_run_bug_codelevels
423: (analysis_run_bug_id, intr_te_abbr, intr_te_level,
424: intr_te_baseline, intr_te_type,
425: created_by, creation_date, last_updated_by , last_update_date)
426: SELECT l_analysis_run_bug_id,

Line 437: ( SELECT 'x' FROM ad_pa_anal_run_bug_codelevels

433: p_user_id,
434: sysdate
435: FROM DUAL
436: WHERE NOT EXISTS
437: ( SELECT 'x' FROM ad_pa_anal_run_bug_codelevels
438: WHERE analysis_run_bug_id = l_analysis_run_bug_id
439: AND intr_te_abbr = l_tmpVar
440: );
441: