5072: IF l_min_txn_id IS NOT NULL THEN
5073: Begin
5074: select source_transaction_date
5075: into l_src_txn_date
5076: from csi_transactions
5077: where transaction_id = l_min_txn_id;
5078: Exception
5079: when no_data_found then
5080: null;
5172: IF p_mode <> 'CREATE' THEN
5173: BEGIN
5174: SELECT 'Y'
5175: INTO l_txn_found
5176: FROM csi_transactions
5177: WHERE inv_material_transaction_id in (l_mtl_txn_tbl(l_ind).transaction_id, l_xfer_mtl_txn_id)
5178: AND rownum = 1;
5179: EXCEPTION
5180: WHEN no_data_found THEN