APPS.WSH_ROUTING_RESPONSE_PKG dependencies on WSH_TRIPS

Line 431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt

427: -- Get the pickup stop Id, trip Id
428: --
429: CURSOR c_GetPickupStopId(p_delId IN NUMBER) IS
430: SELECT wdl.pick_up_stop_id, wt.trip_id, wnd.name, wt.planned_flag, wnd.planned_flag
431: FROM wsh_trip_stops wts, wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_Trips wt
432: WHERE wnd.delivery_id = p_delId
433: and wnd.delivery_id = wdl.delivery_id
434: and wdl.pick_up_stop_id = wts.stop_id
435: and wnd.initial_pickup_location_id = wts.stop_location_id

Line 653: WSH_TRIPS_ACTIONS.Plan(p_trip_rows => l_tripIdTab,

649: IF l_planDelSts AND
650: NVL(l_tripPlanFlag, 'N') NOT IN ('F', 'P') THEN
651: --{
652: l_tripIdTab(l_tripIdTab.COUNT+1) := l_tripId;
653: WSH_TRIPS_ACTIONS.Plan(p_trip_rows => l_tripIdTab,
654: p_action => 'PLAN',
655: x_return_status => l_retStatus);
656: --
657: wsh_util_core.api_post_call(p_return_status => l_retStatus,

Line 669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', WSH_TRIPS_PVT.Get_Name(l_tripId));

665: wsh_debug_sv.logmsg(l_moduleName, 'Error in TripPlan API');
666: END IF;
667: --
668: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_PLAN_ERROR');
669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', WSH_TRIPS_PVT.Get_Name(l_tripId));
670: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
671: --}
672: END IF;
673: --}

Line 1640: FROM wsh_trips

1636:
1637: --Cursor to get carrier,Mode of transport,Service level and load tender status for a trip.
1638: CURSOR validate_trip_csr(p_trip_id NUMBER) IS
1639: SELECT carrier_id,mode_of_transport,service_level, load_tender_status
1640: FROM wsh_trips
1641: WHERE trip_id = p_trip_id;
1642: --
1643:
1644: --Cursor to get carrier name.