APPS.PAY_SA_USER_FUNCTION dependencies on FF_EXEC

Line 6: ,p_inputs IN ff_exec.inputs_t

2: /* $Header: pysarunf.pkb 120.0.12010000.2 2008/10/31 11:59:17 bkeshary ship $ */
3: g_formula_name ff_formulas_f.formula_name%TYPE;
4: PROCEDURE run_formula(p_formula_id IN NUMBER
5: ,p_effective_date IN DATE
6: ,p_inputs IN ff_exec.inputs_t
7: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
8: l_inputs ff_exec.inputs_t;
9: l_outputs ff_exec.outputs_t;
10: BEGIN

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

3: g_formula_name ff_formulas_f.formula_name%TYPE;
4: PROCEDURE run_formula(p_formula_id IN NUMBER
5: ,p_effective_date IN DATE
6: ,p_inputs IN ff_exec.inputs_t
7: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
8: l_inputs ff_exec.inputs_t;
9: l_outputs ff_exec.outputs_t;
10: BEGIN
11: hr_utility.set_location('--In Formula ',20);

Line 8: l_inputs ff_exec.inputs_t;

4: PROCEDURE run_formula(p_formula_id IN NUMBER
5: ,p_effective_date IN DATE
6: ,p_inputs IN ff_exec.inputs_t
7: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
8: l_inputs ff_exec.inputs_t;
9: l_outputs ff_exec.outputs_t;
10: BEGIN
11: hr_utility.set_location('--In Formula ',20);
12: --

Line 9: l_outputs ff_exec.outputs_t;

5: ,p_effective_date IN DATE
6: ,p_inputs IN ff_exec.inputs_t
7: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
8: l_inputs ff_exec.inputs_t;
9: l_outputs ff_exec.outputs_t;
10: BEGIN
11: hr_utility.set_location('--In Formula ',20);
12: --
13: -- Initialize the formula

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

11: hr_utility.set_location('--In Formula ',20);
12: --
13: -- Initialize the formula
14: --
15: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
16: --
17: hr_utility.trace('after ff_exec');
18: -- Set up the input values
19: --

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

13: -- Initialize the formula
14: --
15: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
16: --
17: hr_utility.trace('after ff_exec');
18: -- Set up the input values
19: --
20: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
21: FOR i IN l_inputs.first..l_inputs.last LOOP

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

30: --
31: -- Run the formula
32: --
33: hr_utility.trace('about to exec');
34: ff_exec.run_formula(l_inputs,l_outputs);
35: --
36: -- Populate the output table
37: --
38: IF l_outputs.count > 0 and p_inputs.count > 0 then

Line 97: l_inputs ff_exec.inputs_t;

93: and HSCK.id_flex_num = 20
94: and decode(HSCK.id_flex_num,20,to_number(HSCK.segment1),-9999) = HOU.organization_id
95: and HOI2.org_information_context = 'SA_GOSI_REFERENCE_FORMULA';
96: l_formula_id NUMBER;
97: l_inputs ff_exec.inputs_t;
98: l_outputs ff_exec.outputs_t;
99: l_value NUMBER;
100: begin
101: open csr_get_formula_id;

Line 98: l_outputs ff_exec.outputs_t;

94: and decode(HSCK.id_flex_num,20,to_number(HSCK.segment1),-9999) = HOU.organization_id
95: and HOI2.org_information_context = 'SA_GOSI_REFERENCE_FORMULA';
96: l_formula_id NUMBER;
97: l_inputs ff_exec.inputs_t;
98: l_outputs ff_exec.outputs_t;
99: l_value NUMBER;
100: begin
101: open csr_get_formula_id;
102: fetch csr_get_formula_id into l_formula_id;