APPS.WF_DIAGNOSTICS_APPS dependencies on FND_CONCURRENT

Line 22: l_service_instances fnd_concurrent.service_instance_tab_type;

18: --
19: function Get_GSM_Setup_Info(p_value out nocopy clob)
20: return varchar2 is
21:
22: l_service_instances fnd_concurrent.service_instance_tab_type;
23: l_gsm_enabled VARCHAR2(10);
24: l_service_enabed VARCHAR2(20);
25: l_user_concurrent_queue_name VARCHAR2(300);
26: l_temp_result varchar2(32000);

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 77: FND_CONCURRENT.GET_MANAGER_STATUS (

73: l_status := 'E';
74: end if;
75:
76: -- Check if ICM is running.
77: FND_CONCURRENT.GET_MANAGER_STATUS (
78: applid => 0,
79: managerid => 1,
80: targetp => l_targetp,
81: activep => l_activep,

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 116: l_service_instances := fnd_concurrent.get_service_instances (svc_handle => 'FNDCPGSC');

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
120: -- WHEN OTHERS 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 170: FND_CONCURRENT.GET_MANAGER_STATUS (

166:
167: -- Get each Workflow Service Container status.
168: -- MANAGER_TYPE=1052 and CartType is 'AQCART'
169: -- Other errors are being handled within GET_MANAGER_STATUS API itself
170: FND_CONCURRENT.GET_MANAGER_STATUS (
171: applid => l_app_id,
172: managerid => l_managerid,
173: targetp => l_targetp,
174: activep => l_activep,

Line 179: -- fnd_concurrent_processes and gv$session

175: pmon_method => l_pmon_method,
176: callstat => l_callstat);
177:
178: -- l_callstat <>0 mean there is no process exist in
179: -- fnd_concurrent_processes and gv$session
180: IF l_callstat <> 0 THEN
181: l_temp_result := l_temp_result || ' could not get ' ||
182: ' actual and target process count ';
183:

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 ||