DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_TXN_ERRORS

Line 4983: FROM csi_txn_errors

4979: CURSOR err_txn_cur(
4980: p_transaction_id NUMBER,
4981: p_transfer_transaction_id NUMBER) IS
4982: SELECT inv_material_transaction_id
4983: FROM csi_txn_errors
4984: WHERE inv_material_transaction_id IS NOT NULL
4985: AND inv_material_transaction_id IN (p_transaction_id, p_transfer_transaction_id)
4986: AND processed_flag IN ('R','E');
4987:

Line 5136: -- check against csi_txn_errors

5132: ELSE
5133: l_xfer_mtl_txn_id := -999999;
5134: END IF;
5135:
5136: -- check against csi_txn_errors
5137: -- Begin modification for bug 6755879, FP of bug 6680634
5138: FOR err_txn_rec IN err_txn_cur(
5139: p_transaction_id => l_mtl_txn_tbl(l_ind).transaction_id,
5140: p_transfer_transaction_id => l_xfer_mtl_txn_id)