APPS.AD_PA_SUBMIT_REQUEST dependencies on FND_CONCURRENT

Line 557: l_sub_requests FND_CONCURRENT.REQUESTS_TAB_TYPE;

553: RETCODE OUT NOCOPY NUMBER
554: ) IS
555: l_request_id INTEGER;
556: l_request_set_id INTEGER;
557: l_sub_requests FND_CONCURRENT.REQUESTS_TAB_TYPE;
558: l_cnt NUMBER;
559: BEGIN
560:
561: -- Set the default value to 0 (Normal)

Line 574: SELECT parent_request_id INTO l_request_set_id FROM fnd_concurrent_requests

570:
571: fnd_file.put_line(fnd_file.log, 'Current request id : '|| l_request_id);
572:
573: -- Get the request set id for the current request, ie, StatusTracker
574: SELECT parent_request_id INTO l_request_set_id FROM fnd_concurrent_requests
575: WHERE request_id =
576: ( SELECT parent_request_id
577: FROM fnd_concurrent_requests
578: WHERE request_id = l_request_id );

Line 577: FROM fnd_concurrent_requests

573: -- Get the request set id for the current request, ie, StatusTracker
574: SELECT parent_request_id INTO l_request_set_id FROM fnd_concurrent_requests
575: WHERE request_id =
576: ( SELECT parent_request_id
577: FROM fnd_concurrent_requests
578: WHERE request_id = l_request_id );
579:
580: fnd_file.put_line(fnd_file.log, 'Current request set id : '|| l_request_set_id);
581:

Line 583: l_sub_requests := fnd_concurrent.get_sub_requests(l_request_set_id);

579:
580: fnd_file.put_line(fnd_file.log, 'Current request set id : '|| l_request_set_id);
581:
582: -- Get the data for all the requests in the current request set
583: l_sub_requests := fnd_concurrent.get_sub_requests(l_request_set_id);
584:
585: -- Check the status of each request within the request set and assign the highest value to RETCODE
586: l_cnt := l_sub_requests.first;
587: WHILE l_cnt IS NOT NULL LOOP