APPS.OAM_GCS dependencies on FND_CONCURRENT_QUEUES

Line 49: FROM fnd_concurrent_queues

45: END IF;
46:
47: SELECT count(*)
48: INTO qcount
49: FROM fnd_concurrent_queues
50: WHERE UPPER(node_name) =UPPER(node)
51: AND TO_NUMBER(manager_type) = (select service_id
52: FROM fnd_cp_services where service_handle='OAMGCS');
53:

Line 57: FROM fnd_concurrent_queues

53:
54: IF (qcount = 0) THEN
55: SELECT count(*)
56: INTO ncount
57: FROM fnd_concurrent_queues
58: WHERE concurrent_queue_name = mgr_name;
59:
60: IF (ncount <> 0) THEN
61: SELECT fnd_concurrent_queues_s.nextval

Line 61: SELECT fnd_concurrent_queues_s.nextval

57: FROM fnd_concurrent_queues
58: WHERE concurrent_queue_name = mgr_name;
59:
60: IF (ncount <> 0) THEN
61: SELECT fnd_concurrent_queues_s.nextval
62: INTO dummy
63: FROM dual;
64:
65: mgr_name := substrb('OAMGCS_'||dummy||'_'||UPPER(node),

Line 75: DELETE FROM fnd_concurrent_queues_tl

71: IF(name = 'CONC-OAMGCS NAME') THEN
72: name := 'OAM Generic Collection Service';
73: END IF;
74:
75: DELETE FROM fnd_concurrent_queues_tl
76: WHERE concurrent_queue_name = mgr_name;
77:
78: BEGIN
79: IF NOT fnd_manager.Manager_exists(mgr_name,'FND') THEN

Line 160: FROM fnd_concurrent_queues

156: mgr_name := substrb(mgr_name,1,30);
157: END IF;
158:
159: SELECT concurrent_queue_id INTO queue_id
160: FROM fnd_concurrent_queues
161: WHERE application_id=0 AND concurrent_queue_name LIKE mgr_name;
162:
163: /* Update the workshift for this queue_id with new svc_params */
164:

Line 210: DELETE FROM fnd_concurrent_queues

206: END IF;
207:
208: /* Deleting the specific service instance for specific node*/
209:
210: DELETE FROM fnd_concurrent_queues
211: WHERE application_id=0 AND concurrent_queue_name LIKE mgr_name and UPPER(node_name)=upper(node);
212:
213: END delete_gcs;
214:

Line 245: fnd_concurrent_queues where concurrent_queue_name like mgr_name AND

241:
242:
243: SELECT count(concurrent_queue_id) into instance_count
244: FROM
245: fnd_concurrent_queues where concurrent_queue_name like mgr_name AND
246: upper(node_name) = upper(node);
247:
248: IF (instance_count>0) THEN
249: return 'TRUE';

Line 279: SELECT application_id,concurrent_queue_id INTO appl_id,conc_queue_id FROM fnd_concurrent_queues

275:
276:
277:
278:
279: SELECT application_id,concurrent_queue_id INTO appl_id,conc_queue_id FROM fnd_concurrent_queues
280: where concurrent_queue_name like mgr_name
281: AND upper(node_name) = upper(node);
282:
283: FND_OAM.get_svc_inst_status(appl_id,conc_queue_id,target,actual,svc_status,description,error_code,error_message);