1 package peptoexc AUTHID CURRENT_USER as
2 /* $Header: peptoexc.pkh 115.4 2004/01/16 08:41:41 dcasemor noship $ */
3
4 /*
5 * The following are expiry checking procedures
6 * for date paid balances used by pto accruals
7 */
8
9 /*------------------------------ ASG_PTO_YTD_EC ----------------------------*/
10 /*
11 NAME
12 ASG_PTO_YTD_EC - Assignment Processing Year to Date expiry check.
13 DESCRIPTION
14 NOTES
15 The associated dimension is expiry checked at payroll action level
16 */
17 --
18 -- This is the flag-based expiry routine.
19 --
20 procedure ASG_PTO_YTD_EC
21 (
22 p_owner_payroll_action_id in number, -- run created balance.
23 p_user_payroll_action_id in number, -- current run.
24 p_owner_assignment_action_id in number, -- assact created balance.
25 p_user_assignment_action_id in number, -- current assact.
26 p_owner_effective_date in date, -- eff date of balance.
27 p_user_effective_date in date, -- eff date of current run.
28 p_dimension_name in varchar2, -- balance dimension name.
29 p_expiry_information out nocopy number -- dimension expired flag.
30 );
31
32 --
33 -- This is the overloaded date-based expiry routine.
34 --
35 procedure ASG_PTO_YTD_EC
36 (
37 p_owner_payroll_action_id in number, -- run created balance.
38 p_user_payroll_action_id in number, -- current run.
39 p_owner_assignment_action_id in number, -- assact created balance.
40 p_user_assignment_action_id in number, -- current assact.
41 p_owner_effective_date in date, -- eff date of balance.
42 p_user_effective_date in date, -- eff date of current run.
43 p_dimension_name in varchar2, -- balance dimension name.
44 p_expiry_information out nocopy date -- dimension expired date.
45 );
46
47 /*------------------------------ ASG_PTO_TTD_EC ----------------------------*/
48 /*
49 NAME
50 ASG_PTO_TTD_EC - Assignment Processing Term to Date expiry check.
51 DESCRIPTION
52 NOTES
53 The associated dimension is expiry checked at payroll action level.
54 */
55 --
56 -- This is the flag-based expiry routine.
57 --
58 procedure ASG_PTO_TTD_EC
59 (
60 p_owner_payroll_action_id in number, -- run created balance.
61 p_user_payroll_action_id in number, -- current run.
62 p_owner_assignment_action_id in number, -- assact created balance.
63 p_user_assignment_action_id in number, -- current assact.
64 p_owner_effective_date in date, -- eff date of balance.
65 p_user_effective_date in date, -- eff date of current run.
66 p_dimension_name in varchar2, -- balance dimension name.
67 p_expiry_information out nocopy number -- dimension expired flag.
68 );
69
70 --
71 -- This is the overloaded date-based expiry routine.
72 --
73 procedure ASG_PTO_TTD_EC
74 (
75 p_owner_payroll_action_id in number, -- run created balance.
76 p_user_payroll_action_id in number, -- current run.
77 p_owner_assignment_action_id in number, -- assact created balance.
78 p_user_assignment_action_id in number, -- current assact.
79 p_owner_effective_date in date, -- eff date of balance.
80 p_user_effective_date in date, -- eff date of current run.
81 p_dimension_name in varchar2, -- balance dimension name.
82 p_expiry_information out nocopy date -- dimension expired date.
83 );
84
85 /*-------------------------- ASG_PTO_HD_YTD_EC ----------------------------*/
86 /*
87 NAME
88 ASG_PTO_HD_YTD_EC - Assignment Processing Year to Date expiry check.
89 DESCRIPTION
90 NOTES
91 The associated dimension is expiry checked at payroll action level
92 */
93 --
94 -- This is the flag-based expiry routine.
95 --
96 procedure ASG_PTO_HD_YTD_EC
97 (
98 p_owner_payroll_action_id in number, -- run created balance.
99 p_user_payroll_action_id in number, -- current run.
100 p_owner_assignment_action_id in number, -- assact created balance.
101 p_user_assignment_action_id in number, -- current assact.
102 p_owner_effective_date in date, -- eff date of balance.
103 p_user_effective_date in date, -- eff date of current run.
104 p_dimension_name in varchar2, -- balance dimension name.
105 p_expiry_information out nocopy number -- dimension expired flag.
106 );
107
108 --
109 -- This is the overloaded date-based expiry routine.
110 --
111 procedure ASG_PTO_HD_YTD_EC
112 (
113 p_owner_payroll_action_id in number, -- run created balance.
114 p_user_payroll_action_id in number, -- current run.
115 p_owner_assignment_action_id in number, -- assact created balance.
116 p_user_assignment_action_id in number, -- current assact.
117 p_owner_effective_date in date, -- eff date of balance.
118 p_user_effective_date in date, -- eff date of current run.
119 p_dimension_name in varchar2, -- balance dimension name.
120 p_expiry_information out nocopy date -- dimension expired date.
121 );
122
123 /*
124 * The following are expiry checking procedures
125 * for date earned balances used by pto accruals
126 */
127
128 /*------------------------------ ASG_PTO_DE_YTD_EC ----------------------------*/
129 /*
130 NAME
131 ASG_PTO_DE_YTD_EC - Assignment Processing Year to Date expiry check.
132 DESCRIPTION
133 Used to check expiry of seeded date earned balance in
134 PTO accruals, for a one year plan beginning 01/01.
135 */
136 --
137 -- This is the flag-based expiry routine.
138 --
139 procedure ASG_PTO_DE_YTD_EC
140 (
141 p_owner_payroll_action_id in number, -- run created balance.
142 p_user_payroll_action_id in number, -- current run.
143 p_owner_assignment_action_id in number, -- assact created balance.
144 p_user_assignment_action_id in number, -- current assact.
145 p_owner_effective_date in date, -- eff date of balance.
146 p_user_effective_date in date, -- eff date of current run.
147 p_dimension_name in varchar2, -- balance dimension name.
148 p_expiry_information out nocopy number -- dimension expired flag.
149 );
150
151 --
152 -- This is the overloaded date-based expiry routine.
153 --
154 procedure ASG_PTO_DE_YTD_EC
155 (
156 p_owner_payroll_action_id in number, -- run created balance.
157 p_user_payroll_action_id in number, -- current run.
158 p_owner_assignment_action_id in number, -- assact created balance.
159 p_user_assignment_action_id in number, -- current assact.
160 p_owner_effective_date in date, -- eff date of balance.
161 p_user_effective_date in date, -- eff date of current run.
162 p_dimension_name in varchar2, -- balance dimension name.
163 p_expiry_information out nocopy date -- dimension expired date.
164 );
165
166 /*------------------------------ ASG_PTO_DE_SM_YTD_EC ----------------------------*/
167 /*
168 NAME
169 ASG_PTO_DE_SM_YTD_EC - Assignment Processing Year to Date expiry check.
170 DESCRIPTION
171 Used to check expiry of seeded date earned balance in PTO accruals, for our
172 simple multiplier plan, beginning 01/06 each year.
173 */
174 --
175 -- This is the flag-based expiry routine.
176 --
177 procedure ASG_PTO_DE_SM_YTD_EC
178 (
179 p_owner_payroll_action_id in number, -- run created balance.
180 p_user_payroll_action_id in number, -- current run.
181 p_owner_assignment_action_id in number, -- assact created balance.
182 p_user_assignment_action_id in number, -- current assact.
183 p_owner_effective_date in date, -- eff date of balance.
184 p_user_effective_date in date, -- eff date of current run.
185 p_dimension_name in varchar2, -- balance dimension name.
186 p_expiry_information out nocopy number -- dimension expired flag.
187 );
188
189 --
190 -- This is the overloaded date-based expiry routine.
191 --
192 procedure ASG_PTO_DE_SM_YTD_EC
193 (
194 p_owner_payroll_action_id in number, -- run created balance.
195 p_user_payroll_action_id in number, -- current run.
196 p_owner_assignment_action_id in number, -- assact created balance.
197 p_user_assignment_action_id in number, -- current assact.
198 p_owner_effective_date in date, -- eff date of balance.
199 p_user_effective_date in date, -- eff date of current run.
200 p_dimension_name in varchar2, -- balance dimension name.
201 p_expiry_information out nocopy date -- dimension expired date.
202 );
203
204 /*------------------------------ ASG_PTO_DE_HD_YTD_EC ------------------------*/
205 /*
206 NAME
207 ASG_PTO_DE_HD_YTD_EC - Assignment Processing Year to Date expiry check.
208 DESCRIPTION
209 Used to check expiry of seeded date earned balance in PTO accruals, for a
210 hire date anniversary accrual plan.
211 */
212 --
213 -- This is the flag-based expiry routine.
214 --
215 procedure ASG_PTO_DE_HD_YTD_EC
216 (
217 p_owner_payroll_action_id in number, -- run created balance.
218 p_user_payroll_action_id in number, -- current run.
219 p_owner_assignment_action_id in number, -- assact created balance.
220 p_user_assignment_action_id in number, -- current assact.
221 p_owner_effective_date in date, -- eff date of balance.
222 p_user_effective_date in date, -- eff date of current run.
223 p_dimension_name in varchar2, -- balance dimension name.
224 p_expiry_information out nocopy number -- dimension expired flag.
225 );
226
227 --
228 -- This is the overloaded date-based expiry routine.
229 --
230 procedure ASG_PTO_DE_HD_YTD_EC
231 (
232 p_owner_payroll_action_id in number, -- run created balance.
233 p_user_payroll_action_id in number, -- current run.
234 p_owner_assignment_action_id in number, -- assact created balance.
235 p_user_assignment_action_id in number, -- current assact.
236 p_owner_effective_date in date, -- eff date of balance.
237 p_user_effective_date in date, -- eff date of current run.
238 p_dimension_name in varchar2, -- balance dimension name.
239 p_expiry_information out nocopy date -- dimension expired date.
240 );
241
242 end peptoexc;