APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 4269: FROM fnd_concurrent_requests fcr

4265: -- Monitor batches
4266: LOOP
4267: SELECT COUNT(0)
4268: INTO l_runner_count
4269: FROM fnd_concurrent_requests fcr
4270: WHERE fcr.parent_request_id = l_conc_request_id
4271: AND fcr.phase_code <> 'C';
4272: EXIT WHEN l_runner_count = 0;
4273: dbms_lock.sleep(l_sleep_time);

Line 4279: FROM fnd_concurrent_requests fcr

4275:
4276: FOR rs_errors IN (SELECT fcr.request_id,
4277: fcr.actual_completion_date,
4278: fcr.completion_text
4279: FROM fnd_concurrent_requests fcr
4280: WHERE parent_request_id = l_conc_request_id
4281: AND upper(status_code) = 'E')
4282: LOOP
4283: l_error_count := l_error_count + 1;

Line 4297: FROM fnd_concurrent_requests fcr

4293: l_warning_count := 0;
4294: BEGIN
4295: SELECT COUNT(0)
4296: INTO l_warning_count
4297: FROM fnd_concurrent_requests fcr
4298: WHERE parent_request_id = l_conc_request_id
4299: AND upper(status_code) = 'G';
4300:
4301: fnd_file.put_line(fnd_file.log, 'WARNING REQUESTS: ' || l_warning_count);