Running Oracle Fast Formula from PL/SQL Package Procedure

for c_formula_details_rec IN c_formula_details Loop

v_formula_id := c_formula_details_rec.formula_id;

end loop;

 

FF_EXEC.init_formula(p_formula_id => v_formula_id,

p_effective_date => v_eff_date,

p_inputs => l_f_inputs,

p_outputs => l_f_outputs);

 

IF l_f_inputs.count > 0 THEN

 

FOR i IN l_f_inputs.first .. l_f_inputs.last LOOP

IF l_f_inputs(i).name = 'BUSINESS_GROUP_ID' THEN

l_f_inputs(i).value := nBGId;

 

ELSIF l_f_inputs(i).name = 'ASSIGNMENT_ID' THEN

l_f_inputs(i).value := nAssignmentId;

 

ELSIF l_f_inputs(i).name = 'EFFECTIVE_DATE' THEN

l_f_inputs(i).value := v_eff_date;

ELSIF l_f_inputs(i).name = 'LV_ELEMENT_NAME' THEN

l_f_inputs(i).value := v_Row_Value;

 

END IF;

END LOOP;

END IF;

 

FF_EXEC.run_formula(p_inputs => l_f_inputs,

p_outputs => l_f_outputs,

p_use_dbi_cache => FALSE);

 

for i in l_f_outputs.first .. l_f_outputs.last loop

--

vActualValue:=lpad(l_f_outputs(i).value, 30);

end loop;