APPS.WSH_INBOUND_TXN_HISTORY_PKG dependencies on WSH_INBOUND_TXN_HISTORY_S

Line 91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;

87: --
88: l_index := x_inboundTxnHistory_recTbl.transaction_type.NEXT(l_index);
89: --}
90: END LOOP;
91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
92: --l_txn_id := wsh_inbound_txn_history_s.nextval;
93:
94: FORALL i IN x_inboundTxnHistory_recTbl.transaction_type.FIRST..x_inboundTxnHistory_recTbl.transaction_type.LAST
95: insert into wsh_inbound_txn_history

Line 92: --l_txn_id := wsh_inbound_txn_history_s.nextval;

88: l_index := x_inboundTxnHistory_recTbl.transaction_type.NEXT(l_index);
89: --}
90: END LOOP;
91: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
92: --l_txn_id := wsh_inbound_txn_history_s.nextval;
93:
94: FORALL i IN x_inboundTxnHistory_recTbl.transaction_type.FIRST..x_inboundTxnHistory_recTbl.transaction_type.LAST
95: insert into wsh_inbound_txn_history
96: (TRANSACTION_ID,

Line 120: values(wsh_inbound_txn_history_s.nextval,

116: LAST_UPDATED_BY,
117: CREATION_DATE,
118: CREATED_BY,
119: LAST_UPDATE_LOGIN)
120: values(wsh_inbound_txn_history_s.nextval,
121: x_inboundTxnHistory_recTbl.RECEIPT_NUMBER(i),
122: x_inboundTxnHistory_recTbl.REVISION_NUMBER(i),
123: x_inboundTxnHistory_recTbl.SHIPMENT_NUMBER(i),
124: x_inboundTxnHistory_recTbl.TRANSACTION_TYPE(i),

Line 437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;

433: wsh_util_core.add_message(x_return_status,l_module_name);
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;
439:
440: insert into wsh_inbound_txn_history
441: (TRANSACTION_ID,

Line 438: --l_txn_id := wsh_inbound_txn_history_s.nextval;

434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;
439:
440: insert into wsh_inbound_txn_history
441: (TRANSACTION_ID,
442: RECEIPT_NUMBER,

Line 465: values(wsh_inbound_txn_history_s.nextval,

461: LAST_UPDATED_BY,
462: CREATION_DATE,
463: CREATED_BY,
464: LAST_UPDATE_LOGIN)
465: values(wsh_inbound_txn_history_s.nextval,
466: p_txn_history_rec.RECEIPT_NUMBER,
467: p_txn_history_rec.REVISION_NUMBER,
468: p_txn_history_rec.SHIPMENT_NUMBER,
469: p_txn_history_rec.TRANSACTION_TYPE,