APPS.WIP_MTLINTERFACEPROC_PUB SQL Statements

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

Line: 66

                                      p_delete_stack => fnd_api.g_false);

Line: 78

      select transaction_interface_id, error_code, error_explanation
        bulk collect into l_intTbl, l_errCodeTbl, l_errExpTbl
        from mtl_transactions_interface
       where transaction_header_id = p_txnHdrID
         and process_flag = 3;

Line: 87

        update mtl_transactions_interface
           set error_code = l_errCodeTbl(i),
               error_explanation = l_errExpTbl(i),
               process_flag = wip_constants.mti_error
         where transaction_header_id = p_txnHdrID
           and transaction_interface_id = l_intTbl(i);

Line: 110

                                      p_delete_stack => fnd_api.g_false);

Line: 112

      update mtl_transactions_interface
         set error_code = 'wip_mtlInterfaceProc_pub.processInterface()',
             error_explanation = l_errMessage,
             process_flag = wip_constants.mti_error
       where transaction_header_id = p_txnHdrID;

Line: 127

      select error_explanation
        from mtl_transactions_interface
       where transaction_interface_id = p_txnIntID;

Line: 151

    select rowid, transaction_header_id
      into l_rowID, l_txnHdrID
      from mtl_transactions_interface
     where transaction_interface_id = p_txnIntID
       and transaction_source_type_id = 5
       and process_flag = wip_constants.mti_inventory;

Line: 191

                                      p_delete_stack => fnd_api.g_false);

Line: 206

                                      p_delete_stack => fnd_api.g_false);

Line: 223

                                      p_delete_stack => fnd_api.g_false);

Line: 239

                                      p_delete_stack => fnd_api.g_false);

Line: 260

      select rowid,
             transaction_interface_id txnIntID
        from mtl_transactions_interface
       where transaction_header_id = p_txnHdrID
         and process_flag = 1;

Line: 267

      select transaction_temp_id txnTmpID,
             transaction_action_id txnActionID,
             completion_transaction_id cplTxnID,
             move_transaction_id movTxnID
        from mtl_material_transactions_temp
       where transaction_header_id = p_txnHdrID;