DBA Data[Home] [Help]

APPS.PAY_AE_USER_FUNCTION dependencies on FF_EXEC

Line 8: ,p_inputs IN ff_exec.inputs_t

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

Line 9: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS

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);

Line 10: l_inputs ff_exec.inputs_t;

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: --

Line 11: l_outputs ff_exec.outputs_t;

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

Line 17: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

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: --

Line 19: hr_utility.trace('after ff_exec');

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

Line 36: ff_exec.run_formula(l_inputs,l_outputs);

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

Line 106: l_inputs ff_exec.inputs_t;

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

Line 107: l_outputs ff_exec.outputs_t;

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;

Line 207: l_inputs ff_exec.inputs_t;

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

Line 208: l_outputs ff_exec.outputs_t;

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;

Line 310: l_inputs ff_exec.inputs_t;

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

Line 311: l_outputs ff_exec.outputs_t;

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);