280: END IF;
281:
282: SELECT parent_request_id
283: INTO l_request_id
284: FROM fnd_concurrent_requests child
285: WHERE child.request_id = p_request_id;
286:
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_standard.debug( 'Return value :'||l_request_id);
3404: IF PG_DEBUG in ('Y', 'C') THEN
3405: arp_standard.debug( 'Waiting for the completion of worker '||pg_req_status_tab(i).request_id);
3406: END IF;
3407:
3408: l_complete := FND_CONCURRENT.WAIT_FOR_REQUEST(
3409: request_id => pg_req_status_tab(i).request_id,
3410: interval => 30,
3411: max_wait =>144000,
3412: phase =>pg_req_status_tab(i).phase,