FUNCTION get_prev_req_id(p_conc_program IN VARCHAR2) RETURN VARCHAR2
IS
l_parent_req_id NUMBER;
l_request_id NUMBER;
BEGIN
SELECT parent_request_id
INTO l_parent_req_id
FROM fnd_concurrent_requests
WHERE request_id = FND_PROFILE.VALUE('CONC_REQUEST_ID');
FOR c IN (SELECT request_id,fcpt.user_concurrent_program_name
FROM (SELECT request_id, concurrent_program_id
FROM fnd_concurrent_requests aaa
START WITH request_id = l_parent_req_id
CONNECT BY PRIOR request_id = parent_request_id) cps, fnd_concurrent_programs_tl fcpt
WHERE cps.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.user_concurrent_program_name LIKE p_conc_program
ORDER BY request_id)
LOOP
l_request_id := c.request_id;
EXIT;
END LOOP;
RETURN l_request_id ;
END;