21: end if;
22:
23: select 1
24: into dummy
25: from fnd_concurrent_queues fcq,
26: fnd_concurrent_processes fcp
27: where ((fcq.application_id = appid and
28: fcq.concurrent_queue_id = qid and
29: fcq.max_processes > 0)
66: select 1
67: into dummy
68: from sys.dual
69: where not exists (select 1
70: from fnd_concurrent_queues_vl
71: where application_id = appid
72: and concurrent_queue_name = qname
73: and (row_id <> chartorowid (ro_id)
74: or ro_id is null));
88: select 1
89: into dummy
90: from sys.dual
91: where not exists (select 1
92: from fnd_concurrent_queues_vl
93: where application_id = appid
94: and user_concurrent_queue_name = uqname
95: and (row_id <> chartorowid (ro_id)
96: or ro_id is null));