APPS.WSH_OTM_OUTBOUND dependencies on WSH_TRIP_STOPS_PVT

Line 763: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG Total stops ids',l_upd_trip_stops.COUNT);

759: CLOSE get_trip_stops;
760: IF l_upd_trip_stops.COUNT > 0 THEN
761: --{
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG Total stops ids',l_upd_trip_stops.COUNT);
764: END IF;
765: --
766: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
767: (P_STOP_ID_TAB=>l_upd_trip_stops,

Line 766: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG

762: IF l_debug_on THEN
763: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG Total stops ids',l_upd_trip_stops.COUNT);
764: END IF;
765: --
766: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
767: (P_STOP_ID_TAB=>l_upd_trip_stops,
768: P_TMS_INTERFACE_FLAG_TAB =>l_upd_tms_interface_flags,
769: X_RETURN_STATUS =>l_return_status);
770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

Line 2007: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG

2003: IF l_debug_on THEN
2004: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH API-UPDATE_TMS_INTERFACE_FLAG Total stops ids',l_id_tab.COUNT);
2005: END IF;
2006: --
2007: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
2008: (P_STOP_ID_TAB=>l_id_tab,
2009: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
2010: X_RETURN_STATUS =>l_return_status);
2011: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then