DBA Data[Home] [Help]

APPS.MSC_SRP_PIPE dependencies on FND_CONCURRENT

Line 262: /* check concurrent request status by calling fnd_concurrent.get_request_status

258: return l_msg;
259: END read_pipe;
260:
261:
262: /* check concurrent request status by calling fnd_concurrent.get_request_status
263: possible return from fnd_concurrent.get_request_status are
264: dev_phase: Running(R),Pending(P),Complete(C),Inactive(I);
265: ------------------------------------
266: dev_status: Normal(R)

Line 263: possible return from fnd_concurrent.get_request_status are

259: END read_pipe;
260:
261:
262: /* check concurrent request status by calling fnd_concurrent.get_request_status
263: possible return from fnd_concurrent.get_request_status are
264: dev_phase: Running(R),Pending(P),Complete(C),Inactive(I);
265: ------------------------------------
266: dev_status: Normal(R)
267: Terminating(T)

Line 314: select request_id from Fnd_Concurrent_Requests

310: l_st number ;
311: l_request_id number :=p_request_id;
312:
313: cursor c_child_req (p_parent_req_id number) is
314: select request_id from Fnd_Concurrent_Requests
315: where parent_request_Id = p_parent_req_id;
316:
317:
318: begin

Line 320: if (FND_CONCURRENT.GET_REQUEST_STATUS(request_id=>l_request_id,

316:
317:
318: begin
319:
320: if (FND_CONCURRENT.GET_REQUEST_STATUS(request_id=>l_request_id,
321: appl_shortname=>'',
322: program =>'',
323: phase=>l_phase,
324: status=>l_status,

Line 350: if (FND_CONCURRENT.GET_REQUEST_STATUS(request_id=>cur.request_id,

346: -- check each child request. if any of the child request is in inactive status
347: -- then set the l_st :=1;
348:
349: for cur in c_child_req(l_request_id) loop
350: if (FND_CONCURRENT.GET_REQUEST_STATUS(request_id=>cur.request_id,
351: appl_shortname=>'',
352: program =>'',
353: phase=>l_phase,
354: status=>l_status,