136: --
137: l_formula_id ff_formulas_f.formula_id%TYPE;
138: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
139: l_bg_currency_code VARCHAR2(30);
140: l_inputs ff_exec.inputs_t;
141: l_outputs ff_exec.outputs_t;
142: wrong_input_params exception;
143: wrong_output_params exception;
144: BEGIN
137: l_formula_id ff_formulas_f.formula_id%TYPE;
138: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
139: l_bg_currency_code VARCHAR2(30);
140: l_inputs ff_exec.inputs_t;
141: l_outputs ff_exec.outputs_t;
142: wrong_input_params exception;
143: wrong_output_params exception;
144: BEGIN
145: --
164: --
165: -- Prepare to run the formula.
166: --
167: hr_utility.set_location(c_proc_name, 20);
168: ff_exec.init_formula
169: (l_formula_id
170: ,l_effective_start_date
171: ,l_inputs
172: ,l_outputs);
206: --
207: -- Run the formula.
208: --
209: hr_utility.set_location(c_proc_name, 40);
210: ff_exec.run_formula
211: (l_inputs
212: ,l_outputs);
213: --
214: --
261: -- Local variables.
262: --
263: l_formula_id ff_formulas_f.formula_id%type;
264: l_effective_start_date ff_formulas_f.effective_start_date%type;
265: l_inputs ff_exec.inputs_t;
266: l_outputs ff_exec.outputs_t;
267: l_return_value VARCHAR(240) := p_national_identifier;
268: l_invalid_mesg VARCHAR(240);
269: wrong_input_params exception;
262: --
263: l_formula_id ff_formulas_f.formula_id%type;
264: l_effective_start_date ff_formulas_f.effective_start_date%type;
265: l_inputs ff_exec.inputs_t;
266: l_outputs ff_exec.outputs_t;
267: l_return_value VARCHAR(240) := p_national_identifier;
268: l_invalid_mesg VARCHAR(240);
269: wrong_input_params exception;
270: wrong_output_params exception;
281: --
282: --
283: -- Prepare to run the formula.
284: --
285: ff_exec.init_formula
286: (l_formula_id
287: ,l_effective_start_date
288: ,l_inputs
289: ,l_outputs);
307: --
308: --
309: -- Run the formula.
310: --
311: ff_exec.run_formula
312: (l_inputs
313: ,l_outputs);
314: --
315: --