APPS.QA_ERES_UTIL SQL Statements

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

Line: 17

      SELECT parent_occurrence, parent_collection_id, parent_plan_id
        FROM qa_pc_results_relationship qprr
     CONNECT BY prior qprr.parent_occurrence = qprr.child_occurrence
       START WITH qprr.child_occurrence = l_occ
    ORDER BY level desc;

Line: 63

    l_sql_string := 'SELECT '||l_res_col ||' FROM QA_RESULTS '
                    || 'WHERE plan_id = :1'
                    || ' AND collection_id = :2'
                    || ' AND occurrence = :3';

Line: 89

      SELECT meaning
      FROM   mfg_lookups
      WHERE  lookup_code = p_lookup_code
      AND    lookup_type = p_lookup_type;

Line: 119

       SELECT 'Y'
       FROM   QA_PLAN_CHARS
       WHERE  char_id = 2147483572
       AND    enabled_flag = 1
       AND    plan_id = c_plan_id;

Line: 154

     SELECT  MAX( prompt_sequence ) + 10
     FROM    QA_PLAN_CHARS
     WHERE   plan_id = c_plan_id;

Line: 166

        SELECT
            nvl( max( to_number(substr(result_column_name,10,3)) ), 0 )
        FROM qa_plan_chars qpc,
            qa_chars qc
        WHERE qpc.plan_id = c_plan_id
            AND qc.char_id = qpc.char_id
            AND qc.hardcoded_column is null
            AND qc.datatype in (1,2,3,6);

Line: 199

     INSERT INTO QA_PLAN_CHARS
     (
          plan_id,
          char_id,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          prompt_sequence,
          prompt,
          enabled_flag,
          mandatory_flag,
          read_only_flag,
          ss_poplist_flag,
          information_flag,
          values_exist_flag,
          displayed_flag,
          result_column_name
     )
     VALUES
     (
          p_plan_id,
          l_char_id,
          SYSDATE,
          l_user_id,
          SYSDATE,
          l_user_id,
          l_prompt_seq,
          l_prompt,
          1,
          2,
          1,
          2,
          2,
          2,
          1,
          l_result_column
     );

Line: 243

     SELECT qa_plan_char_action_triggers_s.nextval
     INTO   l_qpcat_id
     FROM   dual;

Line: 248

     INSERT INTO qa_plan_char_action_triggers
     (
           plan_char_action_trigger_id,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           trigger_sequence,
           plan_id,
           char_id,
           operator,
           low_value_lookup,
           high_value_lookup,
           low_value_other,
           high_value_other,
           low_value_other_id,
           high_value_other_id
     )
     VALUES
     (
           l_qpcat_id,
           sysdate,
           l_user_id,
           sysdate,
           l_user_id,
           10,
           p_plan_id,
           l_char_id,
           1,
           NULL,
           NULL,
           'PENDING',
           NULL,
           NULL,
           NULL
     );

Line: 286

     SELECT qa_plan_char_actions_s.nextval
     INTO   l_qpca_id
     FROM   dual;

Line: 291

     l_message := FND_MESSAGE.get_string( 'QA', 'QA_ERES_CANNOT_UPDATE_RESULT' );

Line: 293

     INSERT INTO qa_plan_char_actions
     (
         plan_char_action_id,
         last_update_date,
         last_updated_by,
         creation_date,
         created_by,
         plan_char_action_trigger_id,
         action_id,
         message,
         assign_type
     )
     VALUES
     (
         l_qpca_id,
         sysdate,
         l_user_id,
         sysdate,
         l_user_id,
         l_qpcat_id,
         2,
         l_message,
         --'Results may not be entered while the eSignature Status is Pending.',
         'F'
     );

Line: 373

   	CURSOR c(coll_id IN varchar2) is SELECT distinct plan_id
                 FROM qa_results
                 WHERE plan_id || '-' || collection_id || '-' || occurrence NOT IN
                      (SELECT child_plan_id || '-' || child_collection_id || '-' || child_occurrence
                       FROM qa_pc_results_relationship
                       WHERE parent_collection_id = coll_id)
                 AND collection_id = coll_id;

Line: 401

     CURSOR c(coll_id IN varchar2, l_plan_id IN varchar2) is SELECT plan_id || '-' || collection_id || '-' || occurrence doc_id
                 FROM qa_results
                 WHERE plan_id = l_plan_id
                 AND collection_id = coll_id;