DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES

Line 1: PACKAGE WSH_NEW_DELIVERIES_PVT AUTHID CURRENT_USER as

1: PACKAGE WSH_NEW_DELIVERIES_PVT AUTHID CURRENT_USER as
2: /* $Header: WSHDETHS.pls 120.4 2010/08/06 16:16:47 anvarshn ship $ */
3:
4: -- CONSTANTS declaration --
5: --

Line 211: TMS_INTERFACE_FLAG WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,

207: DESCRIPTION VARCHAR2(30),
208: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
209: PRORATE_WT_FLAG VARCHAR2(1),
210: --OTM R12
211: TMS_INTERFACE_FLAG WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
212: TMS_VERSION_NUMBER WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE,
213: --
214: --R12.1.1 STANDALONE PROJECT
215: PENDING_ADVICE_FLAG WSH_NEW_DELIVERIES.PENDING_ADVICE_FLAG%TYPE,

Line 212: TMS_VERSION_NUMBER WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE,

208: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
209: PRORATE_WT_FLAG VARCHAR2(1),
210: --OTM R12
211: TMS_INTERFACE_FLAG WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
212: TMS_VERSION_NUMBER WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE,
213: --
214: --R12.1.1 STANDALONE PROJECT
215: PENDING_ADVICE_FLAG WSH_NEW_DELIVERIES.PENDING_ADVICE_FLAG%TYPE,
216: CLIENT_ID NUMBER, -- LSP PROJECT Modified R12.1.1 LSP PROJECT

Line 215: PENDING_ADVICE_FLAG WSH_NEW_DELIVERIES.PENDING_ADVICE_FLAG%TYPE,

211: TMS_INTERFACE_FLAG WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
212: TMS_VERSION_NUMBER WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE,
213: --
214: --R12.1.1 STANDALONE PROJECT
215: PENDING_ADVICE_FLAG WSH_NEW_DELIVERIES.PENDING_ADVICE_FLAG%TYPE,
216: CLIENT_ID NUMBER, -- LSP PROJECT Modified R12.1.1 LSP PROJECT
217: CLIENT_CODE VARCHAR2(10), -- LSP PROJECT
218: CONSIGNEE_FLAG VARCHAR2(1) --RTV changes
219: );

Line 366: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries

362: -- Bug 3292364
363: -- Procedure: Table_To_Record
364: -- Parameters: x_delivery_rec: A record of all attributes of a Delivery Record
365: -- p_delivery_id : delivery_id of the delivery that is to be copied
366: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries
367: -- and copy it to a record.
368:
369: PROCEDURE Table_to_Record (p_delivery_id IN NUMBER,
370: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

Line 370: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

366: -- Description: This procedure will copy the attributes of a delivery in wsh_new_deliveries
367: -- and copy it to a record.
368:
369: PROCEDURE Table_to_Record (p_delivery_id IN NUMBER,
370: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
371: x_return_status OUT NOCOPY VARCHAR2);
372:
373: --OTM R12
374: PROCEDURE UPDATE_TMS_INTERFACE_FLAG (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

Line 380: END WSH_NEW_DELIVERIES_PVT;

376: x_return_status OUT NOCOPY VARCHAR2);
377:
378: --
379:
380: END WSH_NEW_DELIVERIES_PVT;