DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_TRANSACTIONS_HISTORY_PKG

Line 259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

255: from wsh_transactions_history
256: where transaction_id = v_trx_id;
257:
258:
259: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
260: l_trx_status wsh_transactions_history.transaction_status%TYPE;
261:
262: l_from_creation_date DATE;
263: l_to_creation_date DATE;

Line 782: p_transaction_rec IN WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,

778: -- logged in Wsh_Interface_Errors table.
779: --=============================================================================
780: --
781: PROCEDURE Process_Shipment_Request (
782: p_transaction_rec IN WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,
783: p_commit_flag IN VARCHAR2,
784: x_return_status OUT NOCOPY VARCHAR2 )
785: IS
786:

Line 866: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

862: l_delivery_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
863: l_detail_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
864: l_del_assgn_interface_tbl WSH_UTIL_CORE.Id_Tab_Type;
865: l_delivery_detail_tab WSH_UTIL_CORE.Id_Tab_Type;
866: l_transaction_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
867:
868: l_init_om_header_rec OM_Header_Rec_Type;
869: l_om_header_rec OM_Header_Rec_Type;
870: l_om_line_tbl_type OM_Line_Tbl_Type;

Line 2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);

2460: l_transaction_rec.transaction_status := 'ER';
2461:
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (
2468: p_txns_history_rec => l_transaction_rec,

Line 2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (

2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History', WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (
2468: p_txns_history_rec => l_transaction_rec,
2469: x_txns_id => l_transaction_rec.transaction_id,
2470: x_return_status => l_return_status );
2471: