DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_WCS dependencies on WMS_DEVICE_REQUESTS_HIST

Line 32: UPDATE wms_device_requests_hist

28: p_status_msg IN VARCHAR2 := NULL
29: )
30: IS
31: BEGIN
32: UPDATE wms_device_requests_hist
33: SET status_code = p_status_code,
34: status_msg = p_status_msg
35: WHERE request_id = p_request_id
36: AND device_id = NVL (p_device_id, device_id);