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 283: ' from wsh_trips wt , wsh_document_instances wdi, wsh_trip_stops wts '||

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

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 1074: 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 ' ;

1070: ||' and wnd.delivery_id in (';
1071: --Bug 7408338
1072: IF (l_p_caller = 'A') THEN
1073: --{
1074: 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 ' ;
1075: bind_col_tab(bind_col_tab.COUNT+1) := to_char(p_trip_id);
1076: ELSE
1077: FOR i in 1..p_dlv_id_tab.COUNT LOOP
1078: --{

Line 1722: select stop_id,TMS_INTERFACE_FLAG from wsh_trip_stops

1718: where delivery_id = c_delivery_id;
1719:
1720: -- define the cursor to get all trip stops for the given trip id.
1721: cursor get_trip_stops(c_trip_id NUMBER) IS
1722: select stop_id,TMS_INTERFACE_FLAG from wsh_trip_stops
1723: where trip_id = c_trip_id;
1724: -- and (TMS_INTERFACE_FLAG ='ASR' or TMS_INTERFACE_FLAG ='ASP');
1725: BEGIN
1726: -- save point

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