DBA Data[Home] [Help]

APPS.PYUDET dependencies on FF_EXEC

Line 1172: l_inputs ff_exec.inputs_t;

1168: p_assignment_id in number) return VARCHAR2
1169: IS
1170: l_formula_id ff_formulas_f.formula_id%type;
1171: l_effective_start_date ff_formulas_f.effective_start_date%type;
1172: l_inputs ff_exec.inputs_t;
1173: l_outputs ff_exec.outputs_t;
1174: l_return_value varchar2(50):= null;
1175: l_formula_mesg varchar2(50):= null;
1176: l_status_value varchar2(2):= null;

Line 1173: l_outputs ff_exec.outputs_t;

1169: IS
1170: l_formula_id ff_formulas_f.formula_id%type;
1171: l_effective_start_date ff_formulas_f.effective_start_date%type;
1172: l_inputs ff_exec.inputs_t;
1173: l_outputs ff_exec.outputs_t;
1174: l_return_value varchar2(50):= null;
1175: l_formula_mesg varchar2(50):= null;
1176: l_status_value varchar2(2):= null;
1177: BEGIN

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

1189: and p_effective_date between effective_start_date and effective_end_date;
1190: ----------------------------
1191: -- Initialize the formula --
1192: ----------------------------
1193: ff_exec.init_formula(l_formula_id,l_effective_start_date,l_inputs,l_outputs);
1194: -------------------------
1195: -- Setup formula input --
1196: -------------------------
1197: for l_in_cnt in l_inputs.first..l_inputs.last loop

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

1207: end loop;
1208: -------------------------
1209: -- Execute the formula --
1210: -------------------------
1211: ff_exec.run_formula(l_inputs,l_outputs);
1212: --------------------
1213: -- Reading output --
1214: --------------------
1215: for l_out_cnt in l_outputs.first..l_outputs.last loop