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',
114: l_temp_result := l_temp_result||'
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 || '
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 || '