1 PACKAGE pay_se_holiday_pay AUTHID CURRENT_USER AS
2 /*$Header: pyseholi.pkh 120.1 2007/06/28 17:28:04 rravi noship $*/
3 FUNCTION get_earning_year_workingdays (
4 p_assignment_id IN NUMBER
5 ,p_effective_date IN DATE
6 ,p_assignment_action_id IN NUMBER
7 )
8 RETURN NUMBER;
9
10 FUNCTION check_entitlement (
11 p_assignment_id IN NUMBER
12 ,p_effective_date IN DATE
13 ,p_pay_start_date IN DATE
14 ,p_pay_end_date IN DATE
15 ,p_earning_start_date OUT NOCOPY DATE
16 ,p_earning_end_date OUT NOCOPY DATE
17 )
18 RETURN VARCHAR2;
19
20 FUNCTION get_paid_unpaid_days (
21 p_assignment_id IN NUMBER
22 ,p_effective_date IN DATE
23 ,p_assignment_action_id IN NUMBER
24 ,p_tax_unit_id IN NUMBER
25 ,p_earning_start_date IN DATE
26 ,p_earning_end_date IN DATE
27 ,p_paid_holiday_days OUT NOCOPY NUMBER
28 ,p_unpaid_holiday_days OUT NOCOPY NUMBER
29 ,p_total_working_days OUT NOCOPY NUMBER
30 )
31 RETURN NUMBER;
32
33 FUNCTION get_vacation_days (
34 p_assignment_id IN NUMBER
35 ,p_effective_date IN DATE
36 ,p_payroll_start_date IN DATE
37 ,p_payroll_end_date IN DATE
38 )
39 RETURN NUMBER;
40
41 FUNCTION get_saved_year_limit_level (
42 p_assignment_id IN NUMBER
43 ,p_effective_date IN DATE
44 ,p_legal_employer OUT NOCOPY VARCHAR2
45 ,p_person OUT NOCOPY VARCHAR2
46 ,p_assignment OUT NOCOPY VARCHAR2
47 )
48 RETURN NUMBER;
49
50 FUNCTION element_exist (
51 p_assignment_id IN NUMBER
52 ,p_date_earned IN DATE
53 ,p_element_name IN VARCHAR2
54 )
55 RETURN NUMBER;
56
57 FUNCTION get_calculation_option (
58 p_assignment_id IN NUMBER
59 ,p_effective_date IN DATE
60 ,p_local_unit_id IN NUMBER
61 ,p_tax_unit_id IN NUMBER
62 ,p_absence_category IN VARCHAR2
63 ,p_return_vacation OUT NOCOPY VARCHAR2
64 )
65 RETURN NUMBER;
66
67 FUNCTION get_saved_holiday_limit (
68 p_assignment_id IN NUMBER
69 ,p_effective_date IN DATE
70 )
71 RETURN NUMBER;
72
73 FUNCTION get_end_year (p_date_earned IN DATE, p_tax_unit_id IN NUMBER)
74 RETURN NUMBER;
75
76 FUNCTION get_further_period_details (
77 p_payroll_id IN NUMBER
78 ,p_date_earned IN DATE
79 ,p_pay_saved_holiday OUT NOCOPY VARCHAR2
80 ,p_no_of_saved_days OUT NOCOPY NUMBER
81 ,p_pay_remaining_saved_days OUT NOCOPY VARCHAR2
82 ,p_pay_additional_holiday OUT NOCOPY VARCHAR2
83 ,p_no_of_additional_holiday OUT NOCOPY NUMBER
84 ,p_pay_remaining_addl_holiday OUT NOCOPY VARCHAR2
85 )
86 RETURN NUMBER;
87
88 FUNCTION get_remaining_saved_pay (
89 p_assignment_id IN NUMBER
90 ,p_assignment_action_id IN NUMBER
91 ,p_effective_date IN DATE
92 ,p_payroll_id IN NUMBER
93 ,p_tax_unit_id IN NUMBER
94 ,p_days_to_pay OUT NOCOPY NUMBER
95 )
96 RETURN VARCHAR2;
97
98 FUNCTION get_hourly_salaried_code (
99 p_assignment_id_id IN NUMBER
100 ,p_date_earned IN DATE
101 )
102 RETURN VARCHAR2;
103
104 FUNCTION update_entitlement_ran (p_tax_unit_id IN NUMBER)
105 RETURN NUMBER;
106
107 FUNCTION get_calendar_days (
108 p_date_earned IN DATE
109 ,p_tax_unit_id IN NUMBER
110 ,p_assignment_id IN NUMBER
111 ,p_pay_proc_period_start_date IN DATE
112 ,p_pay_proc_period_end_date IN DATE
113 ,p_earn_end_date OUT NOCOPY DATE
114 )
115 RETURN NUMBER;
116
117 FUNCTION get_assg_status (
118 p_business_group_id IN NUMBER
119 ,p_asg_id IN NUMBER
120 ,p_pay_proc_period_start_date IN DATE
121 ,p_pay_proc_period_end_date IN DATE
122 ,p_termination_date OUT NOCOPY DATE
123 )
124 RETURN VARCHAR2;
125
126 FUNCTION compensation_entitlement (
127 p_date_earned IN DATE
128 ,p_tax_unit_id IN NUMBER
129 ,p_assignment_id IN NUMBER
130 ,p_assignment_action_id IN NUMBER
131 ,p_pay_proc_period_start_date IN DATE
132 ,p_pay_proc_period_end_date IN DATE
133 ,p_paid_holiday_days OUT NOCOPY NUMBER
134 ,p_termination_date IN DATE
135 ,p_earn_end_date IN DATE
136 )
137 RETURN NUMBER;
138
139 FUNCTION get_sickness_days (
140 p_assignment_action_id IN NUMBER
141 ,p_assignment_id IN NUMBER
142 ,p_tax_unit_id IN NUMBER
143 ,p_date_earned IN DATE
144 )
145 RETURN NUMBER;
146
147 FUNCTION check_advance_holiday_limit (
148 p_assignment_id IN NUMBER
149 ,p_date_earned IN DATE
150 )
151 RETURN VARCHAR2;
152
153 FUNCTION get_cy_start_date (
154 p_assignment_id IN NUMBER
155 ,p_effective_date IN DATE
156 ,p_business_group_id IN NUMBER
157 ,p_tax_unit_id IN NUMBER
158 ,p_payroll_start_date IN DATE
159 ,p_payroll_end_date IN DATE
160 ,p_cy_start_date OUT NOCOPY DATE
161 ,p_cy_end_date OUT NOCOPY DATE
162 )
163 RETURN VARCHAR2;
164
165 FUNCTION get_cy_paid_unpaid_days (
166 p_assignment_id IN NUMBER
167 ,p_effective_date IN DATE
168 ,p_assignment_action_id IN NUMBER
169 ,p_tax_unit_id IN NUMBER
170 ,p_cy_start_date IN DATE
171 ,p_cy_end_date IN DATE
172 ,p_paid_holiday_days OUT NOCOPY NUMBER
173 ,p_unpaid_holiday_days OUT NOCOPY NUMBER
174 --p_total_working_days OUT nocopy NUMBER
175 )
176 RETURN NUMBER;
177
178 FUNCTION get_paid_days_limit (
179 p_assignment_id IN NUMBER
180 ,p_effective_date IN DATE
181 ,p_tax_unit_id IN NUMBER
182 )
183 RETURN NUMBER;
184
185 FUNCTION get_earning_year (p_date_earned IN DATE, p_tax_unit_id IN NUMBER)
186 RETURN NUMBER;
187
188 FUNCTION get_employee_category_type (
189 p_asg_id IN NUMBER
190 ,p_business_group_id IN NUMBER
191 ,p_pay_proc_period_start_date IN DATE
192 ,p_tax_unit_id IN NUMBER
193 )
194 RETURN VARCHAR2;
195
196 FUNCTION get_coincident_holiday_year (
197 p_business_group_id IN NUMBER
198 ,p_tax_unit_id IN NUMBER
199 )
200 RETURN VARCHAR2;
201
202 FUNCTION get_min_assignment_start (p_assignment_id IN NUMBER)
203 RETURN DATE;
204
205 FUNCTION part_time_employee (
206 p_assignment_id IN NUMBER
207 ,p_date_earned IN DATE
208 ,p_full_time OUT NOCOPY NUMBER
209 ,p_days_week OUT NOCOPY NUMBER
210 )
211 RETURN VARCHAR2;
212
213 FUNCTION get_holiday_pay_agreement_row (
214 p_assignment_id IN NUMBER
215 ,p_date_earned IN DATE
216 ,p_business_group_id IN NUMBER
217 )
218 RETURN VARCHAR2;
219
220 FUNCTION get_avg_working_percentage (
221 p_assignment_id IN NUMBER
222 ,p_effective_date IN DATE
223 ,p_business_group_id IN NUMBER
224 ,p_tax_unit_id IN NUMBER
225 )
226 RETURN NUMBER;
227
228 FUNCTION get_employee_age_experience (
229 p_assignment_id IN NUMBER
230 ,p_effective_date IN DATE
231 )
232 RETURN VARCHAR2;
233
234 FUNCTION get_sdays_wrking_percentage (
235 p_assignment_id IN NUMBER
236 ,p_effective_date IN DATE
237 ,p_business_group_id IN NUMBER
238 ,p_tax_unit_id IN NUMBER
239 ,p_first_year IN NUMBER
240 ,p_second_year IN NUMBER
241 ,p_third_year IN NUMBER
242 ,p_fourth_year IN NUMBER
243 ,p_fifth_year IN NUMBER
244 ,p_sixth_year IN NUMBER
245 ,p_seventh_year IN NUMBER
246 ,p_all_years IN NUMBER
247 ,p_saved_days_taken IN NUMBER
248 ,p_saved_days_availed IN NUMBER
249 )
250 RETURN NUMBER;
251 PROCEDURE GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id in number
252 ,P_START_DATE in date
253 ,P_END_DATE in date
254 ,p_start_time in varchar2
255 ,p_end_time in varchar2
256 ,p_calc_type in varchar2
257 ,p_Total_holidays OUT NOCOPY NUMBER
258 );
259 FUNCTION get_avg_earning_year_hours (
260 p_assignment_id IN NUMBER,
261 p_effective_date IN DATE,
262 p_business_group_id IN NUMBER,
263 p_tax_unit_id IN NUMBER,
264 p_total_absence IN Number
265 )
266 RETURN NUMBER;
267 FUNCTION get_First_three_payroll_check (
268 p_assignment_id IN NUMBER,
269 p_effective_date IN DATE,
270 p_business_group_id IN NUMBER,
271 p_tax_unit_id IN NUMBER,
272 p_pay_start_date IN DATE,
273 p_pay_end_date IN DATE
274 )
275 RETURN VARCHAR2;
276 END pay_se_holiday_pay;