23: --
24: l_formula_id NUMBER;
25: l_effective_start_date DATE;
26: l_effective_end_date DATE;
27: l_inputs ff_exec.inputs_t;
28: l_outputs ff_exec.outputs_t;
29: l_business_group_id NUMBER;
30: l_person_id NUMBER;
31: l_organization_id NUMBER;
24: l_formula_id NUMBER;
25: l_effective_start_date DATE;
26: l_effective_end_date DATE;
27: l_inputs ff_exec.inputs_t;
28: l_outputs ff_exec.outputs_t;
29: l_business_group_id NUMBER;
30: l_person_id NUMBER;
31: l_organization_id NUMBER;
32: l_payroll_id NUMBER;
98: per_cagr_utility_pkg.put_log(' Information : Payroll ID = '||l_payroll_id);
99: per_cagr_utility_pkg.put_log(' Information : Person ID = '||l_person_id);
100: per_cagr_utility_pkg.put_log(' Information : Tax Unit ID = '||l_tax_unit_id);
101:
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
100: per_cagr_utility_pkg.put_log(' Information : Tax Unit ID = '||l_tax_unit_id);
101:
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
101:
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');
110: end if;
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');
110: end if;
111: -- if ff_exec.output_count < 8 then
112: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has less than 8 Output values defined.');
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');
110: end if;
111: -- if ff_exec.output_count < 8 then
112: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has less than 8 Output values defined.');
113: -- end if;
114: -- if ff_exec.output_count > 8 then
115: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has more than 8 Output values defined.');
110: end if;
111: -- if ff_exec.output_count < 8 then
112: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has less than 8 Output values defined.');
113: -- end if;
114: -- if ff_exec.output_count > 8 then
115: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has more than 8 Output values defined.');
116: -- end if;
117: -- hr_utility.set_location('FF',12);
118: --
154: hr_utility.set_location(l_proc, 15);
155: --
156: --
157: -- per_cagr_utility_pkg.put_log('Before Start of Run Formula ');
158: ff_exec.run_formula
159: (P_INPUTS => l_inputs
160: ,P_OUTPUTS => l_outputs
161: ,P_USE_DBI_CACHE=> FALSE);
162: --