APPS.FND_SET dependencies on FND_STAGE_FN_PARAMETERS_VL

Line 277: param_id fnd_stage_fn_parameters_vl.parameter_id%TYPE;

273: /* Get a stage function parameter ID given appl ID, function_id, param name */
274: FUNCTION parameter_id_f(fn_appl_id number,
275: fn_id number,
276: name varchar2) return number is
277: param_id fnd_stage_fn_parameters_vl.parameter_id%TYPE;
278: BEGIN
279: SELECT parameter_id
280: INTO param_id
281: FROM fnd_stage_fn_parameters_vl

Line 281: FROM fnd_stage_fn_parameters_vl

277: param_id fnd_stage_fn_parameters_vl.parameter_id%TYPE;
278: BEGIN
279: SELECT parameter_id
280: INTO param_id
281: FROM fnd_stage_fn_parameters_vl
282: WHERE application_id = fn_appl_id
283: AND function_id = fn_id
284: AND parameter_name = name;
285:

Line 2812: from fnd_stage_fn_parameters_vl

2808: fn_id := function_id_f(fn_appl_id, function_short_name);
2809:
2810: select 'y'
2811: into dummy
2812: from fnd_stage_fn_parameters_vl
2813: where application_id = fn_appl_id
2814: and function_id = fn_id
2815: and parameter_name = parameter;
2816:

Line 2857: from fnd_stage_fn_parameters_vl

2853:
2854: begin
2855: select parameter_id
2856: into param_id
2857: from fnd_stage_fn_parameters_vl
2858: where application_id = fn_appl_id
2859: and function_id = fn_id
2860: and parameter_name = parameter;
2861: exception

Line 2932: from fnd_request_set_stages s, fnd_stage_fn_parameters_vl p

2928:
2929: begin
2930: select s.function_id, s.function_application_id, p.parameter_id
2931: into fn_id, fn_appl_id, param_id
2932: from fnd_request_set_stages s, fnd_stage_fn_parameters_vl p
2933: where s.request_set_id = set_id
2934: and s.set_application_id = set_appl_id
2935: and s.request_set_stage_id = stage_id
2936: and s.function_id = p.function_id