1 PACKAGE PAY_DK_ABSENCE_USER AS
2 /*$Header: pydkabsence.pkh 120.1.12000000.2 2007/05/08 06:59:26 saurai noship $*/
3 Function Element_populate (p_assignment_id in number,
4 p_person_id in number,
5 p_absence_attendance_id in number,
6 p_element_type_id in number,
7 p_absence_category in varchar2,
8 p_original_entry_id OUT nocopy NUMBER,
9 p_input_value_name1 OUT NOCOPY VARCHAR2,
10 p_input_value1 OUT NOCOPY VARCHAR2,
11 p_input_value_name2 OUT NOCOPY VARCHAR2,
12 p_input_value2 OUT NOCOPY VARCHAR2,
13 p_input_value_name3 OUT NOCOPY VARCHAR2,
14 p_input_value3 OUT NOCOPY VARCHAR2,
15 p_input_value_name4 OUT NOCOPY VARCHAR2,
16 p_input_value4 OUT NOCOPY VARCHAR2,
17 p_input_value_name5 OUT NOCOPY VARCHAR2,
18 p_input_value5 OUT NOCOPY VARCHAR2,
19 p_input_value_name6 OUT NOCOPY VARCHAR2,
20 p_input_value6 OUT NOCOPY VARCHAR2,
21 p_input_value_name7 OUT NOCOPY VARCHAR2,
22 p_input_value7 OUT NOCOPY VARCHAR2,
23 p_input_value_name8 OUT NOCOPY VARCHAR2,
24 p_input_value8 OUT NOCOPY VARCHAR2,
25 p_input_value_name9 OUT NOCOPY VARCHAR2,
26 p_input_value9 OUT NOCOPY VARCHAR2,
27 p_input_value_name10 OUT NOCOPY VARCHAR2,
28 p_input_value10 OUT NOCOPY VARCHAR2,
29 p_input_value_name11 OUT NOCOPY VARCHAR2,
30 p_input_value11 OUT NOCOPY VARCHAR2,
31 p_input_value_name12 OUT NOCOPY VARCHAR2,
32 p_input_value12 OUT NOCOPY VARCHAR2,
33 p_input_value_name13 OUT NOCOPY VARCHAR2,
34 p_input_value13 OUT NOCOPY VARCHAR2,
35 p_input_value_name14 OUT NOCOPY VARCHAR2,
36 p_input_value14 OUT NOCOPY VARCHAR2,
37 p_input_value_name15 OUT NOCOPY VARCHAR2,
38 p_input_value15 OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
39
40
41 FUNCTION get_override_details
42 (p_assignment_id IN NUMBER
43 ,p_effective_date IN DATE
44 ,p_abs_start_date IN DATE
45 ,p_abs_end_date IN DATE
46 ,p_pre_birth_duration IN OUT NOCOPY NUMBER
47 ,p_post_birth_duration IN OUT NOCOPY NUMBER
48 ,p_maternity_allowance_used OUT NOCOPY NUMBER
49 ,p_shared_allowance_used OUT NOCOPY NUMBER
50 ,p_holiday_override OUT NOCOPY NUMBER
51 ,p_part_time_hours IN OUT NOCOPY NUMBER
52 ,p_part_time_hrs_freq IN OUT NOCOPY VARCHAR2
53 ) RETURN NUMBER;
54
55 FUNCTION get_absence_details
56 (p_assignment_id IN NUMBER
57 ,p_date_earned IN DATE
58 ,p_abs_attendance_id IN NUMBER
59 ,p_expected_dob OUT NOCOPY DATE
60 ,p_actual_dob OUT NOCOPY DATE
61 ,p_pre_birth_duration OUT NOCOPY NUMBER
62 ,p_post_birth_duration OUT NOCOPY NUMBER
63 ,p_frequency OUT NOCOPY VARCHAR2
64 ,p_normal_hours OUT NOCOPY NUMBER
65 ,p_maternity_weeks_transfer OUT NOCOPY NUMBER
66 ,p_holiday_accrual OUT NOCOPY VARCHAR2
67 ) Return varchar2;
68
69 FUNCTION get_assg_term_date
70 (p_business_group_id IN NUMBER
71 ,p_assignment_id IN NUMBER)
72 RETURN DATE;
73
74 /*Function to get paternity absence details*/
75 FUNCTION get_pat_abs_details
76 (
77 p_abs_attendance_id IN NUMBER,
78 p_override_weeks OUT NOCOPY NUMBER,
79 p_holiday_accrual OUT NOCOPY VARCHAR2
80 ) Return NUMBER;
81
82 FUNCTION get_paternity_override
83 (p_assignment_id IN NUMBER
84 ,p_effective_date IN DATE
85 ,p_abs_start_date IN DATE
86 ,p_abs_end_date IN DATE
87 ,p_duration_override IN OUT NOCOPY NUMBER
88 ,p_holiday_override OUT NOCOPY NUMBER
89 ) RETURN NUMBER;
90
91 FUNCTION get_adopt_abs_details
92 (p_assignment_id IN NUMBER
93 ,p_date_earned IN DATE
94 ,p_abs_attendance_id IN NUMBER
95 ,p_expected_dob OUT NOCOPY DATE
96 ,p_actual_dob OUT NOCOPY DATE
97 ,p_pre_adopt_duration OUT NOCOPY NUMBER
98 ,p_post_adopt_duration OUT NOCOPY NUMBER
99 ,p_adopt_weeks_transfer OUT NOCOPY NUMBER
100 ,p_weeks_from_mother OUT NOCOPY NUMBER
101 ,p_sex OUT NOCOPY VARCHAR2
102 ,p_holiday_accrual OUT NOCOPY VARCHAR2
103 ) Return NUMBER ;
104
105 FUNCTION get_parental_details
106 (p_abs_attendance_id IN NUMBER
107 ,p_actual_dob OUT NOCOPY DATE
108 ,p_duration_override OUT NOCOPY NUMBER
109 ,p_parental_type OUT NOCOPY VARCHAR2
110 ,p_holiday_accrual OUT NOCOPY VARCHAR2
111 ) Return varchar2;
112
113 FUNCTION get_parental_override
114 (p_assignment_id IN NUMBER
115 ,p_effective_date IN DATE
116 ,p_abs_start_date IN DATE
117 ,p_abs_end_date IN DATE
118 ,p_shared_duration IN OUT NOCOPY NUMBER
119 ,p_shared_mat_allowance_used OUT NOCOPY NUMBER
120 ,p_shared_adopt_allowance_used OUT NOCOPY NUMBER
121 ,p_holiday_override OUT NOCOPY NUMBER
122 ) RETURN NUMBER;
123
124 FUNCTION get_adopt_override_details
125 (p_assignment_id IN NUMBER
126 ,p_effective_date IN DATE
127 ,p_abs_start_date IN DATE
128 ,p_abs_end_date IN DATE
129 ,p_pre_adopt_duration IN OUT NOCOPY NUMBER
130 ,p_post_adopt_duration IN OUT NOCOPY NUMBER
131 ,p_adoption_allowance_used OUT NOCOPY NUMBER
132 ,p_shared_allowance_used OUT NOCOPY NUMBER
133 ,p_holiday_override OUT NOCOPY NUMBER
134 ) RETURN NUMBER;
135
136 /* Added functions for Holiday Accrual impact */
137
138 FUNCTION conv_day_to_num( p_day VARCHAR2) RETURN NUMBER;
139
140 FUNCTION get_wrk_days_hol_accr
141 (p_wrk_pattern IN VARCHAR2
142 ,p_hrs_in_day IN NUMBER
143 ,p_abs_start_date IN DATE
144 ,p_abs_end_date IN DATE
145 ,p_abs_start_time IN VARCHAR2
146 ,p_abs_end_time IN VARCHAR2
147 ) RETURN NUMBER;
148
149 /* Function to get Part Time Maternity Details */
150 FUNCTION get_ptm_abs_details
151 (p_abs_attendance_id IN NUMBER
152 ,p_actual_dob OUT NOCOPY DATE
153 ,p_part_time_hours OUT NOCOPY NUMBER
154 ,p_part_time_hrs_freq OUT NOCOPY VARCHAR2
155 ,p_holiday_accrual OUT NOCOPY VARCHAR2
156 ) Return varchar2;
157 Function get_part_time_worked_hrs
158 (p_assignment_id IN NUMBER
159 ,p_date_earned IN DATE
160 ,p_abs_start_date IN DATE
161 ,p_abs_end_date IN DATE
162 ,p_start_time IN VARCHAR2
163 ,p_end_time IN VARCHAR2
164 ,p_worked_hours OUT NOCOPY NUMBER
165 ,p_weekly_worked_days OUT NOCOPY NUMBER
166 ) return Varchar2;
167
168 END PAY_DK_ABSENCE_USER;