1 package BEN_CWB_CUSTOM_PERSON_V2_PKG as
2 /* $Header: bencwbco.pkh 120.0 2006/04/11 06:10:31 ddeb noship $ */
3
4
5 -- --------------------------------------------------------------------------
6 -- |---------------------------< get_years_employed >---------------------------|
7 -- --------------------------------------------------------------------------
8 -- Description
9 -- This function returns the years_employed
10 --
11 function get_years_employed(p_person_id in number
12 ,p_assignment_id in number
13 ,p_legislation_code in varchar2
14 ,p_group_pl_id in number
15 ,p_lf_evt_ocrd_dt in date
16 ,p_effective_date in date
17 ,p_years_employed in number)
18
19 return number;
20 --
21
22 -- --------------------------------------------------------------------------
23 -- |---------------------------< get_years_in_job >---------------------------|
24 -- --------------------------------------------------------------------------
25 -- Description
26 -- This function returns the years_in_job
27 --
28 function get_years_in_job(p_person_id in number
29 ,p_assignment_id in number
30 ,p_legislation_code in varchar2
31 ,p_group_pl_id in number
32 ,p_lf_evt_ocrd_dt in date
33 ,p_effective_date in date
34 ,p_years_in_job in number)
35
36 return number;
37 --
38 -- --------------------------------------------------------------------------
39 -- |---------------------------< get_years_in_position >---------------------------|
40 -- --------------------------------------------------------------------------
41 -- Description
42 -- This function returns the years_in_position
43 --
44 function get_years_in_position(p_person_id in number
45 ,p_assignment_id in number
46 ,p_legislation_code in varchar2
47 ,p_group_pl_id in number
48 ,p_lf_evt_ocrd_dt in date
49 ,p_effective_date in date
50 ,p_years_in_position in number)
51
52 return number;
53 --
54 -- --------------------------------------------------------------------------
55 -- |---------------------------< get_years_in_grade >---------------------------|
56 -- --------------------------------------------------------------------------
57 -- Description
58 -- This function returns the years_in_grade
59 --
60 function get_years_in_grade(p_person_id in number
61 ,p_assignment_id in number
62 ,p_legislation_code in varchar2
63 ,p_group_pl_id in number
64 ,p_lf_evt_ocrd_dt in date
65 ,p_effective_date in date
66 ,p_years_in_grade in number)
67
68 return number;
69 --
70 -- --------------------------------------------------------------------------
71 -- |---------------------------< get_base_salary >---------------------------|
72 -- --------------------------------------------------------------------------
73 -- Description
74 -- This function returns the base_salary
75 --
76 function get_base_salary(p_person_id in number
77 ,p_assignment_id in number
78 ,p_legislation_code in varchar2
79 ,p_group_pl_id in number
80 ,p_lf_evt_ocrd_dt in date
81 ,p_effective_date in date
82 ,p_base_salary in number)
83
84 return number;
85 --
86 -- --------------------------------------------------------------------------
87 -- |---------------------------< get_job_id >---------------------------|
88 -- --------------------------------------------------------------------------
89 -- Description
90 -- This function returns the job_id
91 --
92 function get_job_id(p_person_id in number
93 ,p_assignment_id in number
94 ,p_legislation_code in varchar2
95 ,p_group_pl_id in number
96 ,p_lf_evt_ocrd_dt in date
97 ,p_effective_date in date
98 ,p_job_id in number)
99
100 return number;
101 --
102 -- --------------------------------------------------------------------------
103 -- |---------------------------< get_grade_id >---------------------------|
104 -- --------------------------------------------------------------------------
105 -- Description
106 -- This function returns the grade_id
107 --
108 function get_grade_id(p_person_id in number
109 ,p_assignment_id in number
110 ,p_legislation_code in varchar2
111 ,p_group_pl_id in number
112 ,p_lf_evt_ocrd_dt in date
113 ,p_effective_date in date
114 ,p_grade_id in number)
115
116 return number;
117 --
118 -- --------------------------------------------------------------------------
119 -- |---------------------------< get_position_id >---------------------------|
120 -- --------------------------------------------------------------------------
121 -- Description
122 -- This function returns the position_id
123 --
124 function get_position_id(p_person_id in number
125 ,p_assignment_id in number
126 ,p_legislation_code in varchar2
127 ,p_group_pl_id in number
128 ,p_lf_evt_ocrd_dt in date
129 ,p_effective_date in date
130 ,p_position_id in number)
131
132 return number;
133 --
134 -- --------------------------------------------------------------------------
135 -- |---------------------------< get_people_group_id >---------------------------|
136 -- --------------------------------------------------------------------------
137 -- Description
138 -- This function returns the people_group_id
139 --
140 function get_people_group_id(p_person_id in number
141 ,p_assignment_id in number
142 ,p_legislation_code in varchar2
143 ,p_group_pl_id in number
144 ,p_lf_evt_ocrd_dt in date
145 ,p_effective_date in date
146 ,p_people_group_id in number)
147
148 return number;
149 --
150 -- --------------------------------------------------------------------------
151 -- |---------------------------< get_soft_coding_keyflex_id >---------------------------|
152 -- --------------------------------------------------------------------------
153 -- Description
154 -- This function returns the soft_coding_keyflex_id
155 --
156 function get_soft_coding_keyflex_id(p_person_id in number
157 ,p_assignment_id in number
158 ,p_legislation_code in varchar2
159 ,p_group_pl_id in number
160 ,p_lf_evt_ocrd_dt in date
161 ,p_effective_date in date
162 ,p_soft_coding_keyflex_id in number)
163
164 return number;
165 --
166 -- --------------------------------------------------------------------------
167 -- |---------------------------< get_location_id >---------------------------|
168 -- --------------------------------------------------------------------------
169 -- Description
170 -- This function returns the location_id
171 --
172 function get_location_id(p_person_id in number
173 ,p_assignment_id in number
174 ,p_legislation_code in varchar2
175 ,p_group_pl_id in number
179
176 ,p_lf_evt_ocrd_dt in date
177 ,p_effective_date in date
178 ,p_location_id in number)
180 return number;
181 --
182 -- --------------------------------------------------------------------------
183 -- |---------------------------< get_pay_rate_id >---------------------------|
184 -- --------------------------------------------------------------------------
185 -- Description
186 -- This function returns the pay_rate_id
187 --
188 function get_pay_rate_id(p_person_id in number
189 ,p_assignment_id in number
190 ,p_legislation_code in varchar2
191 ,p_group_pl_id in number
192 ,p_lf_evt_ocrd_dt in date
193 ,p_effective_date in date
194 ,p_pay_rate_id in number)
195
196 return number;
197 --
198 -- --------------------------------------------------------------------------
199 -- |---------------------------< get_assignment_status_type_id >---------------------------|
200 -- --------------------------------------------------------------------------
201 -- Description
202 -- This function returns the assignment_status_type_id
203 --
204 function get_assignment_status_type_id(p_person_id in number
208 ,p_lf_evt_ocrd_dt in date
205 ,p_assignment_id in number
206 ,p_legislation_code in varchar2
207 ,p_group_pl_id in number
209 ,p_effective_date in date
210 ,p_assignment_status_type_id in number)
211
212 return number;
213 --
214 -- --------------------------------------------------------------------------
215 -- |---------------------------< get_grade_annulization_factor >---------------------------|
216 -- --------------------------------------------------------------------------
217 -- Description
218 -- This function returns the grade_annulization_factor
219 --
220 function get_grade_annulization_factor(p_person_id in number
221 ,p_assignment_id in number
222 ,p_legislation_code in varchar2
223 ,p_group_pl_id in number
224 ,p_lf_evt_ocrd_dt in date
225 ,p_effective_date in date
226 ,p_grade_annulization_factor in number)
227
228 return number;
229 --
230 -- --------------------------------------------------------------------------
231 -- |---------------------------< get_pay_annulization_factor >---------------------------|
232 -- --------------------------------------------------------------------------
233 -- Description
234 -- This function returns the pay_annulization_factor
235 --
236 function get_pay_annulization_factor(p_person_id in number
237 ,p_assignment_id in number
238 ,p_legislation_code in varchar2
239 ,p_group_pl_id in number
240 ,p_lf_evt_ocrd_dt in date
241 ,p_effective_date in date
242 ,p_pay_annulization_factor in number)
243
244 return number;
245 --
246 -- --------------------------------------------------------------------------
247 -- |---------------------------< get_grd_min_val >---------------------------|
248 -- --------------------------------------------------------------------------
249 -- Description
250 -- This function returns the grd_min_val
251 --
252 function get_grd_min_val(p_person_id in number
253 ,p_assignment_id in number
254 ,p_legislation_code in varchar2
255 ,p_group_pl_id in number
256 ,p_lf_evt_ocrd_dt in date
257 ,p_effective_date in date
258 ,p_grd_min_val in number)
259
260 return number;
261 --
262 -- --------------------------------------------------------------------------
263 -- |---------------------------< get_grd_max_val >---------------------------|
264 -- --------------------------------------------------------------------------
265 -- Description
266 -- This function returns the grd_max_val
267 --
268 function get_grd_max_val(p_person_id in number
269 ,p_assignment_id in number
270 ,p_legislation_code in varchar2
271 ,p_group_pl_id in number
272 ,p_lf_evt_ocrd_dt in date
273 ,p_effective_date in date
274 ,p_grd_max_val in number)
275
276 return number;
277 --
278 -- --------------------------------------------------------------------------
279 -- |---------------------------< get_grd_mid_point >---------------------------|
280 -- --------------------------------------------------------------------------
281 -- Description
282 -- This function returns the grd_mid_pointl
283 --
284 function get_grd_mid_point(p_person_id in number
285 ,p_assignment_id in number
286 ,p_legislation_code in varchar2
287 ,p_group_pl_id in number
288 ,p_lf_evt_ocrd_dt in date
289 ,p_effective_date in date
290 ,p_grd_mid_point in number)
291
292 return number;
293 --
294 -- --------------------------------------------------------------------------
295 -- |---------------------------< get_fte_factor >---------------------------|
296 -- --------------------------------------------------------------------------
297 -- Description
298 -- This function returns the fte_factor
299 --
300 function get_fte_factor(p_person_id in number
301 ,p_assignment_id in number
302 ,p_legislation_code in varchar2
303 ,p_group_pl_id in number
307
304 ,p_lf_evt_ocrd_dt in date
305 ,p_effective_date in date
306 ,p_fte_factor in number)
308 return number;
309 --
310 -- --------------------------------------------------------------------------
311 -- |---------------------------< get_grd_pct_in_range >---------------------------|
312 -- --------------------------------------------------------------------------
313 -- Description
314 -- This function returns the grd_pct_in_range
315 --
316 function get_grd_pct_in_range(p_person_id in number
317 ,p_assignment_id in number
318 ,p_legislation_code in varchar2
319 ,p_group_pl_id in number
320 ,p_lf_evt_ocrd_dt in date
321 ,p_effective_date in date
322 ,p_grd_pct_in_range in number)
323
324 return number;
325 --
326 -- --------------------------------------------------------------------------
327 -- |---------------------------< get_salary_1_year_ago >---------------------------|
328 -- --------------------------------------------------------------------------
329 -- Description
330 -- This function returns the salary_1_year_ago
331 --
332 function get_salary_1_year_ago(p_person_id in number
333 ,p_assignment_id in number
334 ,p_legislation_code in varchar2
335 ,p_group_pl_id in number
336 ,p_lf_evt_ocrd_dt in date
337 ,p_effective_date in date
338 ,p_salary_1_year_ago in number)
339
340 return number;
341 --
342 -- --------------------------------------------------------------------------
343 -- |---------------------------< get_salary_1_year_ago_ann_fctr >---------------------------|
344 -- --------------------------------------------------------------------------
345 -- Description
346 -- This function returns the salary_1_year_ago_ann_fctr
347 --
348 function get_salary_1_year_ago_ann_fctr(p_person_id in number
349 ,p_assignment_id in number
350 ,p_legislation_code in varchar2
351 ,p_group_pl_id in number
352 ,p_lf_evt_ocrd_dt in date
353 ,p_effective_date in date
354 ,p_salary_1_year_ago_ann_fctr in number)
355
356 return number;
357 --
358 -- --------------------------------------------------------------------------
359 -- |---------------------------< get_salary_2_year_ago >---------------------------|
360 -- --------------------------------------------------------------------------
361 -- Description
362 -- This function returns the salary_2_year_ago
363 --
364 function get_salary_2_year_ago(p_person_id in number
365 ,p_assignment_id in number
366 ,p_legislation_code in varchar2
367 ,p_group_pl_id in number
368 ,p_lf_evt_ocrd_dt in date
369 ,p_effective_date in date
370 ,p_salary_2_year_ago in number)
371
372 return number;
373 --
374 -- --------------------------------------------------------------------------
375 -- |---------------------------< get_salary_2_year_ago_ann_fctr >---------------------------|
376 -- --------------------------------------------------------------------------
377 -- Description
378 -- This function returns the salary_2_year_ago_ann_fctr
379 --
380 function get_salary_2_year_ago_ann_fctr(p_person_id in number
381 ,p_assignment_id in number
382 ,p_legislation_code in varchar2
383 ,p_group_pl_id in number
384 ,p_lf_evt_ocrd_dt in date
385 ,p_effective_date in date
386 ,p_salary_2_year_ago_ann_fctr in number)
387
388 return number;
389 --
390 -- --------------------------------------------------------------------------
394 -- This function returns the salary_3_year_ago
391 -- |---------------------------< get_salary_3_year_ago >---------------------------|
392 -- --------------------------------------------------------------------------
393 -- Description
395 --
396 function get_salary_3_year_ago(p_person_id in number
397 ,p_assignment_id in number
398 ,p_legislation_code in varchar2
399 ,p_group_pl_id in number
400 ,p_lf_evt_ocrd_dt in date
401 ,p_effective_date in date
402 ,p_salary_3_year_ago in number)
403
404 return number;
405 --
406 -- --------------------------------------------------------------------------
407 -- |---------------------------< get_salary_3_year_ago_ann_fctr >---------------------------|
408 -- --------------------------------------------------------------------------
409 -- Description
410 -- This function returns the salary_3_year_ago_ann_fctr
411 --
412 function get_salary_3_year_ago_ann_fctr(p_person_id in number
413 ,p_assignment_id in number
414 ,p_legislation_code in varchar2
415 ,p_group_pl_id in number
416 ,p_lf_evt_ocrd_dt in date
417 ,p_effective_date in date
418 ,p_salary_3_year_ago_ann_fctr in number)
419
420 return number;
421 --
422 -- --------------------------------------------------------------------------
423 -- |---------------------------< get_salary_4_year_ago >---------------------------|
424 -- --------------------------------------------------------------------------
425 -- Description
426 -- This function returns the salary_4_year_ago
427 --
428 function get_salary_4_year_ago(p_person_id in number
429 ,p_assignment_id in number
430 ,p_legislation_code in varchar2
431 ,p_group_pl_id in number
432 ,p_lf_evt_ocrd_dt in date
433 ,p_effective_date in date
434 ,p_salary_4_year_ago in number)
435
436 return number;
437 --
438 -- --------------------------------------------------------------------------
439 -- |---------------------------< get_salary_4_year_ago_ann_fctr >---------------------------|
440 -- --------------------------------------------------------------------------
441 -- Description
442 -- This function returns the salary_4_year_ago_ann_fctr
443 --
444 function get_salary_4_year_ago_ann_fctr(p_person_id in number
445 ,p_assignment_id in number
446 ,p_legislation_code in varchar2
447 ,p_group_pl_id in number
448 ,p_lf_evt_ocrd_dt in date
449 ,p_effective_date in date
450 ,p_salary_4_year_ago_ann_fctr in number)
451
455 -- |---------------------------< get_salary_5_year_ago >---------------------------|
452 return number;
453 --
454 -- --------------------------------------------------------------------------
456 -- --------------------------------------------------------------------------
457 -- Description
458 -- This function returns the salary_5_year_ago
459 --
460 function get_salary_5_year_ago(p_person_id in number
461 ,p_assignment_id in number
462 ,p_legislation_code in varchar2
463 ,p_group_pl_id in number
464 ,p_lf_evt_ocrd_dt in date
465 ,p_effective_date in date
466 ,p_salary_5_year_ago in number)
467
468 return number;
469 --
470 -- --------------------------------------------------------------------------
471 -- |---------------------------< get_salary_5_year_ago_ann_fctr >---------------------------|
472 -- --------------------------------------------------------------------------
473 -- Description
474 -- This function returns the salary_5_year_ago_ann_fctr
475 --
476 function get_salary_5_year_ago_ann_fctr(p_person_id in number
477 ,p_assignment_id in number
478 ,p_legislation_code in varchar2
479 ,p_group_pl_id in number
480 ,p_lf_evt_ocrd_dt in date
481 ,p_effective_date in date
482 ,p_salary_5_year_ago_ann_fctr in number)
483
484 return number;
485 --
486 -- --------------------------------------------------------------------------
487 -- |---------------------------< get_prev_sal >---------------------------|
488 -- --------------------------------------------------------------------------
489 -- Description
490 -- This function returns the prev_sal
491 --
492 function get_prev_sal(p_person_id in number
493 ,p_assignment_id in number
494 ,p_legislation_code in varchar2
495 ,p_group_pl_id in number
496 ,p_lf_evt_ocrd_dt in date
497 ,p_effective_date in date
498 ,p_prev_sal in number)
499
500 return number;
501 --
502 -- --------------------------------------------------------------------------
503 -- |---------------------------< get_prev_sal_ann_fctr >---------------------------|
504 -- --------------------------------------------------------------------------
505 -- Description
506 -- This function returns the prev_sal_ann_fctr
507 --
508 function get_prev_sal_ann_fctr(p_person_id in number
509 ,p_assignment_id in number
510 ,p_legislation_code in varchar2
511 ,p_group_pl_id in number
512 ,p_lf_evt_ocrd_dt in date
513 ,p_effective_date in date
514 ,p_prev_sal_ann_fctr in number)
515
516 return number;
517 ---- --------------------------------------------------------------------------
518 -- |---------------------------< get_mkt_annualization_factor >---------------------------|
519 -- --------------------------------------------------------------------------
520 -- Description
521 -- This function returns the mkt_annualization_factor
522 --
523 function get_mkt_annualization_factor(p_person_id in number
524 ,p_assignment_id in number
525 ,p_legislation_code in varchar2
526 ,p_group_pl_id in number
527 ,p_lf_evt_ocrd_dt in date
528 ,p_effective_date in date
529 ,p_mkt_annualization_factor in number)
530
531 return number;
532 ---- --------------------------------------------------------------------------
533 -- |---------------------------< get_mkt_min_salary >---------------------------|
534 -- --------------------------------------------------------------------------
535 -- Description
536 -- This function returns the mkt_min_salary
537 --
538 function get_mkt_min_salary(p_person_id in number
539 ,p_assignment_id in number
540 ,p_legislation_code in varchar2
541 ,p_group_pl_id in number
542 ,p_lf_evt_ocrd_dt in date
543 ,p_effective_date in date
544 ,p_mkt_min_salary in number)
545
546 return number;
550 -- Description
547 ---- --------------------------------------------------------------------------
548 -- |---------------------------< get_mkt_25pct_salary >---------------------------|
549 -- --------------------------------------------------------------------------
551 -- This function returns the mkt_25pct_salary
552 --
553 function get_mkt_25pct_salary(p_person_id in number
554 ,p_assignment_id in number
555 ,p_legislation_code in varchar2
556 ,p_group_pl_id in number
557 ,p_lf_evt_ocrd_dt in date
558 ,p_effective_date in date
559 ,p_mkt_25pct_salary in number)
560
561 return number;
562 ---- --------------------------------------------------------------------------
563 -- |---------------------------< get_mkt_mid_salary >---------------------------|
564 -- --------------------------------------------------------------------------
565 -- Description
566 -- This function returns the mkt_mid_salary
567 --
568 function get_mkt_mid_salary(p_person_id in number
569 ,p_assignment_id in number
570 ,p_legislation_code in varchar2
571 ,p_group_pl_id in number
572 ,p_lf_evt_ocrd_dt in date
573 ,p_effective_date in date
574 ,p_mkt_mid_salary in number)
575
576 return number;
577 ---- --------------------------------------------------------------------------
578 -- |---------------------------< get_mkt_75pct_salary >---------------------------|
579 -- --------------------------------------------------------------------------
580 -- Description
581 -- This function returns the mkt_75pct_salary
582 --
583 function get_mkt_75pct_salary(p_person_id in number
584 ,p_assignment_id in number
585 ,p_legislation_code in varchar2
586 ,p_group_pl_id in number
587 ,p_lf_evt_ocrd_dt in date
588 ,p_effective_date in date
592 ---- --------------------------------------------------------------------------
589 ,p_mkt_75pct_salary in number)
590
591 return number;
593 -- |---------------------------< get_mkt_max_salary >---------------------------|
594 -- --------------------------------------------------------------------------
595 -- Description
596 -- This function returns the mkt_max_salary
597 --
598 function get_mkt_max_salary(p_person_id in number
599 ,p_assignment_id in number
600 ,p_legislation_code in varchar2
601 ,p_group_pl_id in number
602 ,p_lf_evt_ocrd_dt in date
603 ,p_effective_date in date
604 ,p_mkt_max_salary in number)
605
606 return number;
607 ---- --------------------------------------------------------------------------
608 -- |---------------------------< get_mkt_emp_pct_in_range >---------------------------|
609 -- --------------------------------------------------------------------------
610 -- Description
611 -- This function returns the mkt_emp_pct_in_range
612 --
613 function get_mkt_emp_pct_in_range(p_person_id in number
614 ,p_assignment_id in number
615 ,p_legislation_code in varchar2
616 ,p_group_pl_id in number
617 ,p_lf_evt_ocrd_dt in date
618 ,p_effective_date in date
619 ,p_mkt_emp_pct_in_range in number)
620
621 return number;
622 ---- --------------------------------------------------------------------------
623 -- |---------------------------< get_mkt_emp_comparatio >---------------------------|
624 -- --------------------------------------------------------------------------
625 -- Description
626 -- This function returns the mkt_emp_comparatio
627 --
628 function get_mkt_emp_comparatio(p_person_id in number
629 ,p_assignment_id in number
630 ,p_legislation_code in varchar2
631 ,p_group_pl_id in number
632 ,p_lf_evt_ocrd_dt in date
633 ,p_effective_date in date
634 ,p_mkt_emp_comparatio in number)
635
636 return number;
637 ---- --------------------------------------------------------------------------
638 -- |---------------------------< get_mkt_survey_id >---------------------------|
639 -- --------------------------------------------------------------------------
640 -- Description
641 -- This function returns the mkt_survey_id
642 --
643 function get_mkt_survey_id(p_person_id in number
644 ,p_assignment_id in number
645 ,p_legislation_code in varchar2
646 ,p_group_pl_id in number
647 ,p_lf_evt_ocrd_dt in date
648 ,p_effective_date in date
649 ,p_mkt_survey_id in number)
650
651 return number;
652 ---- --------------------------------------------------------------------------
653 -- |---------------------------< get_grd_comparatio >---------------------------|
654 -- --------------------------------------------------------------------------
655 -- Description
656 -- This function returns the grd_comparatio
657 --
658 function get_grd_comparatio(p_person_id in number
659 ,p_assignment_id in number
660 ,p_legislation_code in varchar2
661 ,p_group_pl_id in number
662 ,p_lf_evt_ocrd_dt in date
663 ,p_effective_date in date
664 ,p_grd_comparatio in number)
665
666 return number;
667 ----
668 --------------------------------------------------------------------------
669 -- |---------------------------< get_normal_hours >---------------------------|
670 -- --------------------------------------------------------------------------
671 -- Description
672 -- This function returns the normal_hours
673 --
674 function get_normal_hours(p_person_id in number
675 ,p_assignment_id in number
679 ,p_effective_date in date
676 ,p_legislation_code in varchar2
677 ,p_group_pl_id in number
678 ,p_lf_evt_ocrd_dt in date
680 ,p_normal_hours in number)
681
682 return number;
683 ----
684
685 --------------------------------------------------------------------------
686 -- |---------------------------< get_performance_rating_date >---------------------|
687 -- --------------------------------------------------------------------------
688 -- Description
689 -- This function returns the performance_rating_date
690 --
691 function get_performance_rating_date(p_person_id in number
692 ,p_assignment_id in number
693 ,p_legislation_code in varchar2
694 ,p_group_pl_id in number
695 ,p_lf_evt_ocrd_dt in date
696 ,p_effective_date in date
697 ,p_performance_rating_date in date)
698
699 return date;
700 ----
701
702 --------------------------------------------------------------------------
703 -- |---------------------------< get_start_date>---------------------|
704 -- --------------------------------------------------------------------------
705 -- Description
706 -- This function returns the start_date
707 --
708 function get_start_date(p_person_id in number
709 ,p_assignment_id in number
710 ,p_legislation_code in varchar2
711 ,p_group_pl_id in number
712 ,p_lf_evt_ocrd_dt in date
713 ,p_effective_date in date
714 ,p_start_date in date)
715
716 return date;
717 ----
718
719 --------------------------------------------------------------------------
720 -- |---------------------------< get_original_start_date >---------------------|
721 -- --------------------------------------------------------------------------
722 -- Description
723 -- This function returns the original_start_date
724 --
725 function get_original_start_date(p_person_id in number
726 ,p_assignment_id in number
727 ,p_legislation_code in varchar2
728 ,p_group_pl_id in number
729 ,p_lf_evt_ocrd_dt in date
730 ,p_effective_date in date
731 ,p_original_start_date in date)
732
733 return date;
734 ----
735
736 --------------------------------------------------------------------------
737 -- |---------------------------< get_adjusted_svc_date >---------------------|
738 -- --------------------------------------------------------------------------
739 -- Description
740 -- This function returns the adjusted_svc_date
741 --
742 function get_adjusted_svc_date(p_person_id in number
743 ,p_assignment_id in number
744 ,p_legislation_code in varchar2
745 ,p_group_pl_id in number
749
746 ,p_lf_evt_ocrd_dt in date
747 ,p_effective_date in date
748 ,p_adjusted_svc_date in date)
750 return date;
751 ----
752
753 --------------------------------------------------------------------------
754 -- |---------------------------< get_prev_sal_chg_date >---------------------|
758 --
755 -- --------------------------------------------------------------------------
756 -- Description
757 -- This function returns the prev_sal_chg_date
759 function get_prev_sal_chg_date(p_person_id in number
760 ,p_assignment_id in number
761 ,p_legislation_code in varchar2
762 ,p_group_pl_id in number
763 ,p_lf_evt_ocrd_dt in date
764 ,p_effective_date in date
765 ,p_prev_sal_chg_date in date)
766
767 return date;
768 ----
769
770 --------------------------------------------------------------------------
771 -- |---------------------------< get_feedback_date >---------------------|
772 -- --------------------------------------------------------------------------
773 -- Description
774 -- This function returns the feedback_date
775 --
776 function get_feedback_date(p_person_id in number
777 ,p_assignment_id in number
778 ,p_legislation_code in varchar2
779 ,p_group_pl_id in number
780 ,p_lf_evt_ocrd_dt in date
781 ,p_effective_date in date
782 ,p_feedback_date in date)
783
784 return date;
785 ----
786
787 --------------------------------------------------------------------------
788 -- |---------------------------< get_base_salary_change_date >---------------------|
789 -- --------------------------------------------------------------------------
790 -- Description
791 -- This function returns the base_salary_change_date
792 --
793 function get_base_salary_change_date(p_person_id in number
794 ,p_assignment_id in number
795 ,p_legislation_code in varchar2
796 ,p_group_pl_id in number
797 ,p_lf_evt_ocrd_dt in date
798 ,p_effective_date in date
799 ,p_base_salary_change_date in date)
800
801 return date;
802 ----
803
804 -- --------------------------------------------------------------------------
805 -- |-------------------------< get_full_name >-------------------------|
806 -- --------------------------------------------------------------------------
807 -- Description
808 -- This function returns the full_name
809 --
810 function get_full_name(p_person_id in number
811 ,p_assignment_id in number
812 ,p_legislation_code in varchar2
813 ,p_group_pl_id in number
814 ,p_lf_evt_ocrd_dt in date
815 ,p_effective_date in date
816 ,p_full_name in varchar2)
817 return varchar2;
818 --
819 --
820 -- --------------------------------------------------------------------------
821 -- |-------------------------< get_brief_name >-------------------------|
822 -- --------------------------------------------------------------------------
823 -- Description
824 -- This function returns the brief_name
825 --
826 function get_brief_name(p_person_id in number
827 ,p_assignment_id in number
828 ,p_legislation_code in varchar2
832 ,p_brief_name in varchar2)
829 ,p_group_pl_id in number
830 ,p_lf_evt_ocrd_dt in date
831 ,p_effective_date in date
833 return varchar2;
834 --
835 -- --------------------------------------------------------------------------
836 -- |-------------------------< get_supervisor_full_name >-------------------------|
837 -- --------------------------------------------------------------------------
838 -- Description
839 -- This function returns the supervisor_full_name
840 --
841 function get_supervisor_full_name(p_person_id in number
842 ,p_assignment_id in number
843 ,p_legislation_code in varchar2
844 ,p_group_pl_id in number
845 ,p_lf_evt_ocrd_dt in date
846 ,p_effective_date in date
847 ,p_supervisor_full_name in varchar2)
848 return varchar2;
849 --
850 -- --------------------------------------------------------------------------
851 -- |-------------------------< get_supervisor_brief_name>-------------------------|
852 -- --------------------------------------------------------------------------
853 -- Description
854 -- This function returns the supervisor_brief_name
855 --
856 function get_supervisor_brief_name(p_person_id in number
857 ,p_assignment_id in number
858 ,p_legislation_code in varchar2
859 ,p_group_pl_id in number
860 ,p_lf_evt_ocrd_dt in date
861 ,p_effective_date in date
862 ,p_supervisor_brief_name in varchar2)
863 return varchar2;
864 --
865 -- --------------------------------------------------------------------------
866 -- |-------------------------< get_supervisor_custom_name >-------------------------|
867 -- --------------------------------------------------------------------------
868 -- Description
869 -- This function returns the supervisor_custom_name
870 --
871 function get_supervisor_custom_name(p_person_id in number
872 ,p_assignment_id in number
873 ,p_legislation_code in varchar2
877 ,p_supervisor_custom_name in varchar2)
874 ,p_group_pl_id in number
875 ,p_lf_evt_ocrd_dt in date
876 ,p_effective_date in date
878 return varchar2;
879 --
880 -- --------------------------------------------------------------------------
881 -- |-------------------------< get_payroll_name >-------------------------|
882 -- --------------------------------------------------------------------------
883 -- Description
884 -- This function returns the payroll_name
885 --
886 function get_payroll_name(p_person_id in number
887 ,p_assignment_id in number
888 ,p_legislation_code in varchar2
889 ,p_group_pl_id in number
890 ,p_lf_evt_ocrd_dt in date
891 ,p_effective_date in date
892 ,p_payroll_name in varchar2)
893 return varchar2;
894 --
898 -- Description
895 -- --------------------------------------------------------------------------
896 -- |-------------------------< get_performance_rating >-------------------------|
897 -- --------------------------------------------------------------------------
899 -- This function returns the performance_rating
900 --
901 function get_performance_rating(p_person_id in number
902 ,p_assignment_id in number
903 ,p_legislation_code in varchar2
904 ,p_group_pl_id in number
905 ,p_lf_evt_ocrd_dt in date
906 ,p_effective_date in date
907 ,p_performance_rating in varchar2)
908 return varchar2;
909 --
910 -- --------------------------------------------------------------------------
914 -- This function returns the performance_rating_type
911 -- |-------------------------< get_performance_rating_type >-------------------------|
912 -- --------------------------------------------------------------------------
913 -- Description
915 --
916 function get_performance_rating_type(p_person_id in number
917 ,p_assignment_id in number
918 ,p_legislation_code in varchar2
919 ,p_group_pl_id in number
920 ,p_lf_evt_ocrd_dt in date
921 ,p_effective_date in date
922 ,p_performance_rating_type in varchar2)
923 return varchar2;
924 --
925 -- --------------------------------------------------------------------------
926 -- |-------------------------< get_frequency >-------------------------|
927 -- --------------------------------------------------------------------------
928 -- Description
929 -- This function returns the frequency
930 --
931 function get_frequency(p_person_id in number
932 ,p_assignment_id in number
933 ,p_legislation_code in varchar2
934 ,p_group_pl_id in number
935 ,p_lf_evt_ocrd_dt in date
936 ,p_effective_date in date
937 ,p_frequency in varchar2)
938 return varchar2;
939 --
940 -- --------------------------------------------------------------------------
941 -- |-------------------------< get_grd_quartile >-------------------------|
942 -- --------------------------------------------------------------------------
943 -- Description
944 -- This function returns the grd_quartile
945 --
946 function get_grd_quartile(p_person_id in number
947 ,p_assignment_id in number
948 ,p_legislation_code in varchar2
949 ,p_group_pl_id in number
950 ,p_lf_evt_ocrd_dt in date
951 ,p_effective_date in date
952 ,p_grd_quartile in varchar2)
953 return varchar2;
954 --
955 -- --------------------------------------------------------------------------
956 -- |-------------------------< get_emp_category >-------------------------|
957 -- --------------------------------------------------------------------------
958 -- Description
959 -- This function returns the emp_category
960 --
961 function get_emp_category(p_person_id in number
962 ,p_assignment_id in number
963 ,p_legislation_code in varchar2
964 ,p_group_pl_id in number
965 ,p_lf_evt_ocrd_dt in date
966 ,p_effective_date in date
967 ,p_emp_category in varchar2)
968 return varchar2;
969 --
970 -- --------------------------------------------------------------------------
971 -- |-------------------------< get_change_reason >-------------------------|
972 -- --------------------------------------------------------------------------
973 -- Description
974 -- This function returns the change_reason
975 --
976 function get_change_reason(p_person_id in number
977 ,p_assignment_id in number
981 ,p_effective_date in date
978 ,p_legislation_code in varchar2
979 ,p_group_pl_id in number
980 ,p_lf_evt_ocrd_dt in date
982 ,p_change_reason in varchar2)
983 return varchar2;
984 --
985 -- --------------------------------------------------------------------------
986 -- |-------------------------< get_email_address >-------------------------|
987 -- --------------------------------------------------------------------------
988 -- Description
989 -- This function returns the email_address
990 --
991 function get_email_address(p_person_id in number
992 ,p_assignment_id in number
993 ,p_legislation_code in varchar2
994 ,p_group_pl_id in number
995 ,p_lf_evt_ocrd_dt in date
996 ,p_effective_date in date
1000 -- --------------------------------------------------------------------------
997 ,p_email_address in varchar2)
998 return varchar2;
999 --
1001 -- |-------------------------< get_base_salary_frequency >-------------------------|
1002 -- --------------------------------------------------------------------------
1003 -- Description
1004 -- This function returns the base_salary_frequency
1005 --
1006 function get_base_salary_frequency(p_person_id in number
1007 ,p_assignment_id in number
1008 ,p_legislation_code in varchar2
1009 ,p_group_pl_id in number
1010 ,p_lf_evt_ocrd_dt in date
1011 ,p_effective_date in date
1012 ,p_base_salary_frequency in varchar2)
1013 return varchar2;
1014 --
1015 -- --------------------------------------------------------------------------
1016 -- |-------------------------< get_post_process_stat_cd >-------------------------|
1017 -- --------------------------------------------------------------------------
1018 -- Description
1019 -- This function returns the post_process_stat_cd
1023 ,p_legislation_code in varchar2
1020 --
1021 function get_post_process_stat_cd(p_person_id in number
1022 ,p_assignment_id in number
1024 ,p_group_pl_id in number
1025 ,p_lf_evt_ocrd_dt in date
1026 ,p_effective_date in date
1027 ,p_post_process_stat_cd in varchar2)
1028 return varchar2;
1029 --
1030 -- --------------------------------------------------------------------------
1031 -- |-------------------------< get_feedback_rating >-------------------------|
1032 -- --------------------------------------------------------------------------
1033 -- Description
1034 -- This function returns the feedback_rating
1035 --
1036 function get_feedback_rating(p_person_id in number
1037 ,p_assignment_id in number
1038 ,p_legislation_code in varchar2
1039 ,p_group_pl_id in number
1043 return varchar2;
1040 ,p_lf_evt_ocrd_dt in date
1041 ,p_effective_date in date
1042 ,p_feedback_rating in varchar2)
1044 --
1045 -- --------------------------------------------------------------------------
1046 -- |-------------------------< get_feedback_comments >-------------------------|
1047 -- --------------------------------------------------------------------------
1048 -- Description
1049 -- This function returns the feedback_comments
1050 --
1051 function get_feedback_comments(p_person_id in number
1052 ,p_assignment_id in number
1053 ,p_legislation_code in varchar2
1054 ,p_group_pl_id in number
1055 ,p_lf_evt_ocrd_dt in date
1056 ,p_effective_date in date
1057 ,p_feedback_comments in varchar2)
1058 return varchar2;
1059 --
1060 -- --------------------------------------------------------------------------
1061 -- |-------------------------< get_people_group_name >-------------------------|
1062 -- --------------------------------------------------------------------------
1063 -- Description
1064 -- This function returns the people_group_name
1065 --
1066 function get_people_group_name(p_person_id in number
1067 ,p_assignment_id in number
1068 ,p_legislation_code in varchar2
1069 ,p_group_pl_id in number
1070 ,p_lf_evt_ocrd_dt in date
1071 ,p_effective_date in date
1075 -- --------------------------------------------------------------------------
1072 ,p_people_group_name in varchar2)
1073 return varchar2;
1074 --
1076 -- |-------------------------< get_people_group_segment1>-------------------------|
1077 -- --------------------------------------------------------------------------
1078 -- Description
1079 -- This function returns the people_group_segment1
1080 --
1081 function get_people_group_segment1(p_person_id in number
1082 ,p_assignment_id in number
1083 ,p_legislation_code in varchar2
1084 ,p_group_pl_id in number
1085 ,p_lf_evt_ocrd_dt in date
1086 ,p_effective_date in date
1087 ,p_people_group_segment1 in varchar2)
1088 return varchar2;
1089 --
1090 -- --------------------------------------------------------------------------
1091 -- |-------------------------< get_people_group_segment2 >-------------------------|
1092 -- --------------------------------------------------------------------------
1093 -- Description
1094 -- This function returns the people_group_segment2
1095 --
1096 function get_people_group_segment2(p_person_id in number
1097 ,p_assignment_id in number
1098 ,p_legislation_code in varchar2
1099 ,p_group_pl_id in number
1100 ,p_lf_evt_ocrd_dt in date
1101 ,p_effective_date in date
1102 ,p_people_group_segment2 in varchar2)
1103 return varchar2;
1104 --
1105 -- --------------------------------------------------------------------------
1106 -- |-------------------------< get_people_group_segment3 >-------------------------|
1107 -- --------------------------------------------------------------------------
1108 -- Description
1109 -- This function returns the people_group_segment3
1110 --
1111 function get_people_group_segment3(p_person_id in number
1112 ,p_assignment_id in number
1113 ,p_legislation_code in varchar2
1114 ,p_group_pl_id in number
1115 ,p_lf_evt_ocrd_dt in date
1116 ,p_effective_date in date
1117 ,p_people_group_segment3 in varchar2)
1118 return varchar2;
1119 --
1120 -- --------------------------------------------------------------------------
1121 -- |-------------------------< get_people_group_segment4 >-------------------------|
1125 --
1122 -- --------------------------------------------------------------------------
1123 -- Description
1124 -- This function returns the people_group_segment4
1126 function get_people_group_segment4(p_person_id in number
1127 ,p_assignment_id in number
1128 ,p_legislation_code in varchar2
1129 ,p_group_pl_id in number
1130 ,p_lf_evt_ocrd_dt in date
1131 ,p_effective_date in date
1132 ,p_people_group_segment4 in varchar2)
1133 return varchar2;
1134 --
1135 -- --------------------------------------------------------------------------
1136 -- |-------------------------< get_people_group_segment5 >-------------------------|
1137 -- --------------------------------------------------------------------------
1138 -- Description
1139 -- This function returns the people_group_segment5
1140 --
1141 function get_people_group_segment5(p_person_id in number
1142 ,p_assignment_id in number
1143 ,p_legislation_code in varchar2
1144 ,p_group_pl_id in number
1145 ,p_lf_evt_ocrd_dt in date
1146 ,p_effective_date in date
1147 ,p_people_group_segment5 in varchar2)
1148 return varchar2;
1149 --
1150 -- --------------------------------------------------------------------------
1151 -- |-------------------------< get_people_group_segment6>-------------------------|
1152 -- --------------------------------------------------------------------------
1153 -- Description
1154 -- This function returns the people_group_segment6
1155 --
1156 function get_people_group_segment6(p_person_id in number
1157 ,p_assignment_id in number
1158 ,p_legislation_code in varchar2
1159 ,p_group_pl_id in number
1160 ,p_lf_evt_ocrd_dt in date
1161 ,p_effective_date in date
1162 ,p_people_group_segment6 in varchar2)
1163 return varchar2;
1164 --
1165 -- --------------------------------------------------------------------------
1166 -- |-------------------------< get_people_group_segment7 >-------------------------|
1167 -- --------------------------------------------------------------------------
1168 -- Description
1169 -- This function returns the people_group_segment7
1170 --
1171 function get_people_group_segment7(p_person_id in number
1172 ,p_assignment_id in number
1173 ,p_legislation_code in varchar2
1174 ,p_group_pl_id in number
1175 ,p_lf_evt_ocrd_dt in date
1176 ,p_effective_date in date
1177 ,p_people_group_segment7 in varchar2)
1178 return varchar2;
1179 --
1180 -- --------------------------------------------------------------------------
1181 -- |-------------------------< get_people_group_segment8 >-------------------------|
1182 -- --------------------------------------------------------------------------
1183 -- Description
1184 -- This function returns the people_group_segment8
1185 --
1186 function get_people_group_segment8(p_person_id in number
1187 ,p_assignment_id in number
1188 ,p_legislation_code in varchar2
1189 ,p_group_pl_id in number
1190 ,p_lf_evt_ocrd_dt in date
1191 ,p_effective_date in date
1192 ,p_people_group_segment8 in varchar2)
1193 return varchar2;
1194 --
1195 -- --------------------------------------------------------------------------
1196 -- |-------------------------< get_people_group_segment9 >-------------------------|
1197 -- --------------------------------------------------------------------------
1198 -- Description
1199 -- This function returns the people_group_segment9
1200 --
1201 function get_people_group_segment9(p_person_id in number
1202 ,p_assignment_id in number
1203 ,p_legislation_code in varchar2
1204 ,p_group_pl_id in number
1205 ,p_lf_evt_ocrd_dt in date
1206 ,p_effective_date in date
1210 -- --------------------------------------------------------------------------
1207 ,p_people_group_segment9 in varchar2)
1208 return varchar2;
1209 --
1211 -- |-------------------------< get_people_group_segment10 >-------------------------|
1212 -- --------------------------------------------------------------------------
1213 -- Description
1214 -- This function returns the people_group_segment10
1215 --
1216 function get_people_group_segment10(p_person_id in number
1217 ,p_assignment_id in number
1218 ,p_legislation_code in varchar2
1219 ,p_group_pl_id in number
1220 ,p_lf_evt_ocrd_dt in date
1221 ,p_effective_date in date
1222 ,p_people_group_segment10 in varchar2)
1223 return varchar2;
1224 --
1225 -- --------------------------------------------------------------------------
1226 -- |-------------------------< get_people_group_segment11 >-------------------------|
1227 -- --------------------------------------------------------------------------
1228 -- Description
1229 -- This function returns the people_group_segment11
1230 --
1231 function get_people_group_segment11(p_person_id in number
1232 ,p_assignment_id in number
1233 ,p_legislation_code in varchar2
1234 ,p_group_pl_id in number
1235 ,p_lf_evt_ocrd_dt in date
1236 ,p_effective_date in date
1237 ,p_people_group_segment11 in varchar2)
1238 return varchar2;
1239 --
1240
1241
1242
1243 -- --------------------------------------------------------------------------
1244 -- |-------------------------< get_ass_attribute_category >-------------------------|
1245 -- --------------------------------------------------------------------------
1246 -- Description
1247 -- This function returns the ass_attribute_category
1248 --
1249 function get_ass_attribute_category(p_person_id in number
1250 ,p_assignment_id in number
1251 ,p_legislation_code in varchar2
1252 ,p_group_pl_id in number
1253 ,p_lf_evt_ocrd_dt in date
1254 ,p_effective_date in date
1255 ,p_ass_attribute_category in varchar2)
1256 return varchar2;
1257 --
1258 -- --------------------------------------------------------------------------
1259 -- |-------------------------< get_ass_attribute1 >-------------------------|
1260 -- --------------------------------------------------------------------------
1261 -- Description
1262 -- This function returns the ass_attribute1
1263 --
1264 function get_ass_attribute1(p_person_id in number
1265 ,p_assignment_id in number
1266 ,p_legislation_code in varchar2
1267 ,p_group_pl_id in number
1268 ,p_lf_evt_ocrd_dt in date
1269 ,p_effective_date in date
1270 ,p_ass_attribute1 in varchar2)
1271 return varchar2;
1272 --
1273 -- --------------------------------------------------------------------------
1274 -- |-------------------------< get_ass_attribute2 >-------------------------|
1275 -- --------------------------------------------------------------------------
1276 -- Description
1277 -- This function returns the ass_attribute2
1278 --
1279 function get_ass_attribute2(p_person_id in number
1280 ,p_assignment_id in number
1281 ,p_legislation_code in varchar2
1282 ,p_group_pl_id in number
1283 ,p_lf_evt_ocrd_dt in date
1284 ,p_effective_date in date
1285 ,p_ass_attribute2 in varchar2)
1286 return varchar2;
1287 --
1288 -- --------------------------------------------------------------------------
1289 -- |-------------------------< get_ass_attribute3 >-------------------------|
1290 -- --------------------------------------------------------------------------
1291 -- Description
1292 -- This function returns the ass_attribute3
1293 --
1294 function get_ass_attribute3(p_person_id in number
1295 ,p_assignment_id in number
1296 ,p_legislation_code in varchar2
1297 ,p_group_pl_id in number
1298 ,p_lf_evt_ocrd_dt in date
1299 ,p_effective_date in date
1300 ,p_ass_attribute3 in varchar2)
1301 return varchar2;
1302 --
1303 -- --------------------------------------------------------------------------
1304 -- |-------------------------< get_ass_attribute4 >-------------------------|
1305 -- --------------------------------------------------------------------------
1306 -- Description
1307 -- This function returns the ass_attribute4
1308 --
1309 function get_ass_attribute4(p_person_id in number
1310 ,p_assignment_id in number
1311 ,p_legislation_code in varchar2
1312 ,p_group_pl_id in number
1313 ,p_lf_evt_ocrd_dt in date
1314 ,p_effective_date in date
1315 ,p_ass_attribute4 in varchar2)
1316 return varchar2;
1317 --
1321 -- Description
1318 -- --------------------------------------------------------------------------
1319 -- |-------------------------< get_ass_attribute5 >-------------------------|
1320 -- --------------------------------------------------------------------------
1322 -- This function returns the ass_attribute5
1323 --
1324 function get_ass_attribute5(p_person_id in number
1325 ,p_assignment_id in number
1326 ,p_legislation_code in varchar2
1327 ,p_group_pl_id in number
1328 ,p_lf_evt_ocrd_dt in date
1329 ,p_effective_date in date
1330 ,p_ass_attribute5 in varchar2)
1331 return varchar2;
1332 --
1333 -- --------------------------------------------------------------------------
1334 -- |-------------------------< get_ass_attribute6 >-------------------------|
1335 -- --------------------------------------------------------------------------
1336 -- Description
1337 -- This function returns the ass_attribute6
1338 --
1339 function get_ass_attribute6(p_person_id in number
1340 ,p_assignment_id in number
1341 ,p_legislation_code in varchar2
1342 ,p_group_pl_id in number
1343 ,p_lf_evt_ocrd_dt in date
1344 ,p_effective_date in date
1345 ,p_ass_attribute6 in varchar2)
1346 return varchar2;
1347 --
1348 -- --------------------------------------------------------------------------
1349 -- |-------------------------< get_ass_attribute7 >-------------------------|
1350 -- --------------------------------------------------------------------------
1351 -- Description
1352 -- This function returns the ass_attribute7
1353 --
1354 function get_ass_attribute7(p_person_id in number
1355 ,p_assignment_id in number
1356 ,p_legislation_code in varchar2
1357 ,p_group_pl_id in number
1358 ,p_lf_evt_ocrd_dt in date
1359 ,p_effective_date in date
1360 ,p_ass_attribute7 in varchar2)
1361 return varchar2;
1362 --
1363 -- --------------------------------------------------------------------------
1364 -- |-------------------------< get_ass_attribute8 >-------------------------|
1365 -- --------------------------------------------------------------------------
1366 -- Description
1367 -- This function returns the ass_attribute8
1368 --
1369 function get_ass_attribute8(p_person_id in number
1370 ,p_assignment_id in number
1371 ,p_legislation_code in varchar2
1372 ,p_group_pl_id in number
1373 ,p_lf_evt_ocrd_dt in date
1374 ,p_effective_date in date
1375 ,p_ass_attribute8 in varchar2)
1376 return varchar2;
1377 --
1378 -- --------------------------------------------------------------------------
1379 -- |-------------------------< get_ass_attribute9 >-------------------------|
1380 -- --------------------------------------------------------------------------
1381 -- Description
1382 -- This function returns the ass_attribute9
1383 --
1384 function get_ass_attribute9(p_person_id in number
1388 ,p_lf_evt_ocrd_dt in date
1385 ,p_assignment_id in number
1386 ,p_legislation_code in varchar2
1387 ,p_group_pl_id in number
1389 ,p_effective_date in date
1390 ,p_ass_attribute9 in varchar2)
1391 return varchar2;
1392 --
1393 -- --------------------------------------------------------------------------
1394 -- |-------------------------< get_ass_attribute10 >-------------------------|
1395 -- --------------------------------------------------------------------------
1396 -- Description
1397 -- This function returns the ass_attribute10
1398 --
1399 function get_ass_attribute10(p_person_id in number
1400 ,p_assignment_id in number
1401 ,p_legislation_code in varchar2
1402 ,p_group_pl_id in number
1403 ,p_lf_evt_ocrd_dt in date
1404 ,p_effective_date in date
1405 ,p_ass_attribute10 in varchar2)
1406 return varchar2;
1407 --
1408 -- --------------------------------------------------------------------------
1409 -- |-------------------------< get_ass_attribute11 >-------------------------|
1410 -- --------------------------------------------------------------------------
1411 -- Description
1412 -- This function returns the ass_attribute11
1413 --
1414 function get_ass_attribute11(p_person_id in number
1415 ,p_assignment_id in number
1416 ,p_legislation_code in varchar2
1417 ,p_group_pl_id in number
1418 ,p_lf_evt_ocrd_dt in date
1419 ,p_effective_date in date
1420 ,p_ass_attribute11 in varchar2)
1421 return varchar2;
1422 --
1423
1424 -- --------------------------------------------------------------------------
1425 -- |-------------------------< get_ass_attribute12 >-------------------------|
1426 -- --------------------------------------------------------------------------
1427 -- Description
1428 -- This function returns the ass_attribute12
1429 --
1430 function get_ass_attribute12(p_person_id in number
1431 ,p_assignment_id in number
1435 ,p_effective_date in date
1432 ,p_legislation_code in varchar2
1433 ,p_group_pl_id in number
1434 ,p_lf_evt_ocrd_dt in date
1436 ,p_ass_attribute12 in varchar2)
1437 return varchar2;
1438 --
1439 -- --------------------------------------------------------------------------
1440 -- |-------------------------< get_ass_attribute13 >-------------------------|
1441 -- --------------------------------------------------------------------------
1442 -- Description
1443 -- This function returns the ass_attribute13
1444 --
1445 function get_ass_attribute13(p_person_id in number
1446 ,p_assignment_id in number
1447 ,p_legislation_code in varchar2
1448 ,p_group_pl_id in number
1449 ,p_lf_evt_ocrd_dt in date
1450 ,p_effective_date in date
1451 ,p_ass_attribute13 in varchar2)
1452 return varchar2;
1453 --
1454 -- --------------------------------------------------------------------------
1455 -- |-------------------------< get_ass_attribute14 >-------------------------|
1456 -- --------------------------------------------------------------------------
1457 -- Description
1458 -- This function returns the ass_attribute14
1459 --
1460 function get_ass_attribute14(p_person_id in number
1461 ,p_assignment_id in number
1462 ,p_legislation_code in varchar2
1463 ,p_group_pl_id in number
1464 ,p_lf_evt_ocrd_dt in date
1465 ,p_effective_date in date
1466 ,p_ass_attribute14 in varchar2)
1467 return varchar2;
1468 --
1469 -- --------------------------------------------------------------------------
1470 -- |-------------------------< get_ass_attribute15 >-------------------------|
1471 -- --------------------------------------------------------------------------
1472 -- Description
1473 -- This function returns the ass_attribute15
1474 --
1475 function get_ass_attribute15(p_person_id in number
1476 ,p_assignment_id in number
1477 ,p_legislation_code in varchar2
1478 ,p_group_pl_id in number
1479 ,p_lf_evt_ocrd_dt in date
1480 ,p_effective_date in date
1481 ,p_ass_attribute15 in varchar2)
1482 return varchar2;
1483 --
1484 -- --------------------------------------------------------------------------
1485 -- |-------------------------< get_ass_attribute16 >-------------------------|
1486 -- --------------------------------------------------------------------------
1487 -- Description
1488 -- This function returns the ass_attribute16
1489 --
1490 function get_ass_attribute16(p_person_id in number
1491 ,p_assignment_id in number
1492 ,p_legislation_code in varchar2
1493 ,p_group_pl_id in number
1494 ,p_lf_evt_ocrd_dt in date
1495 ,p_effective_date in date
1496 ,p_ass_attribute16 in varchar2)
1497 return varchar2;
1498 --
1499 -- --------------------------------------------------------------------------
1500 -- |-------------------------< get_ass_attribute17 >-------------------------|
1501 -- --------------------------------------------------------------------------
1502 -- Description
1503 -- This function returns the ass_attribute17
1504 --
1505 function get_ass_attribute17(p_person_id in number
1506 ,p_assignment_id in number
1507 ,p_legislation_code in varchar2
1508 ,p_group_pl_id in number
1509 ,p_lf_evt_ocrd_dt in date
1510 ,p_effective_date in date
1511 ,p_ass_attribute17 in varchar2)
1512 return varchar2;
1513 --
1514 -- --------------------------------------------------------------------------
1515 -- |-------------------------< get_ass_attribute18 >-------------------------|
1516 -- --------------------------------------------------------------------------
1517 -- Description
1518 -- This function returns the ass_attribute18
1519 --
1520 function get_ass_attribute18(p_person_id in number
1524 ,p_lf_evt_ocrd_dt in date
1521 ,p_assignment_id in number
1522 ,p_legislation_code in varchar2
1523 ,p_group_pl_id in number
1525 ,p_effective_date in date
1526 ,p_ass_attribute18 in varchar2)
1527 return varchar2;
1528 --
1529 -- --------------------------------------------------------------------------
1530 -- |-------------------------< get_ass_attribute19 >-------------------------|
1531 -- --------------------------------------------------------------------------
1532 -- Description
1533 -- This function returns the ass_attribute19
1534 --
1535 function get_ass_attribute19(p_person_id in number
1536 ,p_assignment_id in number
1537 ,p_legislation_code in varchar2
1541 ,p_ass_attribute19 in varchar2)
1538 ,p_group_pl_id in number
1539 ,p_lf_evt_ocrd_dt in date
1540 ,p_effective_date in date
1542 return varchar2;
1543 --
1544
1545 -- --------------------------------------------------------------------------
1549 -- This function returns the ass_attribute20
1546 -- |-------------------------< get_ass_attribute20 >-------------------------|
1547 -- --------------------------------------------------------------------------
1548 -- Description
1550 --
1551 function get_ass_attribute20(p_person_id in number
1552 ,p_assignment_id in number
1553 ,p_legislation_code in varchar2
1554 ,p_group_pl_id in number
1555 ,p_lf_evt_ocrd_dt in date
1556 ,p_effective_date in date
1557 ,p_ass_attribute20 in varchar2)
1558 return varchar2;
1559 --
1560
1564 -- Description
1561 -- --------------------------------------------------------------------------
1562 -- |-------------------------< get_ass_attribute21 >-------------------------|
1563 -- --------------------------------------------------------------------------
1565 -- This function returns the ass_attribute21
1566 --
1567 function get_ass_attribute21(p_person_id in number
1568 ,p_assignment_id in number
1569 ,p_legislation_code in varchar2
1570 ,p_group_pl_id in number
1571 ,p_lf_evt_ocrd_dt in date
1572 ,p_effective_date in date
1573 ,p_ass_attribute21 in varchar2)
1574 return varchar2;
1575 --
1576
1577 -- --------------------------------------------------------------------------
1578 -- |-------------------------< get_ass_attribute22 >-------------------------|
1579 -- --------------------------------------------------------------------------
1580 -- Description
1581 -- This function returns the ass_attribute22
1582 --
1583 function get_ass_attribute22(p_person_id in number
1584 ,p_assignment_id in number
1585 ,p_legislation_code in varchar2
1586 ,p_group_pl_id in number
1587 ,p_lf_evt_ocrd_dt in date
1588 ,p_effective_date in date
1589 ,p_ass_attribute22 in varchar2)
1590 return varchar2;
1591 --
1592 -- --------------------------------------------------------------------------
1593 -- |-------------------------< get_ass_attribute23 >-------------------------|
1594 -- --------------------------------------------------------------------------
1595 -- Description
1599 ,p_assignment_id in number
1596 -- This function returns the ass_attribute23
1597 --
1598 function get_ass_attribute23(p_person_id in number
1600 ,p_legislation_code in varchar2
1601 ,p_group_pl_id in number
1602 ,p_lf_evt_ocrd_dt in date
1603 ,p_effective_date in date
1604 ,p_ass_attribute23 in varchar2)
1605 return varchar2;
1606 --
1607 -- --------------------------------------------------------------------------
1608 -- |-------------------------< get_ass_attribute24 >-------------------------|
1609 -- --------------------------------------------------------------------------
1610 -- Description
1611 -- This function returns the ass_attribute24
1612 --
1613 function get_ass_attribute24(p_person_id in number
1614 ,p_assignment_id in number
1615 ,p_legislation_code in varchar2
1616 ,p_group_pl_id in number
1617 ,p_lf_evt_ocrd_dt in date
1618 ,p_effective_date in date
1619 ,p_ass_attribute24 in varchar2)
1620 return varchar2;
1624 -- --------------------------------------------------------------------------
1621 --
1622 -- --------------------------------------------------------------------------
1623 -- |-------------------------< get_ass_attribute25 >-------------------------|
1625 -- Description
1626 -- This function returns the ass_attribute25
1627 --
1628 function get_ass_attribute25(p_person_id in number
1629 ,p_assignment_id in number
1630 ,p_legislation_code in varchar2
1631 ,p_group_pl_id in number
1632 ,p_lf_evt_ocrd_dt in date
1633 ,p_effective_date in date
1634 ,p_ass_attribute25 in varchar2)
1635 return varchar2;
1636 --
1637 -- --------------------------------------------------------------------------
1638 -- |-------------------------< get_ass_attribute26 >-------------------------|
1639 -- --------------------------------------------------------------------------
1640 -- Description
1644 ,p_assignment_id in number
1641 -- This function returns the ass_attribute26
1642 --
1643 function get_ass_attribute26(p_person_id in number
1645 ,p_legislation_code in varchar2
1646 ,p_group_pl_id in number
1650 return varchar2;
1647 ,p_lf_evt_ocrd_dt in date
1648 ,p_effective_date in date
1649 ,p_ass_attribute26 in varchar2)
1651 --
1652 -- --------------------------------------------------------------------------
1653 -- |-------------------------< get_ass_attribute27 >-------------------------|
1654 -- --------------------------------------------------------------------------
1655 -- Description
1656 -- This function returns the ass_attribute27
1657 --
1658 function get_ass_attribute27(p_person_id in number
1659 ,p_assignment_id in number
1660 ,p_legislation_code in varchar2
1661 ,p_group_pl_id in number
1662 ,p_lf_evt_ocrd_dt in date
1663 ,p_effective_date in date
1664 ,p_ass_attribute27 in varchar2)
1665 return varchar2;
1666 --
1667 -- --------------------------------------------------------------------------
1668 -- |-------------------------< get_ass_attribute28 >-------------------------|
1669 -- --------------------------------------------------------------------------
1670 -- Description
1671 -- This function returns the ass_attribute28
1672 --
1673 function get_ass_attribute28(p_person_id in number
1674 ,p_assignment_id in number
1675 ,p_legislation_code in varchar2
1676 ,p_group_pl_id in number
1677 ,p_lf_evt_ocrd_dt in date
1678 ,p_effective_date in date
1679 ,p_ass_attribute28 in varchar2)
1680 return varchar2;
1681 --
1682 -- --------------------------------------------------------------------------
1683 -- |-------------------------< get_ass_attribute29 >-------------------------|
1684 -- --------------------------------------------------------------------------
1685 -- Description
1686 -- This function returns the ass_attribute29
1687 --
1688 function get_ass_attribute29(p_person_id in number
1689 ,p_assignment_id in number
1690 ,p_legislation_code in varchar2
1691 ,p_group_pl_id in number
1692 ,p_lf_evt_ocrd_dt in date
1693 ,p_effective_date in date
1694 ,p_ass_attribute29 in varchar2)
1695 return varchar2;
1696 --
1697
1698 -- --------------------------------------------------------------------------
1699 -- |-------------------------< get_ass_attribute30 >-------------------------|
1700 -- --------------------------------------------------------------------------
1701 -- Description
1702 -- This function returns the ass_attribute30
1703 --
1704 function get_ass_attribute30(p_person_id in number
1705 ,p_assignment_id in number
1706 ,p_legislation_code in varchar2
1707 ,p_group_pl_id in number
1708 ,p_lf_evt_ocrd_dt in date
1709 ,p_effective_date in date
1710 ,p_ass_attribute30 in varchar2)
1711 return varchar2;
1712 --
1713
1714 -- --------------------------------------------------------------------------
1715 -- |-------------------------< get_ws_comments >-------------------------|
1716 -- --------------------------------------------------------------------------
1717 -- Description
1718 -- This function returns the ws_comments
1719 --
1720 function get_ws_comments(p_person_id in number
1721 ,p_assignment_id in number
1722 ,p_legislation_code in varchar2
1723 ,p_group_pl_id in number
1724 ,p_lf_evt_ocrd_dt in date
1725 ,p_effective_date in date
1726 ,p_ws_comments in varchar2)
1727 return varchar2;
1728 --
1729
1730 -- --------------------------------------------------------------------------
1731 -- |-------------------------< get_cpi_attribute_category >-------------------------|
1732 -- --------------------------------------------------------------------------
1733 -- Description
1734 -- This function returns the cpi_attribute_category
1735 --
1736
1740 ,p_group_pl_id in number
1737 function get_cpi_attribute_category(p_person_id in number
1738 ,p_assignment_id in number
1739 ,p_legislation_code in varchar2
1741 ,p_lf_evt_ocrd_dt in date
1742 ,p_effective_date in date
1743 ,p_cpi_attribute_category in varchar2)
1744 return varchar2;
1745 --
1746 -- --------------------------------------------------------------------------
1747 -- |-------------------------< get_cpi_attribute1 >-------------------------|
1748 -- --------------------------------------------------------------------------
1749 -- Description
1750 -- This function returns the cpi_attribute1
1751 --
1752 function get_cpi_attribute1(p_person_id in number
1753 ,p_assignment_id in number
1754 ,p_legislation_code in varchar2
1755 ,p_group_pl_id in number
1756 ,p_lf_evt_ocrd_dt in date
1757 ,p_effective_date in date
1758 ,p_cpi_attribute1 in varchar2)
1759 return varchar2;
1760 --
1761 -- --------------------------------------------------------------------------
1762 -- |-------------------------< get_cpi_attribute2 >-------------------------|
1763 -- --------------------------------------------------------------------------
1764 -- Description
1765 -- This function returns the cpi_attribute2
1766 --
1767 function get_cpi_attribute2(p_person_id in number
1768 ,p_assignment_id in number
1769 ,p_legislation_code in varchar2
1770 ,p_group_pl_id in number
1771 ,p_lf_evt_ocrd_dt in date
1772 ,p_effective_date in date
1773 ,p_cpi_attribute2 in varchar2)
1774 return varchar2;
1775 --
1776 -- --------------------------------------------------------------------------
1777 -- |-------------------------< get_cpi_attribute3 >-------------------------|
1778 -- --------------------------------------------------------------------------
1779 -- Description
1780 -- This function returns the cpi_attribute3
1781 --
1782 function get_cpi_attribute3(p_person_id in number
1783 ,p_assignment_id in number
1784 ,p_legislation_code in varchar2
1785 ,p_group_pl_id in number
1786 ,p_lf_evt_ocrd_dt in date
1787 ,p_effective_date in date
1788 ,p_cpi_attribute3 in varchar2)
1789 return varchar2;
1790 --
1791 -- --------------------------------------------------------------------------
1792 -- |-------------------------< get_cpi_attribute4 >-------------------------|
1793 -- --------------------------------------------------------------------------
1794 -- Description
1795 -- This function returns the cpi_attribute4
1796 --
1800 ,p_group_pl_id in number
1797 function get_cpi_attribute4(p_person_id in number
1798 ,p_assignment_id in number
1799 ,p_legislation_code in varchar2
1801 ,p_lf_evt_ocrd_dt in date
1802 ,p_effective_date in date
1803 ,p_cpi_attribute4 in varchar2)
1804 return varchar2;
1805 --
1806 -- --------------------------------------------------------------------------
1807 -- |-------------------------< get_cpi_attribute5 >-------------------------|
1808 -- --------------------------------------------------------------------------
1809 -- Description
1810 -- This function returns the cpi_attribute5
1811 --
1812 function get_cpi_attribute5(p_person_id in number
1813 ,p_assignment_id in number
1814 ,p_legislation_code in varchar2
1815 ,p_group_pl_id in number
1816 ,p_lf_evt_ocrd_dt in date
1817 ,p_effective_date in date
1818 ,p_cpi_attribute5 in varchar2)
1819 return varchar2;
1820 --
1821 -- --------------------------------------------------------------------------
1822 -- |-------------------------< get_cpi_attribute6 >-------------------------|
1823 -- --------------------------------------------------------------------------
1824 -- Description
1825 -- This function returns the cpi_attribute6
1826 --
1827 function get_cpi_attribute6(p_person_id in number
1828 ,p_assignment_id in number
1829 ,p_legislation_code in varchar2
1830 ,p_group_pl_id in number
1831 ,p_lf_evt_ocrd_dt in date
1832 ,p_effective_date in date
1833 ,p_cpi_attribute6 in varchar2)
1834 return varchar2;
1835 --
1836 -- --------------------------------------------------------------------------
1837 -- |-------------------------< get_cpi_attribute7 >-------------------------|
1838 -- --------------------------------------------------------------------------
1839 -- Description
1840 -- This function returns the cpi_attribute7
1841 --
1842 function get_cpi_attribute7(p_person_id in number
1843 ,p_assignment_id in number
1844 ,p_legislation_code in varchar2
1845 ,p_group_pl_id in number
1846 ,p_lf_evt_ocrd_dt in date
1847 ,p_effective_date in date
1848 ,p_cpi_attribute7 in varchar2)
1849 return varchar2;
1850 --
1851 -- --------------------------------------------------------------------------
1852 -- |-------------------------< get_cpi_attribute8 >-------------------------|
1853 -- --------------------------------------------------------------------------
1854 -- Description
1855 -- This function returns the cpi_attribute8
1856 --
1857 function get_cpi_attribute8(p_person_id in number
1858 ,p_assignment_id in number
1859 ,p_legislation_code in varchar2
1860 ,p_group_pl_id in number
1861 ,p_lf_evt_ocrd_dt in date
1862 ,p_effective_date in date
1866 -- --------------------------------------------------------------------------
1863 ,p_cpi_attribute8 in varchar2)
1864 return varchar2;
1865 --
1867 -- |-------------------------< get_cpi_attribute9 >-------------------------|
1868 -- --------------------------------------------------------------------------
1869 -- Description
1870 -- This function returns the cpi_attribute9
1871 --
1872 function get_cpi_attribute9(p_person_id in number
1873 ,p_assignment_id in number
1874 ,p_legislation_code in varchar2
1875 ,p_group_pl_id in number
1876 ,p_lf_evt_ocrd_dt in date
1877 ,p_effective_date in date
1878 ,p_cpi_attribute9 in varchar2)
1879 return varchar2;
1880 --
1881 -- --------------------------------------------------------------------------
1882 -- |-------------------------< get_cpi_attribute10 >-------------------------|
1883 -- --------------------------------------------------------------------------
1884 -- Description
1885 -- This function returns the cpi_attribute10
1886 --
1887 function get_cpi_attribute10(p_person_id in number
1888 ,p_assignment_id in number
1889 ,p_legislation_code in varchar2
1890 ,p_group_pl_id in number
1891 ,p_lf_evt_ocrd_dt in date
1892 ,p_effective_date in date
1893 ,p_cpi_attribute10 in varchar2)
1894 return varchar2;
1895 --
1896 -- --------------------------------------------------------------------------
1897 -- |-------------------------< get_cpi_attribute11 >-------------------------|
1898 -- --------------------------------------------------------------------------
1899 -- Description
1900 -- This function returns the cpi_attribute11
1901 --
1902 function get_cpi_attribute11(p_person_id in number
1903 ,p_assignment_id in number
1904 ,p_legislation_code in varchar2
1905 ,p_group_pl_id in number
1906 ,p_lf_evt_ocrd_dt in date
1907 ,p_effective_date in date
1908 ,p_cpi_attribute11 in varchar2)
1909 return varchar2;
1910 --
1911
1912 -- --------------------------------------------------------------------------
1913 -- |-------------------------< get_cpi_attribute12 >-------------------------|
1914 -- --------------------------------------------------------------------------
1915 -- Description
1916 -- This function returns the cpi_attribute12
1917 --
1918 function get_cpi_attribute12(p_person_id in number
1919 ,p_assignment_id in number
1920 ,p_legislation_code in varchar2
1921 ,p_group_pl_id in number
1922 ,p_lf_evt_ocrd_dt in date
1923 ,p_effective_date in date
1924 ,p_cpi_attribute12 in varchar2)
1925 return varchar2;
1926 --
1927 -- --------------------------------------------------------------------------
1928 -- |-------------------------< get_cpi_attribute13 >-------------------------|
1929 -- --------------------------------------------------------------------------
1930 -- Description
1931 -- This function returns the cpi_attribute13
1932 --
1933 function get_cpi_attribute13(p_person_id in number
1934 ,p_assignment_id in number
1935 ,p_legislation_code in varchar2
1936 ,p_group_pl_id in number
1937 ,p_lf_evt_ocrd_dt in date
1938 ,p_effective_date in date
1939 ,p_cpi_attribute13 in varchar2)
1940 return varchar2;
1941 --
1942 -- --------------------------------------------------------------------------
1943 -- |-------------------------< get_cpi_attribute14 >-------------------------|
1944 -- --------------------------------------------------------------------------
1945 -- Description
1946 -- This function returns the cpi_attribute14
1947 --
1948 function get_cpi_attribute14(p_person_id in number
1952 ,p_lf_evt_ocrd_dt in date
1949 ,p_assignment_id in number
1950 ,p_legislation_code in varchar2
1951 ,p_group_pl_id in number
1953 ,p_effective_date in date
1954 ,p_cpi_attribute14 in varchar2)
1955 return varchar2;
1956 --
1957 -- --------------------------------------------------------------------------
1958 -- |-------------------------< get_cpi_attribute15 >-------------------------|
1959 -- --------------------------------------------------------------------------
1960 -- Description
1961 -- This function returns the cpi_attribute15
1962 --
1963 function get_cpi_attribute15(p_person_id in number
1964 ,p_assignment_id in number
1965 ,p_legislation_code in varchar2
1966 ,p_group_pl_id in number
1967 ,p_lf_evt_ocrd_dt in date
1968 ,p_effective_date in date
1969 ,p_cpi_attribute15 in varchar2)
1970 return varchar2;
1971 --
1972 -- --------------------------------------------------------------------------
1973 -- |-------------------------< get_cpi_attribute16 >-------------------------|
1974 -- --------------------------------------------------------------------------
1975 -- Description
1976 -- This function returns the cpi_attribute16
1977 --
1978 function get_cpi_attribute16(p_person_id in number
1979 ,p_assignment_id in number
1980 ,p_legislation_code in varchar2
1981 ,p_group_pl_id in number
1982 ,p_lf_evt_ocrd_dt in date
1983 ,p_effective_date in date
1984 ,p_cpi_attribute16 in varchar2)
1985 return varchar2;
1986 --
1987 -- --------------------------------------------------------------------------
1988 -- |-------------------------< get_cpi_attribute17 >-------------------------|
1989 -- --------------------------------------------------------------------------
1990 -- Description
1991 -- This function returns the cpi_attribute17
1992 --
1993 function get_cpi_attribute17(p_person_id in number
1994 ,p_assignment_id in number
1995 ,p_legislation_code in varchar2
1996 ,p_group_pl_id in number
1997 ,p_lf_evt_ocrd_dt in date
1998 ,p_effective_date in date
1999 ,p_cpi_attribute17 in varchar2)
2000 return varchar2;
2001 --
2002 -- --------------------------------------------------------------------------
2003 -- |-------------------------< get_cpi_attribute18 >-------------------------|
2004 -- --------------------------------------------------------------------------
2005 -- Description
2006 -- This function returns the cpi_attribute18
2007 --
2011 ,p_group_pl_id in number
2008 function get_cpi_attribute18(p_person_id in number
2009 ,p_assignment_id in number
2010 ,p_legislation_code in varchar2
2012 ,p_lf_evt_ocrd_dt in date
2013 ,p_effective_date in date
2014 ,p_cpi_attribute18 in varchar2)
2015 return varchar2;
2016 --
2017 -- --------------------------------------------------------------------------
2018 -- |-------------------------< get_cpi_attribute19 >-------------------------|
2019 -- --------------------------------------------------------------------------
2020 -- Description
2021 -- This function returns the cpi_attribute19
2022 --
2023 function get_cpi_attribute19(p_person_id in number
2024 ,p_assignment_id in number
2025 ,p_legislation_code in varchar2
2026 ,p_group_pl_id in number
2027 ,p_lf_evt_ocrd_dt in date
2028 ,p_effective_date in date
2029 ,p_cpi_attribute19 in varchar2)
2030 return varchar2;
2031 --
2032
2033 -- --------------------------------------------------------------------------
2034 -- |-------------------------< get_cpi_attribute20 >-------------------------|
2035 -- --------------------------------------------------------------------------
2036 -- Description
2037 -- This function returns the cpi_attribute20
2038 --
2039 function get_cpi_attribute20(p_person_id in number
2040 ,p_assignment_id in number
2041 ,p_legislation_code in varchar2
2042 ,p_group_pl_id in number
2043 ,p_lf_evt_ocrd_dt in date
2044 ,p_effective_date in date
2045 ,p_cpi_attribute20 in varchar2)
2046 return varchar2;
2047 --
2048
2049 -- --------------------------------------------------------------------------
2053 -- This function returns the cpi_attribute21
2050 -- |-------------------------< get_cpi_attribute21 >-------------------------|
2051 -- --------------------------------------------------------------------------
2052 -- Description
2054 --
2055 function get_cpi_attribute21(p_person_id in number
2056 ,p_assignment_id in number
2057 ,p_legislation_code in varchar2
2058 ,p_group_pl_id in number
2059 ,p_lf_evt_ocrd_dt in date
2060 ,p_effective_date in date
2061 ,p_cpi_attribute21 in varchar2)
2062 return varchar2;
2063 --
2064
2065 -- --------------------------------------------------------------------------
2066 -- |-------------------------< get_cpi_attribute22 >-------------------------|
2067 -- --------------------------------------------------------------------------
2068 -- Description
2069 -- This function returns the cpi_attribute22
2070 --
2071 function get_cpi_attribute22(p_person_id in number
2072 ,p_assignment_id in number
2073 ,p_legislation_code in varchar2
2074 ,p_group_pl_id in number
2075 ,p_lf_evt_ocrd_dt in date
2076 ,p_effective_date in date
2077 ,p_cpi_attribute22 in varchar2)
2078 return varchar2;
2079 --
2080 -- --------------------------------------------------------------------------
2081 -- |-------------------------< get_cpi_attribute23 >-------------------------|
2082 -- --------------------------------------------------------------------------
2083 -- Description
2084 -- This function returns the cpi_attribute23
2085 --
2086 function get_cpi_attribute23(p_person_id in number
2087 ,p_assignment_id in number
2088 ,p_legislation_code in varchar2
2089 ,p_group_pl_id in number
2090 ,p_lf_evt_ocrd_dt in date
2091 ,p_effective_date in date
2092 ,p_cpi_attribute23 in varchar2)
2093 return varchar2;
2094 --
2095 -- --------------------------------------------------------------------------
2096 -- |-------------------------< get_cpi_attribute24 >-------------------------|
2100 --
2097 -- --------------------------------------------------------------------------
2098 -- Description
2099 -- This function returns the cpi_attribute24
2101 function get_cpi_attribute24(p_person_id in number
2102 ,p_assignment_id in number
2103 ,p_legislation_code in varchar2
2104 ,p_group_pl_id in number
2105 ,p_lf_evt_ocrd_dt in date
2106 ,p_effective_date in date
2107 ,p_cpi_attribute24 in varchar2)
2108 return varchar2;
2109 --
2110 -- --------------------------------------------------------------------------
2111 -- |-------------------------< get_cpi_attribute25 >-------------------------|
2112 -- --------------------------------------------------------------------------
2113 -- Description
2114 -- This function returns the cpi_attribute25
2115 --
2116 function get_cpi_attribute25(p_person_id in number
2117 ,p_assignment_id in number
2118 ,p_legislation_code in varchar2
2119 ,p_group_pl_id in number
2120 ,p_lf_evt_ocrd_dt in date
2124 --
2121 ,p_effective_date in date
2122 ,p_cpi_attribute25 in varchar2)
2123 return varchar2;
2125 -- --------------------------------------------------------------------------
2126 -- |-------------------------< get_cpi_attribute26 >-------------------------|
2130 --
2127 -- --------------------------------------------------------------------------
2128 -- Description
2129 -- This function returns the cpi_attribute26
2131 function get_cpi_attribute26(p_person_id in number
2132 ,p_assignment_id in number
2133 ,p_legislation_code in varchar2
2134 ,p_group_pl_id in number
2135 ,p_lf_evt_ocrd_dt in date
2136 ,p_effective_date in date
2137 ,p_cpi_attribute26 in varchar2)
2138 return varchar2;
2139 --
2140 -- --------------------------------------------------------------------------
2141 -- |-------------------------< get_cpi_attribute27 >-------------------------|
2142 -- --------------------------------------------------------------------------
2143 -- Description
2144 -- This function returns the cpi_attribute27
2145 --
2146 function get_cpi_attribute27(p_person_id in number
2147 ,p_assignment_id in number
2148 ,p_legislation_code in varchar2
2149 ,p_group_pl_id in number
2150 ,p_lf_evt_ocrd_dt in date
2151 ,p_effective_date in date
2152 ,p_cpi_attribute27 in varchar2)
2153 return varchar2;
2154 --
2155 -- --------------------------------------------------------------------------
2156 -- |-------------------------< get_cpi_attribute28 >-------------------------|
2157 -- --------------------------------------------------------------------------
2158 -- Description
2159 -- This function returns the cpi_attribute28
2160 --
2161 function get_cpi_attribute28(p_person_id in number
2162 ,p_assignment_id in number
2163 ,p_legislation_code in varchar2
2164 ,p_group_pl_id in number
2165 ,p_lf_evt_ocrd_dt in date
2166 ,p_effective_date in date
2167 ,p_cpi_attribute28 in varchar2)
2168 return varchar2;
2169 --
2170 -- --------------------------------------------------------------------------
2171 -- |-------------------------< get_cpi_attribute29 >-------------------------|
2172 -- --------------------------------------------------------------------------
2173 -- Description
2174 -- This function returns the cpi_attribute29
2175 --
2176 function get_cpi_attribute29(p_person_id in number
2177 ,p_assignment_id in number
2178 ,p_legislation_code in varchar2
2179 ,p_group_pl_id in number
2180 ,p_lf_evt_ocrd_dt in date
2181 ,p_effective_date in date
2182 ,p_cpi_attribute29 in varchar2)
2183 return varchar2;
2184 --
2185
2186 -- --------------------------------------------------------------------------
2187 -- |-------------------------< get_cpi_attribute30 >-------------------------|
2191 --
2188 -- --------------------------------------------------------------------------
2189 -- Description
2190 -- This function returns the cpi_attribute30
2192 function get_cpi_attribute30(p_person_id in number
2193 ,p_assignment_id in number
2194 ,p_legislation_code in varchar2
2195 ,p_group_pl_id in number
2196 ,p_lf_evt_ocrd_dt in date
2197 ,p_effective_date in date
2198 ,p_cpi_attribute30 in varchar2)
2199 return varchar2;
2200 --
2201
2202
2203
2204
2205
2206 -- --------------------------------------------------------------------------
2207 -- |-------------------------< get_grd_quintile >-------------------------|
2208 -- --------------------------------------------------------------------------
2209 -- Description
2210 -- This function returns the grd_quintile
2211 --
2212 function get_grd_quintile(p_person_id in number
2213 ,p_assignment_id in number
2214 ,p_legislation_code in varchar2
2215 ,p_group_pl_id in number
2216 ,p_lf_evt_ocrd_dt in date
2217 ,p_effective_date in date
2218 ,p_grd_quintile in varchar2)
2219 return varchar2;
2220 --
2221 -- --------------------------------------------------------------------------
2222 -- |-------------------------< get_grd_decile >-------------------------|
2223 -- --------------------------------------------------------------------------
2224 -- Description
2225 -- This function returns the grd_decile
2226 --
2227 function get_grd_decile(p_person_id in number
2228 ,p_assignment_id in number
2229 ,p_legislation_code in varchar2
2230 ,p_group_pl_id in number
2231 ,p_lf_evt_ocrd_dt in date
2232 ,p_effective_date in date
2233 ,p_grd_decile in varchar2)
2234 return varchar2;
2235 --
2236 -- --------------------------------------------------------------------------
2237 -- |-------------------------< get_grade_rate_frequency >-------------------------|
2238 -- --------------------------------------------------------------------------
2239 -- Description
2240 -- This function returns the grade_rate_frequency
2241 --
2242 function get_grade_rate_frequency(p_person_id in number
2243 ,p_assignment_id in number
2244 ,p_legislation_code in varchar2
2245 ,p_group_pl_id in number
2246 ,p_lf_evt_ocrd_dt in date
2247 ,p_effective_date in date
2248 ,p_grade_rate_frequency in varchar2)
2249 return varchar2;
2250 --
2251 -- --------------------------------------------------------------------------
2252 -- |-------------------------< get_base_salary_currency >-------------------------|
2253 -- --------------------------------------------------------------------------
2254 -- Description
2255 -- This function returns the base_salary_currency
2256 --
2257 function get_base_salary_currency(p_person_id in number
2258 ,p_assignment_id in number
2259 ,p_legislation_code in varchar2
2260 ,p_group_pl_id in number
2261 ,p_lf_evt_ocrd_dt in date
2262 ,p_effective_date in date
2263 ,p_base_salary_currency in varchar2)
2264 return varchar2;
2265 --
2266 -- --------------------------------------------------------------------------
2267 -- |-------------------------< get_sal_1_yr_ago_freq >-------------------------|
2268 -- --------------------------------------------------------------------------
2272 function get_sal_1_yr_ago_freq(p_person_id in number
2269 -- Description
2270 -- This function returns the salary_1_year_ago_frequency
2271 --
2273 ,p_assignment_id in number
2274 ,p_legislation_code in varchar2
2275 ,p_group_pl_id in number
2276 ,p_lf_evt_ocrd_dt in date
2277 ,p_effective_date in date
2278 ,p_salary_1_year_ago_frequency in varchar2)
2279 return varchar2;
2280 --
2281 -- --------------------------------------------------------------------------
2282 -- |-------------------------< get_sal_1_yr_ago_curr >-------------------------|
2283 -- --------------------------------------------------------------------------
2284 -- Description
2285 -- This function returns the salary_1_year_ago_currency
2286 --
2287 function get_sal_1_yr_ago_curr(p_person_id in number
2288 ,p_assignment_id in number
2289 ,p_legislation_code in varchar2
2290 ,p_group_pl_id in number
2291 ,p_lf_evt_ocrd_dt in date
2292 ,p_effective_date in date
2293 ,p_salary_1_year_ago_currency in varchar2)
2294 return varchar2;
2295 --
2296 -- --------------------------------------------------------------------------
2297 -- |-------------------------< get_sal_2_yr_ago_freq >-------------------------|
2298 -- --------------------------------------------------------------------------
2299 -- Description
2300 -- This function returns the salary_2_year_ago_frequency
2301 --
2302 function get_sal_2_yr_ago_freq(p_person_id in number
2303 ,p_assignment_id in number
2304 ,p_legislation_code in varchar2
2305 ,p_group_pl_id in number
2306 ,p_lf_evt_ocrd_dt in date
2307 ,p_effective_date in date
2308 ,p_salary_2_year_ago_frequency in varchar2)
2309 return varchar2;
2310 --
2311 -- --------------------------------------------------------------------------
2312 -- |-------------------------< get_sal_2_yr_ago_curr >-------------------------|
2313 -- --------------------------------------------------------------------------
2314 -- Description
2315 -- This function returns the salary_2_year_ago_currency
2316 --
2317 function get_sal_2_yr_ago_curr(p_person_id in number
2318 ,p_assignment_id in number
2319 ,p_legislation_code in varchar2
2320 ,p_group_pl_id in number
2321 ,p_lf_evt_ocrd_dt in date
2325 --
2322 ,p_effective_date in date
2323 ,p_salary_2_year_ago_currency in varchar2)
2324 return varchar2;
2326 -- --------------------------------------------------------------------------
2327 -- |-------------------------< get_sal_3_yr_ago_curr >-------------------------|
2328 -- --------------------------------------------------------------------------
2329 -- Description
2330 -- This function returns the salary_3_year_ago_currency
2331 --
2332 function get_sal_3_yr_ago_curr(p_person_id in number
2333 ,p_assignment_id in number
2334 ,p_legislation_code in varchar2
2335 ,p_group_pl_id in number
2336 ,p_lf_evt_ocrd_dt in date
2337 ,p_effective_date in date
2338 ,p_salary_3_year_ago_currency in varchar2)
2339 return varchar2;
2340 --
2344 -- Description
2341 -- --------------------------------------------------------------------------
2342 -- |-------------------------< get_sal_3_yr_ago_freq >-------------------------|
2343 -- --------------------------------------------------------------------------
2345 -- This function returns the salary_3_year_ago_frequency
2346 --
2347 function get_sal_3_yr_ago_freq(p_person_id in number
2348 ,p_assignment_id in number
2349 ,p_legislation_code in varchar2
2350 ,p_group_pl_id in number
2354 return varchar2;
2351 ,p_lf_evt_ocrd_dt in date
2352 ,p_effective_date in date
2353 ,p_salary_3_year_ago_frequency in varchar2)
2355 --
2356 -- --------------------------------------------------------------------------
2357 -- |-------------------------< get_sal_4_yr_ago_freq >-------------------------|
2358 -- --------------------------------------------------------------------------
2359 -- Description
2360 -- This function returns the salary_4_year_ago_frequency
2361 --
2362 function get_sal_4_yr_ago_freq(p_person_id in number
2363 ,p_assignment_id in number
2364 ,p_legislation_code in varchar2
2365 ,p_group_pl_id in number
2366 ,p_lf_evt_ocrd_dt in date
2367 ,p_effective_date in date
2368 ,p_salary_4_year_ago_frequency in varchar2)
2369 return varchar2;
2370 --
2371 -- --------------------------------------------------------------------------
2372 -- |-------------------------< get_sal_4_yr_ago_curr >-------------------------|
2373 -- --------------------------------------------------------------------------
2374 -- Description
2375 -- This function returns the salary_4_year_ago_currency
2376 --
2377 function get_sal_4_yr_ago_curr(p_person_id in number
2378 ,p_assignment_id in number
2379 ,p_legislation_code in varchar2
2380 ,p_group_pl_id in number
2381 ,p_lf_evt_ocrd_dt in date
2382 ,p_effective_date in date
2383 ,p_salary_4_year_ago_currency in varchar2)
2384 return varchar2;
2385 --
2386 -- --------------------------------------------------------------------------
2387 -- |-------------------------< get_sal_5_yr_ago_freq >-------------------------|
2388 -- --------------------------------------------------------------------------
2389 -- Description
2390 -- This function returns the salary_5_year_ago_frequency
2391 --
2392 function get_sal_5_yr_ago_freq(p_person_id in number
2393 ,p_assignment_id in number
2394 ,p_legislation_code in varchar2
2395 ,p_group_pl_id in number
2396 ,p_lf_evt_ocrd_dt in date
2397 ,p_effective_date in date
2398 ,p_salary_5_year_ago_frequency in varchar2)
2399 return varchar2;
2400 --
2401 -- --------------------------------------------------------------------------
2402 -- |-------------------------< get_sal_5_yr_ago_curr >-------------------------|
2403 -- --------------------------------------------------------------------------
2404 -- Description
2405 -- This function returns the salary_5_year_ago_currency
2406 --
2407 function get_sal_5_yr_ago_curr(p_person_id in number
2408 ,p_assignment_id in number
2409 ,p_legislation_code in varchar2
2410 ,p_group_pl_id in number
2411 ,p_lf_evt_ocrd_dt in date
2412 ,p_effective_date in date
2413 ,p_salary_5_year_ago_currency in varchar2)
2414 return varchar2;
2415 --
2416
2417 -- --------------------------------------------------------------------------
2418 -- |-------------------------< get_prev_sal_frequency >-------------------------|
2419 -- --------------------------------------------------------------------------
2420 -- Description
2421 -- This function returns the prev_sal_frequency
2422 --
2423 function get_prev_sal_frequency(p_person_id in number
2424 ,p_assignment_id in number
2425 ,p_legislation_code in varchar2
2426 ,p_group_pl_id in number
2427 ,p_lf_evt_ocrd_dt in date
2428 ,p_effective_date in date
2429 ,p_prev_sal_frequency in varchar2)
2430 return varchar2;
2431 --
2432 -- --------------------------------------------------------------------------
2433 -- |-------------------------< get_prev_sal_currency >-------------------------|
2434 -- --------------------------------------------------------------------------
2435 -- Description
2436 -- This function returns the prev_sal_currency
2437 --
2438 function get_prev_sal_currency(p_person_id in number
2439 ,p_assignment_id in number
2440 ,p_legislation_code in varchar2
2441 ,p_group_pl_id in number
2442 ,p_lf_evt_ocrd_dt in date
2443 ,p_effective_date in date
2444 ,p_prev_sal_currency in varchar2)
2445 return varchar2;
2446 --
2447 -- --------------------------------------------------------------------------
2451 -- This function returns the prev_sal_chg_rsn
2448 -- |-------------------------< get_prev_sal_chg_rsn >-------------------------|
2449 -- --------------------------------------------------------------------------
2450 -- Description
2452 --
2453 function get_prev_sal_chg_rsn(p_person_id in number
2454 ,p_assignment_id in number
2455 ,p_legislation_code in varchar2
2456 ,p_group_pl_id in number
2457 ,p_lf_evt_ocrd_dt in date
2458 ,p_effective_date in date
2459 ,p_prev_sal_chg_rsn in varchar2)
2460 return varchar2;
2461 --
2462 -- --------------------------------------------------------------------------
2463 -- |-------------------------< get_mkt_currency >-------------------------|
2464 -- --------------------------------------------------------------------------
2465 -- Description
2466 -- This function returns the mkt_currency
2467 --
2468 function get_mkt_currency(p_person_id in number
2469 ,p_assignment_id in number
2470 ,p_legislation_code in varchar2
2471 ,p_group_pl_id in number
2472 ,p_lf_evt_ocrd_dt in date
2473 ,p_effective_date in date
2474 ,p_mkt_currency in varchar2)
2475 return varchar2;
2476 --
2477 -- --------------------------------------------------------------------------
2478 -- |-------------------------< get_mkt_frequency >-------------------------|
2479 -- --------------------------------------------------------------------------
2480 -- Description
2481 -- This function returns the mkt_frequency
2482 --
2486 ,p_group_pl_id in number
2483 function get_mkt_frequency(p_person_id in number
2484 ,p_assignment_id in number
2485 ,p_legislation_code in varchar2
2487 ,p_lf_evt_ocrd_dt in date
2488 ,p_effective_date in date
2489 ,p_mkt_frequency in varchar2)
2490 return varchar2;
2491 --
2492 -- --------------------------------------------------------------------------
2493 -- |-------------------------< get_mkt_emp_quartile >-------------------------|
2494 -- --------------------------------------------------------------------------
2495 -- Description
2496 -- This function returns the mkt_emp_quartile
2497 --
2498 function get_mkt_emp_quartile(p_person_id in number
2499 ,p_assignment_id in number
2500 ,p_legislation_code in varchar2
2501 ,p_group_pl_id in number
2502 ,p_lf_evt_ocrd_dt in date
2503 ,p_effective_date in date
2504 ,p_mkt_emp_quartile in varchar2)
2505 return varchar2;
2506 --
2507
2508 end BEN_CWB_CUSTOM_PERSON_V2_PKG;
2509