APPS.QA_AUDIT_PKG SQL Statements

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

Line: 17

      SELECT char_id,result_column_name
      FROM qa_plan_chars
      WHERE plan_id = x_plan_id;

Line: 27

    g_qb_result_columns.DELETE;

Line: 28

    g_que_result_columns.DELETE;

Line: 29

    g_master_result_columns.DELETE;

Line: 51

    CURSOR c1 IS SELECT QA_COLLECTION_ID_S.NEXTVAL FROM DUAL;

Line: 67

    CURSOR c2 IS SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL FROM DUAL;

Line: 79

 FUNCTION common_insert_sql
            RETURN VARCHAR2 IS


 l_sql_string VARCHAR2(1000);

Line: 86

   l_sql_string := 'INSERT INTO qa_results (     collection_id, ' ||
                                                '  occurrence,  ' ||
                                                '  last_update_date, ' ||
                                                '  qa_last_update_date, '||
                                                '  last_updated_by, ' ||
                                                '  qa_last_updated_by, ' ||
                                                '  creation_date,  ' ||
                                                '  qa_creation_date, ' ||
                                                '  created_by, ' ||
                                                '  last_update_login, ' ||
                                                '  qa_created_by, ' ||
                                                '  status, ' ||
                                                '  transaction_number, ' ||
                                                '  organization_id, ' ||
                                                '  plan_id, ' ||
                                                '  txn_header_id, ' ||
                                           g_que_result_columns(qa_ss_const.standard_violated) || ', ' ||
                                           g_que_result_columns(qa_ss_const.section_violated)  || ', ' ||
                                           g_que_result_columns(qa_ss_const.audit_area)        || ', ' ||
                                           g_que_result_columns(qa_ss_const.question_category) || ', ' ||
                                           g_que_result_columns(qa_ss_const.question_code)     || ', ' ||
                                           g_que_result_columns(qa_ss_const.audit_question)    || ') ' ||
                                        ' SELECT   :1,  ' ||
                                             '     QA_OCCURRENCE_S.NEXTVAL, ' ||
                                             '     sysdate, ' ||
                                             '     sysdate, ' ||
                                             '     fnd_global.user_id, ' ||
                                             '     fnd_global.user_id, ' ||
                                             '     sysdate, ' ||
                                             '     sysdate, ' ||
                                             '     fnd_global.user_id, ' ||
                                             '     fnd_global.user_id, ' ||
                                             '     fnd_global.user_id, ' ||
                                             '     2, ' ||
                                             '     -1, ' ||
                                             '     :2, ' || -- question and response org_id
                                             '     :3, ' || -- questions and resp plan_id
                                             '     :4,  ' || -- x_txn_header_id,
                                           g_qb_result_columns(qa_ss_const.standard_violated) || ', ' ||
                                           g_qb_result_columns(qa_ss_const.section_violated)  || ', ' ||
                                           g_qb_result_columns(qa_ss_const.audit_area)        || ', ' ||
                                           g_qb_result_columns(qa_ss_const.question_category) || ', ' ||
                                           g_qb_result_columns(qa_ss_const.question_code)     || ', ' ||
                                           g_qb_result_columns(qa_ss_const.audit_question)    || '  ' ||
                                       ' FROM  QA_RESULTS QR ' ||
                                       ' WHERE QR.PLAN_ID = :5 ' ||-- qb_plan_id
                                       ' AND QR.ORGANIZATION_ID = :6 '; -- qb_org_id

Line: 139

 END common_insert_sql;

Line: 175

    l_sql_string := common_insert_sql ||
                    ' AND ' ||  g_qb_result_columns(qa_ss_const.standard_violated) ||
                    ' IN (SELECT NAME ' ||
                        ' FROM QA_PERFORMANCE_TEMP ' ||
                        ' WHERE KEY = :7) ';

Line: 241

    l_sql_string := common_insert_sql ||
                  ' AND ' || g_qb_result_columns(qa_ss_const.standard_violated) || ' = :7 '||
                  ' AND ' || g_qb_result_columns(qa_ss_const.section_violated)  || ' = :8 '||
                  ' AND ' || g_qb_result_columns(qa_ss_const.audit_area)        || ' = :9 '||
                  ' AND ' || g_qb_result_columns(qa_ss_const.question_category) || ' = :10 ';

Line: 293

  SELECT qr.plan_id,
         qr.collection_id,
         qr.occurrence
  FROM  qa_results qr, qa_pc_plan_relationship qppr
  WHERE qr.plan_id = qppr.parent_plan_id
  AND qppr.child_plan_id = x_id
  AND qr.organization_id = x_org_id
  AND (qr.status = 2 OR qr.status IS NULL)
  AND qr.sequence6 = x_audit_num;

Line: 316

  SELECT count(OCCURRENCE)
  FROM QA_RESULTS
  WHERE plan_id = p_audit_que_plan_id
  AND collection_id = p_collection_id;