APPS.WSH_OTM_OUTBOUND dependencies on WSH_TRIP_STOPS_PVT

Line 764: 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);

760: CLOSE get_trip_stops;
761: IF l_upd_trip_stops.COUNT > 0 THEN
762: --{
763: IF l_debug_on THEN
764: 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);
765: END IF;
766: --
767: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
768: (P_STOP_ID_TAB=>l_upd_trip_stops,

Line 767: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG

763: IF l_debug_on THEN
764: 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);
765: END IF;
766: --
767: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
768: (P_STOP_ID_TAB=>l_upd_trip_stops,
769: P_TMS_INTERFACE_FLAG_TAB =>l_upd_tms_interface_flags,
770: X_RETURN_STATUS =>l_return_status);
771: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

Line 2019: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG

2015: IF l_debug_on THEN
2016: WSH_DEBUG_SV.log(l_sub_module_name,'Calling WSH API-UPDATE_TMS_INTERFACE_FLAG Total stops ids',l_id_tab.COUNT);
2017: END IF;
2018: --
2019: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
2020: (P_STOP_ID_TAB=>l_id_tab,
2021: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
2022: X_RETURN_STATUS =>l_return_status);
2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then