APPS.WSH_INTERFACE_GRP dependencies on WSH_NEW_DELIVERIES

Line 143: FROM wsh_new_deliveries

139: and rownum=1;
140:
141: CURSOR delivery_ship_method (l_delivery_id NUMBER) IS
142: SELECT ship_method_code
143: FROM wsh_new_deliveries
144: WHERE delivery_id = l_delivery_id;
145:
146: -- Bug 4103142 - to get first trip for delivery
147: CURSOR c_first_ship_method (p_delivery_id IN number)IS

Line 149: FROM wsh_new_deliveries del,

145:
146: -- Bug 4103142 - to get first trip for delivery
147: CURSOR c_first_ship_method (p_delivery_id IN number)IS
148: SELECT wt.ship_method_code
149: FROM wsh_new_deliveries del,
150: wsh_delivery_legs dlg,
151: wsh_trip_stops st,
152: wsh_trips wt
153: WHERE del.delivery_id = dlg.delivery_id

Line 382: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

378: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
379: --
380: l_defaults_rec wsh_deliveries_grp.default_parameters_rectype;
381: --
382: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
383: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
384: --
385: l_debug_on BOOLEAN;
386: --

Line 413: FROM WSH_NEW_DELIVERIES

409: , shipping_control
410: --Added for bug 6625788
411: , reason_of_transport
412: , description
413: FROM WSH_NEW_DELIVERIES
414: WHERE delivery_id = p_delivery_id;
415: --
416: BEGIN
417: --

Line 596: p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

592: END Delivery_Action;
593:
594:
595: PROCEDURE Rtrim_deliveries_blank_space (
596: p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
597: p_out_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type) IS
598: l_debug_on BOOLEAN;
599: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
600: G_PKG_NAME || '.' || 'Rtrim_deliveries_blank_space';

Line 597: p_out_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type) IS

593:
594:
595: PROCEDURE Rtrim_deliveries_blank_space (
596: p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
597: p_out_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type) IS
598: l_debug_on BOOLEAN;
599: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' ||
600: G_PKG_NAME || '.' || 'Rtrim_deliveries_blank_space';
601: BEGIN

Line 762: -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information

758: -- p_rec_attr_tab Table of Attributes for the delivery entity
759: -- x_del_out_rec Record of delivery_id, and name of new deliveries,
760: -- VERSION : current version 1.0
761: -- initial version 1.0
762: -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
763: -- specified in p_delivery_info
764: --========================================================================
765: PROCEDURE Create_Update_Delivery
766: ( p_api_version_number IN NUMBER,

Line 770: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

766: ( p_api_version_number IN NUMBER,
767: p_init_msg_list IN VARCHAR2,
768: p_commit IN VARCHAR2 , -- default fnd_api.g_false
769: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
770: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
771: x_del_out_rec_tab OUT NOCOPY WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
772: x_return_status OUT NOCOPY VARCHAR2,
773: x_msg_count OUT NOCOPY NUMBER,
774: x_msg_data OUT NOCOPY VARCHAR2)

Line 780: --l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

776: --
777: l_num_warnings NUMBER := 0;
778: l_num_errors NUMBER := 0;
779: --
780: --l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
781: --l_del_out_rec_tab wsh_delveries_grp.Del_Out_Tbl_Type;
782: --
783: l_debug_on BOOLEAN;
784: --

Line 788: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

784: --
785: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_WRAPPER';
786: l_commit VARCHAR2(100) := FND_API.G_FALSE;
787: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
788: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
789: l_index NUMBER;
790: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
791: --
792: BEGIN