APPS.FND_SVC_COMPONENT dependencies on FND_SVC_COMP_PARAM_VALS

Line 325: l_component_parameter_id fnd_svc_comp_param_vals.component_parameter_id%TYPE;

321: FROM fnd_svc_comp_params_b
322: WHERE component_type = p_component_type;
323:
324: l_rowid VARCHAR2(64);
325: l_component_parameter_id fnd_svc_comp_param_vals.component_parameter_id%TYPE;
326:
327: l_customization_level fnd_svc_components.customization_level%TYPE;
328: l_created_by NUMBER;
329: l_last_updated_by NUMBER;

Line 343: SELECT fnd_svc_comp_param_vals_s.nextval

339:
340: --
341: -- Retrieve next sequence value
342: --
343: SELECT fnd_svc_comp_param_vals_s.nextval
344: INTO l_component_parameter_id
345: FROM dual;
346:
347: --

Line 358: FND_SVC_COMP_PARAM_VALS_PKG.INSERT_ROW

354:
355: --
356: -- Insert parameter value
357: --
358: FND_SVC_COMP_PARAM_VALS_PKG.INSERT_ROW
359: ( x_rowid => l_rowid
360: , x_component_parameter_id => l_component_parameter_id
361: , x_component_id => p_component_id
362: , x_parameter_id => param.parameter_id

Line 514: l_result fnd_svc_comp_param_vals.parameter_value%TYPE;

510: ( p_parameter_name IN VARCHAR2
511: , p_component_id IN NUMBER)
512: RETURN VARCHAR2
513: AS
514: l_result fnd_svc_comp_param_vals.parameter_value%TYPE;
515:
516: BEGIN
517:
518: SELECT parameter_value

Line 520: FROM fnd_svc_comp_param_vals_v

516: BEGIN
517:
518: SELECT parameter_value
519: INTO l_result
520: FROM fnd_svc_comp_param_vals_v
521: WHERE parameter_name = p_parameter_name
522: AND component_id = p_component_id;
523:
524: RETURN l_result;