172: RETURN NUMBER IS
173: --
174: l_return_value NUMBER := to_number(null); -- Keeps the ABV to be returned
175: l_formula_id NUMBER; -- Id of the Fast Formula to be run
176: l_inputs ff_exec.inputs_t;
177: l_outputs ff_exec.outputs_t;
178: --
179: -- Selects applicant's assignment budget value from the ABV table for a given
180: -- budget_measurement type (if it exists)
173: --
174: l_return_value NUMBER := to_number(null); -- Keeps the ABV to be returned
175: l_formula_id NUMBER; -- Id of the Fast Formula to be run
176: l_inputs ff_exec.inputs_t;
177: l_outputs ff_exec.outputs_t;
178: --
179: -- Selects applicant's assignment budget value from the ABV table for a given
180: -- budget_measurement type (if it exists)
181: --
337: ELSE
338: --
339: -- Initialise the Inputs and Outputs tables
340: --
341: FF_Exec.Init_Formula
342: ( l_formula_id
343: , SYSDATE
344: , l_inputs
345: , l_outputs );
362: END IF;
363: --
364: -- Run the formula
365: --
366: FF_Exec.Run_Formula (l_inputs, l_outputs);
367: --
368: -- Get the result
369: --
370: l_return_value := FND_NUMBER.canonical_to_number( l_outputs(l_outputs.first).value );