APPS.WMS_DEVICE_INTEGRATION_PUB SQL Statements

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

Line: 60

	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);