DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS_APPS dependencies on FND_CONCURRENT_QUEUES

Line 48: from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq

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

Line 118: -- FND_CP_SERVICES and FND_CONCURRENT_QUEUES tables

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

Line 162: FROM fnd_concurrent_queues_vl

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

Line 195: -- Handle fetch on fnd_concurrent_queues_vl

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