APPS.WSH_OTM_OUTBOUND dependencies on WSH_TRIP_STOPS

Line 166: FROM wsh_trip_stops

162:
163: --bug# 6497991 (begin) : Update tms_interface_flag for error trip stops back to 'ASR'.
164: CURSOR get_trip_stops(c_trip_id NUMBER) IS
165: SELECT stop_id,'ASR' tms_iface_new_status
166: FROM wsh_trip_stops
167: WHERE trip_id = c_trip_id;
168:
169: x_error_dlv_id_tab WSH_OTM_ID_TAB;
170: l_upd_trip_stops WSH_UTIL_CORE.ID_TAB_TYPE;

Line 282: ' from wsh_trips wt , wsh_document_instances wdi, wsh_trip_stops wts '||

278: 'nvl(WTS.DEPARTURE_NET_WEIGHT,0),'||
279: 'nvl(WTS.DEPARTURE_VOLUME,0), '||
280: 'WTS.WEIGHT_UOM_CODE,'||
281: 'WTS.VOLUME_UOM_CODE '||
282: ' from wsh_trips wt , wsh_document_instances wdi, wsh_trip_stops wts '||
283: ' where wt.trip_id = wts.trip_id '||
284: ' and wdi.entity_name(+) = ''WSH_TRIPS'''||
285: ' and wdi.entity_id(+) = wt.trip_id '||
286: ' and wts.physical_stop_id is null '||

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 1063: l_deliveries_sql := l_deliveries_sql ||' select wdl.delivery_id from wsh_delivery_legs wdl, wsh_trip_stops wts where wdl.pick_up_stop_id = wts.stop_id and wts.trip_id = :1 ' ;

1059: ||' and wnd.delivery_id in (';
1060: --Bug 7408338
1061: IF (l_p_caller = 'A') THEN
1062: --{
1063: l_deliveries_sql := l_deliveries_sql ||' select wdl.delivery_id from wsh_delivery_legs wdl, wsh_trip_stops wts where wdl.pick_up_stop_id = wts.stop_id and wts.trip_id = :1 ' ;
1064: bind_col_tab(bind_col_tab.COUNT+1) := to_char(p_trip_id);
1065: ELSE
1066: FOR i in 1..p_dlv_id_tab.COUNT LOOP
1067: --{

Line 1711: select stop_id,TMS_INTERFACE_FLAG from wsh_trip_stops

1707: where delivery_id = c_delivery_id;
1708:
1709: -- define the cursor to get all trip stops for the given trip id.
1710: cursor get_trip_stops(c_trip_id NUMBER) IS
1711: select stop_id,TMS_INTERFACE_FLAG from wsh_trip_stops
1712: where trip_id = c_trip_id;
1713: -- and (TMS_INTERFACE_FLAG ='ASR' or TMS_INTERFACE_FLAG ='ASP');
1714: BEGIN
1715: -- save point

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