DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_DELIVERY_LEGS_PVT

Line 10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

6: --
7:
8: -- forward declaration
9: PROCEDURE Get_Disabled_List (
10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
11: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
13: , x_return_status OUT NOCOPY VARCHAR2
14: );

Line 12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

8: -- forward declaration
9: PROCEDURE Get_Disabled_List (
10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
11: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
13: , x_return_status OUT NOCOPY VARCHAR2
14: );
15:
16: PROCEDURE Delivery_Leg_Action(

Line 273: WSH_DELIVERY_LEGS_PVT.Lock_Delivery_Leg(

269: SAVEPOINT action_genbol_sp;
270:
271: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1) THEN
272:
273: WSH_DELIVERY_LEGS_PVT.Lock_Delivery_Leg(
274: p_rowid => p_rec_attr_tab(l_index).rowid,
275: p_delivery_leg_info => p_rec_attr_tab(l_index));
276:
277: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 804: l_delivery_leg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;

800: l_api_version_number CONSTANT NUMBER := 1.0;
801: l_api_name CONSTANT VARCHAR2(30) := 'Update_Delivery_Leg';
802: l_debug_on BOOLEAN;
803: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_DELIVERY_LEGS';
804: l_delivery_leg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;
805:
806: l_return_status VARCHAR2(1);
807: l_num_warnings NUMBER;
808: l_num_errors NUMBER;

Line 895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);

891:
892: END IF;
893:
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);
896: END IF;
897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(
898: p_rowid => NULL,
899: p_delivery_leg_info => l_delivery_leg_rec,

Line 897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(

893:
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);
896: END IF;
897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(
898: p_rowid => NULL,
899: p_delivery_leg_info => l_delivery_leg_rec,
900: x_return_status => l_return_status);
901:

Line 953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

949: END Update_Delivery_Leg;
950:
951:
952: PROCEDURE Get_Disabled_List (
953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
954: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
956: , x_return_status OUT NOCOPY VARCHAR2
957: ) IS

Line 955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

951:
952: PROCEDURE Get_Disabled_List (
953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
954: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
956: , x_return_status OUT NOCOPY VARCHAR2
957: ) IS
958:
959: cursor c_get_leg_record(p_dleg_id in number) IS

Line 1037: l_dleg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;

1033: l_api_version_number CONSTANT NUMBER := 1.0;
1034: l_api_name CONSTANT VARCHAR2(30) := 'Get_Disabled_List';
1035: l_debug_on BOOLEAN;
1036: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_Disabled_List';
1037: l_dleg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;
1038:
1039: Begin
1040:
1041: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;