DBA Data[Home] [Help]

APPS.WSH_TRIP_CONSOLIDATION dependencies on WSH_NEW_DELIVERIES_PVT

Line 10: p_DeliveryTab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

6: * delivery records and selects only those whose indexes exist in
7: * p_IndexTab table
8: **/
9: PROCEDURE BuildDeliveryTable(p_IndexTab IN WSH_UTIL_CORE.ID_TAB_TYPE,
10: p_DeliveryTab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11: x_deliveryTab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) IS
12: --
13: l_debugOn BOOLEAN;
14: l_moduleName CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.BuildDeliveryTable';

Line 11: x_deliveryTab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) IS

7: * p_IndexTab table
8: **/
9: PROCEDURE BuildDeliveryTable(p_IndexTab IN WSH_UTIL_CORE.ID_TAB_TYPE,
10: p_DeliveryTab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11: x_deliveryTab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) IS
12: --
13: l_debugOn BOOLEAN;
14: l_moduleName CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.BuildDeliveryTable';
15: --

Line 89: l_DelTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

85: i NUMBER;
86: v_DelivRec t_DelivRec;
87: e_HashError EXCEPTION;
88: c_Deliv t_Cursor_ref;
89: l_DelTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
90: l_DeliveryTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
91: v_DelRec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
92: l_num_warnings NUMBER;
93: l_num_errors NUMBER;

Line 90: l_DeliveryTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

86: v_DelivRec t_DelivRec;
87: e_HashError EXCEPTION;
88: c_Deliv t_Cursor_ref;
89: l_DelTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
90: l_DeliveryTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
91: v_DelRec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
92: l_num_warnings NUMBER;
93: l_num_errors NUMBER;
94: v_HashTab HashTable;

Line 91: v_DelRec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

87: e_HashError EXCEPTION;
88: c_Deliv t_Cursor_ref;
89: l_DelTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
90: l_DeliveryTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
91: v_DelRec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
92: l_num_warnings NUMBER;
93: l_num_errors NUMBER;
94: v_HashTab HashTable;
95: v_DelivTab DelivTable;

Line 829: x_DelivRec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

825:
826:
827:
828: PROCEDURE BuildDelivRec(p_DelivRec IN t_DelivRec,
829: x_DelivRec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
830: x_RetSts OUT NOCOPY VARCHAR2) IS
831: --
832: l_debugOn BOOLEAN;
833: l_moduleName CONSTANT VARCHAR2(2000) := 'wsh.plsql.' || G_PKG_NAME || '.BuildDelivRec';