The following lines contain the word 'select', 'insert', 'update' or 'delete':
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);