eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TMS_RELEASE dependencies on WSH_EXCEPTIONS

Line 1393: DELETE from WSH_EXCEPTIONS we

1389: AND wie.interface_action_code = G_TMS_RELEASE_CODE;
1390:
1391: -- Exceptions are logged always for the deliveries
1392: FORALL i in l_del_wti_tab.FIRST..l_del_wti_tab.LAST
1393: DELETE from WSH_EXCEPTIONS we
1394: WHERE we.delivery_id in (
1395: select wdli.delivery_id
1396: from wsh_trip_stops_interface wtsi,
1397: wsh_del_legs_interface wdli

Line 4277: DELETE from WSH_EXCEPTIONS we

4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Exceptions');
4275: END IF;
4276: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4277: DELETE from WSH_EXCEPTIONS we
4278: WHERE we.delivery_id in (
4279: select wdli.delivery_id
4280: from wsh_trip_stops_interface wtsi,
4281: wsh_del_legs_interface wdli

Line 4295: UPDATE WSH_EXCEPTIONS we

4291: IF l_debug_on THEN
4292: WSH_DEBUG_SV.logmsg(l_module_name,'Start Closing Exceptions');
4293: END IF;
4294: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4295: UPDATE WSH_EXCEPTIONS we
4296: SET status = 'CLOSED'
4297: WHERE we.delivery_id in (
4298: select wdli.delivery_id
4299: from wsh_trip_stops_interface wtsi,