79: WHERE trip_id = x_entity_id;
80:
81: CURSOR get_stop_status(x_stop_id NUMBER) IS
82: SELECT status_code
83: FROM wsh_trip_stops
84: WHERE stop_id = x_stop_id;
85:
86: CURSOR get_leg_status(x_leg_id NUMBER) IS
87: SELECT delivery_id, pick_up_stop_id, drop_off_stop_id
202: --
203: -- Debug Statements
204: --
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
207: END IF;
208: --
209: WSH_TRIP_STOPS_PVT.Get_Disabled_List(
210: p_stop_id => p_entity_id,
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);
207: END IF;
208: --
209: WSH_TRIP_STOPS_PVT.Get_Disabled_List(
210: p_stop_id => p_entity_id,
211: p_parent_entity_id => p_parent_entity_id,
212: p_list_type => p_list_type,
213: x_return_status => x_return_status,