APPS.PAY_FLOW_REQUESTS_PKG dependencies on FND_CONCURRENT

Line 467: l_wait_outcome := fnd_concurrent.wait_for_request

463: COMMIT;
464:
465: hr_utility.set_location(l_proc, 70);
466:
467: l_wait_outcome := fnd_concurrent.wait_for_request
468: (
469: request_id => l_request_id,
470: interval => 5,
471: phase => l_phase,

Line 483: from fnd_concurrent_requests

479:
480: BEGIN
481: --
482: select status_code into l_process_status
483: from fnd_concurrent_requests
484: where request_id = l_request_id;
485:
486: -- If any of the child process has errored, abort the flow
487: if l_process_status = 'E' then

Line 605: fnd_concurrent_requests fcr

601: -- Cursor to get the parent fnd requests which have completed processing
602: CURSOR get_parent_fnd_requests is
603: select ppr.fnd_request_id
604: from PAY_PROCESS_REQUESTS ppr,
605: fnd_concurrent_requests fcr
606: where ppr.fnd_request_id is not null
607: and ppr.PARENT_FND_REQUEST_ID is null
608: and ppr.fnd_request_id = fcr.request_id
609: and fcr.phase_code = 'C'

Line 618: fnd_concurrent_requests fcr

614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
615: select ppr_child.fnd_request_id
616: from PAY_PROCESS_REQUESTS ppr_child,
617: pay_process_requests ppr_parent,
618: fnd_concurrent_requests fcr
619: where ppr_child.parent_fnd_request_id = p_fnd_request_id
620: and ppr_parent.fnd_request_id = ppr_child.parent_fnd_request_id
621: and ppr_parent.fnd_request_id = fcr.request_id
622: and fcr.phase_code = 'C'

Line 778: fnd_concurrent_requests fcr

774: -- and the child request is running, the flow cannot be cancelled
775: CURSOR get_pending_child_request(p_fnd_request_id number) IS
776: select ppr.fnd_request_id
777: from pay_process_requests ppr,
778: fnd_concurrent_requests fcr
779: where ppr.fnd_request_id =
780: ( select min(fnd_request_id)
781: from pay_process_requests
782: where parent_fnd_request_id = p_fnd_request_id

Line 801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);

797: -- Get the pending child request and cancel it
798: open get_pending_child_request(p_fnd_request_id);
799: fetch get_pending_child_request into l_fnd_request_id;
800: if get_pending_child_request%FOUND then
801: l_cancelled := fnd_concurrent.cancel_request(l_fnd_request_id,l_message);
802: end if;
803: close get_pending_child_request;
804:
805: -- If child request has been cancelled then, cancel the parent request also.

Line 808: l_cancelled := fnd_concurrent.cancel_request(p_fnd_request_id,l_message);

804:
805: -- If child request has been cancelled then, cancel the parent request also.
806: if l_cancelled THEN
807:
808: l_cancelled := fnd_concurrent.cancel_request(p_fnd_request_id,l_message);
809:
810: hr_utility.set_message(801, 'PAY_33461_REQ_ACTION_CONFIRM');
811: hr_utility.set_message_token(801,'REQUEST_ID',p_fnd_request_id);
812: hr_utility.set_message_token(801,'ACTION','cancelled');