1 PACKAGE PAY_SE_ABSENCE AUTHID CURRENT_USER AS
2 /* $Header: pysesick.pkh 120.2 2007/08/03 16:02:08 rravi noship $ */
3
4 FUNCTION GET_HOURLY_RATE(
5 p_assignment_id IN NUMBER
6 ,p_effective_date IN DATE
7 ,p_abs_start_date IN DATE
8 ,p_abs_end_date IN DATE
9 ,p_Monthly_Pay IN NUMBER
10 ,p_hourly_rate_option1 OUT NOCOPY VARCHAR
11 ,p_hourly_rate_option2 OUT NOCOPY VARCHAR
12 ,p_hourly_rate_option3 OUT NOCOPY VARCHAR
13 ,p_hourly_rate_option4 OUT NOCOPY VARCHAR
14 ,p_hourly_rate_option5 OUT NOCOPY VARCHAR
15 ,p_hourly_rate_option6 OUT NOCOPY VARCHAR
16 ,p_hourly_rate_option7 OUT NOCOPY VARCHAR
17 ,p_hourly_rate_option8 OUT NOCOPY VARCHAR
18 ,p_hourly_rate_option9 OUT NOCOPY VARCHAR
19 ,p_hourly_rate_option10 OUT NOCOPY VARCHAR
20 ,p_hourly_rate OUT NOCOPY NUMBER
21 ,p_normal_hours OUT NOCOPY NUMBER
22 ,p_working_perc OUT NOCOPY NUMBER
23 ,p_salary_rate_option1 OUT NOCOPY VARCHAR
24 ,p_salary_rate_option2 OUT NOCOPY VARCHAR
25 ,p_salary_rate_option3 OUT NOCOPY VARCHAR
26 ,p_salary_rate_option4 OUT NOCOPY VARCHAR
27 ,p_salary_rate_option5 OUT NOCOPY VARCHAR
28 ,p_salary_rate_option6 OUT NOCOPY VARCHAR
29 ,p_salary_rate_option7 OUT NOCOPY VARCHAR
30 ,p_salary_rate_option8 OUT NOCOPY VARCHAR
31 ,p_salary_rate_option9 OUT NOCOPY VARCHAR
32 ,p_salary_rate_option10 OUT NOCOPY VARCHAR
33 ,p_salary_rate OUT NOCOPY NUMBER
34 ,p_hour_sal OUT NOCOPY VARCHAR
35 )
36 RETURN NUMBER;
37
38 FUNCTION GET_GROUP(
39 p_assignment_id IN NUMBER
40 ,p_effective_date IN DATE
41 ,p_abs_start_date IN DATE
42 ,p_abs_end_date IN DATE
43 ,p_group_start_date1 OUT NOCOPY DATE
44 ,p_group_start_date2 OUT NOCOPY DATE
45 ,p_group_start_date3 OUT NOCOPY DATE
46 ,p_group_start_date4 OUT NOCOPY DATE
47 ,p_group_start_date5 OUT NOCOPY DATE
48 ,p_group_start_date6 OUT NOCOPY DATE
49 ,p_group_start_date7 OUT NOCOPY DATE
50 ,p_group_start_date8 OUT NOCOPY DATE
51 ,p_group_start_date9 OUT NOCOPY DATE
52 ,p_group_start_date10 OUT NOCOPY DATE
53 ,p_group_start_date11 OUT NOCOPY DATE
54 ,p_group_end_date1 OUT NOCOPY DATE
55 ,p_group_end_date2 OUT NOCOPY DATE
56 ,p_group_end_date3 OUT NOCOPY DATE
57 ,p_group_end_date4 OUT NOCOPY DATE
58 ,p_group_end_date5 OUT NOCOPY DATE
59 ,p_group_end_date6 OUT NOCOPY DATE
60 ,p_group_end_date7 OUT NOCOPY DATE
61 ,p_group_end_date8 OUT NOCOPY DATE
62 ,p_group_end_date9 OUT NOCOPY DATE
63 ,p_group_end_date10 OUT NOCOPY DATE
64 ,p_group_end_date11 OUT NOCOPY DATE
65 ,p_group_option1 OUT NOCOPY VARCHAR2
66 ,p_group_option2 OUT NOCOPY VARCHAR2
67 ,p_group_option3 OUT NOCOPY VARCHAR2
68 ,p_group_option4 OUT NOCOPY VARCHAR2
69 ,p_group_option5 OUT NOCOPY VARCHAR2
70 ,p_group_option6 OUT NOCOPY VARCHAR2
71 ,p_group_option7 OUT NOCOPY VARCHAR2
72 ,p_group_option8 OUT NOCOPY VARCHAR2
73 ,p_group_option9 OUT NOCOPY VARCHAR2
74 ,p_group_option10 OUT NOCOPY VARCHAR2
75 ,p_group_option11 OUT NOCOPY VARCHAR2
76 ,p_asg_hour_sal OUT NOCOPY VARCHAR2
77 )
78 RETURN NUMBER;
79
80 FUNCTION CALCULATE_PAYMENT(
81 p_assignment_id IN NUMBER
82 ,p_effective_date IN DATE
83 ,p_assignment_action_id IN NUMBER
84 ,p_pay_start_date IN DATE
85 ,p_pay_end_date IN DATE
86 ,p_abs_start_date IN DATE
87 ,p_abs_end_date IN DATE
88 ,p_monthly_pay IN NUMBER
89 ,p_hourly_rate IN OUT NOCOPY NUMBER
90 ,p_tot_waiting_day_hours OUT NOCOPY NUMBER
91 ,p_tot_waiting_day OUT NOCOPY NUMBER
92 ,p_total_sickness_deduction OUT NOCOPY NUMBER
93 ,p_tot_sickness_ded_14_above OUT NOCOPY NUMBER
94 ,p_total_sick_pay OUT NOCOPY NUMBER
95 ,p_total_sick_pay_14_above OUT NOCOPY NUMBER
96 ,p_tot_waiting_day_ded OUT NOCOPY NUMBER
97 ,p_sickness_14_below_days OUT NOCOPY NUMBER
98 ,p_sickness_above_14_days OUT NOCOPY NUMBER
99 ,p_sickness_pay_hours_14_below OUT NOCOPY NUMBER
100 ,p_sickness_pay_hours_above_14 OUT NOCOPY NUMBER
101 ,p_sex OUT NOCOPY VARCHAR2
102 ,p_tot_sick_pay_days OUT NOCOPY NUMBER
103 ,p_asg_hour_sal OUT NOCOPY VARCHAR2
104 ,p_waiting_date OUT NOCOPY DATE
105 ,p_salary_rate IN OUT NOCOPY NUMBER
106 ,p_fourteenth_date OUT NOCOPY DATE
107 ,p_full_days OUT NOCOPY NUMBER
108 ,p_override_monthly_basic OUT NOCOPY NUMBER
109 ,p_override_monthly_basic_day OUT NOCOPY NUMBER
110 ,p_exceeds_14_days OUT NOCOPY VARCHAR2
111 ,p_sickness_after_14_days_month OUT NOCOPY NUMBER
112 ,p_group_calendar_days OUT NOCOPY NUMBER
113 ,p_group_working_days OUT NOCOPY NUMBER
114 ,p_group_working_hours OUT NOCOPY NUMBER
115
116 )
117 RETURN NUMBER;
118
119 FUNCTION get_waiting_hours(
120 p_abs_hours IN VARCHAR2,
121 p_normal_hours IN VARCHAR2
122 )RETURN NUMBER;
123
124 FUNCTION GET_SICKPAY_DETAILS(
125 p_assignment_id IN NUMBER,
126 p_abs_start_date IN DATE,
127 p_abs_end_date IN DATE,
128 p_sickness_14_below_days IN NUMBER,
129 --p_sickness_above_14_days IN NUMBER,
130 p_sickness_after_14_days_month IN NUMBER,
131 p_sickness_pay_hours_14_below IN NUMBER,
132 p_sickness_pay_hours_above_14 IN NUMBER,
133 p_monthly_pay IN NUMBER,
134 p_asg_hour_sal IN varchar2,
135 p_working_percentage IN NUMBER,
136 p_normal_hours IN NUMBER,
137 p_hourly_rate IN NUMBER,
138 p_waiting_day_hours IN OUT NOCOPY NUMBER,
139 p_waiting_day_deduction OUT NOCOPY NUMBER,
140 p_waiting_day OUT NOCOPY NUMBER,
141 p_sickness_deduction_14_above OUT NOCOPY NUMBER,
142 p_sickness_deduction_14_less OUT NOCOPY NUMBER,
143 p_sick_pay_14_above OUT NOCOPY NUMBER,
144 p_sick_pay_14_less OUT NOCOPY NUMBER,
145 p_salary_rate IN NUMBER,
146 p_effective_date IN DATE,
147 p_assignment_action_id IN NUMBER,
148 p_override_monthly_basic OUT NOCOPY NUMBER,
149 p_override_monthly_basic_day OUT NOCOPY NUMBER
150 )
151 RETURN NUMBER;
152
153 FUNCTION GET_WAITING_DAY(
154 p_assignment_id NUMBER,
155 p_abs_start_date DATE,
156 p_abs_end_date date
157 )
158 RETURN DATE;
159
160 FUNCTION Get_Entitlement_Days(
161 p_assignment_id in NUMBER,
162 p_effective_date IN DATE,
163 p_absence_start_date IN DATE,
164 p_absence_end_date IN DATE,
165 p_entitlement_days OUT NOCOPY NUMBER,
166 p_sickness_days OUT NOCOPY NUMBER
167 )
168 RETURN NUMBER;
169
170 FUNCTION GET_SICKNESS_AFTER_14_PERIOD(p_person_id IN NUMBER,
171 p_assignment_id IN NUMBER,
172 p_payroll_start IN DATE,
173 p_payroll_end IN DATE,
174 p_fourteenth_date IN DATE)
175 RETURN NUMBER;
176
177 FUNCTION Get_Sickness_Group_Details(p_person_id IN NUMBER,
178 p_assignment_id IN NUMBER,
179 p_pay_start_date IN DATE,
180 p_pay_end_date IN DATE,
181 p_abs_group_start_date IN DATE,
182 p_abs_group_end_date IN DATE,
183 p_group_calendar_days OUT NOCOPY NUMBER,
184 p_group_working_days OUT NOCOPY NUMBER,
185 p_group_working_hours OUT NOCOPY NUMBER )
186 RETURN NUMBER;
187
188 END PAY_SE_ABSENCE;
189