APPS.WF_DIAGNOSTICS dependencies on FND_SVC_COMPONENT

Line 1540: FROM FND_SVC_COMPONENTS

1536: l_summary varchar(50);
1537: --
1538: CURSOR c_get_components_id is
1539: SELECT component_id
1540: FROM FND_SVC_COMPONENTS
1541: WHERE component_type = 'WF_MAILER'
1542: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
1543:
1544: begin

Line 1558: fnd_svc_components b,

1554: if (p_ntf_pref = 'SUMHTML') then
1555:
1556: SELECT a.parameter_value into l_summary_param
1557: FROM fnd_svc_comp_param_vals a,
1558: fnd_svc_components b,
1559: fnd_svc_comp_params_vl c
1560: WHERE b.component_id = a.component_id
1561: AND b.component_type = c.component_type
1562: AND c.parameter_id = a.parameter_id

Line 1571: fnd_svc_components b,

1567: else
1568:
1569: SELECT a.parameter_value into l_summary_param
1570: FROM fnd_svc_comp_param_vals a,
1571: fnd_svc_components b,
1572: fnd_svc_comp_params_vl c
1573: WHERE b.component_id = a.component_id
1574: AND b.component_type = c.component_type
1575: AND c.parameter_id = a.parameter_id

Line 1983: from fnd_svc_components

1979: container_type,
1980: inbound_agent_name,
1981: outbound_agent_name,
1982: correlation_id
1983: from fnd_svc_components
1984: where component_type = p_comp_type
1985: and component_name like nvl(p_comp_name, '%');
1986:
1987: cursor c_params (p_comp_id in number) is

Line 2085: from fnd_svc_components

2081: container_type,
2082: inbound_agent_name,
2083: outbound_agent_name,
2084: correlation_id
2085: from fnd_svc_components
2086: where component_type = p_comp_type
2087: and component_name like nvl(p_comp_name, '%')
2088: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
2089:

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

3972:
3973: CURSOR c_comps IS
3974: select component_name comp_name, correlation_id corrid,
3975: inbound_agent_name inbound_agent,
3976: initcap(decode(FND_SVC_COMPONENT.Get_Component_Status(component_name),
3977: 'NOT_CONFIGURED', 'Not Configured',
3978: 'STOPPED_ERROR', 'Stopped with Error',
3979: 'DEACTIVATED_USER', 'User Deactivated',
3980: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,

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

3976: initcap(decode(FND_SVC_COMPONENT.Get_Component_Status(component_name),
3977: 'NOT_CONFIGURED', 'Not Configured',
3978: 'STOPPED_ERROR', 'Stopped with Error',
3979: 'DEACTIVATED_USER', 'User Deactivated',
3980: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,
3981: component_status_info info
3982: FROM fnd_svc_components_v
3983: WHERE component_type in ('WF_AGENT_LISTENER', 'WF_JAVA_AGENT_LISTENER');
3984:

Line 3982: FROM fnd_svc_components_v

3978: 'STOPPED_ERROR', 'Stopped with Error',
3979: 'DEACTIVATED_USER', 'User Deactivated',
3980: FND_SVC_COMPONENT.Get_Component_Status(component_name))) status,
3981: component_status_info info
3982: FROM fnd_svc_components_v
3983: WHERE component_type in ('WF_AGENT_LISTENER', 'WF_JAVA_AGENT_LISTENER');
3984:
3985: l_cells tdType;
3986: i pls_integer;