APPS.WSH_CONC_UTIL_PKG dependencies on WSH_TRIPS

Line 288: FROM WSH_TRIPS

284:
285: CURSOR c_current_trips(x_ship_method_code IN VARCHAR2,
286: x_carrier_id IN NUMBER) IS
287: SELECT trip_id
288: FROM WSH_TRIPS
289: WHERE status_code = 'OP'
290: AND ship_method_code = x_ship_method_code
291: AND carrier_id = x_carrier_id
292: AND mode_of_transport IS NULL

Line 317: FROM WSH_TRIPS

313: AND service_level IS NULL;
314:
315: CURSOR c_lock_trip(x_id IN NUMBER) IS
316: SELECT trip_id
317: FROM WSH_TRIPS
318: WHERE trip_id = x_id
319: FOR UPDATE NOWAIT;
320:
321: CURSOR c_lock_del(x_id IN NUMBER) IS

Line 447: UPDATE WSH_TRIPS

443: END IF;
444:
445: IF p_entity = G_ENTITY_TRIP THEN
446: FORALL i IN 1 .. l_update_index
447: UPDATE WSH_TRIPS
448: SET service_level = p_service_level,
449: mode_of_transport = p_mode_of_transport,
450: last_updated_by = l_user_id,
451: last_update_date = sysdate,