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 415: FROM WSH_NEW_DELIVERIES

411: , reason_of_transport
412: , description
413: --Bug 9795691 - adding ignore_for_planning columnn
414: , ignore_for_planning
415: FROM WSH_NEW_DELIVERIES
416: WHERE delivery_id = p_delivery_id;
417: --
418: BEGIN
419: --

Line 600: p_in_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

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

Line 601: p_out_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type) IS

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

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

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

Line 774: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

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

Line 784: --l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

780: --
781: l_num_warnings NUMBER := 0;
782: l_num_errors NUMBER := 0;
783: --
784: --l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
785: --l_del_out_rec_tab wsh_delveries_grp.Del_Out_Tbl_Type;
786: --
787: l_debug_on BOOLEAN;
788: --

Line 792: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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