APPS.AD_PATCH_ANALYSIS_ENGINE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

    debugPrint ('----- Run the Analysis Engine and Update database------');

Line: 114

    (SELECT
        abbreviation abbr,
        NVL(used_flag, 'Y') used_flag,
        NVL(load_flag, 'N') load_flag,
        codelevel te_level
     FROM ad_trackable_entities)
    LOOP
      ghashLevel(rec.abbr) := rec.te_level;

Line: 131

    ghashLevelIntr.DELETE;

Line: 132

    ghashBaselineIntr.DELETE;

Line: 133

    ghashRequires.DELETE;

Line: 259

            SELECT GREATEST(l_value_1, l_value_2) INTO l_tmpVar FROM DUAL;

Line: 357

      SELECT analysis_run_bug_id INTO l_analysis_run_bug_id
      FROM   ad_pa_analysis_run_bugs
      WHERE   analysis_run_id = p_analysis_run_id
      AND     bug_number      = p_bug_number
      AND     baseline        = p_baseline;

Line: 364

        UPDATE ad_pa_analysis_run_bugs
        SET    analysis_status = l_patch_status
        WHERE  analysis_run_id = p_analysis_run_id
        AND     bug_number      = p_bug_number
        AND     baseline        = p_baseline;

Line: 379

              DELETE FROM ad_pa_anal_run_bug_prereqs
              WHERE analysis_run_bug_id = l_analysis_run_bug_id
              AND prereq_te_abbr = l_tmpVar;

Line: 384

            INSERT INTO ad_pa_anal_run_bug_prereqs
            (analysis_run_bug_id, prereq_te_abbr,  prereq_te_level,
             created_by,  creation_date,	last_updated_by , last_update_date)
            SELECT  l_analysis_run_bug_id,
                    l_tmpVar ,
                    ghashRequires(l_tmpVar),
                    p_user_id,
                    sysdate,
                    p_user_id,
                    sysdate
            FROM DUAL
            WHERE NOT EXISTS
            ( SELECT 'x' FROM ad_pa_anal_run_bug_prereqs
              WHERE analysis_run_bug_id = l_analysis_run_bug_id
              AND prereq_te_abbr = l_tmpVar
            );

Line: 414

              DELETE FROM ad_pa_anal_run_bug_codelevels
              WHERE analysis_run_bug_id = l_analysis_run_bug_id
              AND intr_te_abbr = l_tmpVar;

Line: 422

            INSERT INTO ad_pa_anal_run_bug_codelevels
            (analysis_run_bug_id, intr_te_abbr,  intr_te_level,
             intr_te_baseline, intr_te_type,
             created_by,  creation_date,	last_updated_by , last_update_date)
            SELECT  l_analysis_run_bug_id,
                    l_tmpVar ,
                    l_tmpLevel,
                    l_tmpBaseline,
                    null,
                    p_user_id,
                    sysdate,
                    p_user_id,
                    sysdate
            FROM DUAL
            WHERE NOT EXISTS
            ( SELECT 'x' FROM ad_pa_anal_run_bug_codelevels
              WHERE analysis_run_bug_id = l_analysis_run_bug_id
              AND intr_te_abbr = l_tmpVar
            );

Line: 495

      SELECT count(SNAPSHOT_BUG_ID) INTO l_count
      FROM ad_snapshot_bugfixes
      WHERE bugfix_id in
         (SELECT bug_id FROM AD_BUGS
         WHERE bug_number = to_char(p_bug_number)
  		   AND ARU_RELEASE_NAME = p_release)
      AND snapshot_id =
         (SELECT snapshot_id
          FROM ad_snapshots
  		    WHERE snapshot_name = 'GLOBAL_VIEW'
  		    and snapshot_type = 'G');

Line: 508

      SELECT count(SNAPSHOT_BUG_ID) INTO l_count
      FROM ad_snapshot_bugfixes
      WHERE bugfix_id in
         (SELECT bug_id FROM AD_BUGS
         WHERE bug_number = to_char(p_bug_number)
  		   AND baseline_name = p_baseline
  		   AND ARU_RELEASE_NAME = p_release)
      AND snapshot_id =
         (SELECT snapshot_id
          FROM ad_snapshots
  		    WHERE snapshot_name = 'GLOBAL_VIEW'
  		    and snapshot_type = 'G');

Line: 538

      SELECT  entity_abbr,
              patch_id,
              NVL(upload_run_id,-1),
              NVL(patch_type,'')
      INTO    l_te_abbr,
              l_patch_id,
              l_upload_id,
              l_patch_type
      FROM   ad_pm_patches
      WHERE  bug_number = p_bug_number
      AND    baseline = p_baseline;

Line: 579

        SELECT baseline
        INTO   l_te_baseline
        FROM   ad_trackable_entities
        WHERE  abbreviation = l_te_abbr;

Line: 604

      (SELECT appei.te_abbr,
              nvl(ate.baseline,0) curr_baseline,
	            nvl(appei.baseline,0) intr_baseline,
              nvl(ate.codelevel,0) curr_level,
	            nvl(appei.te_level,0) intr_level
       FROM  ad_pa_patch_entity_info appei,
             ad_trackable_entities ate
       WHERE appei.te_abbr = ate.abbreviation(+)
       AND   appei.patch_id = l_patch_id)
      LOOP
        debugPrint (rec.te_abbr ||' BASELINE (current,intr) ('|| rec.curr_baseline||', '||rec.intr_baseline
	       ||') CODELEVEL (current,intr) ('|| rec.curr_level||', '|| rec.intr_level||')');

Line: 654

      ( SELECT   appri.patch_requires_id,
                 appri.te_abbr,
                 appri.requires_te_abbr,
                 appri.requires_te_level ,
                 appcri.condition_type,
                 appcri.condition_te_abbr,
                 appcri.condition_te_level
        FROM  ad_pa_patch_requires_info appri,
        ad_pa_patch_cond_requires_info appcri
        WHERE appri.patch_id = l_patch_id
        AND   appri.patch_requires_id = appcri.patch_requires_id (+) )

      LOOP
        IF (rec.condition_type IS NULL) THEN
          addPrereq(rec.requires_te_abbr, rec.requires_te_level, ghashRequires);