DBA Data[Home] [Help]

APPS.PAY_FI_GENERAL dependencies on FF_EXEC

Line 39: ,p_inputs IN ff_exec.inputs_t

35: END good_time_format;
36:
37: PROCEDURE run_formula(p_formula_id IN NUMBER
38: ,p_effective_date IN DATE
39: ,p_inputs IN ff_exec.inputs_t
40: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
41: l_inputs ff_exec.inputs_t;
42: l_outputs ff_exec.outputs_t;
43: BEGIN

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

36:
37: PROCEDURE run_formula(p_formula_id IN NUMBER
38: ,p_effective_date IN DATE
39: ,p_inputs IN ff_exec.inputs_t
40: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
41: l_inputs ff_exec.inputs_t;
42: l_outputs ff_exec.outputs_t;
43: BEGIN
44: hr_utility.set_location('--In Formula ',20);

Line 41: l_inputs ff_exec.inputs_t;

37: PROCEDURE run_formula(p_formula_id IN NUMBER
38: ,p_effective_date IN DATE
39: ,p_inputs IN ff_exec.inputs_t
40: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
41: l_inputs ff_exec.inputs_t;
42: l_outputs ff_exec.outputs_t;
43: BEGIN
44: hr_utility.set_location('--In Formula ',20);
45: --

Line 42: l_outputs ff_exec.outputs_t;

38: ,p_effective_date IN DATE
39: ,p_inputs IN ff_exec.inputs_t
40: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
41: l_inputs ff_exec.inputs_t;
42: l_outputs ff_exec.outputs_t;
43: BEGIN
44: hr_utility.set_location('--In Formula ',20);
45: --
46: -- Initialize the formula

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

44: hr_utility.set_location('--In Formula ',20);
45: --
46: -- Initialize the formula
47: --
48: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
49: --
50: hr_utility.trace('after ff_exec');
51: -- Set up the input values
52: --

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

46: -- Initialize the formula
47: --
48: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
49: --
50: hr_utility.trace('after ff_exec');
51: -- Set up the input values
52: --
53: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
54: FOR i IN l_inputs.first..l_inputs.last LOOP

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

63: --
64: -- Run the formula
65: --
66: hr_utility.trace('about to exec');
67: ff_exec.run_formula(l_inputs,l_outputs);
68: --
69: -- Populate the output table
70: --
71: IF l_outputs.count > 0 and p_inputs.count > 0 then

Line 148: l_inputs ff_exec.inputs_t;

144: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
145: and PRL_INFORMATION_CATEGORY = 'FI';
146: */
147: l_formula_id NUMBER;
148: l_inputs ff_exec.inputs_t;
149: l_outputs ff_exec.outputs_t;
150: l_value NUMBER;
151: begin
152: open csr_get_formula_id(p_date_earned,p_assignment_id,'Accrual Formula');

Line 149: l_outputs ff_exec.outputs_t;

145: and PRL_INFORMATION_CATEGORY = 'FI';
146: */
147: l_formula_id NUMBER;
148: l_inputs ff_exec.inputs_t;
149: l_outputs ff_exec.outputs_t;
150: l_value NUMBER;
151: begin
152: open csr_get_formula_id(p_date_earned,p_assignment_id,'Accrual Formula');
153: fetch csr_get_formula_id into l_formula_id;

Line 361: l_inputs ff_exec.inputs_t;

357: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
358: and PRL_INFORMATION_CATEGORY = 'FI';
359: */
360: l_formula_id NUMBER;
361: l_inputs ff_exec.inputs_t;
362: l_outputs ff_exec.outputs_t;
363: l_value NUMBER;
364: begin
365: open csr_get_formula_id(p_date_earned,p_assignment_id,'Entitlement Formula');

Line 362: l_outputs ff_exec.outputs_t;

358: and PRL_INFORMATION_CATEGORY = 'FI';
359: */
360: l_formula_id NUMBER;
361: l_inputs ff_exec.inputs_t;
362: l_outputs ff_exec.outputs_t;
363: l_value NUMBER;
364: begin
365: open csr_get_formula_id(p_date_earned,p_assignment_id,'Entitlement Formula');
366: fetch csr_get_formula_id into l_formula_id;

Line 852: l_inputs ff_exec.inputs_t;

848: and pp.payroll_id = p_payroll_id
849: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
850: and PRL_INFORMATION_CATEGORY = 'FI';
851: l_formula_id NUMBER;
852: l_inputs ff_exec.inputs_t;
853: l_outputs ff_exec.outputs_t;
854: l_value NUMBER;
855: begin
856: open csr_get_formula_id;

Line 853: l_outputs ff_exec.outputs_t;

849: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
850: and PRL_INFORMATION_CATEGORY = 'FI';
851: l_formula_id NUMBER;
852: l_inputs ff_exec.inputs_t;
853: l_outputs ff_exec.outputs_t;
854: l_value NUMBER;
855: begin
856: open csr_get_formula_id;
857: fetch csr_get_formula_id into l_formula_id;