APPS.WSH_ROUTING_REQUEST dependencies on WSH_INBOUND_TXN_HISTORY

Line 4509: -- 3.Get the information from wsh_inbound_txn_history for party and receipt number.

4505: -- Pre-reqs : None.
4506: -- Procedure: API to validate Routing Request Header for Supplier,routing request number and revision. Api does
4507: -- 1.Validate revision number for negative.
4508: -- 2.Validate Supplier information.
4509: -- 3.Get the information from wsh_inbound_txn_history for party and receipt number.
4510: -- 4.If found then this is revision, Un-assign detail lines from delivery.
4511: -- 5.Store the current information in wsh_inbound_txn_history.
4512: -- Parameters :
4513: -- IN:

Line 4511: -- 5.Store the current information in wsh_inbound_txn_history.

4507: -- 1.Validate revision number for negative.
4508: -- 2.Validate Supplier information.
4509: -- 3.Get the information from wsh_inbound_txn_history for party and receipt number.
4510: -- 4.If found then this is revision, Un-assign detail lines from delivery.
4511: -- 5.Store the current information in wsh_inbound_txn_history.
4512: -- Parameters :
4513: -- IN:
4514: -- p_in_param IN Additional parameter passed from routing request UI.
4515: -- p_request_number IN Routing Request Number.

Line 4540: FROM wsh_inbound_txn_history

4536: --Cursor to test if routing request is new one or revision.
4537: CURSOR get_revision_number_csr(cp_request_number VARCHAR2,p_supplier_id
4538: NUMBER) IS
4539: SELECT revision_number,transaction_id
4540: FROM wsh_inbound_txn_history
4541: WHERE receipt_number = cp_request_number
4542: AND TRANSACTION_TYPE ='ROUTING_REQUEST'
4543: AND SUPPLIER_ID=p_supplier_id
4544: ORDER BY revision_number desc;

Line 4546: l_txn_rec WSH_INBOUND_TXN_HISTORY_PKG.ib_txn_history_rec_type;

4542: AND TRANSACTION_TYPE ='ROUTING_REQUEST'
4543: AND SUPPLIER_ID=p_supplier_id
4544: ORDER BY revision_number desc;
4545:
4546: l_txn_rec WSH_INBOUND_TXN_HISTORY_PKG.ib_txn_history_rec_type;
4547: l_revision_number NUMBER;
4548: l_num_warnings number;
4549: l_num_errors number;
4550:

Line 4645: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history (

4641: l_txn_rec.status:= 'PROCESSED';
4642: l_txn_rec.supplier_id := p_detail_att.vendor_id;
4643:
4644: --Store the header information in Inbound Txn History.
4645: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history (
4646: p_txn_history_rec => l_txn_rec,
4647: x_txn_id => p_detail_att.routing_req_id,
4648: x_return_status => l_return_status);
4649:

Line 4651: WSH_DEBUG_SV.log(l_module_name,'WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history

4647: x_txn_id => p_detail_att.routing_req_id,
4648: x_return_status => l_return_status);
4649:
4650: IF l_debug_on THEN
4651: WSH_DEBUG_SV.log(l_module_name,'WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history
4652: l_return_status',l_return_status);
4653: END IF;
4654: wsh_util_core.api_post_call(
4655: p_return_status => l_return_status,