1 PACKAGE pay_dk_sickpay_pkg AS
2 /* $Header: pydksckp.pkh 120.0 2006/03/23 04:02:46 knelli noship $ */
3
4 TYPE l_type IS TABLE OF varchar2(50) INDEX BY binary_integer;
5 l_rec l_type;
6
7 FUNCTION get_worked_hours(p_assignment_id IN number
8 ,p_period_start_date IN date
9 ,p_period_end_date IN date)RETURN number;
10
11 /*Bug 5047360 fix- Passing p_abs_start_time and p_abs_end_time*/
12 FUNCTION get_sickness_dur_details
13 (p_assignment_id IN NUMBER
14 ,p_effective_date IN DATE
15 ,p_abs_start_date IN DATE
16 ,p_abs_end_date IN DATE
17 ,p_abs_start_time IN VARCHAR2 --Bug 5047360 fix
18 ,p_abs_end_time IN VARCHAR2 --Bug 5047360 fix
19 ,p_start_date OUT NOCOPY DATE
20 ,p_end_date OUT NOCOPY DATE
21 ,p_sick_days OUT NOCOPY NUMBER
22 ,p_sick_hours OUT NOCOPY NUMBER
23 ) RETURN NUMBER;
24
25 FUNCTION get_le_sickpay_details
26 (p_effective_date IN DATE,
27 p_org_id IN NUMBER,
28 p_section27 OUT NOCOPY VARCHAR2
29 ) RETURN NUMBER;
30
31 /*Bug 5020916 fix - Fucntion to get the section 28 value based on the payroll processing start date*/
32 FUNCTION get_section28_details
33 (p_assignment_id IN NUMBER
34 ,p_effective_date IN DATE --payroll processing start date
35 ) RETURN VARCHAR2;
36
37 /* Bug fix 5045710, added function get_worked_days */
38 FUNCTION get_worked_days(p_assignment_id IN number
39 ,p_period_start_date IN date
40 ,p_period_end_date IN date)RETURN number;
41
42 /* Bug fix 5045710, added function get_74hours_flag */
43 FUNCTION get_worked_hours_flag(p_assignment_id IN number
44 ,p_worked_days_limit IN number
45 ,p_worked_hours_limit IN number
46 ,p_period_end_date IN date) RETURN varchar2;
47
48 END pay_dk_sickpay_pkg;
49