DBA Data[Home] [Help]

APPS.PAY_ES_BENEFIT_UPLIFT_CALC dependencies on FF_EXEC

Line 24: l_inputs ff_exec.inputs_t;

20: ,p_date_earned IN DATE
21: ,p_formula_name IN VARCHAR2
22: ) RETURN NUMBER IS
23: --
24: l_inputs ff_exec.inputs_t;
25: l_outputs ff_exec.outputs_t;
26: l_formula_exists BOOLEAN := TRUE;
27: l_formula_cached BOOLEAN := FALSE;
28: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 25: l_outputs ff_exec.outputs_t;

21: ,p_formula_name IN VARCHAR2
22: ) RETURN NUMBER IS
23: --
24: l_inputs ff_exec.inputs_t;
25: l_outputs ff_exec.outputs_t;
26: l_formula_exists BOOLEAN := TRUE;
27: l_formula_cached BOOLEAN := FALSE;
28: l_formula_id ff_formulas_f.formula_id%TYPE;
29: l_gross_per_day VARCHAR2(500);

Line 107: l_inputs ff_exec.inputs_t;

103: ,p_rate10 OUT NOCOPY NUMBER
104: ,p_value10 OUT NOCOPY NUMBER
105: ) RETURN VARCHAR2 IS
106: --
107: l_inputs ff_exec.inputs_t;
108: l_outputs ff_exec.outputs_t;
109: l_formula_exists BOOLEAN := TRUE;
110: l_formula_cached BOOLEAN := FALSE;
111: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 108: l_outputs ff_exec.outputs_t;

104: ,p_value10 OUT NOCOPY NUMBER
105: ) RETURN VARCHAR2 IS
106: --
107: l_inputs ff_exec.inputs_t;
108: l_outputs ff_exec.outputs_t;
109: l_formula_exists BOOLEAN := TRUE;
110: l_formula_cached BOOLEAN := FALSE;
111: l_formula_id ff_formulas_f.formula_id%TYPE;
112: l_return_indicator VARCHAR2(1);

Line 327: ,p_inputs IN ff_exec.inputs_t

323: -------------------------------------------------------------------------------
324: PROCEDURE run_formula(p_formula_id IN NUMBER
325: ,p_effective_date IN DATE
326: ,p_formula_name IN VARCHAR2
327: ,p_inputs IN ff_exec.inputs_t
328: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
329: --
330: l_inputs ff_exec.inputs_t;
331: l_outputs ff_exec.outputs_t;

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

324: PROCEDURE run_formula(p_formula_id IN NUMBER
325: ,p_effective_date IN DATE
326: ,p_formula_name IN VARCHAR2
327: ,p_inputs IN ff_exec.inputs_t
328: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
329: --
330: l_inputs ff_exec.inputs_t;
331: l_outputs ff_exec.outputs_t;
332: --

Line 330: l_inputs ff_exec.inputs_t;

326: ,p_formula_name IN VARCHAR2
327: ,p_inputs IN ff_exec.inputs_t
328: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
329: --
330: l_inputs ff_exec.inputs_t;
331: l_outputs ff_exec.outputs_t;
332: --
333: BEGIN
334: hr_utility.set_location('--In Formula ',20);

Line 331: l_outputs ff_exec.outputs_t;

327: ,p_inputs IN ff_exec.inputs_t
328: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
329: --
330: l_inputs ff_exec.inputs_t;
331: l_outputs ff_exec.outputs_t;
332: --
333: BEGIN
334: hr_utility.set_location('--In Formula ',20);
335: --

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

334: hr_utility.set_location('--In Formula ',20);
335: --
336: -- Initialize the formula
337: --
338: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
339: --
340: -- Set up the input values
341: --
342: IF l_inputs.count > 0 and p_inputs.count > 0 THEN

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

351: END IF;
352: --
353: -- Run the formula
354: --
355: ff_exec.run_formula(l_inputs,l_outputs);
356: --
357: -- Populate the output table
358: --
359: IF l_outputs.count > 0 and p_inputs.count > 0 then