APPS.WSH_SHIPMENT_ADVICE_PKG dependencies on WSH_NEW_DEL_INTERFACE

Line 5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE := '94X_INBOUND';

1: PACKAGE BODY WSH_SHIPMENT_ADVICE_PKG AS
2: /* $Header: WSHSAPKB.pls 120.1 2011/12/21 10:12:56 skanduku noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_SHIPMENT_ADVICE_PKG';
5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE := '94X_INBOUND';
6:
7: --
8: --=============================================================================
9: -- PUBLIC PROCEDURE :

Line 202: Wsh_New_Del_Interface wndi

198: wth.Attribute14,
199: wth.Attribute15,
200: null
201: FROM Wsh_Transactions_History wth,
202: Wsh_New_Del_Interface wndi
203: WHERE wndi.interface_action_code = g_interface_action_code
204: AND wndi.delivery_interface_id = to_number(wth.entity_number)
205: AND wth.transaction_id = p_transaction_id
206: AND wth.transaction_status = nvl(p_transaction_status, wth.transaction_status);

Line 306: l_transaction_query := l_transaction_query || ' Wsh_New_Del_Interface wndi ';

302: l_transaction_query := l_transaction_query || 'wth.Attribute15 ';
303:
304: --FROM Clause
305: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';
306: l_transaction_query := l_transaction_query || ' Wsh_New_Del_Interface wndi ';
307: l_transaction_query := l_transaction_query || ' WHERE wth.document_type = ''SA'' ';
308: l_transaction_query := l_transaction_query || ' AND wth.document_direction = ''I'' ';
309:
310: IF p_from_document_number is not null and p_to_document_number is not null