558: END;
559:
560: PROCEDURE run_formula(p_formula_id IN NUMBER
561: ,p_effective_date IN DATE
562: ,p_inputs IN ff_exec.inputs_t
563: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
564: l_inputs ff_exec.inputs_t;
565: l_outputs ff_exec.outputs_t;
566: BEGIN
559:
560: PROCEDURE run_formula(p_formula_id IN NUMBER
561: ,p_effective_date IN DATE
562: ,p_inputs IN ff_exec.inputs_t
563: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
564: l_inputs ff_exec.inputs_t;
565: l_outputs ff_exec.outputs_t;
566: BEGIN
567: hr_utility.set_location('--In Formula ',20);
560: PROCEDURE run_formula(p_formula_id IN NUMBER
561: ,p_effective_date IN DATE
562: ,p_inputs IN ff_exec.inputs_t
563: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
564: l_inputs ff_exec.inputs_t;
565: l_outputs ff_exec.outputs_t;
566: BEGIN
567: hr_utility.set_location('--In Formula ',20);
568: --
561: ,p_effective_date IN DATE
562: ,p_inputs IN ff_exec.inputs_t
563: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
564: l_inputs ff_exec.inputs_t;
565: l_outputs ff_exec.outputs_t;
566: BEGIN
567: hr_utility.set_location('--In Formula ',20);
568: --
569: -- Initialize the formula
567: hr_utility.set_location('--In Formula ',20);
568: --
569: -- Initialize the formula
570: --
571: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
572: --
573: hr_utility.trace('after ff_exec');
574: -- Set up the input values
575: --
569: -- Initialize the formula
570: --
571: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
572: --
573: hr_utility.trace('after ff_exec');
574: -- Set up the input values
575: --
576: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
577: FOR i IN l_inputs.first..l_inputs.last LOOP
586: --
587: -- Run the formula
588: --
589: hr_utility.trace('about to exec');
590: ff_exec.run_formula(l_inputs,l_outputs);
591: --
592: -- Populate the output table
593: --
594: IF l_outputs.count > 0 and p_inputs.count > 0 then
647: and decode(HSCK.id_flex_num,20,to_number(HSCK.segment1),-9999) = HOU.organization_id*/
648: and hsck.segment1 = hou.organization_id
649: and HOI2.org_information_context = 'AE_REFERENCE_FF';
650: l_formula_id NUMBER;
651: l_inputs ff_exec.inputs_t;
652: l_outputs ff_exec.outputs_t;
653: l_value NUMBER;
654: l_indicator NUMBER;
655: i NUMBER;
648: and hsck.segment1 = hou.organization_id
649: and HOI2.org_information_context = 'AE_REFERENCE_FF';
650: l_formula_id NUMBER;
651: l_inputs ff_exec.inputs_t;
652: l_outputs ff_exec.outputs_t;
653: l_value NUMBER;
654: l_indicator NUMBER;
655: i NUMBER;
656: begin
733: and decode(HSCK.id_flex_num,20,to_number(HSCK.segment1),-9999) = HOU.organization_id*/
734: and hsck.segment1 = hou.organization_id
735: and HOI2.org_information_context = 'AE_REFERENCE_FF';
736: l_formula_id NUMBER;
737: l_inputs ff_exec.inputs_t;
738: l_outputs ff_exec.outputs_t;
739: l_value NUMBER;
740: l_monthly_salary NUMBER;
741: i NUMBER;
734: and hsck.segment1 = hou.organization_id
735: and HOI2.org_information_context = 'AE_REFERENCE_FF';
736: l_formula_id NUMBER;
737: l_inputs ff_exec.inputs_t;
738: l_outputs ff_exec.outputs_t;
739: l_value NUMBER;
740: l_monthly_salary NUMBER;
741: i NUMBER;
742: begin