APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 4223: FROM fnd_concurrent_requests fcr

4219: -- Monitor batches
4220: LOOP
4221: SELECT COUNT(0)
4222: INTO l_runner_count
4223: FROM fnd_concurrent_requests fcr
4224: WHERE fcr.parent_request_id = l_conc_request_id
4225: AND fcr.phase_code <> 'C';
4226: EXIT WHEN l_runner_count = 0;
4227: dbms_lock.sleep(l_sleep_time);

Line 4233: FROM fnd_concurrent_requests fcr

4229:
4230: FOR rs_errors IN (SELECT fcr.request_id,
4231: fcr.actual_completion_date,
4232: fcr.completion_text
4233: FROM fnd_concurrent_requests fcr
4234: WHERE parent_request_id = l_conc_request_id
4235: AND upper(status_code) = 'E')
4236: LOOP
4237: l_error_count := l_error_count + 1;

Line 4251: FROM fnd_concurrent_requests fcr

4247: l_warning_count := 0;
4248: BEGIN
4249: SELECT COUNT(0)
4250: INTO l_warning_count
4251: FROM fnd_concurrent_requests fcr
4252: WHERE parent_request_id = l_conc_request_id
4253: AND upper(status_code) = 'G';
4254:
4255: fnd_file.put_line(fnd_file.log, 'WARNING REQUESTS: ' || l_warning_count);