APPS.WSH_EXCEPTIONS_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

  SELECT exception_id, exception_name, status
  FROM   wsh_exceptions
  WHERE  trip_id = v_trip_id;

Line: 48

  SELECT exception_id, exception_name, status
  FROM   wsh_exceptions
  WHERE  trip_stop_id = v_stop_id;

Line: 53

  SELECT exception_id, exception_name, status
  FROM   wsh_exceptions
  WHERE  delivery_id = v_delivery_id;

Line: 58

  SELECT exception_id, exception_name, status
  FROM   wsh_exceptions
  WHERE  delivery_detail_id = v_detail_id;

Line: 63

  SELECT exception_id, exception_name, status
  FROM   WSH_EXCEPTIONS
  WHERE  delivery_detail_id = v_del_detail_id;

Line: 240

        x_updated_rows		OUT NOCOPY 	NUMBER
	) IS

  -- To get the current status of the Exception
  CURSOR get_status IS
  SELECT status
  FROM   wsh_exceptions
  WHERE  exception_id = p_exception_id ;

Line: 319

    x_updated_rows := 0;

Line: 349

       x_updated_rows := 0;

Line: 464

  x_updated_rows := l_success_count;

Line: 559

                SELECT  trip_stop_id
                FROM    wsh_xc_trip_stops_v
                WHERE   trip_id = c_trip_id
                AND     location_code = p_exception_rec.stop_location_id;

Line: 566

                SELECT  wdd.delivery_detail_id, wda.delivery_id, wda.delivery_assignment_id
                FROM    wsh_delivery_details wdd, wsh_delivery_assignments_v wda
                WHERE   wdd.delivery_detail_id = wda.delivery_detail_id
                AND     ((c_delivery_id is null) or (wda.delivery_id =c_delivery_id))
                AND     wdd.delivery_detail_id = p_exception_rec.delivery_detail_id
                AND     wdd.container_flag IN ('N', 'Y'); -- R12 MDC

Line: 575

                SELECT delivery_detail_id
                FROM   wsh_delivery_details
                WHERE  container_flag = 'Y'
                AND    container_name = c_container_name
                AND    delivery_detail_id =
                         nvl(p_exception_rec.delivery_detail_id, delivery_detail_id);

Line: 584

      SELECT delivery_id
      FROM   wsh_new_deliveries
      WHERE  delivery_id = p_delivery_id
      AND    delivery_type = 'STANDARD';

Line: 1290

        SELECT exception_name
        FROM wsh_exception_definitions_v
        WHERE exception_name = p_exception_rec.exception_name;

Line: 1296

        SELECT exception_name
          FROM wsh_exception_definitions_tl
         WHERE exception_name = p_exception_rec.exception_name
           AND language = userenv('LANG');

Line: 1879

	l_updated_rows		NUMBER;

Line: 1988

                   x_updated_rows          =>   l_updated_rows
                   );

Line: 1991

                FND_MESSAGE.SET_NAME('WSH','WSH_NO_OF_RECS_UPDATED');

Line: 1992

                FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_updated_rows);