DBA Data[Home] [Help]

APPS.FND_SVC_COMP_PARAM_VALS_PKG dependencies on FND_SVC_COMPONENTS

Line 337: l_component_type fnd_svc_components.component_type%TYPE;

333:
334: l_component_parameter_id number;
335: l_parameter_id number;
336: l_component_id number;
337: l_component_type fnd_svc_components.component_type%TYPE;
338: begin
339:
340: if (X_OWNER = 'ORACLE') then
341: user_id := 1;

Line 346: FROM fnd_svc_components

342: end if;
343:
344: SELECT component_id, component_type
345: INTO l_component_id, l_component_type
346: FROM fnd_svc_components
347: WHERE component_name = X_COMPONENT_NAME;
348:
349: SELECT parameter_id
350: INTO l_parameter_id