APPS.WMS_RFID_DEVICE_PUB dependencies on WMS_DEVICE_REQUESTS_S

Line 143: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

139: END IF;
140:
141: --populate the WDR table
142: IF l_device_req_id_pkg IS NULL THEN
143: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
144: l_device_req_id_pkg := l_request_id;
145: ELSE
146: l_request_id := l_device_req_id_pkg;
147: END IF;

Line 2362: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;

2358: BEGIN
2359:
2360: x_return_status := 'S';
2361:
2362: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
2363: l_device_req_id_pkg := l_request_id; --to be used for the pallet record
2364:
2365:
2366: --By the time this API is called