277: )
278: is
279: select phase_code,
280: status_code
281: from fnd_concurrent_requests fnd
282: where fnd.request_id = c_request_id;
283: --
284: l_slaves c_slaves%rowtype;
285: --
317: end if;
318: --
319: close c_slaves;
320: --
321: -- Loop to avoid over polling of fnd_concurrent_requests
322: --
323: l_poll_loops := 100000;
324: --
325: for i in 1..l_poll_loops