DBA Data[Home] [Help]

APPS.FND_CONC_REQUEST_PKG dependencies on FND_CONCURRENT_WORKER_REQUESTS

Line 205: from fnd_concurrent_worker_requests

201: into upcode,
202: uscode
203: from sys.dual
204: where not exists (select null
205: from fnd_concurrent_worker_requests
206: where request_id = rid
207: and running_processes > 0
208: and (not (queue_application_id = 0
209: and concurrent_queue_id in (1,4))

Line 367: from fnd_concurrent_worker_requests b

363:
364: begin
365: select count (*) + 1
366: into reqpos
367: from fnd_concurrent_worker_requests b
368: where (b.priority < pri
369: or (b.priority = pri
370: and b.requested_start_date < stdate)
371: or (b.priority = pri

Line 398: from fnd_concurrent_worker_requests

394:
395: begin
396: select count (*)
397: into runreqs
398: from fnd_concurrent_worker_requests
399: where concurrent_queue_name = qname
400: and queue_application_id = qappid
401: and phase_code = 'R';
402:

Line 421: from fnd_concurrent_worker_requests

417:
418: begin
419: select count (*)
420: into pendreqs
421: from fnd_concurrent_worker_requests
422: where concurrent_queue_name = qname
423: and queue_application_id = qappid
424: and phase_code = 'P'
425: and hold_flag <> 'Y'