APPS.WF_DIAGNOSTICS_APPS dependencies on FND_CONCURRENT_QUEUES

Line 45: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq

41: select VARIABLE_NAME, VALUE
42: from FND_ENV_CONTEXT
43: where CONCURRENT_PROCESS_ID in
44: (select max(CONCURRENT_PROCESS_ID)
45: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq
46: where fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
47: and fcq.CONCURRENT_QUEUE_NAME= p_qname
48: and fcp.QUEUE_APPLICATION_ID = p_appId )
49: and VARIABLE_NAME in ('APPL_TOP', 'APPLCSF', 'APPLLOG', 'FND_TOP',

Line 115: -- FND_CP_SERVICES and FND_CONCURRENT_QUEUES tables

111: l_temp_result := l_temp_result||' Enable Status ';
112: l_temp_result := l_temp_result||' Running Status ';
113:
114: begin
115: -- FND_CP_SERVICES and FND_CONCURRENT_QUEUES tables
116: l_service_instances := fnd_concurrent.get_service_instances (svc_handle => 'FNDCPGSC');
117: exception
118: -- Handle -20100 error
119: When No_Service_Instance then

Line 159: FROM fnd_concurrent_queues_vl

155: SELECT user_concurrent_queue_name,
156: concurrent_queue_id,
157: decode(enabled_flag, 'Y', 'ENABLED', 'NOT ENABLED')
158: INTO l_user_concurrent_queue_name, l_managerid, l_service_enabed
159: FROM fnd_concurrent_queues_vl
160: WHERE concurrent_queue_name = l_service_instances(i).instance_name;
161:
162: -- Check if the service is enabled and running,
163: l_temp_result := l_temp_result || ' ' ||

Line 192: -- Handle fetch on fnd_concurrent_queues_vl

188:
189: END IF;
190:
191: EXCEPTION
192: -- Handle fetch on fnd_concurrent_queues_vl
193: when no_data_found then
194: l_temp_result := l_temp_result || ' ' ||
195: 'Could not find concurrent queue for '||
196: l_service_instances(i).instance_name ||