[Home] [Help]
167: or status_code = 'T';
168:
169: select sum(running_processes)
170: into mgr_procs
171: from fnd_concurrent_queues
172: where manager_type = '1';
173: end;
174:
175: --
252:
253: -- Following is just a place holder .. the logic should change ..
254: --
255: if (ManagerType is not null) then
256: Update Fnd_Concurrent_Queues
257: Set Diagnostic_Level = DiagLevel
258: Where Manager_Type = ManagerType;
259: else
260: Update Fnd_Concurrent_Queues
256: Update Fnd_Concurrent_Queues
257: Set Diagnostic_Level = DiagLevel
258: Where Manager_Type = ManagerType;
259: else
260: Update Fnd_Concurrent_Queues
261: Set Diagnostic_Level = DiagLevel
262: Where Application_ID = Application
263: and Concurrent_queue_ID = QueueID;
264: end if;
338: callstat number;
339:
340: cursor svc_cursor (svc_id number) is
341: select application_id, concurrent_queue_id
342: from fnd_concurrent_queues
343: where (max_processes > 0 or running_processes > 0)
344: and manager_type = svc_id;
345:
346: begin
373: if ( actual < target) then
374:
375: /* Are all of the service processes for an instance down? */
376: select count(*) into n
377: from fnd_concurrent_queues
378: where running_processes = 0
379: and max_processes > 0;
380:
381: if ( n > 0) then /* All processes for an instance are down. */
559:
560: cursor svc_cursor (tnode varchar2, inode varchar2) is
561: select application_id, concurrent_queue_id,
562: manager_type, max_processes, running_processes
563: from fnd_concurrent_queues
564: where target_node = tnode
565: or (target_node is null and tnode = inode);
566:
567: begin
566:
567: begin
568: /* Get ICM_NODE */
569: select target_node into icm_node
570: from fnd_concurrent_queues
571: where concurrent_queue_id = 1
572: and application_id = 0;
573:
574: total_target := 0;