1 PACKAGE PAY_NL_DIM_PKG AS
2 /* $Header: pynlexc.pkh 120.1 2005/09/17 05:14:33 gkhangar noship $ */
3 /*------------------------------ ASG_PTD_EC ----------------------------*/
4 /*
5 NAME
6 ASG_PTD_EC - Assignment-level Period to Date expiry check.
7 DESCRIPTION
8 Expiry checking code for the following:
9 NL Assignment-level Period To Date Balance Dimension
10 NOTES
11 The associated dimension is expiry checked at assignment action level
12 */
13 -- Returns dimension expired flag p_expiry_information as 0 or 1
14 procedure ASG_PTD_EC
15 (
16 p_owner_payroll_action_id in number, -- run created balance.
17 p_user_payroll_action_id in number, -- current run.
18 p_owner_assignment_action_id in number, -- assact created balance.
19 p_user_assignment_action_id in number, -- current assact..
20 p_owner_effective_date in date, -- eff date of balance.
21 p_user_effective_date in date, -- eff date of current run.
22 p_dimension_name in varchar2, -- balance dimension name.
23 p_expiry_information out nocopy number -- dimension expired flag.
24 ) ;
25
26 -- Returns the expiry date
27 procedure ASG_PTD_EC
28 (
29 p_owner_payroll_action_id in number, -- run created balance.
30 p_user_payroll_action_id in number, -- current run.
31 p_owner_assignment_action_id in number, -- assact created balance.
32 p_user_assignment_action_id in number, -- current assact..
33 p_owner_effective_date in date, -- eff date of balance.
34 p_user_effective_date in date, -- eff date of current run.
35 p_dimension_name in varchar2, -- balance dimension name.
36 p_expiry_information out nocopy DATE -- dimension expired flag.
37 ) ;
38
39
40
41 --
42 --3019423
43 --Expiry checking code for _PER_PTD
44 --
45
46 /*------------------------------ PER_PTD_EC ----------------------------*/
47 /*
48 NAME
49 PER_PTD_EC - Person-level Period to Date expiry check.
50 DESCRIPTION
51 Expiry checking code for the following:
52 NL Person-level Period To Date Balance Dimension
53 NOTES
54 The associated dimension is expiry checked at assignment action level
55 */
56 procedure PER_PTD_EC
57 (
58 p_owner_payroll_action_id in number, -- run created balance.
59 p_user_payroll_action_id in number, -- current run.
60 p_owner_assignment_action_id in number, -- assact created balance.
61 p_user_assignment_action_id in number, -- current assact..
62 p_owner_effective_date in date, -- eff date of balance.
63 p_user_effective_date in date, -- eff date of current run.
64 p_dimension_name in varchar2, -- balance dimension name.
65 p_expiry_information out nocopy number -- dimension expired flag.
66 ) ;
67
68 procedure PER_PTD_EC
69 (
70 p_owner_payroll_action_id in number, -- run created balance.
71 p_user_payroll_action_id in number, -- current run.
72 p_owner_assignment_action_id in number, -- assact created balance.
73 p_user_assignment_action_id in number, -- current assact..
74 p_owner_effective_date in date, -- eff date of balance.
75 p_user_effective_date in date, -- eff date of current run.
76 p_dimension_name in varchar2, -- balance dimension name.
77 p_expiry_information out nocopy DATE -- dimension expired flag.
78 ) ;
79
80 /*------------------------------ ASG_YTD_EC -------------------------*/
81 /*
82 NAME
83 ASG_YTD_EC - Assignment Tax Year to Date expiry check
84 DESCRIPTION
85 Expiry checking code for the following:
86 NL Assignment-level Tax Year to Date dimension
87 NOTES
88 The associated dimension is expiry checked at assignment action level
89 */
90 -- Returns dimension expired flag p_expiry_information as 0 or 1
91 procedure ASG_YTD_EC
92 (
93 p_owner_payroll_action_id in number, -- run created balance.
94 p_user_payroll_action_id in number, -- current run.
95 p_owner_assignment_action_id in number, -- assact created balance.
96 p_user_assignment_action_id in number, -- current assact..
97 p_owner_effective_date in date, -- eff date of balance.
98 p_user_effective_date in date, -- eff date of current run.
99 p_dimension_name in varchar2, -- balance dimension name.
100 p_expiry_information out nocopy number -- dimension expired flag.
101 ) ;
102
103 -- Returns expiry date
104 procedure ASG_YTD_EC
105 (
106 p_owner_payroll_action_id in number, -- run created balance.
107 p_user_payroll_action_id in number, -- current run.
108 p_owner_assignment_action_id in number, -- assact created balance.
109 p_user_assignment_action_id in number, -- current assact..
110 p_owner_effective_date in date, -- eff date of balance.
111 p_user_effective_date in date, -- eff date of current run.
112 p_dimension_name in varchar2, -- balance dimension name.
113 p_expiry_information out nocopy date -- dimension expired flag.
114 ) ;
115
116
117
118 --
119 --3019423
120 --Expiry checking code for _PER_YTD
121 --
122 /*------------------------------ PER_YTD_EC -------------------------*/
123 /*
124 NAME
125 PER_YTD_EC - Person Tax Year to Date expiry check
126 DESCRIPTION
127 Expiry checking code for the following:
128 NL Person-level Tax Year to Date dimension
129 NOTES
130 The associated dimension is expiry checked at Person level
131 */
132 -- Returns dimension expired flag p_expiry_information as 0 or 1
133 procedure PER_YTD_EC
134 (
135 p_owner_payroll_action_id in number, -- run created balance.
136 p_user_payroll_action_id in number, -- current run.
137 p_owner_assignment_action_id in number, -- assact created balance.
138 p_user_assignment_action_id in number, -- current assact..
139 p_owner_effective_date in date, -- eff date of balance.
140 p_user_effective_date in date, -- eff date of current run.
141 p_dimension_name in varchar2, -- balance dimension name.
142 p_expiry_information out nocopy number -- dimension expired flag.
143 ) ;
144
145 procedure PER_YTD_EC
146 (
147 p_owner_payroll_action_id in number, -- run created balance.
148 p_user_payroll_action_id in number, -- current run.
149 p_owner_assignment_action_id in number, -- assact created balance.
150 p_user_assignment_action_id in number, -- current assact..
151 p_owner_effective_date in date, -- eff date of balance.
152 p_user_effective_date in date, -- eff date of current run.
153 p_dimension_name in varchar2, -- balance dimension name.
154 p_expiry_information out nocopy DATE -- dimension expired flag.
155 ) ;
156
157
158
159 /*------------------------------ ASG_QTD_EC -------------------------*/
160 /*
161 NAME
162 ASG_QTD_EC - Assignment Tax Year to Date expiry check
163 DESCRIPTION
164 Expiry checking code for the following:
165 NL Assignment-level Tax Quarter to Date dimension
166 NOTES
167 The associated dimension is expiry checked at assignment action level
168 */
169 -- Returns dimension expired flag p_expiry_information as 0 or 1
170 procedure ASG_QTD_EC
171 (
172 p_owner_payroll_action_id in number, -- run created balance.
173 p_user_payroll_action_id in number, -- current run.
174 p_owner_assignment_action_id in number, -- assact created balance.
175 p_user_assignment_action_id in number, -- current assact..
176 p_owner_effective_date in date, -- eff date of balance.
177 p_user_effective_date in date, -- eff date of current run.
178 p_dimension_name in varchar2, -- balance dimension name.
179 p_expiry_information out nocopy number -- dimension expired flag.
180 );
181
182 -- Returns expiry date
183 procedure ASG_QTD_EC
184 (
185 p_owner_payroll_action_id in number, -- run created balance.
186 p_user_payroll_action_id in number, -- current run.
187 p_owner_assignment_action_id in number, -- assact created balance.
188 p_user_assignment_action_id in number, -- current assact..
189 p_owner_effective_date in date, -- eff date of balance.
190 p_user_effective_date in date, -- eff date of current run.
191 p_dimension_name in varchar2, -- balance dimension name.
192 p_expiry_information out nocopy DATE -- dimension expired flag.
193 );
194
195
196 --
197 --3019423
198 --Expiry checking code for _PER_QTD
199 --
200 /*------------------------------ PER_QTD_EC -------------------------*/
201 /*
202 NAME
203 PER_QTD_EC - Person Tax Quarter to Date expiry check
204 DESCRIPTION
205 Expiry checking code for the following:
206 NL Person-level Tax Quarter to Date dimension
207 NOTES
208 The associated dimension is expiry checked at Person level
209 */
210 -- Returns dimension expired flag p_expiry_information as 0 or 1
211 procedure PER_QTD_EC
212 (
213 p_owner_payroll_action_id in number, -- run created balance.
214 p_user_payroll_action_id in number, -- current run.
215 p_owner_assignment_action_id in number, -- assact created balance.
216 p_user_assignment_action_id in number, -- current assact..
217 p_owner_effective_date in date, -- eff date of balance.
218 p_user_effective_date in date, -- eff date of current run.
219 p_dimension_name in varchar2, -- balance dimension name.
220 p_expiry_information out nocopy number -- dimension expired flag.
221 );
222
223 -- Returns expiry date
224 procedure PER_QTD_EC
225 (
226 p_owner_payroll_action_id in number, -- run created balance.
227 p_user_payroll_action_id in number, -- current run.
228 p_owner_assignment_action_id in number, -- assact created balance.
229 p_user_assignment_action_id in number, -- current assact..
230 p_owner_effective_date in date, -- eff date of balance.
231 p_user_effective_date in date, -- eff date of current run.
232 p_dimension_name in varchar2, -- balance dimension name.
233 p_expiry_information out nocopy DATE -- dimension expired flag.
234 );
235
236 /*------------------------------ ASG_MON_EC -------------------------*/
237 /*
238 NAME
239 ASG_MON_EC - Assignment Tax Year to Date expiry check
240 DESCRIPTION
241 Expiry checking code for the following:
242 NL Assignment-level Tax Month dimension
243 NOTES
244 The associated dimension is expiry checked at assignment action level
245 */
246 -- Returns dimension expired flag p_expiry_information as 0 or 1
247 procedure ASG_MON_EC
248 (
249 p_owner_payroll_action_id in number, -- run created balance.
250 p_user_payroll_action_id in number, -- current run.
251 p_owner_assignment_action_id in number, -- assact created balance.
252 p_user_assignment_action_id in number, -- current assact..
253 p_owner_effective_date in date, -- eff date of balance.
254 p_user_effective_date in date, -- eff date of current run.
255 p_dimension_name in varchar2, -- balance dimension name.
256 p_expiry_information out nocopy number -- dimension expired flag.
257 );
258
259 -- Returns expiry date
260 procedure ASG_MON_EC
261 (
262 p_owner_payroll_action_id in number, -- run created balance.
263 p_user_payroll_action_id in number, -- current run.
264 p_owner_assignment_action_id in number, -- assact created balance.
265 p_user_assignment_action_id in number, -- current assact..
266 p_owner_effective_date in date, -- eff date of balance.
267 p_user_effective_date in date, -- eff date of current run.
268 p_dimension_name in varchar2, -- balance dimension name.
269 p_expiry_information out nocopy DATE -- dimension expired flag.
270 );
271
272
273 /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/
274 /*
275 NAME
276 ASG_PROC_PTD_EC - Assignment Processing Period to Date expiry check.
277 DESCRIPTION
278 Expiry checking code for the following:
279 NL Element-level Process Period To Date Balance Dimension
280 NOTES
281 The associtated dimension is expiry checked at payroll action level
282 */
283 -- Returns dimension expired flag p_expiry_information as 0 or 1
284 procedure ASG_PROC_PTD_EC
285 (
286 p_owner_payroll_action_id in number, -- run created balance.
287 p_user_payroll_action_id in number, -- current run.
288 p_owner_assignment_action_id in number, -- assact created balance.
289 p_user_assignment_action_id in number, -- current assact..
290 p_owner_effective_date in date, -- eff date of balance.
291 p_user_effective_date in date, -- eff date of current run.
292 p_dimension_name in varchar2, -- balance dimension name.
293 p_expiry_information out nocopy number -- dimension expired flag.
294 ) ;
295
296 -- Returns expiry date
297 procedure ASG_PROC_PTD_EC
298 (
299 p_owner_payroll_action_id in number, -- run created balance.
300 p_user_payroll_action_id in number, -- current run.
301 p_owner_assignment_action_id in number, -- assact created balance.
302 p_user_assignment_action_id in number, -- current assact..
303 p_owner_effective_date in date, -- eff date of balance.
304 p_user_effective_date in date, -- eff date of current run.
308
305 p_dimension_name in varchar2, -- balance dimension name.
306 p_expiry_information out nocopy DATE -- dimension expired flag.
307 ) ;
309
310 /*------------------------------ ASG_SIT_PTD_EC ----------------------------*/
311 /*
312 NAME
313 ASG_SIT_PTD_EC - Assignment SI Type Period to Date expiry check.
314 DESCRIPTION
315 Expiry checking code for the following:
316 NL Element-level Process Period To Date Balance Dimension
317 NOTES
318 The associtated dimension is expiry checked at payroll action level
319 */
320 -- Returns dimension expired flag p_expiry_information as 0 or 1
321 procedure ASG_SIT_PTD_EC
322 (
323 p_owner_payroll_action_id in number, -- run created balance.
324 p_user_payroll_action_id in number, -- current run.
325 p_owner_assignment_action_id in number, -- assact created balance.
326 p_user_assignment_action_id in number, -- current assact..
327 p_owner_effective_date in date, -- eff date of balance.
328 p_user_effective_date in date, -- eff date of current run.
329 p_dimension_name in varchar2, -- balance dimension name.
330 p_expiry_information out nocopy number -- dimension expired flag.
331 ) ;
332
333 -- Returns expiry date
334 procedure ASG_SIT_PTD_EC
335 (
336 p_owner_payroll_action_id in number, -- run created balance.
337 p_user_payroll_action_id in number, -- current run.
338 p_owner_assignment_action_id in number, -- assact created balance.
339 p_user_assignment_action_id in number, -- current assact..
340 p_owner_effective_date in date, -- eff date of balance.
341 p_user_effective_date in date, -- eff date of current run.
342 p_dimension_name in varchar2, -- balance dimension name.
343 p_expiry_information out nocopy DATE -- dimension expired flag.
344 ) ;
345
346 /*------------------------------ ASG_SIT_QTD_EC ----------------------------*/
347 /*
348 NAME
352 NL Element-level Process Quarter To Date Balance Dimension
349 ASG_SIT_QTD_EC - Assignment SI Type Tax Quarter to Date expiry check.
350 DESCRIPTION
351 Expiry checking code for the following:
353 NOTES
354 The associtated dimension is expiry checked at payroll action level
355 */
356 -- Returns dimension expired flag p_expiry_information as 0 or 1
357 procedure ASG_SIT_QTD_EC
358 (
359 p_owner_payroll_action_id in number, -- run created balance.
360 p_user_payroll_action_id in number, -- current run.
361 p_owner_assignment_action_id in number, -- assact created balance.
362 p_user_assignment_action_id in number, -- current assact..
363 p_owner_effective_date in date, -- eff date of balance.
364 p_user_effective_date in date, -- eff date of current run.
365 p_dimension_name in varchar2, -- balance dimension name.
366 p_expiry_information out nocopy number -- dimension expired flag.
367 );
368
369 -- Returns expiry date
370 procedure ASG_SIT_QTD_EC
371 (
372 p_owner_payroll_action_id in number, -- run created balance.
373 p_user_payroll_action_id in number, -- current run.
374 p_owner_assignment_action_id in number, -- assact created balance.
375 p_user_assignment_action_id in number, -- current assact..
376 p_owner_effective_date in date, -- eff date of balance.
377 p_user_effective_date in date, -- eff date of current run.
378 p_dimension_name in varchar2, -- balance dimension name.
379 p_expiry_information out nocopy DATE -- dimension expired flag.
380 );
381 /*------------------------------ ASG_SIT_MON_EC ----------------------------*/
382 /*
383 NAME
384 ASG_SIT_MON_EC - Assignment SI Type Tax Quarter to Date expiry check.
385 DESCRIPTION
386 Expiry checking code for the following:
387 NL Element-level Process Month Balance Dimension
388 NOTES
389 The associtated dimension is expiry checked at payroll action level
390 */
391 -- Returns dimension expired flag p_expiry_information as 0 or 1
392 procedure ASG_SIT_MON_EC
393 (
394 p_owner_payroll_action_id in number, -- run created balance.
395 p_user_payroll_action_id in number, -- current run.
396 p_owner_assignment_action_id in number, -- assact created balance.
397 p_user_assignment_action_id in number, -- current assact..
398 p_owner_effective_date in date, -- eff date of balance.
399 p_user_effective_date in date, -- eff date of current run.
400 p_dimension_name in varchar2, -- balance dimension name.
401 p_expiry_information out nocopy number -- dimension expired flag.
402 );
403
404 -- Returns expiry date
405 procedure ASG_SIT_MON_EC
406 (
407 p_owner_payroll_action_id in number, -- run created balance.
408 p_user_payroll_action_id in number, -- current run.
409 p_owner_assignment_action_id in number, -- assact created balance.
410 p_user_assignment_action_id in number, -- current assact..
411 p_owner_effective_date in date, -- eff date of balance.
412 p_user_effective_date in date, -- eff date of current run.
413 p_dimension_name in varchar2, -- balance dimension name.
414 p_expiry_information out nocopy DATE -- dimension expired flag.
415 );
416
417 /*------------------------------ ASG_SIT_YTD_EC ----------------------------*/
418 /*
419 NAME
420 ASG_SIT_YTD_EC - Assignment SI Type Tax Year to Date expiry check.
421 DESCRIPTION
422 Expiry checking code for the following:
426 */
423 NL Element-level Process Period To Date Balance Dimension
424 NOTES
425 The associtated dimension is expiry checked at payroll action level
427 -- Returns dimension expired flag p_expiry_information as 0 or 1
428 procedure ASG_SIT_YTD_EC
429 (
430 p_owner_payroll_action_id in number, -- run created balance.
431 p_user_payroll_action_id in number, -- current run.
432 p_owner_assignment_action_id in number, -- assact created balance.
433 p_user_assignment_action_id in number, -- current assact..
434 p_owner_effective_date in date, -- eff date of balance.
435 p_user_effective_date in date, -- eff date of current run.
436 p_dimension_name in varchar2, -- balance dimension name.
437 p_expiry_information out nocopy number -- dimension expired flag.
438 ) ;
439
440 -- Returns expiry date
441 procedure ASG_SIT_YTD_EC
442 (
443 p_owner_payroll_action_id in number, -- run created balance.
444 p_user_payroll_action_id in number, -- current run.
445 p_owner_assignment_action_id in number, -- assact created balance.
446 p_user_assignment_action_id in number, -- current assact..
447 p_owner_effective_date in date, -- eff date of balance.
448 p_user_effective_date in date, -- eff date of current run.
449 p_dimension_name in varchar2, -- balance dimension name.
450 p_expiry_information out nocopy DATE -- dimension expired flag.
451 ) ;
452
453 /*------------------------------ ASG_RUN_EC ----------------------------*/
454 /*
455 NAME
456 ASG_RUN_EC - Assignment Run expiry check.
457 DESCRIPTION
458 Expiry checking code for the following:
459 NL Element-level Process Period To Date Balance Dimension
460 NOTES
461 The associtated dimension is expiry checked at payroll action level
462 */
463 -- Returns dimension expired flag p_expiry_information as 0 or 1
464 procedure ASG_RUN_EC
465 (
466 p_owner_payroll_action_id in number, -- run created balance.
467 p_user_payroll_action_id in number, -- current run.
468 p_owner_assignment_action_id in number, -- assact created balance.
469 p_user_assignment_action_id in number, -- current assact..
470 p_owner_effective_date in date, -- eff date of balance.
471 p_user_effective_date in date, -- eff date of current run.
472 p_dimension_name in varchar2, -- balance dimension name.
473 p_expiry_information out nocopy number -- dimension expired flag.
474 ) ;
475
476 /*------------------------------ ASG_SIT_RUN_EC ----------------------------*/
477 /*
478 NAME
479 ASG_SIT_RUN_EC - Assignment Run SI Type Date expiry check.
480 DESCRIPTION
481 Expiry checking code for the following:
482 NL Element-level Process Period To Date Balance Dimension
483 NOTES
484 The associtated dimension is expiry checked at payroll action level
485 */
486 -- Returns dimension expired flag p_expiry_information as 0 or 1
487 procedure ASG_SIT_RUN_EC
488 (
489 p_owner_payroll_action_id in number, -- run created balance.
490 p_user_payroll_action_id in number, -- current run.
491 p_owner_assignment_action_id in number, -- assact created balance.
492 p_user_assignment_action_id in number, -- current assact..
493 p_owner_effective_date in date, -- eff date of balance.
494 p_user_effective_date in date, -- eff date of current run.
495 p_dimension_name in varchar2, -- balance dimension name.
496 p_expiry_information out nocopy number -- dimension expired flag.
497 ) ;
498 -----------------------------------------------------------------------------
499
500 /*------------------------------ ASG_ITD_EC ----------------------------*/
501 /*
502 NAME
503 ASG_ITD_EC - Assignment Inception To Date expiry check.
504 DESCRIPTION
505 Expiry checking code for the following:
506 NL Element-level Process Inception To Date Balance Dimension
507 NOTES
508 The associated dimension is expiry checked at payroll action level
509 */
510 -- Returns dimension expired flag p_expiry_information as 0 or 1
511 procedure ASG_ITD_EC
512 (
513 p_owner_payroll_action_id in number, -- run created balance.
514 p_user_payroll_action_id in number, -- current run.
515 p_owner_assignment_action_id in number, -- assact created balance.
516 p_user_assignment_action_id in number, -- current assact..
517 p_owner_effective_date in date, -- eff date of balance.
518 p_user_effective_date in date, -- eff date of current run.
519 p_dimension_name in varchar2, -- balance dimension name.
520 p_expiry_information out nocopy number -- dimension expired flag.
521 ) ;
522
523 -- Returns expiry date
524 procedure ASG_ITD_EC
525 (
526 p_owner_payroll_action_id in number, -- run created balance.
527 p_user_payroll_action_id in number, -- current run.
528 p_owner_assignment_action_id in number, -- assact created balance.
529 p_user_assignment_action_id in number, -- current assact..
530 p_owner_effective_date in date, -- eff date of balance.
531 p_user_effective_date in date, -- eff date of current run.
532 p_dimension_name in varchar2, -- balance dimension name.
536
533 p_expiry_information out nocopy DATE -- dimension expired flag.
534 ) ;
535
537 --
538 --3019423
539 --Expiry checking code for _PER_ITD
540 --
541 /*------------------------------ PER_ITD_EC ----------------------------*/
542 /*
543 NAME
544 PER_ITD_EC - Person Inception To Date expiry check.
545 DESCRIPTION
546 Expiry checking code for the following:
547 NL Person Inception To Date Balance Dimension
548 NOTES
549 The associated dimension is expiry checked at Person level
550 */
551 -- Returns dimension expired flag p_expiry_information as 0 or 1
552 procedure PER_ITD_EC
553 (
554 p_owner_payroll_action_id in number, -- run created balance.
555 p_user_payroll_action_id in number, -- current run.
556 p_owner_assignment_action_id in number, -- assact created balance.
557 p_user_assignment_action_id in number, -- current assact..
558 p_owner_effective_date in date, -- eff date of balance.
559 p_user_effective_date in date, -- eff date of current run.
560 p_dimension_name in varchar2, -- balance dimension name.
564 -- Returns expiry date
561 p_expiry_information out nocopy number -- dimension expired flag.
562 ) ;
563
565 procedure PER_ITD_EC
566 (
567 p_owner_payroll_action_id in number, -- run created balance.
571 p_owner_effective_date in date, -- eff date of balance.
568 p_user_payroll_action_id in number, -- current run.
569 p_owner_assignment_action_id in number, -- assact created balance.
570 p_user_assignment_action_id in number, -- current assact..
572 p_user_effective_date in date, -- eff date of current run.
573 p_dimension_name in varchar2, -- balance dimension name.
574 p_expiry_information out nocopy DATE -- dimension expired flag.
575 ) ;
576
577
578 /*------------------------------ ASG_LQTD_EC ----------------------------*/
579 /*
580 NAME
581 ASG_LQTD_EC - Assignment Lunar Quarter To Date expiry check.
582
583 NOTES
584 The associated dimension is expiry checked at payroll action level
585 */
586 -- Returns dimension expired flag p_expiry_information as 0 or 1
587 procedure ASG_LQTD_EC
588 (
589 p_owner_payroll_action_id in number, -- run created balance.
590 p_user_payroll_action_id in number, -- current run.
591 p_owner_assignment_action_id in number, -- assact created balance.
592 p_user_assignment_action_id in number, -- current assact..
593 p_owner_effective_date in date, -- eff date of balance.
594 p_user_effective_date in date, -- eff date of current run.
595 p_dimension_name in varchar2, -- balance dimension name.
596 p_expiry_information out nocopy number -- dimension expired flag.
597 );
598
599 -- Returns expiry date
600 procedure ASG_LQTD_EC
601 (
602 p_owner_payroll_action_id in number, -- run created balance.
603 p_user_payroll_action_id in number, -- current run.
604 p_owner_assignment_action_id in number, -- assact created balance.
605 p_user_assignment_action_id in number, -- current assact..
606 p_owner_effective_date in date, -- eff date of balance.
607 p_user_effective_date in date, -- eff date of current run.
608 p_dimension_name in varchar2, -- balance dimension name.
609 p_expiry_information out nocopy DATE -- dimension expired flag.
610 );
611
612
613 /*------------------------------ PER_PAY_SITP_PTD ----------------------------*/
614 /*
615 NAME
616 PER_PAY_SITP_PTD - Person Payroll SI Type Provider Period To Date .
617
618 NOTES
619 The associtated dimension is expiry checked at payroll action level
620 */
621 -- Returns dimension expired flag p_expiry_information as 0 or 1
622 procedure PER_PAY_SITP_PTD
623 (
624 p_owner_payroll_action_id in number, -- run created balance.
625 p_user_payroll_action_id in number, -- current run.
626 p_owner_assignment_action_id in number, -- assact created balance.
627 p_user_assignment_action_id in number, -- current assact..
628 p_owner_effective_date in date, -- eff date of balance.
629 p_user_effective_date in date, -- eff date of current run.
630 p_dimension_name in varchar2, -- balance dimension name.
631 p_expiry_information out nocopy number -- dimension expired flag.
632 );
633
634 -- Returns expiry date
635 procedure PER_PAY_SITP_PTD
636 (
637 p_owner_payroll_action_id in number, -- run created balance.
638 p_user_payroll_action_id in number, -- current run.
639 p_owner_assignment_action_id in number, -- assact created balance.
640 p_user_assignment_action_id in number, -- current assact..
641 p_owner_effective_date in date, -- eff date of balance.
642 p_user_effective_date in date, -- eff date of current run.
643 p_dimension_name in varchar2, -- balance dimension name.
644 p_expiry_information out nocopy DATE -- dimension expired flag.
645 );
646
647 /*------------------------------ PER_PAY_PTD_EC ----------------------------*/
648 /*
649 NAME
650 PER_PAY_PTD_EC - Person Payroll Period To Date Expiry Check.
651
652 NOTES
653 The associated dimension is expiry checked at payroll action level
654 */
655 -- Returns dimension expired flag p_expiry_information as 0 or 1
656 procedure PER_PAY_PTD_EC
657 (
658 p_owner_payroll_action_id in number, -- run created balance.
659 p_user_payroll_action_id in number, -- current run.
660 p_owner_assignment_action_id in number, -- assact created balance.
661 p_user_assignment_action_id in number, -- current assact..
662 p_owner_effective_date in date, -- eff date of balance.
663 p_user_effective_date in date, -- eff date of current run.
664 p_dimension_name in varchar2, -- balance dimension name.
665 p_expiry_information out nocopy number -- dimension expired flag.
666 );
667
668 -- Returns expiry date
669 procedure PER_PAY_PTD_EC
670 (
671 p_owner_payroll_action_id in number, -- run created balance.
672 p_user_payroll_action_id in number, -- current run.
673 p_owner_assignment_action_id in number, -- assact created balance.
674 p_user_assignment_action_id in number, -- current assact..
675 p_owner_effective_date in date, -- eff date of balance.
676 p_user_effective_date in date, -- eff date of current run.
677 p_dimension_name in varchar2, -- balance dimension name.
678 p_expiry_information out nocopy DATE -- dimension expired flag.
679 );
680
681
682
683 /*------------------------------ ASG_LMONTH_EC ----------------------------*/
684 /*
685 NAME
686 ASG_LMONTH_EC - Assignment Lunar Monthly expiry check.
687
688 NOTES
689 The associated dimension is expiry checked at payroll action level
690 */
691 -- Returns dimension expired flag p_expiry_information as 0 or 1
692 procedure ASG_LMONTH_EC
693 (
694 p_owner_payroll_action_id in number, -- run created balance.
695 p_user_payroll_action_id in number, -- current run.
696 p_owner_assignment_action_id in number, -- assact created balance.
697 p_user_assignment_action_id in number, -- current assact..
698 p_owner_effective_date in date, -- eff date of balance.
699 p_user_effective_date in date, -- eff date of current run.
700 p_dimension_name in varchar2, -- balance dimension name.
701 p_expiry_information out nocopy number -- dimension expired flag.
702 );
703
704 -- Returns expiry date
705 procedure ASG_LMONTH_EC
706 (
707 p_owner_payroll_action_id in number, -- run created balance.
708 p_user_payroll_action_id in number, -- current run.
709 p_owner_assignment_action_id in number, -- assact created balance.
710 p_user_assignment_action_id in number, -- current assact..
711 p_owner_effective_date in date, -- eff date of balance.
712 p_user_effective_date in date, -- eff date of current run.
713 p_dimension_name in varchar2, -- balance dimension name.
714 p_expiry_information out nocopy DATE -- dimension expired flag.
715 );
716
717
718
719 /*------------------------------ ASG_SIT_LMONTH_EC ----------------------------*/
720 /*
721 NAME
722 ASG_SIT_LMONTH_EC - Assignment Lunar Monthly expiry check.
723
724 NOTES
725 The associated dimension is expiry checked at payroll action level
726 */
727 -- Returns dimension expired flag p_expiry_information as 0 or 1
728 procedure ASG_SIT_LMON_EC
729 (
730 p_owner_payroll_action_id in number, -- run created balance.
731 p_user_payroll_action_id in number, -- current run.
732 p_owner_assignment_action_id in number, -- assact created balance.
733 p_user_assignment_action_id in number, -- current assact..
734 p_owner_effective_date in date, -- eff date of balance.
735 p_user_effective_date in date, -- eff date of current run.
736 p_dimension_name in varchar2, -- balance dimension name.
737 p_expiry_information out nocopy number -- dimension expired flag.
738 );
739
740 -- Returns expiry date
741 procedure ASG_SIT_LMON_EC
742 (
743 p_owner_payroll_action_id in number, -- run created balance.
744 p_user_payroll_action_id in number, -- current run.
745 p_owner_assignment_action_id in number, -- assact created balance.
746 p_user_assignment_action_id in number, -- current assact..
747 p_owner_effective_date in date, -- eff date of balance.
748 p_user_effective_date in date, -- eff date of current run.
749 p_dimension_name in varchar2, -- balance dimension name.
750 p_expiry_information out nocopy DATE -- dimension expired flag.
751 );
752
753
754 /*------------------------------ PER_PAY_YTD_EC ----------------------------*/
755 /*
756 NAME
757 PER_PAY_YTD_EC - Person Payroll Year to Date expiry check.
758 DESCRIPTION
759 Expiry checking code for the following:
760 NL Element-level Process Year To Date Balance Dimension
761 NOTES
762 The associtated dimension is expiry checked at payroll action level
763 */
764 -- Returns dimension expired flag p_expiry_information as 0 or 1
765 procedure PER_PAY_YTD_EC
766 (
767 p_owner_payroll_action_id in number, -- run created balance.
768 p_user_payroll_action_id in number, -- current run.
769 p_owner_assignment_action_id in number, -- assact created balance.
770 p_user_assignment_action_id in number, -- current assact..
771 p_owner_effective_date in date, -- eff date of balance.
772 p_user_effective_date in date, -- eff date of current run.
773 p_dimension_name in varchar2, -- balance dimension name.
774 p_expiry_information out nocopy number -- dimension expired flag.
775 ) ;
776
777 --Returns Expiry Date
778 procedure PER_PAY_YTD_EC
779 (
780 p_owner_payroll_action_id in number, -- run created balance.
781 p_user_payroll_action_id in number, -- current run.
782 p_owner_assignment_action_id in number, -- assact created balance.
783 p_user_assignment_action_id in number, -- current assact..
784 p_owner_effective_date in date, -- eff date of balance.
785 p_user_effective_date in date, -- eff date of current run.
786 p_dimension_name in varchar2, -- balance dimension name.
787 p_expiry_information out nocopy date -- dimension expired flag.
788 ) ;
789
790
791
792 end PAY_NL_DIM_PKG;