136: x_inboundTxnHistory_recTbl.SHIPMENT_LINE_ID(i),
137: 1,
138: x_inboundTxnHistory_recTbl.SHIP_FROM_LOCATION_ID(i),-- IB-Phase-2
139: SYSDATE,
140: FND_GLOBAL.USER_ID,
141: SYSDATE,
142: FND_GLOBAL.USER_ID,
143: FND_GLOBAL.LOGIN_ID)
144: RETURNING transaction_id BULK COLLECT INTO x_inboundTxnHistory_recTbl.TRANSACTION_ID;
138: x_inboundTxnHistory_recTbl.SHIP_FROM_LOCATION_ID(i),-- IB-Phase-2
139: SYSDATE,
140: FND_GLOBAL.USER_ID,
141: SYSDATE,
142: FND_GLOBAL.USER_ID,
143: FND_GLOBAL.LOGIN_ID)
144: RETURNING transaction_id BULK COLLECT INTO x_inboundTxnHistory_recTbl.TRANSACTION_ID;
145: --
146: --
139: SYSDATE,
140: FND_GLOBAL.USER_ID,
141: SYSDATE,
142: FND_GLOBAL.USER_ID,
143: FND_GLOBAL.LOGIN_ID)
144: RETURNING transaction_id BULK COLLECT INTO x_inboundTxnHistory_recTbl.TRANSACTION_ID;
145: --
146: --
147: l_resultCount := SQL%ROWCOUNT;
481: p_txn_history_rec.SHIPMENT_LINE_ID,
482: 1,
483: p_txn_history_rec.SHIP_FROM_LOCATION_ID, -- IB-Phase-2
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: SYSDATE,
487: FND_GLOBAL.USER_ID,
488: FND_GLOBAL.LOGIN_ID)
489: RETURNING transaction_id into x_txn_id;
483: p_txn_history_rec.SHIP_FROM_LOCATION_ID, -- IB-Phase-2
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: SYSDATE,
487: FND_GLOBAL.USER_ID,
488: FND_GLOBAL.LOGIN_ID)
489: RETURNING transaction_id into x_txn_id;
490: --}
491: --
484: SYSDATE,
485: FND_GLOBAL.USER_ID,
486: SYSDATE,
487: FND_GLOBAL.USER_ID,
488: FND_GLOBAL.LOGIN_ID)
489: RETURNING transaction_id into x_txn_id;
490: --}
491: --
492: -- Debug Statements
822: NULL,SHIP_FROM_LOCATION_ID,
823: p_txn_history_rec.SHIP_FROM_LOCATION_ID),
824: -- } IB-Phase-2
825: LAST_UPDATE_DATE = SYSDATE,
826: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
827: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
828: where TRANSACTION_ID = p_txn_history_rec.transaction_id;
829: --}
830: --
823: p_txn_history_rec.SHIP_FROM_LOCATION_ID),
824: -- } IB-Phase-2
825: LAST_UPDATE_DATE = SYSDATE,
826: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
827: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
828: where TRANSACTION_ID = p_txn_history_rec.transaction_id;
829: --}
830: --
831: -- Debug Statements
1511: --
1512: IF p_action_code = 'REVERT'
1513: THEN
1514: l_txn_history_rec.status := C_PENDING;
1515: l_txn_history_rec.MATCH_REVERTED_BY := FND_GLOBAL.USER_ID;
1516: ELSIF p_action_code = 'CANCEL'
1517: THEN
1518: IF p_txn_type = C_ASN
1519: THEN
1533: ELSE
1534: l_txn_history_rec.status := C_MATCHED;
1535: END IF;
1536: --
1537: l_txn_history_rec.MATCHED_BY := FND_GLOBAL.USER_ID;
1538: --}
1539: END IF;
1540: --
1541: --