APPS.AD_PATCH_IMPACT_API SQL Statements

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

Line: 13

     select bug_number from
     ad_pa_analysis_run_bugs  where analysis_run_id = X_anal_req_id and
     (analysis_status in ('READY', 'MISSING') or analysis_status is null);

Line: 24

    select priority_request_id into req_id from fnd_concurrent_requests where
    request_id = fnd_global.conc_request_id;

Line: 29

    SELECT
      fcr.request_id into anal_req_id
    FROM
      fnd_application fa,
      fnd_concurrent_requests fcr,
      fnd_concurrent_programs fcp
    WHERE
      fcr.priority_request_id     = req_id and
      fcr.program_application_id  = fcp.application_id and
      fcp.application_id          = fa.application_id and
      fcr.concurrent_program_id   = fcp.concurrent_program_id and
      fa.application_short_name   = 'AD' and
      fcp.concurrent_program_name  in ('PATCHANALYSIS', 'PAANALYSIS','PADOWNLOADPATCHES','PAANALYZEPATCHES','PARECOMMENDPATCHES' ) ;

Line: 68

      SELECT aparb.bug_number, aparb.baseline, app.patch_id
      FROM  ad_pa_analysis_run_bugs  aparb,
            ad_pm_patches app
      WHERE aparb.analysis_run_id = X_anal_req_id
      AND aparb.bug_number = app.bug_number
      AND aparb.baseline = app.baseline
      AND app.patch_metadata_key = 'DEFAULT'
      AND (aparb.analysis_status IN ('READY', 'MISSING')
          OR aparb.analysis_status IS NULL);

Line: 89

    SELECT priority_request_id
    INTO req_id
    FROM fnd_concurrent_requests
    WHERE request_id = fnd_global.conc_request_id;

Line: 95

    SELECT
      fcr.request_id into anal_req_id
    FROM
      fnd_application fa,
      fnd_concurrent_requests fcr,
      fnd_concurrent_programs fcp
    WHERE
        fcr.priority_request_id     = req_id
    AND fcr.program_application_id  = fcp.application_id
    AND fcp.application_id          = fa.application_id
    AND fcr.concurrent_program_id   = fcp.concurrent_program_id
    AND fa.application_short_name   = 'AD'
    AND fcp.concurrent_program_name  in
        ('PATCHANALYSIS', 'PAANALYSIS','PADOWNLOADPATCHES','PAANALYZEPATCHES','PARECOMMENDPATCHES' ) ;

Line: 141

    SELECT
      snp.snapshot_id into snap_id
    FROM
      ad_snapshots       snp,
      ad_appl_tops       aat,
      fnd_product_groups fpg
    WHERE
      snp.snapshot_type            = 'G'               and
      snp.snapshot_name            = 'GLOBAL_VIEW'     and
      snp.appl_top_id              = aat.appl_top_id   and
      aat.applications_system_name = fpg.applications_system_name and
      fpg.product_group_id         = 1;

Line: 178

    SELECT
      distinct(prereq_bug_number) prereq_bug_num ,
      prereq_bug_order
    FROM
      ad_pa_anal_bug_deps
    WHERE
      analysis_run_id = X_anal_req_id and
      bug_number = X_bug_number
      order by prereq_bug_order;

Line: 191

    SELECT
      priority_request_id INTO req_id
    FROM
      fnd_concurrent_requests
    WHERE
      request_id = fnd_global.conc_request_id;

Line: 199

    SELECT
      fcr.request_id INTO anal_req_id
    FROM
      fnd_application fa,
      fnd_concurrent_requests fcr,
      fnd_concurrent_programs fcp
    WHERE
      fcr.priority_request_id = req_id    and
      fcr.program_application_id = fcp.application_id and
      fcp.application_id = fa.application_id and
      fcr.concurrent_program_id = fcp.concurrent_program_id and
      fa.application_short_name = 'AD' and
      fcp.concurrent_program_name in
        ('PATCHANALYSIS', 'PAANALYSIS','PADOWNLOADPATCHES','PAANALYZEPATCHES','PARECOMMENDPATCHES' ) ;

Line: 245

     SELECT
       distinct(prereq_bug_number) prereq_bug_num ,
       prereq_bug_order
     FROM   ad_pa_anal_bug_deps
     WHERE  analysis_run_id = X_anal_req_id AND
       bug_number = X_bug_number
     ORDER BY prereq_bug_order;