APPS.PAY_MIX_ROLLBACK_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 663: from fnd_concurrent_requests pa,

659: -- For bug 8971846
660: /*Bug 10152705 Added join of concurrent_program_name = 'UNDO_MIX' to avoid picking for normal ROLLBACK process */
661: cursor csr_parent_req_id (p_request_id NUMBER) is
662: select decode(parspa.parent_request_id,-1,pa.parent_request_id,parspa.parent_request_id)
663: from fnd_concurrent_requests pa,
664: fnd_concurrent_requests parspa,
665: fnd_concurrent_programs fcp
666: where pa.request_id = p_request_id
667: and parspa.concurrent_program_id = fcp.concurrent_program_id

Line 664: fnd_concurrent_requests parspa,

660: /*Bug 10152705 Added join of concurrent_program_name = 'UNDO_MIX' to avoid picking for normal ROLLBACK process */
661: cursor csr_parent_req_id (p_request_id NUMBER) is
662: select decode(parspa.parent_request_id,-1,pa.parent_request_id,parspa.parent_request_id)
663: from fnd_concurrent_requests pa,
664: fnd_concurrent_requests parspa,
665: fnd_concurrent_programs fcp
666: where pa.request_id = p_request_id
667: and parspa.concurrent_program_id = fcp.concurrent_program_id
668: and fcp.concurrent_program_name = 'UNDO_MIX'

Line 700: from fnd_concurrent_requests

696: close csr_parent_req_id;
697: if l_parent_id is not null then
698: select argument3, argument5
699: into l_reject_if_run_results_exist,l_leave_batch
700: from fnd_concurrent_requests
701: where request_id = l_parent_id;
702: else
703: l_reject_if_run_results_exist := l_rec.reject_if_results_exists;
704: l_leave_batch := l_rec.leave_batch;

Line 777: from fnd_concurrent_requests pa,

773: and pbl.batch_line_status = 'T');
774:
775: cursor csr_get_parent_req_id (p_request_id NUMBER) is
776: select decode(parspa.parent_request_id,-1,pa.parent_request_id,parspa.parent_request_id)
777: from fnd_concurrent_requests pa,
778: fnd_concurrent_requests parspa,
779: fnd_concurrent_programs fcp
780: where pa.request_id = p_request_id
781: and parspa.concurrent_program_id = fcp.concurrent_program_id

Line 778: fnd_concurrent_requests parspa,

774:
775: cursor csr_get_parent_req_id (p_request_id NUMBER) is
776: select decode(parspa.parent_request_id,-1,pa.parent_request_id,parspa.parent_request_id)
777: from fnd_concurrent_requests pa,
778: fnd_concurrent_requests parspa,
779: fnd_concurrent_programs fcp
780: where pa.request_id = p_request_id
781: and parspa.concurrent_program_id = fcp.concurrent_program_id
782: and fcp.concurrent_program_name = 'UNDO_MIX'

Line 818: from fnd_concurrent_requests

814:
815: if l_parent_id is not null then
816: select argument5
817: into l_leave_batch
818: from fnd_concurrent_requests
819: where request_id = l_parent_id;
820: else
821: if l_rec.purge_after_rollback = 'Y' then
822: l_leave_batch := 'N';