APPS.MSC_CONC_PROG_MONITOR dependencies on FND_CONCURRENT

Line 15: while fnd_concurrent.get_sub_requests(p_request_id).exists(i) loop

11: l_message varchar2(2048);
12: l_request_id number;
13: begin
14: dbms_output.put_line('request id is ' || p_request_id);
15: while fnd_concurrent.get_sub_requests(p_request_id).exists(i) loop
16: dbms_output.put_line('sub request is ' || fnd_concurrent.get_sub_requests(p_request_id)(i).request_id ||
17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);
18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then
19: return 0;

Line 16: dbms_output.put_line('sub request is ' || fnd_concurrent.get_sub_requests(p_request_id)(i).request_id ||

12: l_request_id number;
13: begin
14: dbms_output.put_line('request id is ' || p_request_id);
15: while fnd_concurrent.get_sub_requests(p_request_id).exists(i) loop
16: dbms_output.put_line('sub request is ' || fnd_concurrent.get_sub_requests(p_request_id)(i).request_id ||
17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);
18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then
19: return 0;
20: end if;

Line 17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);

13: begin
14: dbms_output.put_line('request id is ' || p_request_id);
15: while fnd_concurrent.get_sub_requests(p_request_id).exists(i) loop
16: dbms_output.put_line('sub request is ' || fnd_concurrent.get_sub_requests(p_request_id)(i).request_id ||
17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);
18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then
19: return 0;
20: end if;
21: if child_requests_completed(fnd_concurrent.get_sub_requests(p_request_id)(i).request_id) <> 1 then

Line 18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then

14: dbms_output.put_line('request id is ' || p_request_id);
15: while fnd_concurrent.get_sub_requests(p_request_id).exists(i) loop
16: dbms_output.put_line('sub request is ' || fnd_concurrent.get_sub_requests(p_request_id)(i).request_id ||
17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);
18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then
19: return 0;
20: end if;
21: if child_requests_completed(fnd_concurrent.get_sub_requests(p_request_id)(i).request_id) <> 1 then
22: return 0;

Line 21: if child_requests_completed(fnd_concurrent.get_sub_requests(p_request_id)(i).request_id) <> 1 then

17: fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase);
18: if fnd_concurrent.get_sub_requests(p_request_id)(i).dev_phase <> 'COMPLETE' then
19: return 0;
20: end if;
21: if child_requests_completed(fnd_concurrent.get_sub_requests(p_request_id)(i).request_id) <> 1 then
22: return 0;
23: end if;
24: i:= i+ 1;
25: end loop;

Line 27: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS

23: end if;
24: i:= i+ 1;
25: end loop;
26: l_request_id := p_request_id;
27: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
28: ( l_request_id,
29: NULL,
30: NULL,
31: l_phase,