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: 36

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

Line: 50

 END update_res_col;

Line: 68

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

Line: 86

  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: 104

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

Line: 121

        update_res_col(p_status_code,
                       p_plan_id,
                       p_collection_id,
                       l_occurrence);

Line: 138

        update_res_col(p_status_code,
                       p_plan_id,
                       p_collection_id,
                       l_occurrence);

Line: 149

  END update_collection_col;

Line: 155

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

   l_status_code NUMBER;

Line: 173

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

Line: 184

 END spec_status_update;

Line: 207

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 235

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 264

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 292

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 321

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 351

   update_res_col(l_status_code,
                  p_plan_id,
                  p_collection_id,
                  p_occurrence);

Line: 384

     update_res_col(l_status_code,
                    p_plan_id,
                    p_collection_id,
                    p_occurrence);

Line: 416

     update_collection_col(l_status_code,
                           p_plan_id,
                           p_collection_id,
                           NULL);

Line: 450

     update_collection_col(l_status_code,
                           p_plan_id,
                           p_collection_id,
                           p_txn_header_id);