APPS.WSH_TRIPS_PVT dependencies on WSH_DELIVERY_LEGS

Line 437: FROM wsh_delivery_legs wdl,

433: WHERE rowid = v_rowid;
434:
435: CURSOR trip_deliveries (l_trip_id IN NUMBER) IS
436: SELECT delivery_id
437: FROM wsh_delivery_legs wdl,
438: wsh_trip_stops wts
439: WHERE wts.trip_id = l_trip_id
440: AND wdl.pick_up_stop_id = wts.stop_id;
441:

Line 567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

563: --
564: -- Debug Statements
565: --
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
568: END IF;
569: --
570: wsh_delivery_legs_actions.unassign_deliveries(l_del_ids, l_trip_id, NULL, NULL, l_return_status);
571:

Line 570: wsh_delivery_legs_actions.unassign_deliveries(l_del_ids, l_trip_id, NULL, NULL, l_return_status);

566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
568: END IF;
569: --
570: wsh_delivery_legs_actions.unassign_deliveries(l_del_ids, l_trip_id, NULL, NULL, l_return_status);
571:
572: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
573:
574: ROLLBACK TO SAVEPOINT unassign_del;

Line 727: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl

723: l_rowid VARCHAR2(30);
724:
725: CURSOR c_iscarriersmcchanged IS
726: SELECT wnd.organization_id, wnd.name
727: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl
728: WHERE wnd.delivery_id=wdl.delivery_id
729: and wdl.pick_up_stop_id=wts.stop_id
730: and wts.trip_id = p_trip_info.trip_id
731: and (carrier_id <> p_trip_info.carrier_id