APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_DELIVERY_LEGS_PVT

Line 214: l_delivery_leg_info wsh_delivery_legs_pvt.delivery_leg_rec_type;

210:
211:
212: --2709662
213: l_trip_stop_info wsh_trip_stops_pvt.trip_stop_rec_type;
214: l_delivery_leg_info wsh_delivery_legs_pvt.delivery_leg_rec_type;
215: l_rowid VARCHAR2(30);
216: l_pickup_stop_id NUMBER;
217: l_dropoff_stop_id NUMBER;
218: l_pickup_location_id NUMBER;

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

1729: --
1730: -- Debug Statements
1731: --
1732: IF l_debug_on THEN
1733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
1734: END IF;
1735: --
1736: wsh_delivery_legs_pvt.create_delivery_leg(l_delivery_leg_info, l_rowid, l_leg_id, x_return_status);
1737:

Line 1736: wsh_delivery_legs_pvt.create_delivery_leg(l_delivery_leg_info, l_rowid, l_leg_id, x_return_status);

1732: IF l_debug_on THEN
1733: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
1734: END IF;
1735: --
1736: wsh_delivery_legs_pvt.create_delivery_leg(l_delivery_leg_info, l_rowid, l_leg_id, x_return_status);
1737:
1738: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1739: RAISE e_InvalidDelExcep; -- Bug 5336308
1740: END IF;

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

3175: --
3176: -- Debug Statements
3177: --
3178: IF l_debug_on THEN
3179: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
3180: END IF;
3181: --
3182: wsh_delivery_legs_pvt.delete_delivery_leg(NULL,
3183: l_del_leg_id, l_return_status);

Line 3182: wsh_delivery_legs_pvt.delete_delivery_leg(NULL,

3178: IF l_debug_on THEN
3179: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',WSH_DEBUG_SV.C_PROC_LEVEL);
3180: END IF;
3181: --
3182: wsh_delivery_legs_pvt.delete_delivery_leg(NULL,
3183: l_del_leg_id, l_return_status);
3184:
3185: END IF;
3186:

Line 3944: WSH_DELIVERY_LEGS_PVT.lock_dlvy_leg_no_compare(p_dlvy_leg_id => l_lock_delivery_leg_rec.parent_delivery_leg_id);

3940: SET reprice_required = 'Y'
3941: WHERE CURRENT OF c_lock_delivery_leg;
3942: IF l_lock_delivery_leg_rec.parent_delivery_leg_id IS NOT NULL THEN
3943: BEGIN
3944: WSH_DELIVERY_LEGS_PVT.lock_dlvy_leg_no_compare(p_dlvy_leg_id => l_lock_delivery_leg_rec.parent_delivery_leg_id);
3945: EXCEPTION
3946: WHEN OTHERS THEN
3947: IF c_lock_delivery_leg%ISOPEN THEN
3948: CLOSE c_lock_delivery_leg;