DBA Data[Home] [Help]

APPS.WSH_DATA_PROTECTION dependencies on WSH_TRIP_STOPS

Line 83: FROM wsh_trip_stops

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

Line 206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_DISABLED_LIST',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 209: WSH_TRIP_STOPS_PVT.Get_Disabled_List(

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,