DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_TXN_ERRORS

Line 5076: FROM csi_txn_errors

5072: CURSOR err_txn_cur(
5073: p_transaction_id NUMBER,
5074: p_transfer_transaction_id NUMBER) IS
5075: SELECT inv_material_transaction_id
5076: FROM csi_txn_errors
5077: WHERE inv_material_transaction_id IS NOT NULL
5078: AND inv_material_transaction_id IN (p_transaction_id, p_transfer_transaction_id)
5079: AND processed_flag IN ('R','E');
5080:

Line 5379: -- check against csi_txn_errors

5375: ELSE
5376: l_xfer_mtl_txn_id := -999999;
5377: END IF;
5378:
5379: -- check against csi_txn_errors
5380: -- Begin modification for bug 6755879, FP of bug 6680634
5381: FOR err_txn_rec IN err_txn_cur(
5382: p_transaction_id => l_mtl_txn_tbl(l_ind).transaction_id,
5383: p_transfer_transaction_id => l_xfer_mtl_txn_id)