DBA Data[Home] [Help]

APPS.PYUDET dependencies on FF_EXEC

Line 1046: l_inputs ff_exec.inputs_t;

1042: p_assignment_id in number) return VARCHAR2
1043: IS
1044: l_formula_id ff_formulas_f.formula_id%type;
1045: l_effective_start_date ff_formulas_f.effective_start_date%type;
1046: l_inputs ff_exec.inputs_t;
1047: l_outputs ff_exec.outputs_t;
1048: l_return_value varchar2(50):= null;
1049: l_formula_mesg varchar2(50):= null;
1050: l_status_value varchar2(2):= null;

Line 1047: l_outputs ff_exec.outputs_t;

1043: IS
1044: l_formula_id ff_formulas_f.formula_id%type;
1045: l_effective_start_date ff_formulas_f.effective_start_date%type;
1046: l_inputs ff_exec.inputs_t;
1047: l_outputs ff_exec.outputs_t;
1048: l_return_value varchar2(50):= null;
1049: l_formula_mesg varchar2(50):= null;
1050: l_status_value varchar2(2):= null;
1051: BEGIN

Line 1067: ff_exec.init_formula(l_formula_id,l_effective_start_date,l_inputs,l_outputs);

1063: and p_effective_date between effective_start_date and effective_end_date;
1064: ----------------------------
1065: -- Initialize the formula --
1066: ----------------------------
1067: ff_exec.init_formula(l_formula_id,l_effective_start_date,l_inputs,l_outputs);
1068: -------------------------
1069: -- Setup formula input --
1070: -------------------------
1071: for l_in_cnt in l_inputs.first..l_inputs.last loop

Line 1085: ff_exec.run_formula(l_inputs,l_outputs);

1081: end loop;
1082: -------------------------
1083: -- Execute the formula --
1084: -------------------------
1085: ff_exec.run_formula(l_inputs,l_outputs);
1086: --------------------
1087: -- Reading output --
1088: --------------------
1089: for l_out_cnt in l_outputs.first..l_outputs.last loop