1 PACKAGE PAY_DK_ABSENCE_USER AUTHID CURRENT_USER AS
2 /*$Header: pydkabsence.pkh 120.13 2012/01/19 08:58:17 rpahune ship $*/
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 ,p_payment_during_leave IN OUT NOCOPY VARCHAR2 /* 11694807 */
54 ) RETURN NUMBER;
55
56 FUNCTION get_absence_details
57 (p_assignment_id IN NUMBER
58 ,p_date_earned IN DATE
59 ,p_abs_attendance_id IN NUMBER
60 ,p_expected_dob OUT NOCOPY DATE
61 ,p_actual_dob OUT NOCOPY DATE
62 ,p_pre_birth_duration OUT NOCOPY NUMBER
63 ,p_post_birth_duration OUT NOCOPY NUMBER
64 ,p_frequency OUT NOCOPY VARCHAR2
65 ,p_normal_hours OUT NOCOPY NUMBER
66 ,p_maternity_weeks_transfer OUT NOCOPY NUMBER
67 ,p_holiday_accrual OUT NOCOPY VARCHAR2
68 ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
69 ) Return varchar2;
70
71 FUNCTION get_assg_term_date
72 (p_business_group_id IN NUMBER
73 ,p_assignment_id IN NUMBER)
74 RETURN DATE;
75
76 /*Function to get paternity absence details*/
77 FUNCTION get_pat_abs_details
78 (
79 p_abs_attendance_id IN NUMBER,
80 p_override_weeks OUT NOCOPY NUMBER,
81 p_holiday_accrual OUT NOCOPY VARCHAR2
82 ) Return NUMBER;
83
84 FUNCTION get_paternity_override
85 (p_assignment_id IN NUMBER
86 ,p_effective_date IN DATE
87 ,p_abs_start_date IN DATE
88 ,p_abs_end_date IN DATE
89 ,p_duration_override IN OUT NOCOPY NUMBER
90 ,p_holiday_override OUT NOCOPY NUMBER
91 ) RETURN NUMBER;
92
93 FUNCTION get_adopt_abs_details
94 (p_assignment_id IN NUMBER
95 ,p_date_earned IN DATE
96 ,p_abs_attendance_id IN NUMBER
97 ,p_expected_dob OUT NOCOPY DATE
98 ,p_actual_dob OUT NOCOPY DATE
99 ,p_pre_adopt_duration OUT NOCOPY NUMBER
100 ,p_post_adopt_duration OUT NOCOPY NUMBER
101 ,p_adopt_weeks_transfer OUT NOCOPY NUMBER
102 ,p_weeks_from_mother OUT NOCOPY NUMBER
103 ,p_sex OUT NOCOPY VARCHAR2
104 ,p_holiday_accrual OUT NOCOPY VARCHAR2
105 ) Return NUMBER ;
106
107 FUNCTION get_parental_details
108 (p_abs_attendance_id IN NUMBER
109 ,p_actual_dob OUT NOCOPY DATE
110 ,p_duration_override OUT NOCOPY NUMBER
111 ,p_parental_type OUT NOCOPY VARCHAR2
112 ,p_holiday_accrual OUT NOCOPY VARCHAR2
113 ) Return varchar2;
114
115 FUNCTION get_parental_override
116 (p_assignment_id IN NUMBER
117 ,p_effective_date IN DATE
118 ,p_abs_start_date IN DATE
119 ,p_abs_end_date IN DATE
120 ,p_shared_duration IN OUT NOCOPY NUMBER
121 ,p_shared_mat_allowance_used OUT NOCOPY NUMBER
122 ,p_shared_adopt_allowance_used OUT NOCOPY NUMBER
123 ,p_holiday_override OUT NOCOPY NUMBER
124 ) RETURN NUMBER;
125
126 FUNCTION get_adopt_override_details
127 (p_assignment_id IN NUMBER
128 ,p_effective_date IN DATE
129 ,p_abs_start_date IN DATE
130 ,p_abs_end_date IN DATE
131 ,p_pre_adopt_duration IN OUT NOCOPY NUMBER
132 ,p_post_adopt_duration IN OUT NOCOPY NUMBER
133 ,p_adoption_allowance_used OUT NOCOPY NUMBER
134 ,p_shared_allowance_used OUT NOCOPY NUMBER
135 ,p_holiday_override OUT NOCOPY NUMBER
136 ) RETURN NUMBER;
137
138 /* Added functions for Holiday Accrual impact */
139
140 FUNCTION conv_day_to_num( p_day VARCHAR2) RETURN NUMBER;
141
142 FUNCTION get_wrk_days_hol_accr
143 (p_wrk_pattern IN VARCHAR2
144 ,p_hrs_in_day IN NUMBER
145 ,p_abs_start_date IN DATE
146 ,p_abs_end_date IN DATE
147 ,p_abs_start_time IN VARCHAR2
148 ,p_abs_end_time IN VARCHAR2
149 ) RETURN NUMBER;
150
151 /* Function to get Part Time Maternity Details */
152 FUNCTION get_ptm_abs_details
153 (p_abs_attendance_id IN NUMBER
154 ,p_actual_dob OUT NOCOPY DATE
155 ,p_part_time_hours OUT NOCOPY NUMBER
156 ,p_part_time_hrs_freq OUT NOCOPY VARCHAR2
157 ,p_holiday_accrual OUT NOCOPY VARCHAR2
158 ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
159 ) Return varchar2;
160 Function get_part_time_worked_hrs
161 (p_assignment_id IN NUMBER
162 ,p_date_earned IN DATE
163 ,p_abs_start_date IN DATE
164 ,p_abs_end_date IN DATE
165 ,p_start_time IN VARCHAR2
166 ,p_end_time IN VARCHAR2
167 ,p_worked_hours OUT NOCOPY NUMBER
168 ,p_weekly_worked_days OUT NOCOPY NUMBER
169 ) return Varchar2;
170
171 END PAY_DK_ABSENCE_USER;