APPS.WF_MAILER_PARAMETER dependencies on FND_SVC_COMPONENT

Line 982: l_component_id fnd_svc_components.component_id%TYPE;

978: -- the value of the parameter.
979: FUNCTION GetValueForCorr(pCorrId IN VARCHAR2, pName IN VARCHAR2) RETURN VARCHAR2
980: IS
981:
982: l_component_id fnd_svc_components.component_id%TYPE;
983: l_value fnd_svc_comp_param_vals.parameter_value%TYPE;
984: l_component_found boolean;
985: l_corrid varchar2(40);
986:

Line 989: FROM FND_SVC_COMPONENTS

985: l_corrid varchar2(40);
986:
987: CURSOR c_get_components_for_corr is
988: SELECT component_id
989: FROM FND_SVC_COMPONENTS
990: WHERE
991: l_corrid like correlation_id and
992: component_type = 'WF_MAILER'
993: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;

Line 997: FROM FND_SVC_COMPONENTS

993: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
994:
995: CURSOR c_get_components_for_null_corr is
996: SELECT component_id
997: FROM FND_SVC_COMPONENTS
998: WHERE
999: correlation_id is null and
1000: component_type = 'WF_MAILER'
1001: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;

Line 1033: l_value := FND_SVC_COMPONENT.Retrieve_Parameter_Value

1029: end loop;
1030: END IF;
1031:
1032: if l_component_found then
1033: l_value := FND_SVC_COMPONENT.Retrieve_Parameter_Value
1034: (p_parameter_name => pName,
1035: p_component_id => l_component_id);
1036: END IF;
1037: