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 88: l_DelTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 89: l_DeliveryTab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 90: v_DelRec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

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

Line 809: x_DelivRec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

805:
806:
807:
808: PROCEDURE BuildDelivRec(p_DelivRec IN t_DelivRec,
809: x_DelivRec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
810: x_RetSts OUT NOCOPY VARCHAR2) IS
811: --
812: l_debugOn BOOLEAN;
813: l_moduleName CONSTANT VARCHAR2(2000) := 'wsh.plsql.' || G_PKG_NAME || '.BuildDelivRec';