APPS.CSI_RESUBMIT_PUB SQL Statements

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

Line: 24

      SELECT msg_id,
             msg_code,
             msg_status,
             body_text,
             description
      FROM   xnp_msgs
      WHERE  msg_code like 'CSI%'
      AND    msg_status in ('FAILED', 'REJECTED');

Line: 114

    IF p_option    = 'SELECTED' THEN
      -- process only the records in csi_txn_errors with processed_flag = 'R'
      resubmit_error_txns(errbuf,retcode,p_option);

Line: 150

    SELECT seeded_flag,source_application_id
    FROM   csi_txn_types
    WHERE  transaction_type_id = pc_txn_type_id;

Line: 162

    UPDATE csi_txn_errors
    SET    processed_flag = 'Y'
    WHERE  transaction_error_id = p_error_rec.transaction_error_id;

Line: 251

      SELECT cte.*
      FROM   csi_txn_errors cte,
             mtl_material_transactions mmt
      WHERE  cte.processed_flag IN (l_val_1,l_val_2)
      AND    cte.inv_material_transaction_id = mmt.transaction_id(+)
      ORDER BY mmt.creation_date asc , mmt.transaction_id asc;

Line: 264

     ELSIF process_flag = 'SELECTED' THEN
        l_val_1 := 'R';

Line: 300

          DELETE from csi_txn_errors
          WHERE  transaction_error_id = error_rec.transaction_error_id;

Line: 313

          UPDATE csi_txn_errors
          SET    processed_flag       = 'E',
                 error_text           = l_error_message ,
                 last_update_date     = sysdate,
                 last_update_login    = fnd_global.login_id,
                 last_updated_by      = fnd_global.user_id
          WHERE  transaction_error_id = error_rec.transaction_error_id;