169: if(sm_name = 'CONC-FNDSM NAME') then
170: sm_name := 'Service Manager';
171: end if;
172:
173: delete from fnd_concurrent_queues_tl
174: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
175: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
176:
177: begin
223: if(im_name = 'CONC-FNDIM NAME') then
224: im_name := 'Internal Monitor';
225: end if;
226:
227: delete from fnd_concurrent_queues_tl
228: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
229: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
230:
231: begin
283: if(name = 'CONC-OAMGCS NAME') then
284: name := 'OAM Generic Collection Service';
285: end if;
286:
287: delete from fnd_concurrent_queues_tl
288: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
289: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
290:
291: begin