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 1401: DELETE from WSH_EXCEPTIONS we

1397: AND wie.interface_action_code = G_TMS_RELEASE_CODE;
1398:
1399: -- Exceptions are logged always for the deliveries
1400: FORALL i in l_del_wti_tab.FIRST..l_del_wti_tab.LAST
1401: DELETE from WSH_EXCEPTIONS we
1402: WHERE we.delivery_id in (
1403: select wdli.delivery_id
1404: from wsh_trip_stops_interface wtsi,
1405: wsh_del_legs_interface wdli

Line 4285: DELETE from WSH_EXCEPTIONS we

4281: IF l_debug_on THEN
4282: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Exceptions');
4283: END IF;
4284: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4285: DELETE from WSH_EXCEPTIONS we
4286: WHERE we.delivery_id in (
4287: select wdli.delivery_id
4288: from wsh_trip_stops_interface wtsi,
4289: wsh_del_legs_interface wdli

Line 4303: UPDATE WSH_EXCEPTIONS we

4299: IF l_debug_on THEN
4300: WSH_DEBUG_SV.logmsg(l_module_name,'Start Closing Exceptions');
4301: END IF;
4302: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4303: UPDATE WSH_EXCEPTIONS we
4304: SET status = 'CLOSED'
4305: WHERE we.delivery_id in (
4306: select wdli.delivery_id
4307: from wsh_trip_stops_interface wtsi,