1 PACKAGE PAY_ES_BENEFIT_UPLIFT_CALC AUTHID CURRENT_USER AS
2 /* $Header: pyesssbu.pkh 120.0 2005/05/29 04:39:50 appldev noship $ */
3 --
4 FUNCTION get_gross_per_day(p_assignment_id IN NUMBER
5 ,p_business_group_id IN NUMBER
6 ,p_date_earned IN DATE
7 ,p_formula_name IN VARCHAR2
8 ) RETURN NUMBER;
9 --
10 FUNCTION get_duration(p_assignment_id IN NUMBER
11 ,p_business_group_id IN NUMBER
12 ,p_date_earned IN DATE
13 ,p_formula_name IN VARCHAR2
14 ,p_rate1 OUT NOCOPY NUMBER
15 ,p_value1 OUT NOCOPY NUMBER
16 ,p_rate2 OUT NOCOPY NUMBER
17 ,p_value2 OUT NOCOPY NUMBER
18 ,p_rate3 OUT NOCOPY NUMBER
19 ,p_value3 OUT NOCOPY NUMBER
20 ,p_rate4 OUT NOCOPY NUMBER
21 ,p_value4 OUT NOCOPY NUMBER
22 ,p_rate5 OUT NOCOPY NUMBER
23 ,p_value5 OUT NOCOPY NUMBER
24 ,p_rate6 OUT NOCOPY NUMBER
25 ,p_value6 OUT NOCOPY NUMBER
26 ,p_rate7 OUT NOCOPY NUMBER
27 ,p_value7 OUT NOCOPY NUMBER
28 ,p_rate8 OUT NOCOPY NUMBER
29 ,p_value8 OUT NOCOPY NUMBER
30 ,p_rate9 OUT NOCOPY NUMBER
31 ,p_value9 OUT NOCOPY NUMBER
32 ,p_rate10 OUT NOCOPY NUMBER
33 ,p_value10 OUT NOCOPY NUMBER
34 ) RETURN VARCHAR2;
35 --
36 PROCEDURE cache_formula(p_formula_name IN VARCHAR2
37 ,p_business_group_id IN NUMBER
38 ,p_effective_date IN DATE
39 ,p_formula_id IN OUT NOCOPY NUMBER
40 ,p_formula_exists IN OUT NOCOPY BOOLEAN
41 ,p_formula_cached IN OUT NOCOPY BOOLEAN
42 );
43 --
44 PROCEDURE run_formula(p_formula_id IN NUMBER
45 ,p_effective_date IN DATE
46 ,p_formula_name IN VARCHAR2
47 ,p_inputs IN ff_exec.inputs_t
48 ,p_outputs IN OUT NOCOPY ff_exec.outputs_t);
49 --
50 END pay_es_benefit_uplift_calc;
[Home] [Help]