1 PACKAGE BODY BEN_CWB_CUSTOM_PERSON_V2_PKG as
2 /* $Header: bencwbco.pkb 120.0 2006/04/11 06:08:17 ddeb noship $ */
3 --
4 -- --------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- --------------------------------------------------------------------------
7 --
8 g_package varchar2(33):=' BEN_CWB_CUSTOM_PERSON_V2_PKG.'; --Global package name
9 g_debug boolean := hr_utility.debug_enabled;
10 --
11 --
12
13 -- --------------------------------------------------------------------------
14 -- |---------------------------< get_years_employed >---------------------------|
15 -- --------------------------------------------------------------------------
16 -- Description
17 -- This function returns the years_employed
18 --
19 function get_years_employed(p_person_id in number
20 ,p_assignment_id in number
21 ,p_legislation_code in varchar2
22 ,p_group_pl_id in number
23 ,p_lf_evt_ocrd_dt in date
24 ,p_effective_date in date
25 ,p_years_employed in number)
26
27 return number is
28 --
29 l_proc varchar2(72) := g_package||'get_years_employed';
30 --
31
32 begin
33 --
34 if g_debug then
35 hr_utility.set_location('Entering:'|| l_proc, 10);
36 end if;
37 --
38 -- Customer can override p_years_employed here
39 return p_years_employed;
40 --
41 if g_debug then
42 hr_utility.set_location(' Leaving:'|| l_proc, 99);
43 end if;
44 --
45
46 exception
47 when others then
48 hr_utility.set_location('Exception in '|| l_proc, 99);
49 raise;
50
51 end;
52 -- --------------------------------------------------------------------------
53 -- |---------------------------< get_years_in_job >---------------------------|
54 -- --------------------------------------------------------------------------
55 -- Description
56 -- This function returns the years_in_job
57 --
58 function get_years_in_job(p_person_id in number
59 ,p_assignment_id in number
60 ,p_legislation_code in varchar2
61 ,p_group_pl_id in number
62 ,p_lf_evt_ocrd_dt in date
63 ,p_effective_date in date
64 ,p_years_in_job in number)
65
66 return number is
67 --
68 l_proc varchar2(72) := g_package||'get_years_in_job';
69 --
70 begin
71 --
72 if g_debug then
73 hr_utility.set_location('Entering:'|| l_proc, 10);
74 end if;
75 --
76 -- Customer can override p_years_in_job here
77 return p_years_in_job;
78 --
79 if g_debug then
80 hr_utility.set_location(' Leaving:'|| l_proc, 99);
81 end if;
82 --
83
84 exception
85 when others then
86 hr_utility.set_location('Exception in '|| l_proc, 99);
87 raise;
88
89 end;
90 -- --------------------------------------------------------------------------
91 -- |---------------------------< get_years_in_position >---------------------------|
92 -- --------------------------------------------------------------------------
93 -- Description
94 -- This function returns the years_in_position
95 --
96 function get_years_in_position(p_person_id in number
97 ,p_assignment_id in number
98 ,p_legislation_code in varchar2
99 ,p_group_pl_id in number
100 ,p_lf_evt_ocrd_dt in date
101 ,p_effective_date in date
102 ,p_years_in_position in number)
103
104 return number is
105 --
106 l_proc varchar2(72) := g_package||'get_years_in_position';
107 --
108 begin
109 --
110 if g_debug then
111 hr_utility.set_location('Entering:'|| l_proc, 10);
112 end if;
113 --
114 -- Customer can override p_years_in_position here
115 return p_years_in_position;
116 --
117 if g_debug then
118 hr_utility.set_location(' Leaving:'|| l_proc, 99);
119 end if;
120 --
121
122 exception
123 when others then
124 hr_utility.set_location('Exception in '|| l_proc, 99);
125 raise;
126
127 end;
128 -- --------------------------------------------------------------------------
129 -- |---------------------------< get_years_in_grade >---------------------------|
130 -- --------------------------------------------------------------------------
131 -- Description
132 -- This function returns the years_in_grade
133 --
134 function get_years_in_grade(p_person_id in number
135 ,p_assignment_id in number
136 ,p_legislation_code in varchar2
137 ,p_group_pl_id in number
138 ,p_lf_evt_ocrd_dt in date
139 ,p_effective_date in date
140 ,p_years_in_grade in number)
141
142 return number is
143 --
144 l_proc varchar2(72) := g_package||'get_years_in_grade';
145 --
146 begin
147 --
148 if g_debug then
149 hr_utility.set_location('Entering:'|| l_proc, 10);
150 end if;
151 --
152 -- Customer can override p_years_in_grade here
153 return p_years_in_grade;
154 --
155 if g_debug then
156 hr_utility.set_location(' Leaving:'|| l_proc, 99);
157 end if;
158 --
159
160 exception
161 when others then
162 hr_utility.set_location('Exception in '|| l_proc, 99);
163 raise;
164
165 end;
166 -- --------------------------------------------------------------------------
167 -- |---------------------------< get_base_salary >---------------------------|
168 -- --------------------------------------------------------------------------
169 -- Description
170 -- This function returns the base_salary
171 --
172 function get_base_salary(p_person_id in number
173 ,p_assignment_id in number
174 ,p_legislation_code in varchar2
175 ,p_group_pl_id in number
176 ,p_lf_evt_ocrd_dt in date
177 ,p_effective_date in date
178 ,p_base_salary in number)
179
180 return number is
181 --
182 l_proc varchar2(72) := g_package||'get_base_salary';
183 --
184 begin
185 --
186 if g_debug then
187 hr_utility.set_location('Entering:'|| l_proc, 10);
188 end if;
189 --
190 -- Customer can override p_base_salary here
191 return p_base_salary;
192 --
193 if g_debug then
194 hr_utility.set_location(' Leaving:'|| l_proc, 99);
195 end if;
196 --
197
198 exception
199 when others then
200 hr_utility.set_location('Exception in '|| l_proc, 99);
201 raise;
202
203 end;
204 -- --------------------------------------------------------------------------
205 -- |---------------------------< get_job_id >---------------------------|
206 -- --------------------------------------------------------------------------
207 -- Description
208 -- This function returns the job_id
209 --
210 function get_job_id(p_person_id in number
211 ,p_assignment_id in number
212 ,p_legislation_code in varchar2
213 ,p_group_pl_id in number
214 ,p_lf_evt_ocrd_dt in date
215 ,p_effective_date in date
216 ,p_job_id in number)
217
218 return number is
219 --
220 l_proc varchar2(72) := g_package||'get_job_id';
221 --
222 begin
223 --
224 if g_debug then
225 hr_utility.set_location('Entering:'|| l_proc, 10);
226 end if;
227 --
228 -- Customer can override p_job_id here
229 return p_job_id;
230 --
231 if g_debug then
232 hr_utility.set_location(' Leaving:'|| l_proc, 99);
233 end if;
234 --
235
236 exception
237 when others then
238 hr_utility.set_location('Exception in '|| l_proc, 99);
239 raise;
240
241 end;
242 -- --------------------------------------------------------------------------
243 -- |---------------------------< get_grade_id >---------------------------|
244 -- --------------------------------------------------------------------------
245 -- Description
246 -- This function returns the grade_id
247 --
248 function get_grade_id(p_person_id in number
249 ,p_assignment_id in number
250 ,p_legislation_code in varchar2
251 ,p_group_pl_id in number
252 ,p_lf_evt_ocrd_dt in date
253 ,p_effective_date in date
254 ,p_grade_id in number)
255
256 return number is
257 --
258 l_proc varchar2(72) := g_package||'get_grade_id';
259 --
260 begin
261 --
262 if g_debug then
263 hr_utility.set_location('Entering:'|| l_proc, 10);
264 end if;
265 --
266 -- Customer can override p_grade_id here
267 return p_grade_id;
268 --
269 if g_debug then
270 hr_utility.set_location(' Leaving:'|| l_proc, 99);
271 end if;
272 --
273
274 exception
275 when others then
276 hr_utility.set_location('Exception in '|| l_proc, 99);
277 raise;
278
279 end;
280 -- --------------------------------------------------------------------------
281 -- |---------------------------< get_position_id >---------------------------|
282 -- --------------------------------------------------------------------------
283 -- Description
284 -- This function returns the position_id
285 --
286 function get_position_id(p_person_id in number
287 ,p_assignment_id in number
288 ,p_legislation_code in varchar2
289 ,p_group_pl_id in number
290 ,p_lf_evt_ocrd_dt in date
291 ,p_effective_date in date
292 ,p_position_id in number)
293
294 return number is
295 --
296 l_proc varchar2(72) := g_package||'get_position_id';
297 --
298 begin
299 --
300 if g_debug then
301 hr_utility.set_location('Entering:'|| l_proc, 10);
302 end if;
303 --
304 -- Customer can override p_position_id here
305 return p_position_id;
306 --
307 if g_debug then
308 hr_utility.set_location(' Leaving:'|| l_proc, 99);
309 end if;
310 --
311
312 exception
313 when others then
314 hr_utility.set_location('Exception in '|| l_proc, 99);
315 raise;
316
317 end;
318 -- --------------------------------------------------------------------------
319 -- |---------------------------< get_people_group_id >---------------------------|
320 -- --------------------------------------------------------------------------
321 -- Description
322 -- This function returns the people_group_id
323 --
324 function get_people_group_id(p_person_id in number
325 ,p_assignment_id in number
326 ,p_legislation_code in varchar2
327 ,p_group_pl_id in number
328 ,p_lf_evt_ocrd_dt in date
329 ,p_effective_date in date
330 ,p_people_group_id in number)
331
332 return number is
333 --
334 l_proc varchar2(72) := g_package||'get_people_group_id';
335 --
336 begin
337 --
338 if g_debug then
339 hr_utility.set_location('Entering:'|| l_proc, 10);
340 end if;
341 --
342 -- Customer can override p_people_group_id here
343 return p_people_group_id;
344 --
345 if g_debug then
346 hr_utility.set_location(' Leaving:'|| l_proc, 99);
347 end if;
348 --
349
350 exception
351 when others then
352 hr_utility.set_location('Exception in '|| l_proc, 99);
353 raise;
354
355 end;
356 -- --------------------------------------------------------------------------
357 -- |---------------------------< get_soft_coding_keyflex_id >---------------------------|
358 -- --------------------------------------------------------------------------
359 -- Description
360 -- This function returns the soft_coding_keyflex_id
361 --
362 function get_soft_coding_keyflex_id(p_person_id in number
363 ,p_assignment_id in number
364 ,p_legislation_code in varchar2
365 ,p_group_pl_id in number
366 ,p_lf_evt_ocrd_dt in date
367 ,p_effective_date in date
368 ,p_soft_coding_keyflex_id in number)
369
370 return number is
371 --
372 l_proc varchar2(72) := g_package||'get_soft_coding_keyflex_id';
373 --
374 begin
375 --
376 if g_debug then
377 hr_utility.set_location('Entering:'|| l_proc, 10);
378 end if;
379 --
380 -- Customer can override p_soft_coding_keyflex_id here
381 return p_soft_coding_keyflex_id;
382 --
383 if g_debug then
384 hr_utility.set_location(' Leaving:'|| l_proc, 99);
385 end if;
386 --
387
388 exception
389 when others then
390 hr_utility.set_location('Exception in '|| l_proc, 99);
391 raise;
392
393 end;
394 -- --------------------------------------------------------------------------
395 -- |---------------------------< get_location_id >---------------------------|
396 -- --------------------------------------------------------------------------
397 -- Description
398 -- This function returns the location_id
399 --
400 function get_location_id(p_person_id in number
401 ,p_assignment_id in number
402 ,p_legislation_code in varchar2
403 ,p_group_pl_id in number
404 ,p_lf_evt_ocrd_dt in date
405 ,p_effective_date in date
406 ,p_location_id in number)
407
408 return number is
409 --
410 l_proc varchar2(72) := g_package||'get_location_id';
411 --
412 begin
413 --
414 if g_debug then
415 hr_utility.set_location('Entering:'|| l_proc, 10);
416 end if;
417 --
418 -- Customer can override p_location_id here
419 return p_location_id;
420 --
421 if g_debug then
422 hr_utility.set_location(' Leaving:'|| l_proc, 99);
423 end if;
424 --
425
426 exception
427 when others then
428 hr_utility.set_location('Exception in '|| l_proc, 99);
429 raise;
430
431 end;
432 -- --------------------------------------------------------------------------
433 -- |---------------------------< get_pay_rate_id >---------------------------|
434 -- --------------------------------------------------------------------------
435 -- Description
436 -- This function returns the pay_rate_id
437 --
438 function get_pay_rate_id(p_person_id in number
439 ,p_assignment_id in number
440 ,p_legislation_code in varchar2
441 ,p_group_pl_id in number
442 ,p_lf_evt_ocrd_dt in date
443 ,p_effective_date in date
444 ,p_pay_rate_id in number)
445
446 return number is
447 --
448 l_proc varchar2(72) := g_package||'get_pay_rate_id';
449 --
450 begin
451 --
452 if g_debug then
453 hr_utility.set_location('Entering:'|| l_proc, 10);
454 end if;
455 --
456 -- Customer can override p_pay_rate_id here
457 return p_pay_rate_id;
458 --
459 if g_debug then
460 hr_utility.set_location(' Leaving:'|| l_proc, 99);
461 end if;
462 --
463
464 exception
465 when others then
466 hr_utility.set_location('Exception in '|| l_proc, 99);
467 raise;
468
469 end;
470 -- --------------------------------------------------------------------------
471 -- |---------------------------< get_assignment_status_type_id >---------------------------|
472 -- --------------------------------------------------------------------------
473 -- Description
477 ,p_assignment_id in number
474 -- This function returns the assignment_status_type_id
475 --
476 function get_assignment_status_type_id(p_person_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_assignment_status_type_id in number)
483
484 return number is
485 --
486 l_proc varchar2(72) := g_package||'get_assignment_status_type_id';
487 --
488 begin
489 --
490 if g_debug then
491 hr_utility.set_location('Entering:'|| l_proc, 10);
492 end if;
493 --
494 -- Customer can override p_assignment_status_type_id here
495 return p_assignment_status_type_id;
496 --
497 if g_debug then
498 hr_utility.set_location(' Leaving:'|| l_proc, 99);
499 end if;
500 --
501
502 exception
503 when others then
504 hr_utility.set_location('Exception in '|| l_proc, 99);
505 raise;
506
507 end;
508 -- --------------------------------------------------------------------------
509 -- |---------------------------< get_grade_annulization_factor >---------------------------|
510 -- --------------------------------------------------------------------------
511 -- Description
512 -- This function returns the grade_annulization_factor
513 --
514 function get_grade_annulization_factor(p_person_id in number
515 ,p_assignment_id in number
516 ,p_legislation_code in varchar2
517 ,p_group_pl_id in number
518 ,p_lf_evt_ocrd_dt in date
519 ,p_effective_date in date
520 ,p_grade_annulization_factor in number)
521
522 return number is
523 --
524 l_proc varchar2(72) := g_package||'get_grade_annulization_factor';
525 --
526 begin
527 --
528 if g_debug then
529 hr_utility.set_location('Entering:'|| l_proc, 10);
530 end if;
531 --
532 -- Customer can override p_grade_annulization_factor here
533 return p_grade_annulization_factor;
534 --
535 if g_debug then
536 hr_utility.set_location(' Leaving:'|| l_proc, 99);
537 end if;
538 --
539
540 exception
541 when others then
542 hr_utility.set_location('Exception in '|| l_proc, 99);
543 raise;
544
545 end;
546 -- --------------------------------------------------------------------------
547 -- |---------------------------< get_pay_annulization_factor >---------------------------|
548 -- --------------------------------------------------------------------------
549 -- Description
550 -- This function returns the pay_annulization_factor
551 --
552 function get_pay_annulization_factor(p_person_id in number
553 ,p_assignment_id in number
554 ,p_legislation_code in varchar2
555 ,p_group_pl_id in number
556 ,p_lf_evt_ocrd_dt in date
557 ,p_effective_date in date
558 ,p_pay_annulization_factor in number)
559
560 return number is
561 --
562 l_proc varchar2(72) := g_package||'get_pay_annulization_factor';
563 --
564 begin
565 --
566 if g_debug then
567 hr_utility.set_location('Entering:'|| l_proc, 10);
568 end if;
569 --
570 -- Customer can override p_pay_annulization_factor here
571 return p_pay_annulization_factor;
572 --
573 if g_debug then
574 hr_utility.set_location(' Leaving:'|| l_proc, 99);
575 end if;
576 --
577
578 exception
579 when others then
580 hr_utility.set_location('Exception in '|| l_proc, 99);
581 raise;
582
583 end;
584 -- --------------------------------------------------------------------------
585 -- |---------------------------< get_grd_min_val >---------------------------|
586 -- --------------------------------------------------------------------------
587 -- Description
588 -- This function returns the grd_min_val
589 --
590 function get_grd_min_val(p_person_id in number
591 ,p_assignment_id in number
592 ,p_legislation_code in varchar2
593 ,p_group_pl_id in number
594 ,p_lf_evt_ocrd_dt in date
595 ,p_effective_date in date
596 ,p_grd_min_val in number)
597
598 return number is
599 --
600 l_proc varchar2(72) := g_package||'get_grd_min_val';
601 --
602 begin
603 --
604 if g_debug then
605 hr_utility.set_location('Entering:'|| l_proc, 10);
606 end if;
607 --
608 -- Customer can override p_grd_min_val here
609 return p_grd_min_val;
610 --
611 if g_debug then
612 hr_utility.set_location(' Leaving:'|| l_proc, 99);
613 end if;
614 --
615
616 exception
617 when others then
618 hr_utility.set_location('Exception in '|| l_proc, 99);
619 raise;
620
621 end;
622 -- --------------------------------------------------------------------------
623 -- |---------------------------< get_grd_max_val >---------------------------|
624 -- --------------------------------------------------------------------------
625 -- Description
626 -- This function returns the grd_max_val
627 --
628 function get_grd_max_val(p_person_id in number
632 ,p_lf_evt_ocrd_dt in date
629 ,p_assignment_id in number
630 ,p_legislation_code in varchar2
631 ,p_group_pl_id in number
633 ,p_effective_date in date
634 ,p_grd_max_val in number)
635
636 return number is
637 --
638 l_proc varchar2(72) := g_package||'get_grd_max_val';
639 --
640 begin
641 --
642 if g_debug then
643 hr_utility.set_location('Entering:'|| l_proc, 10);
644 end if;
645 --
646 -- Customer can override p_grd_max_val here
647 return p_grd_max_val;
648 --
649 if g_debug then
650 hr_utility.set_location(' Leaving:'|| l_proc, 99);
651 end if;
652 --
653
654 exception
655 when others then
656 hr_utility.set_location('Exception in '|| l_proc, 99);
657 raise;
658
659 end;
660 -- --------------------------------------------------------------------------
661 -- |---------------------------< get_grd_mid_point >---------------------------|
662 -- --------------------------------------------------------------------------
663 -- Description
664 -- This function returns the grd_mid_pointl
665 --
666 function get_grd_mid_point(p_person_id in number
667 ,p_assignment_id in number
668 ,p_legislation_code in varchar2
669 ,p_group_pl_id in number
670 ,p_lf_evt_ocrd_dt in date
671 ,p_effective_date in date
672 ,p_grd_mid_point in number)
673
674 return number is
675 --
676 l_proc varchar2(72) := g_package||'get_grd_mid_point';
677 --
678 begin
679 --
680 if g_debug then
681 hr_utility.set_location('Entering:'|| l_proc, 10);
682 end if;
683 --
684 -- Customer can override p_grd_mid_point here
685 return p_grd_mid_point;
686 --
687 if g_debug then
688 hr_utility.set_location(' Leaving:'|| l_proc, 99);
689 end if;
690 --
691
692 exception
693 when others then
694 hr_utility.set_location('Exception in '|| l_proc, 99);
695 raise;
696
697 end;
698 -- --------------------------------------------------------------------------
699 -- |---------------------------< get_fte_factor >---------------------------|
700 -- --------------------------------------------------------------------------
701 -- Description
702 -- This function returns the fte_factor
703 --
704 function get_fte_factor(p_person_id in number
705 ,p_assignment_id in number
706 ,p_legislation_code in varchar2
707 ,p_group_pl_id in number
708 ,p_lf_evt_ocrd_dt in date
709 ,p_effective_date in date
710 ,p_fte_factor in number)
711
712 return number is
713 --
714 l_proc varchar2(72) := g_package||'get_fte_factor';
715 --
716 begin
717 --
718 if g_debug then
719 hr_utility.set_location('Entering:'|| l_proc, 10);
720 end if;
721 --
722 -- Customer can override p_fte_factor here
723 return p_fte_factor;
724 --
725 if g_debug then
726 hr_utility.set_location(' Leaving:'|| l_proc, 99);
727 end if;
728 --
729
730 exception
731 when others then
732 hr_utility.set_location('Exception in '|| l_proc, 99);
733 raise;
734
735 end;
736 -- --------------------------------------------------------------------------
737 -- |---------------------------< get_grd_pct_in_range >---------------------------|
738 -- --------------------------------------------------------------------------
739 -- Description
740 -- This function returns the grd_pct_in_range
741 --
742 function get_grd_pct_in_range(p_person_id in number
743 ,p_assignment_id in number
744 ,p_legislation_code in varchar2
745 ,p_group_pl_id in number
746 ,p_lf_evt_ocrd_dt in date
747 ,p_effective_date in date
748 ,p_grd_pct_in_range in number)
749
750 return number is
751 --
752 l_proc varchar2(72) := g_package||'get_grd_pct_in_range';
753 --
754 begin
755 --
756 if g_debug then
757 hr_utility.set_location('Entering:'|| l_proc, 10);
758 end if;
759 --
760 -- Customer can override p_grd_pct_in_range here
761 return p_grd_pct_in_range;
762 --
763 if g_debug then
764 hr_utility.set_location(' Leaving:'|| l_proc, 99);
765 end if;
766 --
767
768 exception
769 when others then
770 hr_utility.set_location('Exception in '|| l_proc, 99);
771 raise;
772
773 end;
774 -- --------------------------------------------------------------------------
775 -- |---------------------------< get_salary_1_year_ago >---------------------------|
776 -- --------------------------------------------------------------------------
777 -- Description
778 -- This function returns the salary_1_year_ago
779 --
780 function get_salary_1_year_ago(p_person_id in number
781 ,p_assignment_id in number
782 ,p_legislation_code in varchar2
783 ,p_group_pl_id in number
784 ,p_lf_evt_ocrd_dt in date
785 ,p_effective_date in date
789 --
786 ,p_salary_1_year_ago in number)
787
788 return number is
790 l_proc varchar2(72) := g_package||'get_salary_1_year_ago';
791 --
792 begin
793 --
794 if g_debug then
795 hr_utility.set_location('Entering:'|| l_proc, 10);
796 end if;
797 --
798 -- Customer can override p_salary_1_year_ago here
799 return p_salary_1_year_ago;
800 --
801 if g_debug then
802 hr_utility.set_location(' Leaving:'|| l_proc, 99);
803 end if;
804 --
805
806 exception
807 when others then
808 hr_utility.set_location('Exception in '|| l_proc, 99);
809 raise;
810
811 end;
812 -- --------------------------------------------------------------------------
813 -- |---------------------------< get_salary_1_year_ago_ann_fctr >---------------------------|
814 -- --------------------------------------------------------------------------
815 -- Description
816 -- This function returns the salary_1_year_ago_ann_fctr
817 --
818 function get_salary_1_year_ago_ann_fctr(p_person_id in number
819 ,p_assignment_id in number
820 ,p_legislation_code in varchar2
821 ,p_group_pl_id in number
822 ,p_lf_evt_ocrd_dt in date
823 ,p_effective_date in date
824 ,p_salary_1_year_ago_ann_fctr in number)
825
826 return number is
827 --
828 l_proc varchar2(72) := g_package||'get_salary_1_year_ago_ann_fctr';
829 --
830 begin
831 --
832 if g_debug then
833 hr_utility.set_location('Entering:'|| l_proc, 10);
834 end if;
835 --
836 -- Customer can override p_salary_1_year_ago_ann_fctr here
837 return p_salary_1_year_ago_ann_fctr;
838 --
839 if g_debug then
840 hr_utility.set_location(' Leaving:'|| l_proc, 99);
841 end if;
842 --
843
844 exception
845 when others then
846 hr_utility.set_location('Exception in '|| l_proc, 99);
847 raise;
848
849 end;
850 -- --------------------------------------------------------------------------
851 -- |---------------------------< get_salary_2_year_ago >---------------------------|
852 -- --------------------------------------------------------------------------
853 -- Description
854 -- This function returns the salary_2_year_ago
855 --
856 function get_salary_2_year_ago(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_salary_2_year_ago in number)
863
864 return number is
865 --
866 l_proc varchar2(72) := g_package||'salary_2_year_ago';
867 --
868 begin
869 --
870 if g_debug then
871 hr_utility.set_location('Entering:'|| l_proc, 10);
872 end if;
873 --
874 -- Customer can override p_salary_1_year_ago_ann_fctr here
875 return p_salary_2_year_ago;
876 --
877 if g_debug then
878 hr_utility.set_location(' Leaving:'|| l_proc, 99);
879 end if;
880 --
881
882 exception
883 when others then
884 hr_utility.set_location('Exception in '|| l_proc, 99);
885 raise;
886
887 end;
888 -- --------------------------------------------------------------------------
889 -- |---------------------------< get_salary_2_year_ago_ann_fctr >---------------------------|
890 -- --------------------------------------------------------------------------
891 -- Description
892 -- This function returns the salary_2_year_ago_ann_fctr
893 --
894 function get_salary_2_year_ago_ann_fctr(p_person_id in number
895 ,p_assignment_id in number
896 ,p_legislation_code in varchar2
897 ,p_group_pl_id in number
898 ,p_lf_evt_ocrd_dt in date
899 ,p_effective_date in date
900 ,p_salary_2_year_ago_ann_fctr in number)
901
902 return number is
903 --
904 l_proc varchar2(72) := g_package||'get_salary_2_year_ago_ann_fctr';
905 --
906 begin
907 --
908 if g_debug then
909 hr_utility.set_location('Entering:'|| l_proc, 10);
910 end if;
911 --
912 -- Customer can override p_salary_2_year_ago_ann_fctr here
913 return p_salary_2_year_ago_ann_fctr;
914 --
915 if g_debug then
916 hr_utility.set_location(' Leaving:'|| l_proc, 99);
917 end if;
918 --
919
920 exception
921 when others then
922 hr_utility.set_location('Exception in '|| l_proc, 99);
923 raise;
924
925 end;
926 -- --------------------------------------------------------------------------
927 -- |---------------------------< get_salary_3_year_ago >---------------------------|
928 -- --------------------------------------------------------------------------
929 -- Description
930 -- This function returns the salary_3_year_ago
931 --
932 function get_salary_3_year_ago(p_person_id in number
933 ,p_assignment_id in number
934 ,p_legislation_code in varchar2
935 ,p_group_pl_id in number
936 ,p_lf_evt_ocrd_dt in date
937 ,p_effective_date in date
938 ,p_salary_3_year_ago in number)
939
940 return number is
941 --
945 --
942 l_proc varchar2(72) := g_package||'get_salary_3_year_ago';
943 --
944 begin
946 if g_debug then
947 hr_utility.set_location('Entering:'|| l_proc, 10);
948 end if;
949 --
950 -- Customer can override p_salary_3_year_ago here
951 return p_salary_3_year_ago;
952 --
953 if g_debug then
954 hr_utility.set_location(' Leaving:'|| l_proc, 99);
955 end if;
956 --
957
958 exception
959 when others then
960 hr_utility.set_location('Exception in '|| l_proc, 99);
961 raise;
962
963 end;
964 -- --------------------------------------------------------------------------
965 -- |---------------------------< get_salary_3_year_ago_ann_fctr >---------------------------|
966 -- --------------------------------------------------------------------------
967 -- Description
968 -- This function returns the salary_3_year_ago_ann_fctr
969 --
970 function get_salary_3_year_ago_ann_fctr(p_person_id in number
971 ,p_assignment_id in number
972 ,p_legislation_code in varchar2
973 ,p_group_pl_id in number
974 ,p_lf_evt_ocrd_dt in date
975 ,p_effective_date in date
976 ,p_salary_3_year_ago_ann_fctr in number)
977
978 return number is
979 --
980 l_proc varchar2(72) := g_package||'get_salary_3_year_ago_ann_fctr';
981 --
982 begin
983 --
984 if g_debug then
985 hr_utility.set_location('Entering:'|| l_proc, 10);
986 end if;
987 --
988 -- Customer can override p_salary_3_year_ago_ann_fctr here
989 return p_salary_3_year_ago_ann_fctr;
990 --
991 if g_debug then
992 hr_utility.set_location(' Leaving:'|| l_proc, 99);
993 end if;
994 --
995
996 exception
997 when others then
998 hr_utility.set_location('Exception in '|| l_proc, 99);
999 raise;
1000
1001 end;
1002 -- --------------------------------------------------------------------------
1003 -- |---------------------------< get_salary_4_year_ago >---------------------------|
1004 -- --------------------------------------------------------------------------
1005 -- Description
1006 -- This function returns the salary_4_year_ago
1007 --
1008 function get_salary_4_year_ago(p_person_id in number
1009 ,p_assignment_id in number
1010 ,p_legislation_code in varchar2
1011 ,p_group_pl_id in number
1012 ,p_lf_evt_ocrd_dt in date
1013 ,p_effective_date in date
1014 ,p_salary_4_year_ago in number)
1015
1016 return number is
1017 --
1018 l_proc varchar2(72) := g_package||'get_salary_4_year_ago';
1019 --
1020 begin
1021 --
1022 if g_debug then
1023 hr_utility.set_location('Entering:'|| l_proc, 10);
1024 end if;
1025 --
1026 -- Customer can override p_salary_4_year_ago here
1027 return p_salary_4_year_ago;
1028 --
1029 if g_debug then
1030 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1031 end if;
1032 --
1033
1034 exception
1035 when others then
1036 hr_utility.set_location('Exception in '|| l_proc, 99);
1037 raise;
1038
1039 end;
1040 -- --------------------------------------------------------------------------
1041 -- |---------------------------< get_salary_4_year_ago_ann_fctr >---------------------------|
1042 -- --------------------------------------------------------------------------
1043 -- Description
1044 -- This function returns the salary_4_year_ago_ann_fctr
1045 --
1046 function get_salary_4_year_ago_ann_fctr(p_person_id in number
1047 ,p_assignment_id in number
1048 ,p_legislation_code in varchar2
1049 ,p_group_pl_id in number
1050 ,p_lf_evt_ocrd_dt in date
1051 ,p_effective_date in date
1052 ,p_salary_4_year_ago_ann_fctr in number)
1053
1054 return number is
1055 --
1056 l_proc varchar2(72) := g_package||'get_salary_4_year_ago_ann_fctr';
1057 --
1058 begin
1059 --
1060 if g_debug then
1061 hr_utility.set_location('Entering:'|| l_proc, 10);
1062 end if;
1063 --
1064 -- Customer can override p_salary_4_year_ago_ann_fctr here
1065 return p_salary_4_year_ago_ann_fctr;
1066 --
1067 if g_debug then
1068 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1069 end if;
1070 --
1071
1072 exception
1073 when others then
1074 hr_utility.set_location('Exception in '|| l_proc, 99);
1075 raise;
1076
1077 end;
1078 -- --------------------------------------------------------------------------
1079 -- |---------------------------< get_salary_5_year_ago >---------------------------|
1080 -- --------------------------------------------------------------------------
1081 -- Description
1082 -- This function returns the salary_5_year_ago
1083 --
1084 function get_salary_5_year_ago(p_person_id in number
1085 ,p_assignment_id in number
1086 ,p_legislation_code in varchar2
1087 ,p_group_pl_id in number
1088 ,p_lf_evt_ocrd_dt in date
1089 ,p_effective_date in date
1090 ,p_salary_5_year_ago in number)
1091
1092 return number is
1093 --
1094 l_proc varchar2(72) := g_package||'get_salary_5_year_ago';
1095 --
1096 begin
1097 --
1101 --
1098 if g_debug then
1099 hr_utility.set_location('Entering:'|| l_proc, 10);
1100 end if;
1102 -- Customer can override p_salary_5_year_ago here
1103 return p_salary_5_year_ago;
1104 --
1105 if g_debug then
1106 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1107 end if;
1108 --
1109
1110 exception
1111 when others then
1112 hr_utility.set_location('Exception in '|| l_proc, 99);
1113 raise;
1114
1115 end;
1116 -- --------------------------------------------------------------------------
1117 -- |---------------------------< get_salary_5_year_ago_ann_fctr >---------------------------|
1118 -- --------------------------------------------------------------------------
1119 -- Description
1120 -- This function returns the salary_5_year_ago_ann_fctr
1121 --
1122 function get_salary_5_year_ago_ann_fctr(p_person_id in number
1123 ,p_assignment_id in number
1124 ,p_legislation_code in varchar2
1125 ,p_group_pl_id in number
1126 ,p_lf_evt_ocrd_dt in date
1127 ,p_effective_date in date
1128 ,p_salary_5_year_ago_ann_fctr in number)
1129
1130 return number is
1131 --
1132 l_proc varchar2(72) := g_package||'get_salary_5_year_ago_ann_fctr';
1133 --
1134 begin
1135 --
1136 if g_debug then
1137 hr_utility.set_location('Entering:'|| l_proc, 10);
1138 end if;
1139 --
1140 -- Customer can override p_salary_5_year_ago_ann_fctr here
1141 return p_salary_5_year_ago_ann_fctr;
1142 --
1143 if g_debug then
1144 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1145 end if;
1146 --
1147
1148 exception
1149 when others then
1150 hr_utility.set_location('Exception in '|| l_proc, 99);
1151 raise;
1152
1153 end;
1154 -- --------------------------------------------------------------------------
1155 -- |---------------------------< get_prev_sal >---------------------------|
1156 -- --------------------------------------------------------------------------
1157 -- Description
1158 -- This function returns the prev_sal
1159 --
1160 function get_prev_sal(p_person_id in number
1161 ,p_assignment_id in number
1162 ,p_legislation_code in varchar2
1163 ,p_group_pl_id in number
1164 ,p_lf_evt_ocrd_dt in date
1165 ,p_effective_date in date
1166 ,p_prev_sal in number)
1167
1168 return number is
1169 --
1170 l_proc varchar2(72) := g_package||'get_prev_sal';
1171 --
1172 begin
1173 --
1174 if g_debug then
1175 hr_utility.set_location('Entering:'|| l_proc, 10);
1176 end if;
1177 --
1178 -- Customer can override p_prev_sal here
1179 return p_prev_sal;
1180 --
1181 if g_debug then
1182 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1183 end if;
1184 --
1185
1186 exception
1187 when others then
1188 hr_utility.set_location('Exception in '|| l_proc, 99);
1189 raise;
1190
1191 end;
1192 -- --------------------------------------------------------------------------
1193 -- |---------------------------< get_prev_sal_ann_fctr >---------------------------|
1194 -- --------------------------------------------------------------------------
1195 -- Description
1196 -- This function returns the prev_sal_ann_fctr
1197 --
1198 function get_prev_sal_ann_fctr(p_person_id in number
1199 ,p_assignment_id in number
1200 ,p_legislation_code in varchar2
1201 ,p_group_pl_id in number
1202 ,p_lf_evt_ocrd_dt in date
1203 ,p_effective_date in date
1204 ,p_prev_sal_ann_fctr in number)
1205
1206 return number is
1207 --
1208 l_proc varchar2(72) := g_package||'get_prev_sal_ann_fctr';
1209 --
1210 begin
1211 --
1212 if g_debug then
1213 hr_utility.set_location('Entering:'|| l_proc, 10);
1214 end if;
1215 --
1216 -- Customer can override p_prev_sal_ann_fctr here
1217 return p_prev_sal_ann_fctr;
1218 --
1219 if g_debug then
1220 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1221 end if;
1222 --
1223
1224 exception
1225 when others then
1226 hr_utility.set_location('Exception in '|| l_proc, 99);
1227 raise;
1228
1229 end;
1230 ---- --------------------------------------------------------------------------
1231 -- |---------------------------< get_mkt_annualization_factor >---------------------------|
1232 -- --------------------------------------------------------------------------
1233 -- Description
1234 -- This function returns the mkt_annualization_factor
1235 --
1236 function get_mkt_annualization_factor(p_person_id in number
1237 ,p_assignment_id in number
1238 ,p_legislation_code in varchar2
1239 ,p_group_pl_id in number
1240 ,p_lf_evt_ocrd_dt in date
1241 ,p_effective_date in date
1242 ,p_mkt_annualization_factor in number)
1243
1244 return number is
1245 --
1246 l_proc varchar2(72) := g_package||'get_mkt_annualization_factor';
1247 --
1248 begin
1249 --
1250 if g_debug then
1251 hr_utility.set_location('Entering:'|| l_proc, 10);
1252 end if;
1253 --
1254 -- Customer can override p_mkt_annualization_factor here
1258 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1255 return p_mkt_annualization_factor;
1256 --
1257 if g_debug then
1259 end if;
1260 --
1261
1262 exception
1263 when others then
1264 hr_utility.set_location('Exception in '|| l_proc, 99);
1265 raise;
1266
1267 end;
1268 --------------------------------------------------------------------------
1269 -- |---------------------------< get_mkt_min_salary >---------------------------|
1270 -- --------------------------------------------------------------------------
1271 -- Description
1272 -- This function returns the mkt_min_salary
1273 --
1274 function get_mkt_min_salary(p_person_id in number
1275 ,p_assignment_id in number
1276 ,p_legislation_code in varchar2
1277 ,p_group_pl_id in number
1278 ,p_lf_evt_ocrd_dt in date
1279 ,p_effective_date in date
1280 ,p_mkt_min_salary in number)
1281
1282 return number is
1283 --
1284 l_proc varchar2(72) := g_package||'get_mkt_min_salary';
1285 --
1286 begin
1287 --
1288 if g_debug then
1289 hr_utility.set_location('Entering:'|| l_proc, 10);
1290 end if;
1291 --
1292 -- Customer can override p_mkt_min_salary here
1293 return p_mkt_min_salary;
1294 --
1295 if g_debug then
1296 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1297 end if;
1298 --
1299
1300 exception
1301 when others then
1302 hr_utility.set_location('Exception in '|| l_proc, 99);
1303 raise;
1304
1305 end;
1306 --------------------------------------------------------------------------
1307 -- |---------------------------< get_mkt_25pct_salary >---------------------------|
1308 -- --------------------------------------------------------------------------
1309 -- Description
1310 -- This function returns the mkt_25pct_salary
1311 --
1312 function get_mkt_25pct_salary(p_person_id in number
1313 ,p_assignment_id in number
1314 ,p_legislation_code in varchar2
1315 ,p_group_pl_id in number
1316 ,p_lf_evt_ocrd_dt in date
1317 ,p_effective_date in date
1318 ,p_mkt_25pct_salary in number)
1319
1320 return number is
1321 --
1322 l_proc varchar2(72) := g_package||'get_mkt_25pct_salary';
1323 --
1324 begin
1325 --
1326 if g_debug then
1327 hr_utility.set_location('Entering:'|| l_proc, 10);
1328 end if;
1329 --
1330 -- Customer can override p_mkt_25pct_salary here
1331 return p_mkt_25pct_salary;
1332 --
1333 if g_debug then
1334 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1335 end if;
1336 --
1337
1338 exception
1339 when others then
1340 hr_utility.set_location('Exception in '|| l_proc, 99);
1341 raise;
1342
1343 end;
1344 --------------------------------------------------------------------------
1345 -- |---------------------------< get_mkt_mid_salary >---------------------------|
1346 -- --------------------------------------------------------------------------
1347 -- Description
1348 -- This function returns the mkt_mid_salary
1349 --
1350 function get_mkt_mid_salary(p_person_id in number
1351 ,p_assignment_id in number
1352 ,p_legislation_code in varchar2
1353 ,p_group_pl_id in number
1354 ,p_lf_evt_ocrd_dt in date
1355 ,p_effective_date in date
1356 ,p_mkt_mid_salary in number)
1357
1358 return number is
1359 --
1360 l_proc varchar2(72) := g_package||'get_mkt_mid_salary';
1361 --
1362 begin
1363 --
1364 if g_debug then
1365 hr_utility.set_location('Entering:'|| l_proc, 10);
1366 end if;
1367 --
1368 -- Customer can override p_mkt_mid_salary here
1369 return p_mkt_mid_salary;
1370 --
1371 if g_debug then
1372 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1373 end if;
1374 --
1375
1376 exception
1377 when others then
1378 hr_utility.set_location('Exception in '|| l_proc, 99);
1379 raise;
1380
1381 end;
1382 --------------------------------------------------------------------------
1383 -- |---------------------------< get_mkt_75pct_salary >---------------------------|
1384 -- --------------------------------------------------------------------------
1385 -- Description
1386 -- This function returns the mkt_75pct_salary
1387 --
1388 function get_mkt_75pct_salary(p_person_id in number
1389 ,p_assignment_id in number
1390 ,p_legislation_code in varchar2
1391 ,p_group_pl_id in number
1392 ,p_lf_evt_ocrd_dt in date
1393 ,p_effective_date in date
1394 ,p_mkt_75pct_salary in number)
1395
1396 return number is
1397 --
1398 l_proc varchar2(72) := g_package||'get_mkt_75pct_salary';
1399 --
1400 begin
1401 --
1402 if g_debug then
1403 hr_utility.set_location('Entering:'|| l_proc, 10);
1404 end if;
1405 --
1406 -- Customer can override p_mkt_75pct_salary here
1407 return p_mkt_75pct_salary;
1408 --
1409 if g_debug then
1410 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1411 end if;
1412 --
1413
1414 exception
1415 when others then
1419 end;
1416 hr_utility.set_location('Exception in '|| l_proc, 99);
1417 raise;
1418
1420
1421 -----
1422 ---------------------------------------------------------------------
1423 -- |---------------------------< get_mkt_max_salary >---------------------------|
1424 -- --------------------------------------------------------------------------
1425 -- Description
1426 -- This function returns the mkt_max_salary
1427 --
1428 function get_mkt_max_salary(p_person_id in number
1429 ,p_assignment_id in number
1430 ,p_legislation_code in varchar2
1431 ,p_group_pl_id in number
1432 ,p_lf_evt_ocrd_dt in date
1433 ,p_effective_date in date
1434 ,p_mkt_max_salary in number)
1435
1436 return number is
1437 --
1438 l_proc varchar2(72) := g_package||'get_mkt_max_salary';
1439 --
1440 begin
1441 --
1442 if g_debug then
1443 hr_utility.set_location('Entering:'|| l_proc, 10);
1444 end if;
1445 --
1446 -- Customer can override p_mkt_max_salary here
1447 return p_mkt_max_salary;
1448 --
1449 if g_debug then
1450 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1451 end if;
1452 --
1453
1454 exception
1455 when others then
1456 hr_utility.set_location('Exception in '|| l_proc, 99);
1457 raise;
1458
1459 end;
1460
1461
1462 --------------------------------------------------------------------------
1463 -- |---------------------------< get_mkt_emp_pct_in_range >---------------------------|
1464 -- --------------------------------------------------------------------------
1465 -- Description
1466 -- This function returns the mkt_emp_pct_in_range
1467 --
1468 function get_mkt_emp_pct_in_range(p_person_id in number
1469 ,p_assignment_id in number
1470 ,p_legislation_code in varchar2
1471 ,p_group_pl_id in number
1472 ,p_lf_evt_ocrd_dt in date
1473 ,p_effective_date in date
1474 ,p_mkt_emp_pct_in_range in number)
1475
1476 return number is
1477 --
1478 l_proc varchar2(72) := g_package||'get_mkt_emp_pct_in_range';
1479 --
1480 begin
1481 --
1482 if g_debug then
1483 hr_utility.set_location('Entering:'|| l_proc, 10);
1484 end if;
1485 --
1486 -- Customer can override p_mkt_emp_pct_in_range here
1487 return p_mkt_emp_pct_in_range;
1488 --
1489 if g_debug then
1490 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1491 end if;
1492 --
1493
1494 exception
1495 when others then
1496 hr_utility.set_location('Exception in '|| l_proc, 99);
1497 raise;
1498
1499 end;
1500
1501 --------------------------------------------------------------------------
1502 -- |---------------------------< get_mkt_emp_comparatio >---------------------------|
1503 -- --------------------------------------------------------------------------
1504 -- Description
1505 -- This function returns the mkt_emp_comparatio
1506 --
1507 function get_mkt_emp_comparatio(p_person_id in number
1508 ,p_assignment_id in number
1509 ,p_legislation_code in varchar2
1510 ,p_group_pl_id in number
1511 ,p_lf_evt_ocrd_dt in date
1512 ,p_effective_date in date
1513 ,p_mkt_emp_comparatio in number)
1514
1515 return number is
1516 --
1517 l_proc varchar2(72) := g_package||'get_mkt_emp_comparatio';
1518 --
1519 begin
1520 --
1521 if g_debug then
1522 hr_utility.set_location('Entering:'|| l_proc, 10);
1523 end if;
1524 --
1525 -- Customer can override p_mkt_emp_comparatio here
1526 return p_mkt_emp_comparatio;
1527 --
1528 if g_debug then
1529 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1530 end if;
1531 --
1532
1533 exception
1534 when others then
1535 hr_utility.set_location('Exception in '|| l_proc, 99);
1536 raise;
1537
1538 end;
1539
1540 --------------------------------------------------------------------------
1541 -- |---------------------------< get_mkt_survey_id >---------------------------|
1542 -- --------------------------------------------------------------------------
1543 -- Description
1544 -- This function returns the mkt_survey_id
1545 --
1546 function get_mkt_survey_id(p_person_id in number
1547 ,p_assignment_id in number
1548 ,p_legislation_code in varchar2
1549 ,p_group_pl_id in number
1550 ,p_lf_evt_ocrd_dt in date
1551 ,p_effective_date in date
1552 ,p_mkt_survey_id in number)
1553
1554 return number is
1555 --
1556 l_proc varchar2(72) := g_package||'get_mkt_survey_id';
1557 --
1558 begin
1559 --
1560 if g_debug then
1561 hr_utility.set_location('Entering:'|| l_proc, 10);
1562 end if;
1563 --
1564 -- Customer can override p_mkt_survey_id here
1565
1566 return p_mkt_survey_id;
1567 --
1568 if g_debug then
1569 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1570 end if;
1571 --
1572
1573 exception
1574 when others then
1575 hr_utility.set_location('Exception in '|| l_proc, 99);
1576 raise;
1577
1578 end;
1579 ----
1583 -- Description
1580 ---------------------------------------------------
1581 -- |---------------------------< get_grd_comparatio >---------------------------|
1582 -- --------------------------------------------------------------------------
1584 -- This function returns the grd_comparatio
1585 --
1586 function get_grd_comparatio(p_person_id in number
1587 ,p_assignment_id in number
1588 ,p_legislation_code in varchar2
1589 ,p_group_pl_id in number
1590 ,p_lf_evt_ocrd_dt in date
1591 ,p_effective_date in date
1592 ,p_grd_comparatio in number)
1593
1594 return number is
1595 --
1596 l_proc varchar2(72) := g_package||'get_grd_comparatio';
1597 --
1598
1599 begin
1600 --
1601 if g_debug then
1602 hr_utility.set_location('Entering:'|| l_proc, 10);
1603 end if;
1604 --
1605 -- Customer can override p_grd_comparatio here
1606 return p_grd_comparatio;
1607 --
1608 if g_debug then
1609 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1610 end if;
1611 --
1612
1613 exception
1614 when others then
1615 hr_utility.set_location('Exception in '|| l_proc, 99);
1616 raise;
1617
1618 end;
1619
1620 --------------------------------------------------------------------------
1621 -- |---------------------------< get_normal_hours >---------------------------|
1622 -- --------------------------------------------------------------------------
1623 -- Description
1624 -- This function returns the normal_hours
1625 --
1626 function get_normal_hours(p_person_id in number
1627 ,p_assignment_id in number
1628 ,p_legislation_code in varchar2
1629 ,p_group_pl_id in number
1630 ,p_lf_evt_ocrd_dt in date
1631 ,p_effective_date in date
1632 ,p_normal_hours in number)
1633
1634 return number is
1635 --
1636 l_proc varchar2(72) := g_package||'get_normal_hours';
1637 --
1638
1639 begin
1640 --
1641 if g_debug then
1642 hr_utility.set_location('Entering:'|| l_proc, 10);
1643 end if;
1644 --
1645 -- Customer can override p_normal_hours here
1646 return p_normal_hours;
1647 --
1648 if g_debug then
1649 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1650 end if;
1651 --
1652
1653 exception
1654 when others then
1655 hr_utility.set_location('Exception in '|| l_proc, 99);
1656 raise;
1657
1658 end;
1659
1660 --------------------------------------------------------------------------
1661 -- |---------------------------< get_performance_rating_date >---------------------|
1662 -- --------------------------------------------------------------------------
1663 -- Description
1664 -- This function returns the performance_rating_date
1665 --
1666 function get_performance_rating_date(p_person_id in number
1667 ,p_assignment_id in number
1668 ,p_legislation_code in varchar2
1669 ,p_group_pl_id in number
1670 ,p_lf_evt_ocrd_dt in date
1671 ,p_effective_date in date
1672 ,p_performance_rating_date in date)
1673
1674 return date is
1675 --
1676 l_proc varchar2(72) := g_package||'get_performance_rating_date';
1677 --
1678 begin
1679 --
1680 if g_debug then
1681 hr_utility.set_location('Entering:'|| l_proc, 10);
1682 end if;
1683 --
1684 -- Customer can override p_performance_rating_date here
1685 return p_performance_rating_date;
1686 --
1687 if g_debug then
1688 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1689 end if;
1690 --
1691
1692 exception
1693 when others then
1694 hr_utility.set_location('Exception in '|| l_proc, 99);
1695 raise;
1696
1697 end;
1698
1699 --------------------------------------------------------------------------
1700 -- |---------------------------< get_start_date>---------------------|
1701 -- --------------------------------------------------------------------------
1702 -- Description
1703 -- This function returns the start_date
1704 --
1705 function get_start_date(p_person_id in number
1706 ,p_assignment_id in number
1707 ,p_legislation_code in varchar2
1708 ,p_group_pl_id in number
1709 ,p_lf_evt_ocrd_dt in date
1710 ,p_effective_date in date
1711 ,p_start_date in date)
1712
1713 return date is
1714 --
1715 l_proc varchar2(72) := g_package||'get_start_date';
1716 --
1717
1718 begin
1719 --
1720 if g_debug then
1721 hr_utility.set_location('Entering:'|| l_proc, 10);
1722 end if;
1723 --
1724 -- Customer can override p_start_date here
1725 return p_start_date;
1726 --
1727 if g_debug then
1728 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1729 end if;
1730 --
1731
1732 exception
1733 when others then
1734 hr_utility.set_location('Exception in '|| l_proc, 99);
1735 raise;
1736
1737 end;
1738
1739 --------------------------------------------------------------------------
1740 -- |---------------------------< get_original_start_date >---------------------|
1741 -- --------------------------------------------------------------------------
1745 function get_original_start_date(p_person_id in number
1742 -- Description
1743 -- This function returns the original_start_date
1744 --
1746 ,p_assignment_id in number
1747 ,p_legislation_code in varchar2
1748 ,p_group_pl_id in number
1749 ,p_lf_evt_ocrd_dt in date
1750 ,p_effective_date in date
1751 ,p_original_start_date in date)
1752
1753 return date is
1754 --
1755 l_proc varchar2(72) := g_package||'get_original_start_date';
1756 --
1757
1758 begin
1759 --
1760 if g_debug then
1761 hr_utility.set_location('Entering:'|| l_proc, 10);
1762 end if;
1763 --
1764 -- Customer can override p_original_start_date here
1765 return p_original_start_date;
1766 --
1767 if g_debug then
1768 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1769 end if;
1770 --
1771
1772 exception
1773 when others then
1774 hr_utility.set_location('Exception in '|| l_proc, 99);
1775 raise;
1776
1777 end;
1778
1779 --------------------------------------------------------------------------
1780 -- |---------------------------< get_adjusted_svc_date >---------------------|
1781 -- --------------------------------------------------------------------------
1782 -- Description
1783 -- This function returns the adjusted_svc_date
1784 --
1785 function get_adjusted_svc_date(p_person_id in number
1786 ,p_assignment_id in number
1787 ,p_legislation_code in varchar2
1788 ,p_group_pl_id in number
1789 ,p_lf_evt_ocrd_dt in date
1790 ,p_effective_date in date
1791 ,p_adjusted_svc_date in date)
1792
1793 return date is
1794 --
1795 l_proc varchar2(72) := g_package||'get_adjusted_svc_date';
1796 --
1797 begin
1798 --
1799 if g_debug then
1800 hr_utility.set_location('Entering:'|| l_proc, 10);
1801 end if;
1802 --
1803 -- Customer can override p_adjusted_svc_date here
1804 return p_adjusted_svc_date;
1805 --
1806 if g_debug then
1807 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1808 end if;
1809 --
1810
1811 exception
1812 when others then
1813 hr_utility.set_location('Exception in '|| l_proc, 99);
1814 raise;
1815
1816 end;
1817
1818 --------------------------------------------------------------------------
1819 -- |---------------------------< get_prev_sal_chg_date >---------------------|
1820 -- --------------------------------------------------------------------------
1821 -- Description
1822 -- This function returns the prev_sal_chg_date
1823 --
1824 function get_prev_sal_chg_date(p_person_id in number
1825 ,p_assignment_id in number
1826 ,p_legislation_code in varchar2
1827 ,p_group_pl_id in number
1828 ,p_lf_evt_ocrd_dt in date
1829 ,p_effective_date in date
1830 ,p_prev_sal_chg_date in date)
1831
1832 return date is
1833 --
1834 l_proc varchar2(72) := g_package||'get_prev_sal_chg_date';
1835 --
1836 begin
1837 --
1838 if g_debug then
1839 hr_utility.set_location('Entering:'|| l_proc, 10);
1840 end if;
1841 --
1842 -- Customer can override p_prev_sal_chg_date here
1843 return p_prev_sal_chg_date;
1844 --
1845 if g_debug then
1846 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1847 end if;
1848 --
1849
1850 exception
1851 when others then
1852 hr_utility.set_location('Exception in '|| l_proc, 99);
1853 raise;
1854
1855 end;
1856 --------------------------------------------------------------------------
1857 -- |---------------------------< get_feedback_date >---------------------|
1858 -- --------------------------------------------------------------------------
1859 -- Description
1860 -- This function returns the feedback_date
1861 --
1862 function get_feedback_date(p_person_id in number
1863 ,p_assignment_id in number
1864 ,p_legislation_code in varchar2
1865 ,p_group_pl_id in number
1866 ,p_lf_evt_ocrd_dt in date
1867 ,p_effective_date in date
1868 ,p_feedback_date in date)
1869
1870 return date is
1871 --
1872 l_proc varchar2(72) := g_package||'get_feedback_date';
1873 --
1874
1875 begin
1876 --
1877 if g_debug then
1878 hr_utility.set_location('Entering:'|| l_proc, 10);
1879 end if;
1880 --
1881 -- Customer can override p_feedback_date here
1882 return p_feedback_date;
1883 --
1884 if g_debug then
1885 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1886 end if;
1887 --
1888
1889 exception
1890 when others then
1891 hr_utility.set_location('Exception in '|| l_proc, 99);
1892 raise;
1893
1894 end;
1895
1896 --------------------------------------------------------------------------
1897 -- |---------------------------< get_base_salary_change_date >---------------------|
1898 -- --------------------------------------------------------------------------
1899 -- Description
1900 -- This function returns the base_salary_change_date
1901 --
1902 function get_base_salary_change_date(p_person_id in number
1906 ,p_lf_evt_ocrd_dt in date
1903 ,p_assignment_id in number
1904 ,p_legislation_code in varchar2
1905 ,p_group_pl_id in number
1907 ,p_effective_date in date
1908 ,p_base_salary_change_date in date)
1909
1910 return date is
1911 --
1912 l_proc varchar2(72) := g_package||'get_base_salary_change_date';
1913 --
1914 begin
1915 --
1916 if g_debug then
1917 hr_utility.set_location('Entering:'|| l_proc, 10);
1918 end if;
1919 --
1920 -- Customer can override p_base_salary_change_date here
1921 return p_base_salary_change_date;
1922 --
1923 if g_debug then
1924 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1925 end if;
1926 --
1927
1928 exception
1929 when others then
1930 hr_utility.set_location('Exception in '|| l_proc, 99);
1931 raise;
1932
1933 end;
1934
1935 -- --------------------------------------------------------------------------
1936 -- |-------------------------< get_full_name >-------------------------|
1937 -- --------------------------------------------------------------------------
1938 -- Description
1939 -- This function returns the full_name
1940 --
1941 function get_full_name(p_person_id in number
1942 ,p_assignment_id in number
1943 ,p_legislation_code in varchar2
1944 ,p_group_pl_id in number
1945 ,p_lf_evt_ocrd_dt in date
1946 ,p_effective_date in date
1947 ,p_full_name in varchar2)
1948 return varchar2 is
1949 --
1950 l_proc varchar2(72) := g_package||'get_full_name';
1951 --
1952
1953 begin
1954 --
1955 if g_debug then
1956 hr_utility.set_location('Entering:'|| l_proc, 10);
1957 end if;
1958 --
1959 -- Customer can override p_full_name here
1960 return p_full_name;
1961 --
1962 if g_debug then
1963 hr_utility.set_location(' Leaving:'|| l_proc, 99);
1964 end if;
1965 --
1966
1967 exception
1968 when others then
1969 hr_utility.set_location('Exception in '|| l_proc, 99);
1970 raise;
1971
1972 end;
1973 --
1974 -- --------------------------------------------------------------------------
1975 -- |-------------------------< get_brief_name >-------------------------|
1976 -- --------------------------------------------------------------------------
1977 -- Description
1978 -- This function returns the brief_name
1979 --
1980 function get_brief_name(p_person_id in number
1981 ,p_assignment_id in number
1982 ,p_legislation_code in varchar2
1983 ,p_group_pl_id in number
1984 ,p_lf_evt_ocrd_dt in date
1985 ,p_effective_date in date
1986 ,p_brief_name in varchar2)
1987 return varchar2 is
1988 --
1989 l_proc varchar2(72) := g_package||'get_brief_name';
1990 --
1991 begin
1992 --
1993 if g_debug then
1994 hr_utility.set_location('Entering:'|| l_proc, 10);
1995 end if;
1996 --
1997 -- Customer can override p_brief_name here
1998 return p_brief_name;
1999 --
2000 if g_debug then
2001 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2002 end if;
2003 --
2004
2005 exception
2006 when others then
2007 hr_utility.set_location('Exception in '|| l_proc, 99);
2008 raise;
2009
2010 end;
2011 -- --------------------------------------------------------------------------
2012 -- |-------------------------< get_supervisor_full_name >-------------------------|
2013 -- --------------------------------------------------------------------------
2014 -- Description
2015 -- This function returns the supervisor_full_name
2016 --
2017 function get_supervisor_full_name(p_person_id in number
2018 ,p_assignment_id in number
2019 ,p_legislation_code in varchar2
2020 ,p_group_pl_id in number
2021 ,p_lf_evt_ocrd_dt in date
2022 ,p_effective_date in date
2023 ,p_supervisor_full_name in varchar2)
2024 return varchar2 is
2025 --
2026 l_proc varchar2(72) := g_package||'get_supervisor_full_name';
2027 --
2028 begin
2029 --
2030 if g_debug then
2031 hr_utility.set_location('Entering:'|| l_proc, 10);
2032 end if;
2033 --
2034 -- Customer can override p_supervisor_full_name here
2035 return p_supervisor_full_name;
2036 --
2037 if g_debug then
2038 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2039 end if;
2040 --
2041
2042 exception
2043 when others then
2044 hr_utility.set_location('Exception in '|| l_proc, 99);
2045 raise;
2046
2047 end;
2048 -- --------------------------------------------------------------------------
2049 -- |-------------------------< get_supervisor_brief_name>-------------------------|
2050 -- --------------------------------------------------------------------------
2051 -- Description
2052 -- This function returns the supervisor_brief_name
2053 --
2054 function get_supervisor_brief_name(p_person_id in number
2055 ,p_assignment_id in number
2056 ,p_legislation_code in varchar2
2057 ,p_group_pl_id in number
2061 return varchar2 is
2058 ,p_lf_evt_ocrd_dt in date
2059 ,p_effective_date in date
2060 ,p_supervisor_brief_name in varchar2)
2062 --
2063 l_proc varchar2(72) := g_package||'get_supervisor_brief_name';
2064 --
2065 begin
2066 --
2067 if g_debug then
2068 hr_utility.set_location('Entering:'|| l_proc, 10);
2069 end if;
2070 --
2071 -- Customer can override p_supervisor_brief_name here
2072 return p_supervisor_brief_name;
2073 --
2074 if g_debug then
2075 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2076 end if;
2077 --
2078
2079 exception
2080 when others then
2081 hr_utility.set_location('Exception in '|| l_proc, 99);
2082 raise;
2083
2084 end;
2085 -- --------------------------------------------------------------------------
2086 -- |-------------------------< get_supervisor_custom_name >-------------------------|
2087 -- --------------------------------------------------------------------------
2088 -- Description
2089 -- This function returns the supervisor_custom_name
2090 --
2091 function get_supervisor_custom_name(p_person_id in number
2092 ,p_assignment_id in number
2093 ,p_legislation_code in varchar2
2094 ,p_group_pl_id in number
2095 ,p_lf_evt_ocrd_dt in date
2096 ,p_effective_date in date
2097 ,p_supervisor_custom_name in varchar2)
2098 return varchar2 is
2099 --
2100 l_proc varchar2(72) := g_package||'get_supervisor_custom_name';
2101 --
2102 begin
2103 --
2104 if g_debug then
2105 hr_utility.set_location('Entering:'|| l_proc, 10);
2106 end if;
2107 --
2108 -- Customer can override p_supervisor_custom_name here
2109 return p_supervisor_custom_name;
2110 --
2111 if g_debug then
2112 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2113 end if;
2114 --
2115
2116 exception
2117 when others then
2118 hr_utility.set_location('Exception in '|| l_proc, 99);
2119 raise;
2120
2121 end;
2122 -- --------------------------------------------------------------------------
2123 -- |-------------------------< get_payroll_name >-------------------------|
2124 -- --------------------------------------------------------------------------
2125 -- Description
2126 -- This function returns the payroll_name
2127 --
2128 function get_payroll_name(p_person_id in number
2129 ,p_assignment_id in number
2130 ,p_legislation_code in varchar2
2131 ,p_group_pl_id in number
2132 ,p_lf_evt_ocrd_dt in date
2133 ,p_effective_date in date
2134 ,p_payroll_name in varchar2)
2135 return varchar2 is
2136 --
2137 l_proc varchar2(72) := g_package||'get_payroll_name';
2138 --
2139 begin
2140 --
2141 if g_debug then
2142 hr_utility.set_location('Entering:'|| l_proc, 10);
2143 end if;
2144 --
2145 -- Customer can override p_payroll_name here
2146 return p_payroll_name;
2147 --
2148 if g_debug then
2149 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2150 end if;
2151 --
2152
2153 exception
2154 when others then
2155 hr_utility.set_location('Exception in '|| l_proc, 99);
2156 raise;
2157
2158 end;
2159 -- --------------------------------------------------------------------------
2160 -- |-------------------------< get_performance_rating >-------------------------|
2161 -- --------------------------------------------------------------------------
2162 -- Description
2163 -- This function returns the performance_rating
2164 --
2165 function get_performance_rating(p_person_id in number
2166 ,p_assignment_id in number
2167 ,p_legislation_code in varchar2
2168 ,p_group_pl_id in number
2169 ,p_lf_evt_ocrd_dt in date
2170 ,p_effective_date in date
2171 ,p_performance_rating in varchar2)
2172 return varchar2 is
2173 --
2174 l_proc varchar2(72) := g_package||'get_performance_rating';
2175 --
2176
2177 begin
2178 --
2179 if g_debug then
2180 hr_utility.set_location('Entering:'|| l_proc, 10);
2181 end if;
2182 --
2183 -- Customer can override p_performance_rating here
2184 return p_performance_rating;
2185 --
2186 if g_debug then
2187 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2188 end if;
2189 --
2190
2191 exception
2192 when others then
2193 hr_utility.set_location('Exception in '|| l_proc, 99);
2194 raise;
2195
2196 end;
2197 -- --------------------------------------------------------------------------
2198 -- |-------------------------< get_performance_rating_type >-------------------------|
2199 -- --------------------------------------------------------------------------
2200 -- Description
2201 -- This function returns the performance_rating_type
2202 --
2203 function get_performance_rating_type(p_person_id in number
2204 ,p_assignment_id in number
2205 ,p_legislation_code in varchar2
2206 ,p_group_pl_id in number
2207 ,p_lf_evt_ocrd_dt in date
2208 ,p_effective_date in date
2212 l_proc varchar2(72) := g_package||'get_performance_rating_type';
2209 ,p_performance_rating_type in varchar2)
2210 return varchar2 is
2211 --
2213 --
2214 begin
2215 --
2216 if g_debug then
2217 hr_utility.set_location('Entering:'|| l_proc, 10);
2218 end if;
2219 --
2220 -- Customer can override p_performance_rating_type here
2221 return p_performance_rating_type;
2222 --
2223 if g_debug then
2224 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2225 end if;
2226 --
2227
2228 exception
2229 when others then
2230 hr_utility.set_location('Exception in '|| l_proc, 99);
2231 raise;
2232
2233 end;
2234 -- --------------------------------------------------------------------------
2235 -- |-------------------------< get_frequency >-------------------------|
2236 -- --------------------------------------------------------------------------
2237 -- Description
2238 -- This function returns the frequency
2239 --
2240 function get_frequency(p_person_id in number
2241 ,p_assignment_id in number
2242 ,p_legislation_code in varchar2
2243 ,p_group_pl_id in number
2244 ,p_lf_evt_ocrd_dt in date
2245 ,p_effective_date in date
2246 ,p_frequency in varchar2)
2247 return varchar2 is
2248 --
2249 l_proc varchar2(72) := g_package||'get_frequency';
2250 --
2251 begin
2252 --
2253 if g_debug then
2254 hr_utility.set_location('Entering:'|| l_proc, 10);
2255 end if;
2256 --
2257 -- Customer can override p_frequency here
2258 return p_frequency;
2259 --
2260 if g_debug then
2261 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2262 end if;
2263 --
2264
2265 exception
2266 when others then
2267 hr_utility.set_location('Exception in '|| l_proc, 99);
2268 raise;
2269
2270 end;
2271 -- --------------------------------------------------------------------------
2272 -- |-------------------------< get_grd_quartile >-------------------------|
2273 -- --------------------------------------------------------------------------
2274 -- Description
2275 -- This function returns the grd_quartile
2276 --
2277 function get_grd_quartile(p_person_id in number
2278 ,p_assignment_id in number
2279 ,p_legislation_code in varchar2
2280 ,p_group_pl_id in number
2281 ,p_lf_evt_ocrd_dt in date
2282 ,p_effective_date in date
2283 ,p_grd_quartile in varchar2)
2284 return varchar2 is
2285 --
2286 l_proc varchar2(72) := g_package||'get_grd_quartile';
2287 --
2288 begin
2289 --
2290 if g_debug then
2291 hr_utility.set_location('Entering:'|| l_proc, 10);
2292 end if;
2293 --
2294 -- Customer can override p_grd_quartile here
2295 return p_grd_quartile;
2296 --
2297 if g_debug then
2298 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2299 end if;
2300 --
2301
2302 exception
2303 when others then
2304 hr_utility.set_location('Exception in '|| l_proc, 99);
2305 raise;
2306
2307 end;
2308 -- --------------------------------------------------------------------------
2309 -- |-------------------------< get_emp_category >-------------------------|
2310 -- --------------------------------------------------------------------------
2311 -- Description
2312 -- This function returns the emp_category
2313 --
2314 function get_emp_category(p_person_id in number
2315 ,p_assignment_id in number
2316 ,p_legislation_code in varchar2
2317 ,p_group_pl_id in number
2318 ,p_lf_evt_ocrd_dt in date
2319 ,p_effective_date in date
2320 ,p_emp_category in varchar2)
2321 return varchar2 is
2322 --
2323 l_proc varchar2(72) := g_package||'get_emp_category';
2324 --
2325 begin
2326 --
2327 if g_debug then
2328 hr_utility.set_location('Entering:'|| l_proc, 10);
2329 end if;
2330 --
2331 -- Customer can override p_emp_category here
2332 return p_emp_category;
2333 --
2334 if g_debug then
2335 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2336 end if;
2337 --
2338
2339 exception
2340 when others then
2341 hr_utility.set_location('Exception in '|| l_proc, 99);
2342 raise;
2343
2344 end;
2345 -- --------------------------------------------------------------------------
2346 -- |-------------------------< get_change_reason >-------------------------|
2347 -- --------------------------------------------------------------------------
2348 -- Description
2349 -- This function returns the change_reason
2350 --
2351 function get_change_reason(p_person_id in number
2352 ,p_assignment_id in number
2353 ,p_legislation_code in varchar2
2354 ,p_group_pl_id in number
2355 ,p_lf_evt_ocrd_dt in date
2356 ,p_effective_date in date
2357 ,p_change_reason in varchar2)
2358 return varchar2 is
2359 --
2360 l_proc varchar2(72) := g_package||'get_change_reason';
2361 --
2362 begin
2363 --
2364 if g_debug then
2368 -- Customer can override p_change_reason here
2365 hr_utility.set_location('Entering:'|| l_proc, 10);
2366 end if;
2367 --
2369 return p_change_reason;
2370 --
2371 if g_debug then
2372 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2373 end if;
2374 --
2375
2376 exception
2377 when others then
2378 hr_utility.set_location('Exception in '|| l_proc, 99);
2379 raise;
2380
2381 end;
2382 -- --------------------------------------------------------------------------
2383 -- |-------------------------< get_email_address >-------------------------|
2384 -- --------------------------------------------------------------------------
2385 -- Description
2386 -- This function returns the email_address
2387 --
2388 function get_email_address(p_person_id in number
2389 ,p_assignment_id in number
2390 ,p_legislation_code in varchar2
2391 ,p_group_pl_id in number
2392 ,p_lf_evt_ocrd_dt in date
2393 ,p_effective_date in date
2394 ,p_email_address in varchar2)
2395 return varchar2 is
2396 --
2397 l_proc varchar2(72) := g_package||'get_email_address';
2398 --
2399 begin
2400 --
2401 if g_debug then
2402 hr_utility.set_location('Entering:'|| l_proc, 10);
2403 end if;
2404 --
2405 -- Customer can override p_email_address here
2406 return p_email_address;
2407 --
2408 if g_debug then
2409 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2410 end if;
2411 --
2412
2413 exception
2414 when others then
2415 hr_utility.set_location('Exception in '|| l_proc, 99);
2416 raise;
2417
2418 end;
2419 -- --------------------------------------------------------------------------
2420 -- |-------------------------< get_base_salary_frequency >-------------------------|
2421 -- --------------------------------------------------------------------------
2422 -- Description
2423 -- This function returns the base_salary_frequency
2424 --
2425 function get_base_salary_frequency(p_person_id in number
2426 ,p_assignment_id in number
2427 ,p_legislation_code in varchar2
2428 ,p_group_pl_id in number
2429 ,p_lf_evt_ocrd_dt in date
2430 ,p_effective_date in date
2431 ,p_base_salary_frequency in varchar2)
2432 return varchar2 is
2433 --
2434 l_proc varchar2(72) := g_package||'get_base_salary_frequency';
2435 --
2436 begin
2437 --
2438 if g_debug then
2439 hr_utility.set_location('Entering:'|| l_proc, 10);
2440 end if;
2441 --
2442 -- Customer can override p_base_salary_frequency here
2443 return p_base_salary_frequency;
2444 --
2445 if g_debug then
2446 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2447 end if;
2448 --
2449
2450 exception
2451 when others then
2452 hr_utility.set_location('Exception in '|| l_proc, 99);
2453 raise;
2454
2455 end;
2456 -- --------------------------------------------------------------------------
2457 -- |-------------------------< get_post_process_stat_cd >-------------------------|
2458 -- --------------------------------------------------------------------------
2459 -- Description
2460 -- This function returns the post_process_stat_cd
2461 --
2462 function get_post_process_stat_cd(p_person_id in number
2463 ,p_assignment_id in number
2464 ,p_legislation_code in varchar2
2465 ,p_group_pl_id in number
2466 ,p_lf_evt_ocrd_dt in date
2467 ,p_effective_date in date
2468 ,p_post_process_stat_cd in varchar2)
2469 return varchar2 is
2470 --
2471 l_proc varchar2(72) := g_package||'get_post_process_stat_cd';
2472 --
2473 begin
2474 --
2475 if g_debug then
2476 hr_utility.set_location('Entering:'|| l_proc, 10);
2477 end if;
2478 --
2479 -- Customer can override p_post_process_stat_cd here
2480 return p_post_process_stat_cd;
2481 --
2482 if g_debug then
2483 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2484 end if;
2485 --
2486
2487 exception
2488 when others then
2489 hr_utility.set_location('Exception in '|| l_proc, 99);
2490 raise;
2491
2492 end;
2493 -- --------------------------------------------------------------------------
2494 -- |-------------------------< get_feedback_rating >-------------------------|
2495 -- --------------------------------------------------------------------------
2496 -- Description
2497 -- This function returns the feedback_rating
2498 --
2499 function get_feedback_rating(p_person_id in number
2500 ,p_assignment_id in number
2501 ,p_legislation_code in varchar2
2502 ,p_group_pl_id in number
2503 ,p_lf_evt_ocrd_dt in date
2504 ,p_effective_date in date
2505 ,p_feedback_rating in varchar2)
2506 return varchar2 is
2507 --
2508 l_proc varchar2(72) := g_package||'get_feedback_rating';
2509 --
2510 begin
2511 --
2512 if g_debug then
2513 hr_utility.set_location('Entering:'|| l_proc, 10);
2514 end if;
2515 --
2516 -- Customer can override p_feedback_rating here
2517 return p_feedback_rating;
2518 --
2522 --
2519 if g_debug then
2520 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2521 end if;
2523
2524 exception
2525 when others then
2526 hr_utility.set_location('Exception in '|| l_proc, 99);
2527 raise;
2528
2529 end;
2530 -- --------------------------------------------------------------------------
2531 -- |-------------------------< get_feedback_comments >-------------------------|
2532 -- --------------------------------------------------------------------------
2533 -- Description
2534 -- This function returns the feedback_comments
2535 --
2536 function get_feedback_comments(p_person_id in number
2537 ,p_assignment_id in number
2538 ,p_legislation_code in varchar2
2539 ,p_group_pl_id in number
2540 ,p_lf_evt_ocrd_dt in date
2541 ,p_effective_date in date
2542 ,p_feedback_comments in varchar2)
2543 return varchar2 is
2544 --
2545 l_proc varchar2(72) := g_package||'get_feedback_comments';
2546 --
2547 begin
2548 --
2549 if g_debug then
2550 hr_utility.set_location('Entering:'|| l_proc, 10);
2551 end if;
2552 --
2553 -- Customer can override p_feedback_comments here
2554 return p_feedback_comments;
2555 --
2556 if g_debug then
2557 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2558 end if;
2559 --
2560
2561 exception
2562 when others then
2563 hr_utility.set_location('Exception in '|| l_proc, 99);
2564 raise;
2565
2566 end;
2567 -- --------------------------------------------------------------------------
2568 -- |-------------------------< get_people_group_name >-------------------------|
2569 -- --------------------------------------------------------------------------
2570 -- Description
2571 -- This function returns the people_group_name
2572 --
2573 function get_people_group_name(p_person_id in number
2574 ,p_assignment_id in number
2575 ,p_legislation_code in varchar2
2576 ,p_group_pl_id in number
2577 ,p_lf_evt_ocrd_dt in date
2578 ,p_effective_date in date
2579 ,p_people_group_name in varchar2)
2580 return varchar2 is
2581 --
2582 l_proc varchar2(72) := g_package||'get_people_group_name';
2583 --
2584 begin
2585 --
2586 if g_debug then
2587 hr_utility.set_location('Entering:'|| l_proc, 10);
2588 end if;
2589 --
2590 -- Customer can override p_people_group_name here
2591 return p_people_group_name;
2592 --
2593 if g_debug then
2594 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2595 end if;
2596 --
2597
2598 exception
2599 when others then
2600 hr_utility.set_location('Exception in '|| l_proc, 99);
2601 raise;
2602
2603 end;
2604 -- --------------------------------------------------------------------------
2605 -- |-------------------------< get_people_group_segment1>-------------------------|
2606 -- --------------------------------------------------------------------------
2607 -- Description
2608 -- This function returns the people_group_segment1
2609 --
2610 function get_people_group_segment1(p_person_id in number
2611 ,p_assignment_id in number
2612 ,p_legislation_code in varchar2
2613 ,p_group_pl_id in number
2614 ,p_lf_evt_ocrd_dt in date
2615 ,p_effective_date in date
2616 ,p_people_group_segment1 in varchar2)
2617 return varchar2 is
2618 --
2619 l_proc varchar2(72) := g_package||'get_people_group_segment1';
2620 --
2621 begin
2622 --
2623 if g_debug then
2624 hr_utility.set_location('Entering:'|| l_proc, 10);
2625 end if;
2626 --
2627 -- Customer can override p_people_group_segment1 here
2628 return p_people_group_segment1;
2629 --
2630 if g_debug then
2631 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2632 end if;
2633 --
2634
2635 exception
2636 when others then
2637 hr_utility.set_location('Exception in '|| l_proc, 99);
2638 raise;
2639
2640 end;
2641 -- --------------------------------------------------------------------------
2642 -- |-------------------------< get_people_group_segment2 >-------------------------|
2643 -- --------------------------------------------------------------------------
2644 -- Description
2645 -- This function returns the people_group_segment2
2646 --
2647 function get_people_group_segment2(p_person_id in number
2648 ,p_assignment_id in number
2649 ,p_legislation_code in varchar2
2650 ,p_group_pl_id in number
2651 ,p_lf_evt_ocrd_dt in date
2652 ,p_effective_date in date
2653 ,p_people_group_segment2 in varchar2)
2654 return varchar2 is
2655 --
2656 l_proc varchar2(72) := g_package||'get_people_group_segment2';
2657 --
2658 begin
2659 --
2660 if g_debug then
2661 hr_utility.set_location('Entering:'|| l_proc, 10);
2662 end if;
2663 --
2664 -- Customer can override p_people_group_segment2 here
2665 return p_people_group_segment2;
2666 --
2667 if g_debug then
2668 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2669 end if;
2670 --
2671
2672 exception
2676
2673 when others then
2674 hr_utility.set_location('Exception in '|| l_proc, 99);
2675 raise;
2677 end;
2678 -- --------------------------------------------------------------------------
2679 -- |-------------------------< get_people_group_segment3 >-------------------------|
2680 -- --------------------------------------------------------------------------
2681 -- Description
2682 -- This function returns the people_group_segment3
2683 --
2684 function get_people_group_segment3(p_person_id in number
2685 ,p_assignment_id in number
2686 ,p_legislation_code in varchar2
2687 ,p_group_pl_id in number
2688 ,p_lf_evt_ocrd_dt in date
2689 ,p_effective_date in date
2690 ,p_people_group_segment3 in varchar2)
2691 return varchar2 is
2692 --
2693 l_proc varchar2(72) := g_package||'get_people_group_segment3';
2694 --
2695 begin
2696 --
2697 if g_debug then
2698 hr_utility.set_location('Entering:'|| l_proc, 10);
2699 end if;
2700 --
2701 -- Customer can override p_people_group_segment3 here
2702 return p_people_group_segment3;
2703 --
2704 if g_debug then
2705 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2706 end if;
2707 --
2708
2709 exception
2710 when others then
2711 hr_utility.set_location('Exception in '|| l_proc, 99);
2712 raise;
2713
2714 end;
2715 -- --------------------------------------------------------------------------
2716 -- |-------------------------< get_people_group_segment4 >-------------------------|
2717 -- --------------------------------------------------------------------------
2718 -- Description
2719 -- This function returns the people_group_segment4
2720 --
2721 function get_people_group_segment4(p_person_id in number
2722 ,p_assignment_id in number
2723 ,p_legislation_code in varchar2
2724 ,p_group_pl_id in number
2725 ,p_lf_evt_ocrd_dt in date
2726 ,p_effective_date in date
2727 ,p_people_group_segment4 in varchar2)
2728 return varchar2 is
2729 --
2730 l_proc varchar2(72) := g_package||'get_people_group_segment4';
2731 --
2732 begin
2733 --
2734 if g_debug then
2735 hr_utility.set_location('Entering:'|| l_proc, 10);
2736 end if;
2737 --
2738 -- Customer can override p_people_group_segment4 here
2739 return p_people_group_segment4;
2740 --
2741 if g_debug then
2742 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2743 end if;
2744 --
2745
2746 exception
2747 when others then
2748 hr_utility.set_location('Exception in '|| l_proc, 99);
2749 raise;
2750
2751 end;
2752 -- --------------------------------------------------------------------------
2753 -- |-------------------------< get_people_group_segment5 >-------------------------|
2754 -- --------------------------------------------------------------------------
2755 -- Description
2756 -- This function returns the people_group_segment5
2757 --
2758 function get_people_group_segment5(p_person_id in number
2759 ,p_assignment_id in number
2760 ,p_legislation_code in varchar2
2761 ,p_group_pl_id in number
2762 ,p_lf_evt_ocrd_dt in date
2763 ,p_effective_date in date
2764 ,p_people_group_segment5 in varchar2)
2765 return varchar2 is
2766 --
2767 l_proc varchar2(72) := g_package||'get_people_group_segment5';
2768 --
2769 begin
2770 --
2771 if g_debug then
2772 hr_utility.set_location('Entering:'|| l_proc, 10);
2773 end if;
2774 --
2775 -- Customer can override p_people_group_segment5 here
2776 return p_people_group_segment5;
2777 --
2778 if g_debug then
2779 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2780 end if;
2781 --
2782
2783 exception
2784 when others then
2785 hr_utility.set_location('Exception in '|| l_proc, 99);
2786 raise;
2787
2788 end;
2789 -- --------------------------------------------------------------------------
2790 -- |-------------------------< get_people_group_segment6>-------------------------|
2791 -- --------------------------------------------------------------------------
2792 -- Description
2793 -- This function returns the people_group_segment6
2794 --
2795 function get_people_group_segment6(p_person_id in number
2796 ,p_assignment_id in number
2797 ,p_legislation_code in varchar2
2798 ,p_group_pl_id in number
2799 ,p_lf_evt_ocrd_dt in date
2800 ,p_effective_date in date
2801 ,p_people_group_segment6 in varchar2)
2802 return varchar2 is
2803 --
2804 l_proc varchar2(72) := g_package||'get_people_group_segment6';
2805 --
2806 begin
2807 --
2808 if g_debug then
2809 hr_utility.set_location('Entering:'|| l_proc, 10);
2810 end if;
2811 --
2812 -- Customer can override p_people_group_segment6 here
2813 return p_people_group_segment6;
2814 --
2815 if g_debug then
2816 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2817 end if;
2818 --
2819
2820 exception
2821 when others then
2822 hr_utility.set_location('Exception in '|| l_proc, 99);
2823 raise;
2827 -- |-------------------------< get_people_group_segment7 >-------------------------|
2824
2825 end;
2826 -- --------------------------------------------------------------------------
2828 -- --------------------------------------------------------------------------
2829 -- Description
2830 -- This function returns the people_group_segment7
2831 --
2832 function get_people_group_segment7(p_person_id in number
2833 ,p_assignment_id in number
2834 ,p_legislation_code in varchar2
2835 ,p_group_pl_id in number
2836 ,p_lf_evt_ocrd_dt in date
2837 ,p_effective_date in date
2838 ,p_people_group_segment7 in varchar2)
2839 return varchar2 is
2840 --
2841 l_proc varchar2(72) := g_package||'get_people_group_segment7';
2842 --
2843 begin
2844 --
2845 if g_debug then
2846 hr_utility.set_location('Entering:'|| l_proc, 10);
2847 end if;
2848 --
2849 -- Customer can override p_people_group_segment7 here
2850 return p_people_group_segment7;
2851 --
2852 if g_debug then
2853 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2854 end if;
2855 --
2856
2857 exception
2858 when others then
2859 hr_utility.set_location('Exception in '|| l_proc, 99);
2860 raise;
2861
2862 end;
2863 -- --------------------------------------------------------------------------
2864 -- |-------------------------< get_people_group_segment8 >-------------------------|
2865 -- --------------------------------------------------------------------------
2866 -- Description
2867 -- This function returns the people_group_segment8
2868 --
2869 function get_people_group_segment8(p_person_id in number
2870 ,p_assignment_id in number
2871 ,p_legislation_code in varchar2
2872 ,p_group_pl_id in number
2873 ,p_lf_evt_ocrd_dt in date
2874 ,p_effective_date in date
2875 ,p_people_group_segment8 in varchar2)
2876 return varchar2 is
2877 --
2878 l_proc varchar2(72) := g_package||'get_people_group_segment8';
2879 --
2880 begin
2881 --
2882 if g_debug then
2883 hr_utility.set_location('Entering:'|| l_proc, 10);
2884 end if;
2885 --
2886 -- Customer can override p_people_group_segment8 here
2887 return p_people_group_segment8;
2888 --
2889 if g_debug then
2890 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2891 end if;
2892 --
2893
2894 exception
2895 when others then
2896 hr_utility.set_location('Exception in '|| l_proc, 99);
2897 raise;
2898
2899 end;
2900 -- --------------------------------------------------------------------------
2901 -- |-------------------------< get_people_group_segment9 >-------------------------|
2902 -- --------------------------------------------------------------------------
2903 -- Description
2904 -- This function returns the people_group_segment9
2905 --
2906 function get_people_group_segment9(p_person_id in number
2907 ,p_assignment_id in number
2908 ,p_legislation_code in varchar2
2909 ,p_group_pl_id in number
2910 ,p_lf_evt_ocrd_dt in date
2911 ,p_effective_date in date
2912 ,p_people_group_segment9 in varchar2)
2913 return varchar2 is
2914 --
2915 l_proc varchar2(72) := g_package||'get_people_group_segment9';
2916 --
2917 begin
2918 --
2919 if g_debug then
2920 hr_utility.set_location('Entering:'|| l_proc, 10);
2921 end if;
2922 --
2923 -- Customer can override p_people_group_segment9 here
2924 return p_people_group_segment9;
2925 --
2926 if g_debug then
2927 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2928 end if;
2929 --
2930
2931 exception
2932 when others then
2933 hr_utility.set_location('Exception in '|| l_proc, 99);
2934 raise;
2935
2936 end;
2937 -- --------------------------------------------------------------------------
2938 -- |-------------------------< get_people_group_segment10 >-------------------------|
2939 -- --------------------------------------------------------------------------
2940 -- Description
2941 -- This function returns the people_group_segment10
2942 --
2943 function get_people_group_segment10(p_person_id in number
2944 ,p_assignment_id in number
2945 ,p_legislation_code in varchar2
2946 ,p_group_pl_id in number
2947 ,p_lf_evt_ocrd_dt in date
2948 ,p_effective_date in date
2949 ,p_people_group_segment10 in varchar2)
2950 return varchar2 is
2951 --
2952 l_proc varchar2(72) := g_package||'get_people_group_segment10';
2953 --
2954 begin
2955 --
2956 if g_debug then
2957 hr_utility.set_location('Entering:'|| l_proc, 10);
2958 end if;
2959 --
2960 -- Customer can override p_people_group_segment10 here
2961 return p_people_group_segment10;
2962 --
2963 if g_debug then
2964 hr_utility.set_location(' Leaving:'|| l_proc, 99);
2965 end if;
2966 --
2967
2968 exception
2969 when others then
2970 hr_utility.set_location('Exception in '|| l_proc, 99);
2971 raise;
2972
2973 end;
2974 -- --------------------------------------------------------------------------
2978 -- This function returns the people_group_segment11
2975 -- |-------------------------< get_people_group_segment11 >-------------------------|
2976 -- --------------------------------------------------------------------------
2977 -- Description
2979 --
2980 function get_people_group_segment11(p_person_id in number
2981 ,p_assignment_id in number
2982 ,p_legislation_code in varchar2
2983 ,p_group_pl_id in number
2984 ,p_lf_evt_ocrd_dt in date
2985 ,p_effective_date in date
2986 ,p_people_group_segment11 in varchar2)
2987 return varchar2 is
2988 --
2989 l_proc varchar2(72) := g_package||'get_people_group_segment11';
2990 --
2991 begin
2992 --
2993 if g_debug then
2994 hr_utility.set_location('Entering:'|| l_proc, 10);
2995 end if;
2996 --
2997 -- Customer can override p_people_group_segment11 here
2998 return p_people_group_segment11;
2999 --
3000 if g_debug then
3001 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3002 end if;
3003 --
3004
3005 exception
3006 when others then
3007 hr_utility.set_location('Exception in '|| l_proc, 99);
3008 raise;
3009
3010 end;
3011
3012
3013 -- --------------------------------------------------------------------------
3014 -- |-------------------------< get_ass_attribute_category >-------------------------|
3015 -- --------------------------------------------------------------------------
3016 -- Description
3017 -- This function returns the ass_attribute_category
3018 --
3019 function get_ass_attribute_category(p_person_id in number
3020 ,p_assignment_id in number
3021 ,p_legislation_code in varchar2
3022 ,p_group_pl_id in number
3023 ,p_lf_evt_ocrd_dt in date
3024 ,p_effective_date in date
3025 ,p_ass_attribute_category in varchar2)
3026 return varchar2 is
3027 --
3028 l_proc varchar2(72) := g_package||'get_ass_attribute_category';
3029 --
3030 begin
3031 --
3032 if g_debug then
3033 hr_utility.set_location('Entering:'|| l_proc, 10);
3034 end if;
3035 --
3036 -- Customer can override p_ass_attribute_category here
3037 return p_ass_attribute_category;
3038 --
3039 if g_debug then
3040 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3041 end if;
3042 --
3043
3044 exception
3045 when others then
3046 hr_utility.set_location('Exception in '|| l_proc, 99);
3047 raise;
3048
3049 end;
3050 -- --------------------------------------------------------------------------
3051 -- |-------------------------< get_ass_attribute1 >-------------------------|
3052 -- --------------------------------------------------------------------------
3053 -- Description
3054 -- This function returns the ass_attribute1
3055 --
3056 function get_ass_attribute1(p_person_id in number
3057 ,p_assignment_id in number
3058 ,p_legislation_code in varchar2
3059 ,p_group_pl_id in number
3060 ,p_lf_evt_ocrd_dt in date
3061 ,p_effective_date in date
3062 ,p_ass_attribute1 in varchar2)
3063 return varchar2 is
3064 --
3065 l_proc varchar2(72) := g_package||'get_ass_attribute1';
3066 --
3067 begin
3068 --
3069 if g_debug then
3070 hr_utility.set_location('Entering:'|| l_proc, 10);
3071 end if;
3072 --
3073 -- Customer can override p_ass_attribute1 here
3074 return p_ass_attribute1;
3075 --
3076 if g_debug then
3077 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3078 end if;
3079 --
3080
3081 exception
3082 when others then
3083 hr_utility.set_location('Exception in '|| l_proc, 99);
3084 raise;
3085
3086 end;
3087 -- --------------------------------------------------------------------------
3088 -- |-------------------------< get_ass_attribute2 >-------------------------|
3089 -- --------------------------------------------------------------------------
3090 -- Description
3091 -- This function returns the ass_attribute2
3092 --
3093 function get_ass_attribute2(p_person_id in number
3094 ,p_assignment_id in number
3095 ,p_legislation_code in varchar2
3096 ,p_group_pl_id in number
3097 ,p_lf_evt_ocrd_dt in date
3098 ,p_effective_date in date
3099 ,p_ass_attribute2 in varchar2)
3100 return varchar2 is
3101 --
3102 l_proc varchar2(72) := g_package||'get_ass_attribute2';
3103 --
3104 begin
3105 --
3106 if g_debug then
3107 hr_utility.set_location('Entering:'|| l_proc, 10);
3108 end if;
3109 --
3110 -- Customer can override p_ass_attribute2 here
3111 return p_ass_attribute2;
3112 --
3113 if g_debug then
3114 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3115 end if;
3116 --
3117
3118 exception
3119 when others then
3120 hr_utility.set_location('Exception in '|| l_proc, 99);
3121 raise;
3122
3123 end;
3124 -- --------------------------------------------------------------------------
3125 -- |-------------------------< get_ass_attribute3 >-------------------------|
3126 -- --------------------------------------------------------------------------
3130 function get_ass_attribute3(p_person_id in number
3127 -- Description
3128 -- This function returns the ass_attribute3
3129 --
3131 ,p_assignment_id in number
3132 ,p_legislation_code in varchar2
3133 ,p_group_pl_id in number
3134 ,p_lf_evt_ocrd_dt in date
3135 ,p_effective_date in date
3136 ,p_ass_attribute3 in varchar2)
3137 return varchar2 is
3138 --
3139 l_proc varchar2(72) := g_package||'get_ass_attribute3';
3140 --
3141 begin
3142 --
3143 if g_debug then
3144 hr_utility.set_location('Entering:'|| l_proc, 10);
3145 end if;
3146 --
3147 -- Customer can override p_ass_attribute3 here
3148 return p_ass_attribute3;
3149 --
3150 if g_debug then
3151 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3152 end if;
3153 --
3154
3155 exception
3156 when others then
3157 hr_utility.set_location('Exception in '|| l_proc, 99);
3158 raise;
3159
3160 end;
3161 -- --------------------------------------------------------------------------
3162 -- |-------------------------< get_ass_attribute4 >-------------------------|
3163 -- --------------------------------------------------------------------------
3164 -- Description
3165 -- This function returns the ass_attribute4
3166 --
3167 function get_ass_attribute4(p_person_id in number
3168 ,p_assignment_id in number
3169 ,p_legislation_code in varchar2
3170 ,p_group_pl_id in number
3171 ,p_lf_evt_ocrd_dt in date
3172 ,p_effective_date in date
3173 ,p_ass_attribute4 in varchar2)
3174 return varchar2 is
3175 --
3176 l_proc varchar2(72) := g_package||'get_ass_attribute4';
3177 --
3178 begin
3179 --
3180 if g_debug then
3181 hr_utility.set_location('Entering:'|| l_proc, 10);
3182 end if;
3183 --
3184 -- Customer can override p_ass_attribute4 here
3185 return p_ass_attribute4;
3186 --
3187 if g_debug then
3188 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3189 end if;
3190 --
3191
3192 exception
3193 when others then
3194 hr_utility.set_location('Exception in '|| l_proc, 99);
3195 raise;
3196
3197 end;
3198 -- --------------------------------------------------------------------------
3199 -- |-------------------------< get_ass_attribute5 >-------------------------|
3200 -- --------------------------------------------------------------------------
3201 -- Description
3202 -- This function returns the ass_attribute5
3203 --
3204 function get_ass_attribute5(p_person_id in number
3205 ,p_assignment_id in number
3206 ,p_legislation_code in varchar2
3207 ,p_group_pl_id in number
3208 ,p_lf_evt_ocrd_dt in date
3209 ,p_effective_date in date
3210 ,p_ass_attribute5 in varchar2)
3211 return varchar2 is
3212 --
3213 l_proc varchar2(72) := g_package||'get_ass_attribute5';
3214 --
3215 begin
3216 --
3217 if g_debug then
3218 hr_utility.set_location('Entering:'|| l_proc, 10);
3219 end if;
3220 --
3221 -- Customer can override p_ass_attribute5 here
3222 return p_ass_attribute5;
3223 --
3224 if g_debug then
3225 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3226 end if;
3227 --
3228
3229 exception
3230 when others then
3231 hr_utility.set_location('Exception in '|| l_proc, 99);
3232 raise;
3233
3234 end;
3235 -- --------------------------------------------------------------------------
3236 -- |-------------------------< get_ass_attribute6 >-------------------------|
3237 -- --------------------------------------------------------------------------
3238 -- Description
3239 -- This function returns the ass_attribute6
3240 --
3241 function get_ass_attribute6(p_person_id in number
3242 ,p_assignment_id in number
3243 ,p_legislation_code in varchar2
3244 ,p_group_pl_id in number
3245 ,p_lf_evt_ocrd_dt in date
3246 ,p_effective_date in date
3247 ,p_ass_attribute6 in varchar2)
3248 return varchar2 is
3249 --
3250 l_proc varchar2(72) := g_package||'get_ass_attribute6';
3251 --
3252 begin
3253 --
3254 if g_debug then
3255 hr_utility.set_location('Entering:'|| l_proc, 10);
3256 end if;
3257 --
3258 -- Customer can override p_ass_attribute6 here
3259 return p_ass_attribute6;
3260 --
3261 if g_debug then
3262 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3263 end if;
3264 --
3265
3266 exception
3267 when others then
3268 hr_utility.set_location('Exception in '|| l_proc, 99);
3269 raise;
3270
3271 end;
3272 -- --------------------------------------------------------------------------
3273 -- |-------------------------< get_ass_attribute7 >-------------------------|
3274 -- --------------------------------------------------------------------------
3275 -- Description
3276 -- This function returns the ass_attribute7
3277 --
3278 function get_ass_attribute7(p_person_id in number
3279 ,p_assignment_id in number
3280 ,p_legislation_code in varchar2
3284 ,p_ass_attribute7 in varchar2)
3281 ,p_group_pl_id in number
3282 ,p_lf_evt_ocrd_dt in date
3283 ,p_effective_date in date
3285 return varchar2 is
3286 --
3287 l_proc varchar2(72) := g_package||'get_ass_attribute7';
3288 --
3289 begin
3290 --
3291 if g_debug then
3292 hr_utility.set_location('Entering:'|| l_proc, 10);
3293 end if;
3294 --
3295 -- Customer can override p_ass_attribute7 here
3296 return p_ass_attribute7;
3297 --
3298 if g_debug then
3299 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3300 end if;
3301 --
3302
3303 exception
3304 when others then
3305 hr_utility.set_location('Exception in '|| l_proc, 99);
3306 raise;
3307
3308 end;
3309 -- --------------------------------------------------------------------------
3310 -- |-------------------------< get_ass_attribute8 >-------------------------|
3311 -- --------------------------------------------------------------------------
3312 -- Description
3313 -- This function returns the ass_attribute8
3314 --
3315 function get_ass_attribute8(p_person_id in number
3316 ,p_assignment_id in number
3317 ,p_legislation_code in varchar2
3318 ,p_group_pl_id in number
3319 ,p_lf_evt_ocrd_dt in date
3320 ,p_effective_date in date
3321 ,p_ass_attribute8 in varchar2)
3322 return varchar2 is
3323 --
3324 l_proc varchar2(72) := g_package||'get_ass_attribute8';
3325 --
3326 begin
3327 --
3328 if g_debug then
3329 hr_utility.set_location('Entering:'|| l_proc, 10);
3330 end if;
3331 --
3332 -- Customer can override p_ass_attribute8 here
3333 return p_ass_attribute8;
3334 --
3335 if g_debug then
3336 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3337 end if;
3338 --
3339
3340 exception
3341 when others then
3342 hr_utility.set_location('Exception in '|| l_proc, 99);
3343 raise;
3344
3345 end;
3346 -- --------------------------------------------------------------------------
3347 -- |-------------------------< get_ass_attribute9 >-------------------------|
3348 -- --------------------------------------------------------------------------
3349 -- Description
3350 -- This function returns the ass_attribute9
3351 --
3352 function get_ass_attribute9(p_person_id in number
3353 ,p_assignment_id in number
3354 ,p_legislation_code in varchar2
3355 ,p_group_pl_id in number
3356 ,p_lf_evt_ocrd_dt in date
3357 ,p_effective_date in date
3358 ,p_ass_attribute9 in varchar2)
3359 return varchar2 is
3360 --
3361 l_proc varchar2(72) := g_package||'get_ass_attribute9';
3362 --
3363 begin
3364 --
3365 if g_debug then
3366 hr_utility.set_location('Entering:'|| l_proc, 10);
3367 end if;
3368 --
3369 -- Customer can override p_ass_attribute9 here
3370 return p_ass_attribute9;
3371 --
3372 if g_debug then
3373 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3374 end if;
3375 --
3376
3377 exception
3378 when others then
3379 hr_utility.set_location('Exception in '|| l_proc, 99);
3380 raise;
3381
3382 end;
3383 -- --------------------------------------------------------------------------
3384 -- |-------------------------< get_ass_attribute10 >-------------------------|
3385 -- --------------------------------------------------------------------------
3386 -- Description
3387 -- This function returns the ass_attribute10
3388 --
3389 function get_ass_attribute10(p_person_id in number
3390 ,p_assignment_id in number
3391 ,p_legislation_code in varchar2
3392 ,p_group_pl_id in number
3393 ,p_lf_evt_ocrd_dt in date
3394 ,p_effective_date in date
3395 ,p_ass_attribute10 in varchar2)
3396 return varchar2 is
3397 --
3398 l_proc varchar2(72) := g_package||'get_ass_attribute10';
3399 --
3400 begin
3401 --
3402 if g_debug then
3403 hr_utility.set_location('Entering:'|| l_proc, 10);
3404 end if;
3405 --
3406 -- Customer can override p_ass_attribute10 here
3407 return p_ass_attribute10;
3408 --
3409 if g_debug then
3410 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3411 end if;
3412 --
3413
3414 exception
3415 when others then
3416 hr_utility.set_location('Exception in '|| l_proc, 99);
3417 raise;
3418
3419 end;
3420 -- --------------------------------------------------------------------------
3421 -- |-------------------------< get_ass_attribute11 >-------------------------|
3422 -- --------------------------------------------------------------------------
3423 -- Description
3424 -- This function returns the ass_attribute11
3425 --
3426 function get_ass_attribute11(p_person_id in number
3427 ,p_assignment_id in number
3428 ,p_legislation_code in varchar2
3429 ,p_group_pl_id in number
3430 ,p_lf_evt_ocrd_dt in date
3431 ,p_effective_date in date
3432 ,p_ass_attribute11 in varchar2)
3433 return varchar2 is
3437 begin
3434 --
3435 l_proc varchar2(72) := g_package||'get_ass_attribute11';
3436 --
3438 --
3439 if g_debug then
3440 hr_utility.set_location('Entering:'|| l_proc, 10);
3441 end if;
3442 --
3443 -- Customer can override p_ass_attribute11 here
3444 return p_ass_attribute11;
3445 --
3446 if g_debug then
3447 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3448 end if;
3449 --
3450
3451 exception
3452 when others then
3453 hr_utility.set_location('Exception in '|| l_proc, 99);
3454 raise;
3455
3456 end;
3457 -- --------------------------------------------------------------------------
3458 -- |-------------------------< get_ass_attribute12 >-------------------------|
3459 -- --------------------------------------------------------------------------
3460 -- Description
3461 -- This function returns the ass_attribute12
3462 --
3463 function get_ass_attribute12(p_person_id in number
3464 ,p_assignment_id in number
3465 ,p_legislation_code in varchar2
3466 ,p_group_pl_id in number
3467 ,p_lf_evt_ocrd_dt in date
3468 ,p_effective_date in date
3469 ,p_ass_attribute12 in varchar2)
3470 return varchar2 is
3471 --
3472 l_proc varchar2(72) := g_package||'get_ass_attribute12';
3473 --
3474
3475 begin
3476 --
3477 if g_debug then
3478 hr_utility.set_location('Entering:'|| l_proc, 10);
3479 end if;
3480 --
3481 -- Customer can override p_ass_attribute12 here
3482 return p_ass_attribute12;
3483 --
3484 if g_debug then
3485 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3486 end if;
3487 --
3488
3489 exception
3490 when others then
3491 hr_utility.set_location('Exception in '|| l_proc, 99);
3492 raise;
3493
3494 end;
3495 -- --------------------------------------------------------------------------
3496 -- |-------------------------< get_ass_attribute13 >-------------------------|
3497 -- --------------------------------------------------------------------------
3498 -- Description
3499 -- This function returns the ass_attribute13
3500 --
3501 function get_ass_attribute13(p_person_id in number
3502 ,p_assignment_id in number
3503 ,p_legislation_code in varchar2
3504 ,p_group_pl_id in number
3505 ,p_lf_evt_ocrd_dt in date
3506 ,p_effective_date in date
3507 ,p_ass_attribute13 in varchar2)
3508 return varchar2 is
3509 --
3510 l_proc varchar2(72) := g_package||'get_ass_attribute13';
3511 --
3512 begin
3513 --
3514 if g_debug then
3515 hr_utility.set_location('Entering:'|| l_proc, 10);
3516 end if;
3517 --
3518 -- Customer can override p_ass_attribute13 here
3519 return p_ass_attribute13;
3520 --
3521 if g_debug then
3522 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3523 end if;
3524 --
3525
3526 exception
3527 when others then
3528 hr_utility.set_location('Exception in '|| l_proc, 99);
3529 raise;
3530
3531 end;
3532 -- --------------------------------------------------------------------------
3533 -- |-------------------------< get_ass_attribute14 >-------------------------|
3534 -- --------------------------------------------------------------------------
3535 -- Description
3536 -- This function returns the ass_attribute14
3537 --
3538 function get_ass_attribute14(p_person_id in number
3539 ,p_assignment_id in number
3540 ,p_legislation_code in varchar2
3541 ,p_group_pl_id in number
3542 ,p_lf_evt_ocrd_dt in date
3543 ,p_effective_date in date
3544 ,p_ass_attribute14 in varchar2)
3545 return varchar2 is
3546 --
3547 l_proc varchar2(72) := g_package||'get_ass_attribute14';
3548 --
3549 begin
3550 --
3551 if g_debug then
3552 hr_utility.set_location('Entering:'|| l_proc, 10);
3553 end if;
3554 --
3555 -- Customer can override p_ass_attribute14 here
3556 return p_ass_attribute14;
3557 --
3558 if g_debug then
3559 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3560 end if;
3561 --
3562
3563 exception
3564 when others then
3565 hr_utility.set_location('Exception in '|| l_proc, 99);
3566 raise;
3567
3568 end;
3569 -- --------------------------------------------------------------------------
3570 -- |-------------------------< get_ass_attribute15 >-------------------------|
3571 -- --------------------------------------------------------------------------
3572 -- Description
3573 -- This function returns the ass_attribute15
3574 --
3575 function get_ass_attribute15(p_person_id in number
3576 ,p_assignment_id in number
3577 ,p_legislation_code in varchar2
3578 ,p_group_pl_id in number
3579 ,p_lf_evt_ocrd_dt in date
3580 ,p_effective_date in date
3581 ,p_ass_attribute15 in varchar2)
3582 return varchar2 is
3583 --
3584 l_proc varchar2(72) := g_package||'get_ass_attribute15';
3585 --
3586 begin
3587 --
3588 if g_debug then
3589 hr_utility.set_location('Entering:'|| l_proc, 10);
3590 end if;
3594 --
3591 --
3592 -- Customer can override p_ass_attribute15 here
3593 return p_ass_attribute15;
3595 if g_debug then
3596 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3597 end if;
3598 --
3599
3600 exception
3601 when others then
3602 hr_utility.set_location('Exception in '|| l_proc, 99);
3603 raise;
3604
3605 end;
3606 -- --------------------------------------------------------------------------
3607 -- |-------------------------< get_ass_attribute16 >-------------------------|
3608 -- --------------------------------------------------------------------------
3609 -- Description
3610 -- This function returns the ass_attribute16
3611 --
3612 function get_ass_attribute16(p_person_id in number
3613 ,p_assignment_id in number
3614 ,p_legislation_code in varchar2
3615 ,p_group_pl_id in number
3616 ,p_lf_evt_ocrd_dt in date
3617 ,p_effective_date in date
3618 ,p_ass_attribute16 in varchar2)
3619 return varchar2 is
3620 --
3621 l_proc varchar2(72) := g_package||'get_ass_attribute16';
3622 --
3623 begin
3624 --
3625 if g_debug then
3626 hr_utility.set_location('Entering:'|| l_proc, 10);
3627 end if;
3628 --
3629 -- Customer can override p_ass_attribute16 here
3630 return p_ass_attribute16;
3631 --
3632 if g_debug then
3633 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3634 end if;
3635 --
3636
3637 exception
3638 when others then
3639 hr_utility.set_location('Exception in '|| l_proc, 99);
3640 raise;
3641
3642 end;
3643 -- --------------------------------------------------------------------------
3644 -- |-------------------------< get_ass_attribute17 >-------------------------|
3645 -- --------------------------------------------------------------------------
3646 -- Description
3647 -- This function returns the ass_attribute17
3648 --
3649 function get_ass_attribute17(p_person_id in number
3650 ,p_assignment_id in number
3651 ,p_legislation_code in varchar2
3652 ,p_group_pl_id in number
3653 ,p_lf_evt_ocrd_dt in date
3654 ,p_effective_date in date
3655 ,p_ass_attribute17 in varchar2)
3656 return varchar2 is
3657 --
3658 l_proc varchar2(72) := g_package||'get_ass_attribute17';
3659 --
3660 begin
3661 --
3662 if g_debug then
3663 hr_utility.set_location('Entering:'|| l_proc, 10);
3664 end if;
3665 --
3666 -- Customer can override p_ass_attribute17 here
3667 return p_ass_attribute17;
3668 --
3669 if g_debug then
3670 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3671 end if;
3672 --
3673
3674 exception
3675 when others then
3676 hr_utility.set_location('Exception in '|| l_proc, 99);
3677 raise;
3678
3679 end;
3680 -- --------------------------------------------------------------------------
3681 -- |-------------------------< get_ass_attribute18 >-------------------------|
3682 -- --------------------------------------------------------------------------
3683 -- Description
3684 -- This function returns the ass_attribute18
3685 --
3686 function get_ass_attribute18(p_person_id in number
3687 ,p_assignment_id in number
3688 ,p_legislation_code in varchar2
3689 ,p_group_pl_id in number
3690 ,p_lf_evt_ocrd_dt in date
3691 ,p_effective_date in date
3692 ,p_ass_attribute18 in varchar2)
3693 return varchar2 is
3694 --
3695 l_proc varchar2(72) := g_package||'get_ass_attribute18';
3696 --
3697 begin
3698 --
3699 if g_debug then
3700 hr_utility.set_location('Entering:'|| l_proc, 10);
3701 end if;
3702 --
3703 -- Customer can override p_ass_attribute18 here
3704 return p_ass_attribute18;
3705 --
3706 if g_debug then
3707 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3708 end if;
3709 --
3710
3711 exception
3712 when others then
3713 hr_utility.set_location('Exception in '|| l_proc, 99);
3714 raise;
3715
3716 end;
3717 -- --------------------------------------------------------------------------
3718 -- |-------------------------< get_ass_attribute19 >-------------------------|
3719 -- --------------------------------------------------------------------------
3720 -- Description
3721 -- This function returns the ass_attribute19
3722 --
3723 function get_ass_attribute19(p_person_id in number
3724 ,p_assignment_id in number
3725 ,p_legislation_code in varchar2
3726 ,p_group_pl_id in number
3727 ,p_lf_evt_ocrd_dt in date
3728 ,p_effective_date in date
3729 ,p_ass_attribute19 in varchar2)
3730 return varchar2 is
3731 --
3732 l_proc varchar2(72) := g_package||'get_ass_attribute19';
3733 --
3734 begin
3735 --
3736 if g_debug then
3737 hr_utility.set_location('Entering:'|| l_proc, 10);
3738 end if;
3739 --
3740 -- Customer can override p_ass_attribute19 here
3741 return p_ass_attribute19;
3742 --
3743 if g_debug then
3744 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3745 end if;
3746 --
3750 hr_utility.set_location('Exception in '|| l_proc, 99);
3747
3748 exception
3749 when others then
3751 raise;
3752
3753 end;
3754
3755 -- --------------------------------------------------------------------------
3756 -- |-------------------------< get_ass_attribute20 >-------------------------|
3757 -- --------------------------------------------------------------------------
3758 -- Description
3759 -- This function returns the ass_attribute20
3760 --
3761 function get_ass_attribute20(p_person_id in number
3762 ,p_assignment_id in number
3763 ,p_legislation_code in varchar2
3764 ,p_group_pl_id in number
3765 ,p_lf_evt_ocrd_dt in date
3766 ,p_effective_date in date
3767 ,p_ass_attribute20 in varchar2)
3768 return varchar2 is
3769 --
3770 l_proc varchar2(72) := g_package||'get_ass_attribute20';
3771 --
3772 begin
3773 --
3774 if g_debug then
3775 hr_utility.set_location('Entering:'|| l_proc, 10);
3776 end if;
3777 --
3778 -- Customer can override p_ass_attribute20 here
3779 return p_ass_attribute20;
3780 --
3781 if g_debug then
3782 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3783 end if;
3784 --
3785
3786 exception
3787 when others then
3788 hr_utility.set_location('Exception in '|| l_proc, 99);
3789 raise;
3790
3791 end;
3792
3793 -- --------------------------------------------------------------------------
3794 -- |-------------------------< get_ass_attribute21 >-------------------------|
3795 -- --------------------------------------------------------------------------
3796 -- Description
3797 -- This function returns the ass_attribute21
3798 --
3799 function get_ass_attribute21(p_person_id in number
3800 ,p_assignment_id in number
3801 ,p_legislation_code in varchar2
3802 ,p_group_pl_id in number
3803 ,p_lf_evt_ocrd_dt in date
3804 ,p_effective_date in date
3805 ,p_ass_attribute21 in varchar2)
3806 return varchar2 is
3807 --
3808 l_proc varchar2(72) := g_package||'get_ass_attribute21';
3809 --
3810 begin
3811 --
3812 if g_debug then
3813 hr_utility.set_location('Entering:'|| l_proc, 10);
3814 end if;
3815 --
3816 -- Customer can override p_ass_attribute21 here
3817 return p_ass_attribute21;
3818 --
3819 if g_debug then
3820 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3821 end if;
3822 --
3823
3824 exception
3825 when others then
3826 hr_utility.set_location('Exception in '|| l_proc, 99);
3827 raise;
3828
3829 end;
3830
3831 -- --------------------------------------------------------------------------
3832 -- |-------------------------< get_ass_attribute22 >-------------------------|
3833 -- --------------------------------------------------------------------------
3834 -- Description
3835 -- This function returns the ass_attribute22
3836 --
3837 function get_ass_attribute22(p_person_id in number
3838 ,p_assignment_id in number
3839 ,p_legislation_code in varchar2
3840 ,p_group_pl_id in number
3841 ,p_lf_evt_ocrd_dt in date
3842 ,p_effective_date in date
3843 ,p_ass_attribute22 in varchar2)
3844 return varchar2 is
3845 --
3846 l_proc varchar2(72) := g_package||'get_ass_attribute22';
3847 --
3848 begin
3849 --
3850 if g_debug then
3851 hr_utility.set_location('Entering:'|| l_proc, 10);
3852 end if;
3853 --
3854 -- Customer can override p_ass_attribute22 here
3855 return p_ass_attribute22;
3856 --
3857 if g_debug then
3858 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3859 end if;
3860 --
3861
3862 exception
3863 when others then
3864 hr_utility.set_location('Exception in '|| l_proc, 99);
3865 raise;
3866
3867 end;
3868 -- --------------------------------------------------------------------------
3869 -- |-------------------------< get_ass_attribute23 >-------------------------|
3870 -- --------------------------------------------------------------------------
3871 -- Description
3872 -- This function returns the ass_attribute23
3873 --
3874 function get_ass_attribute23(p_person_id in number
3875 ,p_assignment_id in number
3876 ,p_legislation_code in varchar2
3877 ,p_group_pl_id in number
3878 ,p_lf_evt_ocrd_dt in date
3879 ,p_effective_date in date
3880 ,p_ass_attribute23 in varchar2)
3881 return varchar2 is
3882 --
3883 l_proc varchar2(72) := g_package||'get_ass_attribute23';
3884 --
3885 begin
3886 --
3887 if g_debug then
3888 hr_utility.set_location('Entering:'|| l_proc, 10);
3889 end if;
3890 --
3891 -- Customer can override p_ass_attribute23 here
3892 return p_ass_attribute23;
3893 --
3894 if g_debug then
3895 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3896 end if;
3897 --
3898
3899 exception
3900 when others then
3901 hr_utility.set_location('Exception in '|| l_proc, 99);
3902 raise;
3903
3904 end;
3908 -- Description
3905 -- --------------------------------------------------------------------------
3906 -- |-------------------------< get_ass_attribute24 >-------------------------|
3907 -- --------------------------------------------------------------------------
3909 -- This function returns the ass_attribute24
3910 --
3911 function get_ass_attribute24(p_person_id in number
3912 ,p_assignment_id in number
3913 ,p_legislation_code in varchar2
3914 ,p_group_pl_id in number
3915 ,p_lf_evt_ocrd_dt in date
3916 ,p_effective_date in date
3917 ,p_ass_attribute24 in varchar2)
3918 return varchar2 is
3919 --
3920 l_proc varchar2(72) := g_package||'get_ass_attribute24';
3921 --
3922 begin
3923 --
3924 if g_debug then
3925 hr_utility.set_location('Entering:'|| l_proc, 10);
3926 end if;
3927 --
3928 -- Customer can override p_ass_attribute24 here
3929 return p_ass_attribute24;
3930 --
3931 if g_debug then
3932 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3933 end if;
3934 --
3935
3936 exception
3937 when others then
3938 hr_utility.set_location('Exception in '|| l_proc, 99);
3939 raise;
3940
3941 end;
3942 -- --------------------------------------------------------------------------
3943 -- |-------------------------< get_ass_attribute25 >-------------------------|
3944 -- --------------------------------------------------------------------------
3945 -- Description
3946 -- This function returns the ass_attribute25
3947 --
3948 function get_ass_attribute25(p_person_id in number
3949 ,p_assignment_id in number
3950 ,p_legislation_code in varchar2
3951 ,p_group_pl_id in number
3952 ,p_lf_evt_ocrd_dt in date
3953 ,p_effective_date in date
3954 ,p_ass_attribute25 in varchar2)
3955 return varchar2 is
3956 --
3957 l_proc varchar2(72) := g_package||'get_ass_attribute25';
3958 --
3959 begin
3960 --
3961 if g_debug then
3962 hr_utility.set_location('Entering:'|| l_proc, 10);
3963 end if;
3964 --
3965 -- Customer can override p_ass_attribute25 here
3966 return p_ass_attribute25;
3967 --
3968 if g_debug then
3969 hr_utility.set_location(' Leaving:'|| l_proc, 99);
3970 end if;
3971 --
3972
3973 exception
3974 when others then
3975 hr_utility.set_location('Exception in '|| l_proc, 99);
3976 raise;
3977
3978 end;
3979 -- --------------------------------------------------------------------------
3980 -- |-------------------------< get_ass_attribute26 >-------------------------|
3981 -- --------------------------------------------------------------------------
3982 -- Description
3983 -- This function returns the ass_attribute26
3984 --
3985 function get_ass_attribute26(p_person_id in number
3986 ,p_assignment_id in number
3987 ,p_legislation_code in varchar2
3988 ,p_group_pl_id in number
3989 ,p_lf_evt_ocrd_dt in date
3990 ,p_effective_date in date
3991 ,p_ass_attribute26 in varchar2)
3992 return varchar2 is
3993 --
3994 l_proc varchar2(72) := g_package||'get_ass_attribute26';
3995 --
3996 begin
3997 --
3998 if g_debug then
3999 hr_utility.set_location('Entering:'|| l_proc, 10);
4000 end if;
4001 --
4002 -- Customer can override p_ass_attribute26 here
4003 return p_ass_attribute26;
4004 --
4005 if g_debug then
4006 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4007 end if;
4008 --
4009
4010 exception
4011 when others then
4012 hr_utility.set_location('Exception in '|| l_proc, 99);
4013 raise;
4014
4015 end;
4016 -- --------------------------------------------------------------------------
4017 -- |-------------------------< get_ass_attribute27 >-------------------------|
4018 -- --------------------------------------------------------------------------
4019 -- Description
4020 -- This function returns the ass_attribute27
4021 --
4022 function get_ass_attribute27(p_person_id in number
4023 ,p_assignment_id in number
4024 ,p_legislation_code in varchar2
4025 ,p_group_pl_id in number
4026 ,p_lf_evt_ocrd_dt in date
4027 ,p_effective_date in date
4028 ,p_ass_attribute27 in varchar2)
4029 return varchar2 is
4030 --
4031 l_proc varchar2(72) := g_package||'get_ass_attribute27';
4032 --
4033 begin
4034 --
4035 if g_debug then
4036 hr_utility.set_location('Entering:'|| l_proc, 10);
4037 end if;
4038 --
4039 -- Customer can override p_ass_attribute27 here
4040 return p_ass_attribute27;
4041 --
4042 if g_debug then
4043 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4044 end if;
4045 --
4046
4047 exception
4048 when others then
4049 hr_utility.set_location('Exception in '|| l_proc, 99);
4050 raise;
4051
4052 end;
4053 -- --------------------------------------------------------------------------
4054 -- |-------------------------< get_ass_attribute28 >-------------------------|
4055 -- --------------------------------------------------------------------------
4059 function get_ass_attribute28(p_person_id in number
4056 -- Description
4057 -- This function returns the ass_attribute28
4058 --
4060 ,p_assignment_id in number
4061 ,p_legislation_code in varchar2
4062 ,p_group_pl_id in number
4063 ,p_lf_evt_ocrd_dt in date
4064 ,p_effective_date in date
4065 ,p_ass_attribute28 in varchar2)
4066 return varchar2 is
4067 --
4068 l_proc varchar2(72) := g_package||'get_ass_attribute28';
4069 --
4070 begin
4071 --
4072 if g_debug then
4073 hr_utility.set_location('Entering:'|| l_proc, 10);
4074 end if;
4075 --
4076 -- Customer can override p_ass_attribute28 here
4077 return p_ass_attribute28;
4078 --
4079 if g_debug then
4080 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4081 end if;
4082 --
4083
4084 exception
4085 when others then
4086 hr_utility.set_location('Exception in '|| l_proc, 99);
4087 raise;
4088
4089 end;
4090 -- --------------------------------------------------------------------------
4091 -- |-------------------------< get_ass_attribute29 >-------------------------|
4092 -- --------------------------------------------------------------------------
4093 -- Description
4094 -- This function returns the ass_attribute29
4095 --
4096 function get_ass_attribute29(p_person_id in number
4097 ,p_assignment_id in number
4098 ,p_legislation_code in varchar2
4099 ,p_group_pl_id in number
4100 ,p_lf_evt_ocrd_dt in date
4101 ,p_effective_date in date
4102 ,p_ass_attribute29 in varchar2)
4103 return varchar2 is
4104 --
4105 l_proc varchar2(72) := g_package||'get_ass_attribute29';
4106 --
4107 begin
4108 --
4109 if g_debug then
4110 hr_utility.set_location('Entering:'|| l_proc, 10);
4111 end if;
4112 --
4113 -- Customer can override p_ass_attribute29 here
4114 return p_ass_attribute29;
4115 --
4116 if g_debug then
4117 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4118 end if;
4119 --
4120
4121 exception
4122 when others then
4123 hr_utility.set_location('Exception in '|| l_proc, 99);
4124 raise;
4125
4126 end;
4127
4128 -- --------------------------------------------------------------------------
4129 -- |-------------------------< get_ass_attribute30 >-------------------------|
4130 -- --------------------------------------------------------------------------
4131 -- Description
4132 -- This function returns the ass_attribute30
4133 --
4134 function get_ass_attribute30(p_person_id in number
4135 ,p_assignment_id in number
4136 ,p_legislation_code in varchar2
4137 ,p_group_pl_id in number
4138 ,p_lf_evt_ocrd_dt in date
4139 ,p_effective_date in date
4140 ,p_ass_attribute30 in varchar2)
4141 return varchar2 is
4142 --
4143 l_proc varchar2(72) := g_package||'get_ass_attribute30';
4144 --
4145
4146 begin
4147 --
4148 if g_debug then
4149 hr_utility.set_location('Entering:'|| l_proc, 10);
4150 end if;
4151 --
4152 -- Customer can override p_ass_attribute30 here
4153 return p_ass_attribute30;
4154 --
4155 if g_debug then
4156 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4157 end if;
4158 --
4159
4160 exception
4161 when others then
4162 hr_utility.set_location('Exception in '|| l_proc, 99);
4163 raise;
4164
4165 end;
4166 -- --------------------------------------------------------------------------
4167 -- |-------------------------< get_ws_comments >-------------------------|
4168 -- --------------------------------------------------------------------------
4169 -- Description
4170 -- This function returns the ws_comments
4171 --
4172 function get_ws_comments(p_person_id in number
4173 ,p_assignment_id in number
4174 ,p_legislation_code in varchar2
4175 ,p_group_pl_id in number
4176 ,p_lf_evt_ocrd_dt in date
4177 ,p_effective_date in date
4178 ,p_ws_comments in varchar2)
4179 return varchar2 is
4180 --
4181 l_proc varchar2(72) := g_package||'get_ws_comments';
4182 --
4183
4184 begin
4185 --
4186 if g_debug then
4187 hr_utility.set_location('Entering:'|| l_proc, 10);
4188 end if;
4189 --
4190 -- Customer can override p_ws_comments here
4191 return p_ws_comments;
4192 --
4193 if g_debug then
4194 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4195 end if;
4196 --
4197
4198 exception
4199 when others then
4200 hr_utility.set_location('Exception in '|| l_proc, 99);
4201 raise;
4202
4203 end;
4204
4205 --
4206 -- --------------------------------------------------------------------------
4207 -- |-------------------------< get_cpi_attribute_category >-------------------------|
4208 -- --------------------------------------------------------------------------
4209 -- Description
4210 -- This function returns the cpi_attribute_category
4211 --
4212
4213 function get_cpi_attribute_category(p_person_id in number
4217 ,p_lf_evt_ocrd_dt in date
4214 ,p_assignment_id in number
4215 ,p_legislation_code in varchar2
4216 ,p_group_pl_id in number
4218 ,p_effective_date in date
4219 ,p_cpi_attribute_category in varchar2)
4220 return varchar2 is
4221 --
4222 l_proc varchar2(72) := g_package||'get_cpi_attribute_category';
4223 --
4224 begin
4225 --
4226 if g_debug then
4227 hr_utility.set_location('Entering:'|| l_proc, 10);
4228 end if;
4229 --
4230 -- Customer can override p_cpi_attribute_category here
4231 return p_cpi_attribute_category;
4232 --
4233 if g_debug then
4234 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4235 end if;
4236 --
4237
4238 exception
4239 when others then
4240 hr_utility.set_location('Exception in '|| l_proc, 99);
4241 raise;
4242
4243 end;
4244
4245 -- --------------------------------------------------------------------------
4246 -- |-------------------------< get_cpi_attribute1 >-------------------------|
4247 -- --------------------------------------------------------------------------
4248 -- Description
4249 -- This function returns the cpi_attribute1
4250 --
4251 function get_cpi_attribute1(p_person_id in number
4252 ,p_assignment_id in number
4253 ,p_legislation_code in varchar2
4254 ,p_group_pl_id in number
4255 ,p_lf_evt_ocrd_dt in date
4256 ,p_effective_date in date
4257 ,p_cpi_attribute1 in varchar2)
4258 return varchar2 is
4259 --
4260 l_proc varchar2(72) := g_package||'get_cpi_attribute1';
4261 --
4262 begin
4263 --
4264 if g_debug then
4265 hr_utility.set_location('Entering:'|| l_proc, 10);
4266 end if;
4267 --
4268 -- Customer can override p_cpi_attribute1 here
4269 return p_cpi_attribute1;
4270 --
4271 if g_debug then
4272 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4273 end if;
4274 --
4275
4276 exception
4277 when others then
4278 hr_utility.set_location('Exception in '|| l_proc, 99);
4279 raise;
4280
4281 end;
4282 -- --------------------------------------------------------------------------
4283 -- |-------------------------< get_cpi_attribute2 >-------------------------|
4284 -- --------------------------------------------------------------------------
4285 -- Description
4286 -- This function returns the cpi_attribute2
4287 --
4288 function get_cpi_attribute2(p_person_id in number
4289 ,p_assignment_id in number
4290 ,p_legislation_code in varchar2
4291 ,p_group_pl_id in number
4292 ,p_lf_evt_ocrd_dt in date
4293 ,p_effective_date in date
4294 ,p_cpi_attribute2 in varchar2)
4295 return varchar2 is
4296 --
4297 l_proc varchar2(72) := g_package||'get_cpi_attribute2';
4298 --
4299 begin
4300 --
4301 if g_debug then
4302 hr_utility.set_location('Entering:'|| l_proc, 10);
4303 end if;
4304 --
4305 -- Customer can override p_cpi_attribute2 here
4306 return p_cpi_attribute2;
4307 --
4308 if g_debug then
4309 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4310 end if;
4311 --
4312
4313 exception
4314 when others then
4315 hr_utility.set_location('Exception in '|| l_proc, 99);
4316 raise;
4317
4318 end;
4319 -- --------------------------------------------------------------------------
4320 -- |-------------------------< get_cpi_attribute3 >-------------------------|
4321 -- --------------------------------------------------------------------------
4322 -- Description
4323 -- This function returns the cpi_attribute3
4324 --
4325 function get_cpi_attribute3(p_person_id in number
4326 ,p_assignment_id in number
4327 ,p_legislation_code in varchar2
4328 ,p_group_pl_id in number
4329 ,p_lf_evt_ocrd_dt in date
4330 ,p_effective_date in date
4331 ,p_cpi_attribute3 in varchar2)
4332 return varchar2 is
4333 --
4334 l_proc varchar2(72) := g_package||'get_cpi_attribute3';
4335 --
4336 begin
4337 --
4338 if g_debug then
4339 hr_utility.set_location('Entering:'|| l_proc, 10);
4340 end if;
4341 --
4342 -- Customer can override p_cpi_attribute3 here
4343 return p_cpi_attribute3;
4344 --
4345 if g_debug then
4346 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4347 end if;
4348 --
4349
4350 exception
4351 when others then
4352 hr_utility.set_location('Exception in '|| l_proc, 99);
4353 raise;
4354
4355 end;
4356 -- --------------------------------------------------------------------------
4357 -- |-------------------------< get_cpi_attribute4 >-------------------------|
4358 -- --------------------------------------------------------------------------
4359 -- Description
4360 -- This function returns the cpi_attribute4
4361 --
4362 function get_cpi_attribute4(p_person_id in number
4363 ,p_assignment_id in number
4364 ,p_legislation_code in varchar2
4365 ,p_group_pl_id in number
4369 return varchar2 is
4366 ,p_lf_evt_ocrd_dt in date
4367 ,p_effective_date in date
4368 ,p_cpi_attribute4 in varchar2)
4370 --
4371 l_proc varchar2(72) := g_package||'get_cpi_attribute4';
4372 --
4373 begin
4374 --
4375 if g_debug then
4376 hr_utility.set_location('Entering:'|| l_proc, 10);
4377 end if;
4378 --
4379 -- Customer can override p_cpi_attribute4 here
4380 return p_cpi_attribute4;
4381 --
4382 if g_debug then
4383 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4384 end if;
4385 --
4386
4387 exception
4388 when others then
4389 hr_utility.set_location('Exception in '|| l_proc, 99);
4390 raise;
4391
4392 end;
4393 -- --------------------------------------------------------------------------
4394 -- |-------------------------< get_cpi_attribute5 >-------------------------|
4395 -- --------------------------------------------------------------------------
4396 -- Description
4397 -- This function returns the cpi_attribute5
4398 --
4399 function get_cpi_attribute5(p_person_id in number
4400 ,p_assignment_id in number
4401 ,p_legislation_code in varchar2
4402 ,p_group_pl_id in number
4403 ,p_lf_evt_ocrd_dt in date
4404 ,p_effective_date in date
4405 ,p_cpi_attribute5 in varchar2)
4406 return varchar2 is
4407 --
4408 l_proc varchar2(72) := g_package||'get_cpi_attribute5';
4409 --
4410 begin
4411 --
4412 if g_debug then
4413 hr_utility.set_location('Entering:'|| l_proc, 10);
4414 end if;
4415 --
4416 -- Customer can override p_cpi_attribute5 here
4417 return p_cpi_attribute5;
4418 --
4419 if g_debug then
4420 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4421 end if;
4422 --
4423
4424 exception
4425 when others then
4426 hr_utility.set_location('Exception in '|| l_proc, 99);
4427 raise;
4428
4429 end;
4430 -- --------------------------------------------------------------------------
4431 -- |-------------------------< get_cpi_attribute6 >-------------------------|
4432 -- --------------------------------------------------------------------------
4433 -- Description
4434 -- This function returns the cpi_attribute6
4435 --
4436 function get_cpi_attribute6(p_person_id in number
4437 ,p_assignment_id in number
4438 ,p_legislation_code in varchar2
4439 ,p_group_pl_id in number
4440 ,p_lf_evt_ocrd_dt in date
4441 ,p_effective_date in date
4442 ,p_cpi_attribute6 in varchar2)
4443 return varchar2 is
4444 --
4445 l_proc varchar2(72) := g_package||'get_cpi_attribute6';
4446 --
4447 begin
4448 --
4449 if g_debug then
4450 hr_utility.set_location('Entering:'|| l_proc, 10);
4451 end if;
4452 --
4453 -- Customer can override p_cpi_attribute6 here
4454 return p_cpi_attribute6;
4455 --
4456 if g_debug then
4457 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4458 end if;
4459 --
4460
4461 exception
4462 when others then
4463 hr_utility.set_location('Exception in '|| l_proc, 99);
4464 raise;
4465
4466 end;
4467 -- --------------------------------------------------------------------------
4468 -- |-------------------------< get_cpi_attribute7 >-------------------------|
4469 -- --------------------------------------------------------------------------
4470 -- Description
4471 -- This function returns the cpi_attribute7
4472 --
4473 function get_cpi_attribute7(p_person_id in number
4474 ,p_assignment_id in number
4475 ,p_legislation_code in varchar2
4476 ,p_group_pl_id in number
4477 ,p_lf_evt_ocrd_dt in date
4478 ,p_effective_date in date
4479 ,p_cpi_attribute7 in varchar2)
4480 return varchar2 is
4481 --
4482 l_proc varchar2(72) := g_package||'get_cpi_attribute7';
4483 --
4484 begin
4485 --
4486 if g_debug then
4487 hr_utility.set_location('Entering:'|| l_proc, 10);
4488 end if;
4489 --
4490 -- Customer can override p_cpi_attribute7 here
4491 return p_cpi_attribute7;
4492 --
4493 if g_debug then
4494 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4495 end if;
4496 --
4497
4498 exception
4499 when others then
4500 hr_utility.set_location('Exception in '|| l_proc, 99);
4501 raise;
4502
4503 end;
4504 -- --------------------------------------------------------------------------
4505 -- |-------------------------< get_cpi_attribute8 >-------------------------|
4506 -- --------------------------------------------------------------------------
4507 -- Description
4508 -- This function returns the cpi_attribute8
4509 --
4510 function get_cpi_attribute8(p_person_id in number
4511 ,p_assignment_id in number
4512 ,p_legislation_code in varchar2
4513 ,p_group_pl_id in number
4514 ,p_lf_evt_ocrd_dt in date
4515 ,p_effective_date in date
4516 ,p_cpi_attribute8 in varchar2)
4517 return varchar2 is
4518 --
4522 --
4519 l_proc varchar2(72) := g_package||'get_cpi_attribute8';
4520 --
4521 begin
4523 if g_debug then
4524 hr_utility.set_location('Entering:'|| l_proc, 10);
4525 end if;
4526 --
4527 -- Customer can override p_cpi_attribute8 here
4528 return p_cpi_attribute8;
4529 --
4530 if g_debug then
4531 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4532 end if;
4533 --
4534
4535 exception
4536 when others then
4537 hr_utility.set_location('Exception in '|| l_proc, 99);
4538 raise;
4539
4540 end;
4541 -- --------------------------------------------------------------------------
4542 -- |-------------------------< get_cpi_attribute9 >-------------------------|
4543 -- --------------------------------------------------------------------------
4544 -- Description
4545 -- This function returns the cpi_attribute9
4546 --
4547 function get_cpi_attribute9(p_person_id in number
4548 ,p_assignment_id in number
4549 ,p_legislation_code in varchar2
4550 ,p_group_pl_id in number
4551 ,p_lf_evt_ocrd_dt in date
4552 ,p_effective_date in date
4553 ,p_cpi_attribute9 in varchar2)
4554 return varchar2 is
4555 --
4556 l_proc varchar2(72) := g_package||'get_cpi_attribute9';
4557 --
4558 begin
4559 --
4560 if g_debug then
4561 hr_utility.set_location('Entering:'|| l_proc, 10);
4562 end if;
4563 --
4564 -- Customer can override p_cpi_attribute9 here
4565 return p_cpi_attribute9;
4566 --
4567 if g_debug then
4568 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4569 end if;
4570 --
4571
4572 exception
4573 when others then
4574 hr_utility.set_location('Exception in '|| l_proc, 99);
4575 raise;
4576
4577 end;
4578 -- --------------------------------------------------------------------------
4579 -- |-------------------------< get_cpi_attribute10 >-------------------------|
4580 -- --------------------------------------------------------------------------
4581 -- Description
4582 -- This function returns the cpi_attribute10
4583 --
4584 function get_cpi_attribute10(p_person_id in number
4585 ,p_assignment_id in number
4586 ,p_legislation_code in varchar2
4587 ,p_group_pl_id in number
4588 ,p_lf_evt_ocrd_dt in date
4589 ,p_effective_date in date
4590 ,p_cpi_attribute10 in varchar2)
4591 return varchar2 is
4592 --
4593 l_proc varchar2(72) := g_package||'get_cpi_attribute10';
4594 --
4595 begin
4596 --
4597 if g_debug then
4598 hr_utility.set_location('Entering:'|| l_proc, 10);
4599 end if;
4600 --
4601 -- Customer can override p_cpi_attribute10 here
4602 return p_cpi_attribute10;
4603 --
4604 if g_debug then
4605 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4606 end if;
4607 --
4608
4609 exception
4610 when others then
4611 hr_utility.set_location('Exception in '|| l_proc, 99);
4612 raise;
4613
4614 end;
4615 -- --------------------------------------------------------------------------
4616 -- |-------------------------< get_cpi_attribute11 >-------------------------|
4617 -- --------------------------------------------------------------------------
4618 -- Description
4619 -- This function returns the cpi_attribute11
4620 --
4621 function get_cpi_attribute11(p_person_id in number
4622 ,p_assignment_id in number
4623 ,p_legislation_code in varchar2
4624 ,p_group_pl_id in number
4625 ,p_lf_evt_ocrd_dt in date
4626 ,p_effective_date in date
4627 ,p_cpi_attribute11 in varchar2)
4628 return varchar2 is
4629 --
4630 l_proc varchar2(72) := g_package||'get_cpi_attribute11';
4631 --
4632 begin
4633 --
4634 if g_debug then
4635 hr_utility.set_location('Entering:'|| l_proc, 10);
4636 end if;
4637 --
4638 -- Customer can override p_cpi_attribute11 here
4639 return p_cpi_attribute11;
4640 --
4641 if g_debug then
4642 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4643 end if;
4644 --
4645
4646 exception
4647 when others then
4648 hr_utility.set_location('Exception in '|| l_proc, 99);
4649 raise;
4650
4651 end;
4652 -- --------------------------------------------------------------------------
4653 -- |-------------------------< get_cpi_attribute12 >-------------------------|
4654 -- --------------------------------------------------------------------------
4655 -- Description
4656 -- This function returns the cpi_attribute12
4657 --
4658 function get_cpi_attribute12(p_person_id in number
4659 ,p_assignment_id in number
4660 ,p_legislation_code in varchar2
4661 ,p_group_pl_id in number
4662 ,p_lf_evt_ocrd_dt in date
4663 ,p_effective_date in date
4664 ,p_cpi_attribute12 in varchar2)
4665 return varchar2 is
4666 --
4667 l_proc varchar2(72) := g_package||'get_cpi_attribute12';
4668 --
4669
4670 begin
4671 --
4672 if g_debug then
4673 hr_utility.set_location('Entering:'|| l_proc, 10);
4674 end if;
4675 --
4679 if g_debug then
4676 -- Customer can override p_cpi_attribute12 here
4677 return p_cpi_attribute12;
4678 --
4680 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4681 end if;
4682 --
4683
4684 exception
4685 when others then
4686 hr_utility.set_location('Exception in '|| l_proc, 99);
4687 raise;
4688
4689 end;
4690 -- --------------------------------------------------------------------------
4691 -- |-------------------------< get_cpi_attribute13 >-------------------------|
4692 -- --------------------------------------------------------------------------
4693 -- Description
4694 -- This function returns the cpi_attribute13
4695 --
4696 function get_cpi_attribute13(p_person_id in number
4697 ,p_assignment_id in number
4698 ,p_legislation_code in varchar2
4699 ,p_group_pl_id in number
4700 ,p_lf_evt_ocrd_dt in date
4701 ,p_effective_date in date
4702 ,p_cpi_attribute13 in varchar2)
4703 return varchar2 is
4704 --
4705 l_proc varchar2(72) := g_package||'get_cpi_attribute13';
4706 --
4707 begin
4708 --
4709 if g_debug then
4710 hr_utility.set_location('Entering:'|| l_proc, 10);
4711 end if;
4712 --
4713 -- Customer can override p_cpi_attribute13 here
4714 return p_cpi_attribute13;
4715 --
4716 if g_debug then
4717 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4718 end if;
4719 --
4720
4721 exception
4722 when others then
4723 hr_utility.set_location('Exception in '|| l_proc, 99);
4724 raise;
4725
4726 end;
4727 -- --------------------------------------------------------------------------
4728 -- |-------------------------< get_cpi_attribute14 >-------------------------|
4729 -- --------------------------------------------------------------------------
4730 -- Description
4731 -- This function returns the cpi_attribute14
4732 --
4733 function get_cpi_attribute14(p_person_id in number
4734 ,p_assignment_id in number
4735 ,p_legislation_code in varchar2
4736 ,p_group_pl_id in number
4737 ,p_lf_evt_ocrd_dt in date
4738 ,p_effective_date in date
4739 ,p_cpi_attribute14 in varchar2)
4740 return varchar2 is
4741 --
4742 l_proc varchar2(72) := g_package||'get_cpi_attribute14';
4743 --
4744 begin
4745 --
4746 if g_debug then
4747 hr_utility.set_location('Entering:'|| l_proc, 10);
4748 end if;
4749 --
4750 -- Customer can override p_cpi_attribute14 here
4751 return p_cpi_attribute14;
4752 --
4753 if g_debug then
4754 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4755 end if;
4756 --
4757
4758 exception
4759 when others then
4760 hr_utility.set_location('Exception in '|| l_proc, 99);
4761 raise;
4762
4763 end;
4764 -- --------------------------------------------------------------------------
4765 -- |-------------------------< get_cpi_attribute15 >-------------------------|
4766 -- --------------------------------------------------------------------------
4767 -- Description
4768 -- This function returns the cpi_attribute15
4769 --
4770 function get_cpi_attribute15(p_person_id in number
4771 ,p_assignment_id in number
4772 ,p_legislation_code in varchar2
4773 ,p_group_pl_id in number
4774 ,p_lf_evt_ocrd_dt in date
4775 ,p_effective_date in date
4776 ,p_cpi_attribute15 in varchar2)
4777 return varchar2 is
4778 --
4779 l_proc varchar2(72) := g_package||'get_cpi_attribute15';
4780 --
4781 begin
4782 --
4783 if g_debug then
4784 hr_utility.set_location('Entering:'|| l_proc, 10);
4785 end if;
4786 --
4787 -- Customer can override p_cpi_attribute15 here
4788 return p_cpi_attribute15;
4789 --
4790 if g_debug then
4791 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4792 end if;
4793 --
4794
4795 exception
4796 when others then
4797 hr_utility.set_location('Exception in '|| l_proc, 99);
4798 raise;
4799
4800 end;
4801 -- --------------------------------------------------------------------------
4802 -- |-------------------------< get_cpi_attribute16 >-------------------------|
4803 -- --------------------------------------------------------------------------
4804 -- Description
4805 -- This function returns the cpi_attribute16
4806 --
4807 function get_cpi_attribute16(p_person_id in number
4808 ,p_assignment_id in number
4809 ,p_legislation_code in varchar2
4810 ,p_group_pl_id in number
4811 ,p_lf_evt_ocrd_dt in date
4812 ,p_effective_date in date
4813 ,p_cpi_attribute16 in varchar2)
4814 return varchar2 is
4815 --
4816 l_proc varchar2(72) := g_package||'get_cpi_attribute16';
4817 --
4818 begin
4819 --
4820 if g_debug then
4821 hr_utility.set_location('Entering:'|| l_proc, 10);
4822 end if;
4823 --
4824 -- Customer can override p_cpi_attribute16 here
4825 return p_cpi_attribute16;
4826 --
4827 if g_debug then
4828 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4829 end if;
4830 --
4831
4835 raise;
4832 exception
4833 when others then
4834 hr_utility.set_location('Exception in '|| l_proc, 99);
4836
4837 end;
4838 -- --------------------------------------------------------------------------
4839 -- |-------------------------< get_cpi_attribute17 >-------------------------|
4840 -- --------------------------------------------------------------------------
4841 -- Description
4842 -- This function returns the cpi_attribute17
4843 --
4844 function get_cpi_attribute17(p_person_id in number
4845 ,p_assignment_id in number
4846 ,p_legislation_code in varchar2
4847 ,p_group_pl_id in number
4848 ,p_lf_evt_ocrd_dt in date
4849 ,p_effective_date in date
4850 ,p_cpi_attribute17 in varchar2)
4851 return varchar2 is
4852 --
4853 l_proc varchar2(72) := g_package||'get_cpi_attribute17';
4854 --
4855 begin
4856 --
4857 if g_debug then
4858 hr_utility.set_location('Entering:'|| l_proc, 10);
4859 end if;
4860 --
4861 -- Customer can override p_cpi_attribute17 here
4862 return p_cpi_attribute17;
4863 --
4864 if g_debug then
4865 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4866 end if;
4867 --
4868
4869 exception
4870 when others then
4871 hr_utility.set_location('Exception in '|| l_proc, 99);
4872 raise;
4873
4874 end;
4875 -- --------------------------------------------------------------------------
4876 -- |-------------------------< get_cpi_attribute18 >-------------------------|
4877 -- --------------------------------------------------------------------------
4878 -- Description
4879 -- This function returns the cpi_attribute18
4880 --
4881 function get_cpi_attribute18(p_person_id in number
4882 ,p_assignment_id in number
4883 ,p_legislation_code in varchar2
4884 ,p_group_pl_id in number
4885 ,p_lf_evt_ocrd_dt in date
4886 ,p_effective_date in date
4887 ,p_cpi_attribute18 in varchar2)
4888 return varchar2 is
4889 --
4890 l_proc varchar2(72) := g_package||'get_cpi_attribute18';
4891 --
4892 begin
4893 --
4894 if g_debug then
4895 hr_utility.set_location('Entering:'|| l_proc, 10);
4896 end if;
4897 --
4898 -- Customer can override p_cpi_attribute18 here
4899 return p_cpi_attribute18;
4900 --
4901 if g_debug then
4902 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4903 end if;
4904 --
4905
4906 exception
4907 when others then
4908 hr_utility.set_location('Exception in '|| l_proc, 99);
4909 raise;
4910
4911 end;
4912 -- --------------------------------------------------------------------------
4913 -- |-------------------------< get_cpi_attribute19 >-------------------------|
4914 -- --------------------------------------------------------------------------
4915 -- Description
4916 -- This function returns the cpi_attribute19
4917 --
4918 function get_cpi_attribute19(p_person_id in number
4919 ,p_assignment_id in number
4920 ,p_legislation_code in varchar2
4921 ,p_group_pl_id in number
4922 ,p_lf_evt_ocrd_dt in date
4923 ,p_effective_date in date
4924 ,p_cpi_attribute19 in varchar2)
4925 return varchar2 is
4926 --
4927 l_proc varchar2(72) := g_package||'get_cpi_attribute19';
4928 --
4929 begin
4930 --
4931 if g_debug then
4932 hr_utility.set_location('Entering:'|| l_proc, 10);
4933 end if;
4934 --
4935 -- Customer can override p_cpi_attribute19 here
4936 return p_cpi_attribute19;
4937 --
4938 if g_debug then
4939 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4940 end if;
4941 --
4942
4943 exception
4944 when others then
4945 hr_utility.set_location('Exception in '|| l_proc, 99);
4946 raise;
4947
4948 end;
4949
4950 -- --------------------------------------------------------------------------
4951 -- |-------------------------< get_cpi_attribute20 >-------------------------|
4952 -- --------------------------------------------------------------------------
4953 -- Description
4954 -- This function returns the cpi_attribute20
4955 --
4956 function get_cpi_attribute20(p_person_id in number
4957 ,p_assignment_id in number
4958 ,p_legislation_code in varchar2
4959 ,p_group_pl_id in number
4960 ,p_lf_evt_ocrd_dt in date
4961 ,p_effective_date in date
4962 ,p_cpi_attribute20 in varchar2)
4963 return varchar2 is
4964 --
4965 l_proc varchar2(72) := g_package||'get_cpi_attribute20';
4966 --
4967 begin
4968 --
4969 if g_debug then
4970 hr_utility.set_location('Entering:'|| l_proc, 10);
4971 end if;
4972 --
4973 -- Customer can override p_cpi_attribute20 here
4974 return p_cpi_attribute20;
4975 --
4976 if g_debug then
4977 hr_utility.set_location(' Leaving:'|| l_proc, 99);
4978 end if;
4979 --
4980
4981 exception
4982 when others then
4983 hr_utility.set_location('Exception in '|| l_proc, 99);
4984 raise;
4985
4986 end;
4987
4991 -- Description
4988 -- --------------------------------------------------------------------------
4989 -- |-------------------------< get_cpi_attribute21 >-------------------------|
4990 -- --------------------------------------------------------------------------
4992 -- This function returns the cpi_attribute21
4993 --
4994 function get_cpi_attribute21(p_person_id in number
4995 ,p_assignment_id in number
4996 ,p_legislation_code in varchar2
4997 ,p_group_pl_id in number
4998 ,p_lf_evt_ocrd_dt in date
4999 ,p_effective_date in date
5000 ,p_cpi_attribute21 in varchar2)
5001 return varchar2 is
5002 --
5003 l_proc varchar2(72) := g_package||'get_cpi_attribute21';
5004 --
5005 begin
5006 --
5007 if g_debug then
5008 hr_utility.set_location('Entering:'|| l_proc, 10);
5009 end if;
5010 --
5011 -- Customer can override p_cpi_attribute21 here
5012 return p_cpi_attribute21;
5013 --
5014 if g_debug then
5015 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5016 end if;
5017 --
5018
5019 exception
5020 when others then
5021 hr_utility.set_location('Exception in '|| l_proc, 99);
5022 raise;
5023
5024 end;
5025
5026 -- --------------------------------------------------------------------------
5027 -- |-------------------------< get_cpi_attribute22 >-------------------------|
5028 -- --------------------------------------------------------------------------
5029 -- Description
5030 -- This function returns the cpi_attribute22
5031 --
5032 function get_cpi_attribute22(p_person_id in number
5033 ,p_assignment_id in number
5034 ,p_legislation_code in varchar2
5035 ,p_group_pl_id in number
5036 ,p_lf_evt_ocrd_dt in date
5037 ,p_effective_date in date
5038 ,p_cpi_attribute22 in varchar2)
5039 return varchar2 is
5040 --
5041 l_proc varchar2(72) := g_package||'get_cpi_attribute22';
5042 --
5043 begin
5044 --
5045 if g_debug then
5046 hr_utility.set_location('Entering:'|| l_proc, 10);
5047 end if;
5048 --
5049 -- Customer can override p_cpi_attribute22 here
5050 return p_cpi_attribute22;
5051 --
5052 if g_debug then
5053 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5054 end if;
5055 --
5056
5057 exception
5058 when others then
5059 hr_utility.set_location('Exception in '|| l_proc, 99);
5060 raise;
5061
5062 end;
5063 -- --------------------------------------------------------------------------
5064 -- |-------------------------< get_cpi_attribute23 >-------------------------|
5065 -- --------------------------------------------------------------------------
5066 -- Description
5067 -- This function returns the cpi_attribute23
5068 --
5069 function get_cpi_attribute23(p_person_id in number
5070 ,p_assignment_id in number
5071 ,p_legislation_code in varchar2
5072 ,p_group_pl_id in number
5073 ,p_lf_evt_ocrd_dt in date
5074 ,p_effective_date in date
5075 ,p_cpi_attribute23 in varchar2)
5076 return varchar2 is
5077 --
5078 l_proc varchar2(72) := g_package||'get_cpi_attribute23';
5079 --
5080 begin
5081 --
5082 if g_debug then
5083 hr_utility.set_location('Entering:'|| l_proc, 10);
5084 end if;
5085 --
5086 -- Customer can override p_cpi_attribute23 here
5087 return p_cpi_attribute23;
5088 --
5089 if g_debug then
5090 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5091 end if;
5092 --
5093
5094 exception
5095 when others then
5096 hr_utility.set_location('Exception in '|| l_proc, 99);
5097 raise;
5098
5099 end;
5100 -- --------------------------------------------------------------------------
5101 -- |-------------------------< get_cpi_attribute24 >-------------------------|
5102 -- --------------------------------------------------------------------------
5103 -- Description
5104 -- This function returns the cpi_attribute24
5105 --
5106 function get_cpi_attribute24(p_person_id in number
5107 ,p_assignment_id in number
5108 ,p_legislation_code in varchar2
5109 ,p_group_pl_id in number
5110 ,p_lf_evt_ocrd_dt in date
5111 ,p_effective_date in date
5112 ,p_cpi_attribute24 in varchar2)
5113 return varchar2 is
5114 --
5115 l_proc varchar2(72) := g_package||'get_cpi_attribute24';
5116 --
5117 begin
5118 --
5119 if g_debug then
5120 hr_utility.set_location('Entering:'|| l_proc, 10);
5121 end if;
5122 --
5123 -- Customer can override p_cpi_attribute24 here
5124 return p_cpi_attribute24;
5125 --
5126 if g_debug then
5127 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5128 end if;
5129 --
5130
5131 exception
5132 when others then
5133 hr_utility.set_location('Exception in '|| l_proc, 99);
5134 raise;
5135
5136 end;
5137 -- --------------------------------------------------------------------------
5138 -- |-------------------------< get_cpi_attribute25 >-------------------------|
5139 -- --------------------------------------------------------------------------
5143 function get_cpi_attribute25(p_person_id in number
5140 -- Description
5141 -- This function returns the cpi_attribute25
5142 --
5144 ,p_assignment_id in number
5145 ,p_legislation_code in varchar2
5146 ,p_group_pl_id in number
5147 ,p_lf_evt_ocrd_dt in date
5148 ,p_effective_date in date
5149 ,p_cpi_attribute25 in varchar2)
5150 return varchar2 is
5151 --
5152 l_proc varchar2(72) := g_package||'get_cpi_attribute25';
5153 --
5154 begin
5155 --
5156 if g_debug then
5157 hr_utility.set_location('Entering:'|| l_proc, 10);
5158 end if;
5159 --
5160 -- Customer can override p_cpi_attribute25 here
5161 return p_cpi_attribute25;
5162 --
5163 if g_debug then
5164 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5165 end if;
5166 --
5167
5168 exception
5169 when others then
5170 hr_utility.set_location('Exception in '|| l_proc, 99);
5171 raise;
5172
5173 end;
5174 -- --------------------------------------------------------------------------
5175 -- |-------------------------< get_cpi_attribute26 >-------------------------|
5176 -- --------------------------------------------------------------------------
5177 -- Description
5178 -- This function returns the cpi_attribute26
5179 --
5180 function get_cpi_attribute26(p_person_id in number
5181 ,p_assignment_id in number
5182 ,p_legislation_code in varchar2
5183 ,p_group_pl_id in number
5184 ,p_lf_evt_ocrd_dt in date
5185 ,p_effective_date in date
5186 ,p_cpi_attribute26 in varchar2)
5187 return varchar2 is
5188 --
5189 l_proc varchar2(72) := g_package||'get_cpi_attribute26';
5190 --
5191 begin
5192 --
5193 if g_debug then
5194 hr_utility.set_location('Entering:'|| l_proc, 10);
5195 end if;
5196 --
5197 -- Customer can override p_cpi_attribute26 here
5198 return p_cpi_attribute26;
5199 --
5200 if g_debug then
5201 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5202 end if;
5203 --
5204
5205 exception
5206 when others then
5207 hr_utility.set_location('Exception in '|| l_proc, 99);
5208 raise;
5209
5210 end;
5211 -- --------------------------------------------------------------------------
5212 -- |-------------------------< get_cpi_attribute27 >-------------------------|
5213 -- --------------------------------------------------------------------------
5214 -- Description
5215 -- This function returns the cpi_attribute27
5216 --
5217 function get_cpi_attribute27(p_person_id in number
5218 ,p_assignment_id in number
5219 ,p_legislation_code in varchar2
5220 ,p_group_pl_id in number
5221 ,p_lf_evt_ocrd_dt in date
5222 ,p_effective_date in date
5223 ,p_cpi_attribute27 in varchar2)
5224 return varchar2 is
5225 --
5226 l_proc varchar2(72) := g_package||'get_cpi_attribute27';
5227 --
5228 begin
5229 --
5230 if g_debug then
5231 hr_utility.set_location('Entering:'|| l_proc, 10);
5232 end if;
5233 --
5234 -- Customer can override p_cpi_attribute27 here
5235 return p_cpi_attribute27;
5236 --
5237 if g_debug then
5238 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5239 end if;
5240 --
5241
5242 exception
5243 when others then
5244 hr_utility.set_location('Exception in '|| l_proc, 99);
5245 raise;
5246
5247 end;
5248 -- --------------------------------------------------------------------------
5249 -- |-------------------------< get_cpi_attribute28 >-------------------------|
5250 -- --------------------------------------------------------------------------
5251 -- Description
5252 -- This function returns the cpi_attribute28
5253 --
5254 function get_cpi_attribute28(p_person_id in number
5255 ,p_assignment_id in number
5256 ,p_legislation_code in varchar2
5257 ,p_group_pl_id in number
5258 ,p_lf_evt_ocrd_dt in date
5259 ,p_effective_date in date
5260 ,p_cpi_attribute28 in varchar2)
5261 return varchar2 is
5262 --
5263 l_proc varchar2(72) := g_package||'get_cpi_attribute28';
5264 --
5265 begin
5266 --
5267 if g_debug then
5268 hr_utility.set_location('Entering:'|| l_proc, 10);
5269 end if;
5270 --
5271 -- Customer can override p_cpi_attribute28 here
5272 return p_cpi_attribute28;
5273 --
5274 if g_debug then
5275 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5276 end if;
5277 --
5278
5279 exception
5280 when others then
5281 hr_utility.set_location('Exception in '|| l_proc, 99);
5282 raise;
5283
5284 end;
5285 -- --------------------------------------------------------------------------
5286 -- |-------------------------< get_cpi_attribute29 >-------------------------|
5287 -- --------------------------------------------------------------------------
5288 -- Description
5289 -- This function returns the cpi_attribute29
5290 --
5291 function get_cpi_attribute29(p_person_id in number
5292 ,p_assignment_id in number
5296 ,p_effective_date in date
5293 ,p_legislation_code in varchar2
5294 ,p_group_pl_id in number
5295 ,p_lf_evt_ocrd_dt in date
5297 ,p_cpi_attribute29 in varchar2)
5298 return varchar2 is
5299 --
5300 l_proc varchar2(72) := g_package||'get_cpi_attribute29';
5301 --
5302 begin
5303 --
5304 if g_debug then
5305 hr_utility.set_location('Entering:'|| l_proc, 10);
5306 end if;
5307 --
5308 -- Customer can override p_cpi_attribute29 here
5309 return p_cpi_attribute29;
5310 --
5311 if g_debug then
5312 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5313 end if;
5314 --
5315
5316 exception
5317 when others then
5318 hr_utility.set_location('Exception in '|| l_proc, 99);
5319 raise;
5320
5321 end;
5322
5323 -- --------------------------------------------------------------------------
5324 -- |-------------------------< get_cpi_attribute30 >-------------------------|
5325 -- --------------------------------------------------------------------------
5326 -- Description
5327 -- This function returns the cpi_attribute30
5328 --
5329 function get_cpi_attribute30(p_person_id in number
5330 ,p_assignment_id in number
5331 ,p_legislation_code in varchar2
5332 ,p_group_pl_id in number
5333 ,p_lf_evt_ocrd_dt in date
5334 ,p_effective_date in date
5335 ,p_cpi_attribute30 in varchar2)
5336 return varchar2 is
5337 --
5338 l_proc varchar2(72) := g_package||'get_cpi_attribute30';
5339 --
5340
5341 begin
5342 --
5343 if g_debug then
5344 hr_utility.set_location('Entering:'|| l_proc, 10);
5345 end if;
5346 --
5347 -- Customer can override p_cpi_attribute30 here
5348 return p_cpi_attribute30;
5349 --
5350 if g_debug then
5351 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5352 end if;
5353 --
5354
5355 exception
5356 when others then
5357 hr_utility.set_location('Exception in '|| l_proc, 99);
5358 raise;
5359
5360 end;
5361
5362 -- --------------------------------------------------------------------------
5363 -- |-------------------------< get_grd_quintile >-------------------------|
5364 -- --------------------------------------------------------------------------
5365 -- Description
5366 -- This function returns the grd_quintile
5367 --
5368 function get_grd_quintile(p_person_id in number
5369 ,p_assignment_id in number
5370 ,p_legislation_code in varchar2
5371 ,p_group_pl_id in number
5372 ,p_lf_evt_ocrd_dt in date
5373 ,p_effective_date in date
5374 ,p_grd_quintile in varchar2)
5375 return varchar2 is
5376 --
5377 l_proc varchar2(72) := g_package||'get_grd_quintile';
5378 --
5379 begin
5380 --
5381 if g_debug then
5382 hr_utility.set_location('Entering:'|| l_proc, 10);
5383 end if;
5384 --
5385 -- Customer can override p_grd_quintile here
5386 return p_grd_quintile;
5387 --
5388 if g_debug then
5389 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5390 end if;
5391 --
5392
5393 exception
5394 when others then
5395 hr_utility.set_location('Exception in '|| l_proc, 99);
5396 raise;
5397
5398 end;
5399 -- --------------------------------------------------------------------------
5400 -- |-------------------------< get_grd_decile >-------------------------|
5401 -- --------------------------------------------------------------------------
5402 -- Description
5403 -- This function returns the grd_decile
5404 --
5405 function get_grd_decile(p_person_id in number
5406 ,p_assignment_id in number
5407 ,p_legislation_code in varchar2
5408 ,p_group_pl_id in number
5409 ,p_lf_evt_ocrd_dt in date
5410 ,p_effective_date in date
5411 ,p_grd_decile in varchar2)
5412 return varchar2 is
5413 --
5414 l_proc varchar2(72) := g_package||'get_grd_decile';
5415 --
5416 begin
5417 --
5418 if g_debug then
5419 hr_utility.set_location('Entering:'|| l_proc, 10);
5420 end if;
5421 --
5422 -- Customer can override p_grd_decile here
5423 return p_grd_decile;
5424 --
5425 if g_debug then
5426 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5427 end if;
5428 --
5429
5430 exception
5431 when others then
5432 hr_utility.set_location('Exception in '|| l_proc, 99);
5433 raise;
5434
5435 end;
5436 -- --------------------------------------------------------------------------
5437 -- |-------------------------< get_grade_rate_frequency >-------------------------|
5438 -- --------------------------------------------------------------------------
5439 -- Description
5440 -- This function returns the grade_rate_frequency
5441 --
5442 function get_grade_rate_frequency(p_person_id in number
5443 ,p_assignment_id in number
5444 ,p_legislation_code in varchar2
5445 ,p_group_pl_id in number
5446 ,p_lf_evt_ocrd_dt in date
5447 ,p_effective_date in date
5451 l_proc varchar2(72) := g_package||'get_grade_rate_frequency';
5448 ,p_grade_rate_frequency in varchar2)
5449 return varchar2 is
5450 --
5452 --
5453
5454 begin
5455 --
5456 if g_debug then
5457 hr_utility.set_location('Entering:'|| l_proc, 10);
5458 end if;
5459 --
5460 -- Customer can override p_grade_rate_frequency here
5461 return p_grade_rate_frequency;
5462 --
5463 if g_debug then
5464 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5465 end if;
5466 --
5467
5468 exception
5469 when others then
5470 hr_utility.set_location('Exception in '|| l_proc, 99);
5471 raise;
5472
5473 end;
5474 -- --------------------------------------------------------------------------
5475 -- |-------------------------< get_base_salary_currency >-------------------------|
5476 -- --------------------------------------------------------------------------
5477 -- Description
5478 -- This function returns the base_salary_currency
5479 --
5480 function get_base_salary_currency(p_person_id in number
5481 ,p_assignment_id in number
5482 ,p_legislation_code in varchar2
5483 ,p_group_pl_id in number
5484 ,p_lf_evt_ocrd_dt in date
5485 ,p_effective_date in date
5486 ,p_base_salary_currency in varchar2)
5487 return varchar2 is
5488 --
5489 l_proc varchar2(72) := g_package||'get_base_salary_currency';
5490 --
5491 begin
5492 --
5493 if g_debug then
5494 hr_utility.set_location('Entering:'|| l_proc, 10);
5495 end if;
5496 --
5497 -- Customer can override p_base_salary_currency here
5498 return p_base_salary_currency;
5499 --
5500 if g_debug then
5501 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5502 end if;
5503 --
5504
5505 exception
5506 when others then
5507 hr_utility.set_location('Exception in '|| l_proc, 99);
5508 raise;
5509
5510 end;
5511 -- --------------------------------------------------------------------------
5512 -- |-------------------------< get_sal_1_yr_ago_freq >-------------------------|
5513 -- --------------------------------------------------------------------------
5514 -- Description
5515 -- This function returns the salary_1_year_ago_frequency
5516 --
5517 function get_sal_1_yr_ago_freq(p_person_id in number
5518 ,p_assignment_id in number
5519 ,p_legislation_code in varchar2
5520 ,p_group_pl_id in number
5521 ,p_lf_evt_ocrd_dt in date
5522 ,p_effective_date in date
5523 ,p_salary_1_year_ago_frequency in varchar2)
5524 return varchar2 is
5525 --
5526 l_proc varchar2(72) := g_package||'get_sal_1_yr_ago_freq';
5527 --
5528 begin
5529 --
5530 if g_debug then
5531 hr_utility.set_location('Entering:'|| l_proc, 10);
5532 end if;
5533 --
5534 -- Customer can override p_salary_1_year_ago_frequency here
5535 return p_salary_1_year_ago_frequency;
5536 --
5537 if g_debug then
5538 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5539 end if;
5540 --
5541
5542 exception
5543 when others then
5544 hr_utility.set_location('Exception in '|| l_proc, 99);
5545 raise;
5546
5547 end;
5548 -- --------------------------------------------------------------------------
5549 -- |-------------------------< get_sal_1_yr_ago_curr >-------------------------|
5550 -- --------------------------------------------------------------------------
5551 -- Description
5552 -- This function returns the salary_1_year_ago_currency
5553 --
5554 function get_sal_1_yr_ago_curr(p_person_id in number
5555 ,p_assignment_id in number
5556 ,p_legislation_code in varchar2
5557 ,p_group_pl_id in number
5558 ,p_lf_evt_ocrd_dt in date
5559 ,p_effective_date in date
5560 ,p_salary_1_year_ago_currency in varchar2)
5561 return varchar2 is
5562 --
5563 l_proc varchar2(72) := g_package||'get_sal_1_yr_ago_curr';
5564 --
5565 begin
5566 --
5567 if g_debug then
5568 hr_utility.set_location('Entering:'|| l_proc, 10);
5569 end if;
5570 --
5571 -- Customer can override p_salary_1_year_ago_currency here
5572 return p_salary_1_year_ago_currency;
5573 --
5574 if g_debug then
5575 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5576 end if;
5577 --
5578
5579 exception
5580 when others then
5581 hr_utility.set_location('Exception in '|| l_proc, 99);
5582 raise;
5583
5584 end;
5585 -- --------------------------------------------------------------------------
5586 -- |-------------------------< get_sal_2_yr_ago_freq >-------------------------|
5587 -- --------------------------------------------------------------------------
5588 -- Description
5589 -- This function returns the salary_2_year_ago_frequency
5590 --
5591 function get_sal_2_yr_ago_freq(p_person_id in number
5592 ,p_assignment_id in number
5593 ,p_legislation_code in varchar2
5594 ,p_group_pl_id in number
5595 ,p_lf_evt_ocrd_dt in date
5596 ,p_effective_date in date
5597 ,p_salary_2_year_ago_frequency in varchar2)
5601 --
5598 return varchar2 is
5599 --
5600 l_proc varchar2(72) := g_package||'get_sal_2_yr_ago_freq';
5602
5603 begin
5604 --
5605 if g_debug then
5606 hr_utility.set_location('Entering:'|| l_proc, 10);
5607 end if;
5608 --
5609 -- Customer can override p_salary_2_year_ago_frequency here
5610 return p_salary_2_year_ago_frequency;
5611 --
5612 if g_debug then
5613 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5614 end if;
5615 --
5616
5617 exception
5618 when others then
5619 hr_utility.set_location('Exception in '|| l_proc, 99);
5620 raise;
5621
5622 end;
5623 -- --------------------------------------------------------------------------
5624 -- |-------------------------< get_sal_2_yr_ago_curr >-------------------------|
5625 -- --------------------------------------------------------------------------
5626 -- Description
5627 -- This function returns the salary_2_year_ago_currency
5628 --
5629 function get_sal_2_yr_ago_curr(p_person_id in number
5630 ,p_assignment_id in number
5631 ,p_legislation_code in varchar2
5632 ,p_group_pl_id in number
5633 ,p_lf_evt_ocrd_dt in date
5634 ,p_effective_date in date
5635 ,p_salary_2_year_ago_currency in varchar2)
5636 return varchar2 is
5637 --
5638 l_proc varchar2(72) := g_package||'get_sal_2_yr_ago_curr';
5639 --
5640
5641 begin
5642 --
5643 if g_debug then
5644 hr_utility.set_location('Entering:'|| l_proc, 10);
5645 end if;
5646 --
5647 -- Customer can override p_salary_2_year_ago_currency here
5648 return p_salary_2_year_ago_currency;
5649 --
5650 if g_debug then
5651 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5652 end if;
5653 --
5654
5655 exception
5656 when others then
5657 hr_utility.set_location('Exception in '|| l_proc, 99);
5658 raise;
5659
5660 end;
5661 -- --------------------------------------------------------------------------
5662 -- |-------------------------< get_sal_3_yr_ago_curr >-------------------------|
5663 -- --------------------------------------------------------------------------
5664 -- Description
5665 -- This function returns the salary_3_year_ago_currency
5666 --
5667 function get_sal_3_yr_ago_curr(p_person_id in number
5668 ,p_assignment_id in number
5669 ,p_legislation_code in varchar2
5670 ,p_group_pl_id in number
5671 ,p_lf_evt_ocrd_dt in date
5672 ,p_effective_date in date
5673 ,p_salary_3_year_ago_currency in varchar2)
5674 return varchar2 is
5675 --
5676 l_proc varchar2(72) := g_package||'get_sal_3_yr_ago_curr';
5677 --
5678 begin
5679 --
5680 if g_debug then
5681 hr_utility.set_location('Entering:'|| l_proc, 10);
5682 end if;
5683 --
5684 -- Customer can override p_salary_3_year_ago_currency here
5685 return p_salary_3_year_ago_currency;
5686 --
5687 if g_debug then
5688 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5689 end if;
5690 --
5691
5692 exception
5693 when others then
5694 hr_utility.set_location('Exception in '|| l_proc, 99);
5695 raise;
5696
5697 end;
5698 -- --------------------------------------------------------------------------
5699 -- |-------------------------< get_sal_3_yr_ago_freq >-------------------------|
5700 -- --------------------------------------------------------------------------
5701 -- Description
5702 -- This function returns the salary_3_year_ago_frequency
5703 --
5704 function get_sal_3_yr_ago_freq(p_person_id in number
5705 ,p_assignment_id in number
5706 ,p_legislation_code in varchar2
5707 ,p_group_pl_id in number
5708 ,p_lf_evt_ocrd_dt in date
5709 ,p_effective_date in date
5710 ,p_salary_3_year_ago_frequency in varchar2)
5711 return varchar2 is
5712 --
5713 l_proc varchar2(72) := g_package||'get_sal_3_yr_ago_freq';
5714 --
5715
5716 begin
5717 --
5718 if g_debug then
5719 hr_utility.set_location('Entering:'|| l_proc, 10);
5720 end if;
5721 --
5722 -- Customer can override p_salary_3_year_ago_frequency here
5723 return p_salary_3_year_ago_frequency;
5724 --
5725 if g_debug then
5726 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5727 end if;
5728 --
5729
5730 exception
5731 when others then
5732 hr_utility.set_location('Exception in '|| l_proc, 99);
5733 raise;
5734
5735 end;
5736 -- --------------------------------------------------------------------------
5737 -- |-------------------------< get_sal_4_yr_ago_freq >-------------------------|
5738 -- --------------------------------------------------------------------------
5739 -- Description
5740 -- This function returns the salary_4_year_ago_frequency
5741 --
5742 function get_sal_4_yr_ago_freq(p_person_id in number
5743 ,p_assignment_id in number
5744 ,p_legislation_code in varchar2
5745 ,p_group_pl_id in number
5746 ,p_lf_evt_ocrd_dt in date
5747 ,p_effective_date in date
5748 ,p_salary_4_year_ago_frequency in varchar2)
5749 return varchar2 is
5750 --
5754 --
5751 l_proc varchar2(72) := g_package||'get_sal_4_yr_ago_freq';
5752 --
5753 begin
5755 if g_debug then
5756 hr_utility.set_location('Entering:'|| l_proc, 10);
5757 end if;
5758 --
5759 -- Customer can override p_salary_4_year_ago_frequency here
5760 return p_salary_4_year_ago_frequency;
5761 --
5762 if g_debug then
5763 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5764 end if;
5765 --
5766
5767 exception
5768 when others then
5769 hr_utility.set_location('Exception in '|| l_proc, 99);
5770 raise;
5771
5772 end;
5773 -- --------------------------------------------------------------------------
5774 -- |-------------------------< get_sal_4_yr_ago_curr >-------------------------|
5775 -- --------------------------------------------------------------------------
5776 -- Description
5777 -- This function returns the salary_4_year_ago_currency
5778 --
5779 function get_sal_4_yr_ago_curr(p_person_id in number
5780 ,p_assignment_id in number
5781 ,p_legislation_code in varchar2
5782 ,p_group_pl_id in number
5783 ,p_lf_evt_ocrd_dt in date
5784 ,p_effective_date in date
5785 ,p_salary_4_year_ago_currency in varchar2)
5786 return varchar2 is
5787 --
5788 l_proc varchar2(72) := g_package||'get_sal_4_yr_ago_curr';
5789 --
5790 begin
5791 --
5792 if g_debug then
5793 hr_utility.set_location('Entering:'|| l_proc, 10);
5794 end if;
5795 --
5796 -- Customer can override p_salary_4_year_ago_currency here
5797 return p_salary_4_year_ago_currency;
5798 --
5799 if g_debug then
5800 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5801 end if;
5802 --
5803
5804 exception
5805 when others then
5806 hr_utility.set_location('Exception in '|| l_proc, 99);
5807 raise;
5808
5809 end;
5810 -- --------------------------------------------------------------------------
5811 -- |-------------------------< get_sal_5_yr_ago_freq >-------------------------|
5812 -- --------------------------------------------------------------------------
5813 -- Description
5814 -- This function returns the salary_5_year_ago_frequency
5815 --
5816 function get_sal_5_yr_ago_freq(p_person_id in number
5817 ,p_assignment_id in number
5818 ,p_legislation_code in varchar2
5819 ,p_group_pl_id in number
5820 ,p_lf_evt_ocrd_dt in date
5821 ,p_effective_date in date
5822 ,p_salary_5_year_ago_frequency in varchar2)
5823 return varchar2 is
5824 --
5825 l_proc varchar2(72) := g_package||'get_sal_5_yr_ago_freq';
5826 --
5827
5828 begin
5829 --
5830 if g_debug then
5831 hr_utility.set_location('Entering:'|| l_proc, 10);
5832 end if;
5833 --
5834 -- Customer can override p_salary_5_year_ago_frequency here
5835 return p_salary_5_year_ago_frequency;
5836 --
5837 if g_debug then
5838 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5839 end if;
5840 --
5841
5842 exception
5843 when others then
5844 hr_utility.set_location('Exception in '|| l_proc, 99);
5845 raise;
5846
5847 end;
5848 -- --------------------------------------------------------------------------
5849 -- |-------------------------< get_sal_5_yr_ago_curr >-------------------------|
5850 -- --------------------------------------------------------------------------
5851 -- Description
5852 -- This function returns the salary_5_year_ago_currency
5853 --
5854 function get_sal_5_yr_ago_curr(p_person_id in number
5855 ,p_assignment_id in number
5856 ,p_legislation_code in varchar2
5857 ,p_group_pl_id in number
5858 ,p_lf_evt_ocrd_dt in date
5859 ,p_effective_date in date
5860 ,p_salary_5_year_ago_currency in varchar2)
5861 return varchar2 is
5862 --
5863 l_proc varchar2(72) := g_package||'get_sal_5_yr_ago_curr';
5864 --
5865
5866 begin
5867 --
5868 if g_debug then
5869 hr_utility.set_location('Entering:'|| l_proc, 10);
5870 end if;
5871 --
5872 -- Customer can override p_salary_5_year_ago_currency here
5873 return p_salary_5_year_ago_currency;
5874 --
5875 if g_debug then
5876 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5877 end if;
5878 --
5879
5880 exception
5881 when others then
5882 hr_utility.set_location('Exception in '|| l_proc, 99);
5883 raise;
5884
5885 end;
5886 -- --------------------------------------------------------------------------
5887 -- |-------------------------< get_prev_sal_frequency >-------------------------|
5888 -- --------------------------------------------------------------------------
5889 -- Description
5890 -- This function returns the prev_sal_frequency
5891 --
5892 function get_prev_sal_frequency(p_person_id in number
5893 ,p_assignment_id in number
5894 ,p_legislation_code in varchar2
5895 ,p_group_pl_id in number
5896 ,p_lf_evt_ocrd_dt in date
5897 ,p_effective_date in date
5898 ,p_prev_sal_frequency in varchar2)
5899 return varchar2 is
5900 --
5901 l_proc varchar2(72) := g_package||'get_prev_sal_frequency';
5905 --
5902 --
5903
5904 begin
5906 if g_debug then
5907 hr_utility.set_location('Entering:'|| l_proc, 10);
5908 end if;
5909 --
5910 -- Customer can override p_prev_sal_frequency here
5911 return p_prev_sal_frequency;
5912 --
5913 if g_debug then
5914 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5915 end if;
5916 --
5917
5918 exception
5919 when others then
5920 hr_utility.set_location('Exception in '|| l_proc, 99);
5921 raise;
5922
5923 end;
5924 -- --------------------------------------------------------------------------
5925 -- |-------------------------< get_prev_sal_currency >-------------------------|
5926 -- --------------------------------------------------------------------------
5927 -- Description
5928 -- This function returns the prev_sal_currency
5929 --
5930 function get_prev_sal_currency(p_person_id in number
5931 ,p_assignment_id in number
5932 ,p_legislation_code in varchar2
5933 ,p_group_pl_id in number
5934 ,p_lf_evt_ocrd_dt in date
5935 ,p_effective_date in date
5936 ,p_prev_sal_currency in varchar2)
5937 return varchar2 is
5938 --
5939 l_proc varchar2(72) := g_package||'get_prev_sal_currency';
5940 --
5941
5942 begin
5943 --
5944 if g_debug then
5945 hr_utility.set_location('Entering:'|| l_proc, 10);
5946 end if;
5947 --
5948 -- Customer can override p_prev_sal_currency here
5949 return p_prev_sal_currency;
5950 --
5951 if g_debug then
5952 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5953 end if;
5954 --
5955
5956 exception
5957 when others then
5958 hr_utility.set_location('Exception in '|| l_proc, 99);
5959 raise;
5960
5961 end;
5962 -- --------------------------------------------------------------------------
5963 -- |-------------------------< get_prev_sal_chg_rsn >-------------------------|
5964 -- --------------------------------------------------------------------------
5965 -- Description
5966 -- This function returns the prev_sal_chg_rsn
5967 --
5968 function get_prev_sal_chg_rsn(p_person_id in number
5969 ,p_assignment_id in number
5970 ,p_legislation_code in varchar2
5971 ,p_group_pl_id in number
5972 ,p_lf_evt_ocrd_dt in date
5973 ,p_effective_date in date
5974 ,p_prev_sal_chg_rsn in varchar2)
5975 return varchar2 is
5976 --
5977 l_proc varchar2(72) := g_package||'get_prev_sal_chg_rsn';
5978 --
5979
5980 begin
5981 --
5982 if g_debug then
5983 hr_utility.set_location('Entering:'|| l_proc, 10);
5984 end if;
5985 --
5986 -- Customer can override p_prev_sal_chg_rsn here
5987 return p_prev_sal_chg_rsn;
5988 --
5989 if g_debug then
5990 hr_utility.set_location(' Leaving:'|| l_proc, 99);
5991 end if;
5992 --
5993
5994 exception
5995 when others then
5996 hr_utility.set_location('Exception in '|| l_proc, 99);
5997 raise;
5998
5999 end;
6000 -- --------------------------------------------------------------------------
6001 -- |-------------------------< get_mkt_currency >-------------------------|
6002 -- --------------------------------------------------------------------------
6003 -- Description
6004 -- This function returns the mkt_currency
6005 --
6006 function get_mkt_currency(p_person_id in number
6007 ,p_assignment_id in number
6008 ,p_legislation_code in varchar2
6009 ,p_group_pl_id in number
6010 ,p_lf_evt_ocrd_dt in date
6011 ,p_effective_date in date
6012 ,p_mkt_currency in varchar2)
6013 return varchar2 is
6014 --
6015 l_proc varchar2(72) := g_package||'get_mkt_currency';
6016 --
6017 begin
6018 --
6019 if g_debug then
6020 hr_utility.set_location('Entering:'|| l_proc, 10);
6021 end if;
6022 --
6023 -- Customer can override p_mkt_currency here
6024 return p_mkt_currency;
6025 --
6026 if g_debug then
6027 hr_utility.set_location(' Leaving:'|| l_proc, 99);
6028 end if;
6029 --
6030
6031 exception
6032 when others then
6033 hr_utility.set_location('Exception in '|| l_proc, 99);
6034 raise;
6035
6036 end;
6037 -- --------------------------------------------------------------------------
6038 -- |-------------------------< get_mkt_frequency >-------------------------|
6039 -- --------------------------------------------------------------------------
6040 -- Description
6041 -- This function returns the mkt_frequency
6042 --
6043 function get_mkt_frequency(p_person_id in number
6044 ,p_assignment_id in number
6045 ,p_legislation_code in varchar2
6046 ,p_group_pl_id in number
6047 ,p_lf_evt_ocrd_dt in date
6048 ,p_effective_date in date
6049 ,p_mkt_frequency in varchar2)
6050 return varchar2 is
6051 --
6052 l_proc varchar2(72) := g_package||'get_mkt_frequency';
6053 --
6054
6055 begin
6056 --
6057 if g_debug then
6058 hr_utility.set_location('Entering:'|| l_proc, 10);
6059 end if;
6060 --
6061 -- Customer can override p_mkt_frequency here
6062 return p_mkt_frequency;
6063 --
6064 if g_debug then
6065 hr_utility.set_location(' Leaving:'|| l_proc, 99);
6066 end if;
6067 --
6068
6069 exception
6070 when others then
6071 hr_utility.set_location('Exception in '|| l_proc, 99);
6072 raise;
6073
6074 end;
6075 -- --------------------------------------------------------------------------
6076 -- |-------------------------< get_mkt_emp_quartile >-------------------------|
6077 -- --------------------------------------------------------------------------
6078 -- Description
6079 -- This function returns the mkt_emp_quartile
6080 --
6081 function get_mkt_emp_quartile(p_person_id in number
6082 ,p_assignment_id in number
6083 ,p_legislation_code in varchar2
6084 ,p_group_pl_id in number
6085 ,p_lf_evt_ocrd_dt in date
6086 ,p_effective_date in date
6087 ,p_mkt_emp_quartile in varchar2)
6088 return varchar2 is
6089 --
6090 l_proc varchar2(72) := g_package||'get_mkt_emp_quartile';
6091 --
6092 begin
6093 --
6094 if g_debug then
6095 hr_utility.set_location('Entering:'|| l_proc, 10);
6096 end if;
6097 --
6098 -- Customer can override p_mkt_emp_quartile here
6099 return p_mkt_emp_quartile;
6100 --
6101 if g_debug then
6102 hr_utility.set_location(' Leaving:'|| l_proc, 99);
6103 end if;
6104 --
6105
6106 exception
6107 when others then
6108 hr_utility.set_location('Exception in '|| l_proc, 99);
6109 raise;
6110
6111 end;
6112
6113
6114 end BEN_CWB_CUSTOM_PERSON_V2_PKG;
6115
6116