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_CONC_UTIL_PKG dependencies on WSH_TRIPS

Line 276: FROM WSH_TRIPS

272:
273: CURSOR c_current_trips(x_ship_method_code IN VARCHAR2,
274: x_carrier_id IN NUMBER) IS
275: SELECT trip_id
276: FROM WSH_TRIPS
277: WHERE status_code = 'OP'
278: AND ship_method_code = x_ship_method_code
279: AND carrier_id = x_carrier_id
280: AND mode_of_transport IS NULL

Line 305: FROM WSH_TRIPS

301: AND service_level IS NULL;
302:
303: CURSOR c_lock_trip(x_id IN NUMBER) IS
304: SELECT trip_id
305: FROM WSH_TRIPS
306: WHERE trip_id = x_id
307: FOR UPDATE NOWAIT;
308:
309: CURSOR c_lock_del(x_id IN NUMBER) IS

Line 435: UPDATE WSH_TRIPS

431: END IF;
432:
433: IF p_entity = G_ENTITY_TRIP THEN
434: FORALL i IN 1 .. l_update_index
435: UPDATE WSH_TRIPS
436: SET service_level = p_service_level,
437: mode_of_transport = p_mode_of_transport,
438: last_updated_by = l_user_id,
439: last_update_date = sysdate,