APPS.WF_DIAGNOSTICS dependencies on FND_SVC_COMPONENT

Line 1727: FROM FND_SVC_COMPONENTS

1723: l_summary varchar(50);
1724: --
1725: CURSOR c_get_components_id is
1726: SELECT component_id
1727: FROM FND_SVC_COMPONENTS
1728: WHERE component_type = 'WF_MAILER'
1729: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
1730:
1731: begin

Line 1745: fnd_svc_components b,

1741: if (p_ntf_pref = 'SUMHTML') then
1742:
1743: SELECT a.parameter_value into l_summary_param
1744: FROM fnd_svc_comp_param_vals a,
1745: fnd_svc_components b,
1746: fnd_svc_comp_params_vl c
1747: WHERE b.component_id = a.component_id
1748: AND b.component_type = c.component_type
1749: AND c.parameter_id = a.parameter_id

Line 1758: fnd_svc_components b,

1754: else
1755:
1756: SELECT a.parameter_value into l_summary_param
1757: FROM fnd_svc_comp_param_vals a,
1758: fnd_svc_components b,
1759: fnd_svc_comp_params_vl c
1760: WHERE b.component_id = a.component_id
1761: AND b.component_type = c.component_type
1762: AND c.parameter_id = a.parameter_id

Line 2170: from fnd_svc_components

2166: container_type,
2167: inbound_agent_name,
2168: outbound_agent_name,
2169: correlation_id
2170: from fnd_svc_components
2171: where component_type = p_comp_type
2172: and component_name like nvl(p_comp_name, '%');
2173:
2174: cursor c_params (p_comp_id in number) is

Line 2272: from fnd_svc_components

2268: container_type,
2269: inbound_agent_name,
2270: outbound_agent_name,
2271: correlation_id
2272: from fnd_svc_components
2273: where component_type = p_comp_type
2274: and component_name like nvl(p_comp_name, '%')
2275: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
2276:

Line 4327: initcap(decode(FND_SVC_COMPONENT.Get_Component_Status(component_name),

4323:
4324: CURSOR c_comps IS
4325: select component_name comp_name, correlation_id corrid,
4326: inbound_agent_name inbound_agent,
4327: initcap(decode(FND_SVC_COMPONENT.Get_Component_Status(component_name),
4328: 'NOT_CONFIGURED', 'Not Configured',
4329: 'STOPPED_ERROR', 'Stopped with Error',
4330: 'DEACTIVATED_USER', 'User Deactivated',
4331: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,

Line 4331: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,

4327: initcap(decode(FND_SVC_COMPONENT.Get_Component_Status(component_name),
4328: 'NOT_CONFIGURED', 'Not Configured',
4329: 'STOPPED_ERROR', 'Stopped with Error',
4330: 'DEACTIVATED_USER', 'User Deactivated',
4331: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,
4332: component_status_info info
4333: FROM fnd_svc_components_v
4334: WHERE component_type in ('WF_AGENT_LISTENER', 'WF_JAVA_AGENT_LISTENER');
4335:

Line 4333: FROM fnd_svc_components_v

4329: 'STOPPED_ERROR', 'Stopped with Error',
4330: 'DEACTIVATED_USER', 'User Deactivated',
4331: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,
4332: component_status_info info
4333: FROM fnd_svc_components_v
4334: WHERE component_type in ('WF_AGENT_LISTENER', 'WF_JAVA_AGENT_LISTENER');
4335:
4336: l_cells tdType;
4337: i pls_integer;