APPS.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on FND_CONCURRENT_REQUESTS

Line 649: l_request_id fnd_concurrent_requests.request_id%TYPE;

645: )
646: IS
647: l_api_name CONSTANT VARCHAR2(30) := 'check_workers_status';
648:
649: l_request_id fnd_concurrent_requests.request_id%TYPE;
650: l_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE;
651:
652: CURSOR l_cur_workers_request(
653: lp_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE)

Line 650: l_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE;

646: IS
647: l_api_name CONSTANT VARCHAR2(30) := 'check_workers_status';
648:
649: l_request_id fnd_concurrent_requests.request_id%TYPE;
650: l_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE;
651:
652: CURSOR l_cur_workers_request(
653: lp_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE)
654: IS

Line 653: lp_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE)

649: l_request_id fnd_concurrent_requests.request_id%TYPE;
650: l_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE;
651:
652: CURSOR l_cur_workers_request(
653: lp_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE)
654: IS
655: SELECT request_id
656: FROM fnd_concurrent_requests
657: WHERE parent_request_id = lp_parent_request_id

Line 656: FROM fnd_concurrent_requests

652: CURSOR l_cur_workers_request(
653: lp_parent_request_id fnd_concurrent_requests.parent_request_id%TYPE)
654: IS
655: SELECT request_id
656: FROM fnd_concurrent_requests
657: WHERE parent_request_id = lp_parent_request_id
658: ORDER BY request_id;
659:
660: -- for FND_CONCURRENT.get_request_status

Line 692: FROM fnd_concurrent_requests

688: l_request_id := p_workers(1);
689:
690: SELECT parent_request_id
691: INTO l_parent_request_id
692: FROM fnd_concurrent_requests
693: WHERE request_id = l_request_id;
694: -- **** for debug information in readonly UT environment.--- begin ****
695: JMF_SHIKYU_RPT_UTIL.debug_output
696: (