4:
5:
6: PROCEDURE run_formula(p_formula_id IN NUMBER
7: ,p_effective_date IN DATE
8: ,p_inputs IN ff_exec.inputs_t
9: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
10: l_inputs ff_exec.inputs_t;
11: l_outputs ff_exec.outputs_t;
12: BEGIN
5:
6: PROCEDURE run_formula(p_formula_id IN NUMBER
7: ,p_effective_date IN DATE
8: ,p_inputs IN ff_exec.inputs_t
9: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
10: l_inputs ff_exec.inputs_t;
11: l_outputs ff_exec.outputs_t;
12: BEGIN
13: hr_utility.set_location('--In Formula ',20);
6: PROCEDURE run_formula(p_formula_id IN NUMBER
7: ,p_effective_date IN DATE
8: ,p_inputs IN ff_exec.inputs_t
9: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
10: l_inputs ff_exec.inputs_t;
11: l_outputs ff_exec.outputs_t;
12: BEGIN
13: hr_utility.set_location('--In Formula ',20);
14: --
7: ,p_effective_date IN DATE
8: ,p_inputs IN ff_exec.inputs_t
9: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
10: l_inputs ff_exec.inputs_t;
11: l_outputs ff_exec.outputs_t;
12: BEGIN
13: hr_utility.set_location('--In Formula ',20);
14: --
15: -- Initialize the formula
13: hr_utility.set_location('--In Formula ',20);
14: --
15: -- Initialize the formula
16: --
17: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
18: --
19: hr_utility.trace('after ff_exec');
20: -- Set up the input values
21: --
15: -- Initialize the formula
16: --
17: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
18: --
19: hr_utility.trace('after ff_exec');
20: -- Set up the input values
21: --
22: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
23: FOR i IN l_inputs.first..l_inputs.last LOOP
32: --
33: -- Run the formula
34: --
35: hr_utility.trace('about to exec');
36: ff_exec.run_formula(l_inputs,l_outputs);
37: --
38: -- Populate the output table
39: --
40: IF l_outputs.count > 0 and p_inputs.count > 0 then
102: and HSCK.id_flex_num = p_id_flex_num
103: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
104: and HOI2.org_information_context = 'AE_REFERENCE_FF';
105: l_formula_id NUMBER;
106: l_inputs ff_exec.inputs_t;
107: l_outputs ff_exec.outputs_t;
108: l_value NUMBER;
109: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
110: begin
103: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
104: and HOI2.org_information_context = 'AE_REFERENCE_FF';
105: l_formula_id NUMBER;
106: l_inputs ff_exec.inputs_t;
107: l_outputs ff_exec.outputs_t;
108: l_value NUMBER;
109: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
110: begin
111: open csr_get_id_flex_num;
203: and HSCK.id_flex_num = p_id_flex_num
204: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
205: and HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';
206: l_formula_id NUMBER;
207: l_inputs ff_exec.inputs_t;
208: l_outputs ff_exec.outputs_t;
209: l_value NUMBER;
210: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
211: begin
204: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
205: and HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';
206: l_formula_id NUMBER;
207: l_inputs ff_exec.inputs_t;
208: l_outputs ff_exec.outputs_t;
209: l_value NUMBER;
210: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
211: begin
212: open csr_get_id_flex_num;
306: and HSCK.id_flex_num = p_id_flex_num
307: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
308: and HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';
309: l_formula_id NUMBER;
310: l_inputs ff_exec.inputs_t;
311: l_outputs ff_exec.outputs_t;
312: l_value NUMBER;
313: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
314: begin
307: and decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
308: and HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';
309: l_formula_id NUMBER;
310: l_inputs ff_exec.inputs_t;
311: l_outputs ff_exec.outputs_t;
312: l_value NUMBER;
313: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
314: begin
315: hr_utility.set_location('Inside run_SA_GOSI_formula',10);