APPS.QA_ERES_DEFER SQL Statements

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

Line: 17

 PROCEDURE update_res_col
             (p_status_code   IN VARCHAR2,
              p_plan_id       IN NUMBER,
              p_collection_id IN NUMBER,
              p_occurrence    IN NUMBER
             ) IS
---------------------------------------------------------------------

   l_sql_string  VARCHAR2(1000);

Line: 32

   l_sql_string := 'UPDATE qa_results SET ' || l_res_col ||' = :1'
                   ||' WHERE plan_id = :2'
                   ||' and collection_id = :3'
                   ||' and occurrence = :4';

Line: 46

 END update_res_col;

Line: 64

    SELECT  'Y'
    FROM    EDR_PSIG_DOCUMENTS
    WHERE   event_name = c_event_name
    AND     event_key = c_event_key;

Line: 82

  PROCEDURE update_collection_col
            (p_status_code   IN VARCHAR2,
             p_plan_id       IN NUMBER,
             p_collection_id IN NUMBER,
             p_txn_header_id IN NUMBER
            ) IS

    -- Bug 5508639. SHKALYAN 13-Sep-2006.
    -- New cursor to get result occurrences based on txn_header_id
    -- Modified the name of the old cursor to get_results_col
    CURSOR  get_results_txn( c_txn_header_id NUMBER, c_collection_id NUMBER , c_plan_id NUMBER ) IS
    SELECT  occurrence
    FROM    QA_RESULTS
    WHERE   collection_id = c_collection_id
    AND     txn_header_id = c_txn_header_id
    AND     plan_id = c_plan_id;

Line: 100

    SELECT  occurrence
    FROM    QA_RESULTS
    WHERE   collection_id = c_collection_id
    AND     plan_id = c_plan_id;

Line: 117

        update_res_col(p_status_code,
                       p_plan_id,
                       p_collection_id,
                       l_occurrence);

Line: 134

        update_res_col(p_status_code,
                       p_plan_id,
                       p_collection_id,
                       l_occurrence);

Line: 145

  END update_collection_col;

Line: 151

 PROCEDURE spec_status_update
              (p_spec_id  in number
              ) IS
---------------------------------------------------------------------

   l_status_code NUMBER;

Line: 169

   l_sql_string := 'UPDATE qa_specs SET spec_status = :1'
                   ||' WHERE spec_id = :2';

Line: 180

 END spec_status_update;

Line: 203

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 231

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 260

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 288

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 317

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 347

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 380

     update_res_col(l_status_code,
                    p_plan_id,
                    p_collection_id,
                    p_occurrence);

Line: 412

     update_collection_col(l_status_code,
                           p_plan_id,
                           p_collection_id,
                           NULL);

Line: 446

     update_collection_col(l_status_code,
                           p_plan_id,
                           p_collection_id,
                           p_txn_header_id);