APPS.GMO_DVC_INTG_PVT dependencies on WMS_DEVICES_VL

Line 28: cursor c_get_device_details is select name from wms_devices_vl where device_id = P_DEVICE_ID;

24: IS PRAGMA AUTONOMOUS_TRANSACTION;
25:
26: l_device_name varchar2(30);
27: l_signon_wrk_stn varchar2(100);
28: cursor c_get_device_details is select name from wms_devices_vl where device_id = P_DEVICE_ID;
29:
30: BEGIN
31:
32: open c_get_device_details;

Line 600: cursor c_get_device_details is select output_method, output_method_id, name, subinventory_code from wms_devices_vl where device_id = P_DEVICE_ID;

596: l_is_device_locked boolean;
597:
598: l_no_msg_components_err exception;
599: cursor c_get_org_details is select organization_code from mtl_parameters where organization_id = P_ORGANIZATION_ID;
600: cursor c_get_device_details is select output_method, output_method_id, name, subinventory_code from wms_devices_vl where device_id = P_DEVICE_ID;
601: cursor c_get_device_response is select RESP_COMP_CODE_VALUE from gmo_device_responses_t where request_id = l_request_id and RESP_COMP_CODE = l_response_code;
602:
603:
604: