APPS.WMS_DEVICE_INTEGRATION_WCS SQL Statements

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

Line: 24

   PROCEDURE update_request (
      p_request_id    IN   NUMBER,
      p_device_id     IN   NUMBER := NULL,
      p_status_code   IN   VARCHAR2,
      p_status_msg    IN   VARCHAR2 := NULL
   )
   IS
   BEGIN
      UPDATE wms_device_requests_hist
         SET status_code = p_status_code,
             status_msg = p_status_msg
       WHERE request_id = p_request_id
         AND device_id = NVL (p_device_id, device_id);