1 PACKAGE BODY BEN_CWB_CUSTOM_PERSON_PKG as
2 /* $Header: bencwbpr.pkb 120.0 2005/05/28 04:00:44 appldev noship $ */
3 --
4 -- --------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- --------------------------------------------------------------------------
7 --
8 g_package varchar2(33):=' ben_cwb_custom_person_pkg.'; --Global package name
9 g_debug boolean := hr_utility.debug_enabled;
10 --
11 --
12 -- --------------------------------------------------------------------------
13 -- |---------------------------< get_custom_name >---------------------------|
14 -- --------------------------------------------------------------------------
15 function get_custom_name(p_person_id in number
16 ,p_assignment_id in number
17 ,p_legislation_code in varchar2
18 ,p_group_pl_id in number
19 ,p_lf_evt_ocrd_dt in date
20 ,p_effective_date in date)
21 return varchar2 is
22 --
23 l_proc varchar2(72) := g_package||'get_custom_name';
24 --
25 begin
26 --
27 if g_debug then
28 hr_utility.set_location('Entering:'|| l_proc, 10);
29 end if;
30 --
31 return null;
32 --
33 if g_debug then
34 hr_utility.set_location(' Leaving:'|| l_proc, 99);
35 end if;
36 --
37 exception
38 when others then
39 hr_utility.set_location('Exception in '|| l_proc, 99);
40 raise;
41
42 end;
43 --
44 -- --------------------------------------------------------------------------
45 -- |-------------------------< get_custom_segment1 >-------------------------|
46 -- --------------------------------------------------------------------------
47 function get_custom_segment1(p_person_id in number
48 ,p_assignment_id in number
49 ,p_legislation_code in varchar2
50 ,p_group_pl_id in number
51 ,p_lf_evt_ocrd_dt in date
52 ,p_effective_date in date)
53 return varchar2 is
54 --
55 l_proc varchar2(72) := g_package||'get_custom_segment1';
56 --
57 begin
58 --
59 if g_debug then
60 hr_utility.set_location('Entering:'|| l_proc, 10);
61 end if;
62 --
63 return null;
64 --
65 if g_debug then
66 hr_utility.set_location(' Leaving:'|| l_proc, 99);
67 end if;
68 --
69 exception
70 when others then
71 hr_utility.set_location('Exception in '|| l_proc, 99);
72 raise;
73
74 end;
75 --
76 -- --------------------------------------------------------------------------
77 -- |-------------------------< get_custom_segment2 >-------------------------|
78 -- --------------------------------------------------------------------------
79 function get_custom_segment2(p_person_id in number
80 ,p_assignment_id in number
81 ,p_legislation_code in varchar2
82 ,p_group_pl_id in number
83 ,p_lf_evt_ocrd_dt in date
84 ,p_effective_date in date)
85 return varchar2 is
86 --
87 l_proc varchar2(72) := g_package||'get_custom_segment2';
88 --
89 begin
90 --
91 if g_debug then
92 hr_utility.set_location('Entering:'|| l_proc, 10);
93 end if;
94 --
95 return null;
96 --
97 if g_debug then
98 hr_utility.set_location(' Leaving:'|| l_proc, 99);
99 end if;
100 --
101
102 exception
103 when others then
104 hr_utility.set_location('Exception in '|| l_proc, 99);
105 raise;
106
107 end;
108 --
109 -- --------------------------------------------------------------------------
110 -- |-------------------------< get_custom_segment3 >-------------------------|
111 -- --------------------------------------------------------------------------
112 function get_custom_segment3(p_person_id in number
113 ,p_assignment_id in number
114 ,p_legislation_code in varchar2
115 ,p_group_pl_id in number
116 ,p_lf_evt_ocrd_dt in date
117 ,p_effective_date in date)
118 return varchar2 is
119 --
120 l_proc varchar2(72) := g_package||'get_custom_segment3';
121 --
122 begin
123 --
124 if g_debug then
125 hr_utility.set_location('Entering:'|| l_proc, 10);
126 end if;
127 --
128 return null;
129 --
130 if g_debug then
131 hr_utility.set_location(' Leaving:'|| l_proc, 99);
132 end if;
133 -- return null;
134 exception
135 when others then
136 hr_utility.set_location('Exception in '|| l_proc, 99);
137 raise;
138
139
140 end;
141 --
142 -- --------------------------------------------------------------------------
143 -- |-------------------------< get_custom_segment4 >-------------------------|
144 -- --------------------------------------------------------------------------
145 function get_custom_segment4(p_person_id in number
146 ,p_assignment_id in number
147 ,p_legislation_code in varchar2
148 ,p_group_pl_id in number
149 ,p_lf_evt_ocrd_dt in date
150 ,p_effective_date in date)
151 return varchar2 is
152 --
153 l_proc varchar2(72) := g_package||'get_custom_segment4';
154 --
155 begin
156 --
157 if g_debug then
158 hr_utility.set_location('Entering:'|| l_proc, 10);
159 end if;
160 --
161 return null;
162 --
163 if g_debug then
164 hr_utility.set_location(' Leaving:'|| l_proc, 99);
165 end if;
166 --
167
168 exception
169 when others then
170 hr_utility.set_location('Exception in '|| l_proc, 99);
171 raise;
172
173
174 end;
175 --
176 -- --------------------------------------------------------------------------
177 -- |-------------------------< get_custom_segment5 >-------------------------|
178 -- --------------------------------------------------------------------------
179 function get_custom_segment5(p_person_id in number
180 ,p_assignment_id in number
181 ,p_legislation_code in varchar2
182 ,p_group_pl_id in number
183 ,p_lf_evt_ocrd_dt in date
184 ,p_effective_date in date)
185 return varchar2 is
186 --
187 l_proc varchar2(72) := g_package||'get_custom_segment5';
188 --
189 begin
190 --
191 if g_debug then
192 hr_utility.set_location('Entering:'|| l_proc, 10);
193 end if;
194 --
195 return null;
196 --
197 if g_debug then
198 hr_utility.set_location(' Leaving:'|| l_proc, 99);
199 end if;
200 --
201
202 exception
203 when others then
204 hr_utility.set_location('Exception in '|| l_proc, 99);
205 raise;
206
207
208 end;
209 --
210 -- --------------------------------------------------------------------------
211 -- |-------------------------< get_custom_segment6 >-------------------------|
212 -- --------------------------------------------------------------------------
213 function get_custom_segment6(p_person_id in number
214 ,p_assignment_id in number
215 ,p_legislation_code in varchar2
216 ,p_group_pl_id in number
217 ,p_lf_evt_ocrd_dt in date
218 ,p_effective_date in date)
219 return varchar2 is
220 --
221 l_proc varchar2(72) := g_package||'get_custom_segment6';
222 --
223 begin
224 --
225 if g_debug then
226 hr_utility.set_location('Entering:'|| l_proc, 10);
227 end if;
228 --
229 return null;
230 --
231 if g_debug then
232 hr_utility.set_location(' Leaving:'|| l_proc, 99);
233 end if;
234 --
235 exception
236 when others then
237 hr_utility.set_location('Exception in '|| l_proc, 99);
238 raise;
239
240
241 end;
242 --
243 -- --------------------------------------------------------------------------
244 -- |-------------------------< get_custom_segment7 >-------------------------|
245 -- --------------------------------------------------------------------------
246 function get_custom_segment7(p_person_id in number
247 ,p_assignment_id in number
248 ,p_legislation_code in varchar2
249 ,p_group_pl_id in number
250 ,p_lf_evt_ocrd_dt in date
251 ,p_effective_date in date)
252 return varchar2 is
253 --
254 l_proc varchar2(72) := g_package||'get_custom_segment7';
255 --
256 begin
257 --
258 if g_debug then
259 hr_utility.set_location('Entering:'|| l_proc, 10);
260 end if;
261 --
262 return null;
263 --
264 if g_debug then
265 hr_utility.set_location(' Leaving:'|| l_proc, 99);
266 end if;
267 --
268
269 exception
270 when others then
271 hr_utility.set_location('Exception in '|| l_proc, 99);
272 raise;
273
274
275 end;
276 --
277 -- --------------------------------------------------------------------------
278 -- |-------------------------< get_custom_segment8 >-------------------------|
279 -- --------------------------------------------------------------------------
280 function get_custom_segment8(p_person_id in number
281 ,p_assignment_id in number
282 ,p_legislation_code in varchar2
283 ,p_group_pl_id in number
284 ,p_lf_evt_ocrd_dt in date
285 ,p_effective_date in date)
286 return varchar2 is
287 --
288 l_proc varchar2(72) := g_package||'get_custom_segment8';
289 --
290 begin
291 --
292 if g_debug then
293 hr_utility.set_location('Entering:'|| l_proc, 10);
294 end if;
295 --
296 return null;
297 --
298 if g_debug then
299 hr_utility.set_location(' Leaving:'|| l_proc, 99);
300 end if;
301 --
302
303 exception
304 when others then
305 hr_utility.set_location('Exception in '|| l_proc, 99);
306 raise;
307
308
309 end;
310 --
311 -- --------------------------------------------------------------------------
312 -- |-------------------------< get_custom_segment9 >-------------------------|
313 -- --------------------------------------------------------------------------
314 function get_custom_segment9(p_person_id in number
315 ,p_assignment_id in number
316 ,p_legislation_code in varchar2
317 ,p_group_pl_id in number
318 ,p_lf_evt_ocrd_dt in date
319 ,p_effective_date in date)
320 return varchar2 is
321 --
322 l_proc varchar2(72) := g_package||'get_custom_segment9';
323 --
324 begin
325 --
326 if g_debug then
327 hr_utility.set_location('Entering:'|| l_proc, 10);
328 end if;
329 --
330 return null;
331 --
332 if g_debug then
333 hr_utility.set_location(' Leaving:'|| l_proc, 99);
334 end if;
335 --
336
337 exception
338 when others then
339 hr_utility.set_location('Exception in '|| l_proc, 99);
340 raise;
341
342
343 end;
344 --
345 -- --------------------------------------------------------------------------
346 -- |-------------------------< get_custom_segment10 >------------------------|
347 -- --------------------------------------------------------------------------
348 function get_custom_segment10(p_person_id in number
349 ,p_assignment_id in number
350 ,p_legislation_code in varchar2
351 ,p_group_pl_id in number
352 ,p_lf_evt_ocrd_dt in date
353 ,p_effective_date in date)
354 return varchar2 is
355 --
356 l_proc varchar2(72) := g_package||'get_custom_segment10';
357 --
358 begin
359 --
360 if g_debug then
361 hr_utility.set_location('Entering:'|| l_proc, 10);
362 end if;
363 --
364 return null;
365 --
366 if g_debug then
367 hr_utility.set_location(' Leaving:'|| l_proc, 99);
368 end if;
369 --
370
371 exception
372 when others then
373 hr_utility.set_location('Exception in '|| l_proc, 99);
374 raise;
375
376
377 end;
378 --
379 -- --------------------------------------------------------------------------
383 ,p_assignment_id in number
380 -- |-------------------------< get_custom_segment11 >-------------------------|
381 -- --------------------------------------------------------------------------
382 function get_custom_segment11(p_person_id in number
384 ,p_legislation_code in varchar2
385 ,p_group_pl_id in number
386 ,p_lf_evt_ocrd_dt in date
387 ,p_effective_date in date)
388 return number is
389 --
390 l_proc varchar2(72) := g_package||'get_custom_segment11';
391 --
392 begin
393 --
394 if g_debug then
395 hr_utility.set_location('Entering:'|| l_proc, 10);
396 end if;
397 --
398 return null;
399 --
400 if g_debug then
401 hr_utility.set_location(' Leaving:'|| l_proc, 99);
402 end if;
403 --
404
405 exception
406 when others then
407 hr_utility.set_location('Exception in '|| l_proc, 99);
408 raise;
409
410
411 end;
412 --
413 -- --------------------------------------------------------------------------
414 -- |-------------------------< get_custom_segment12 >-------------------------|
415 -- --------------------------------------------------------------------------
416 function get_custom_segment12(p_person_id in number
417 ,p_assignment_id in number
418 ,p_legislation_code in varchar2
419 ,p_group_pl_id in number
420 ,p_lf_evt_ocrd_dt in date
421 ,p_effective_date in date)
422 return number is
423 --
424 l_proc varchar2(72) := g_package||'get_custom_segment12';
425 --
426 begin
427 --
428 if g_debug then
429 hr_utility.set_location('Entering:'|| l_proc, 10);
430 end if;
431 --
432 return null;
433 --
434 if g_debug then
435 hr_utility.set_location(' Leaving:'|| l_proc, 99);
436 end if;
437 --
438
439 exception
440 when others then
441 hr_utility.set_location('Exception in '|| l_proc, 99);
442 raise;
443
444
445 end;
446 --
447 -- --------------------------------------------------------------------------
448 -- |-------------------------< get_custom_segment13 >-------------------------|
449 -- --------------------------------------------------------------------------
450 function get_custom_segment13(p_person_id in number
451 ,p_assignment_id in number
452 ,p_legislation_code in varchar2
453 ,p_group_pl_id in number
454 ,p_lf_evt_ocrd_dt in date
455 ,p_effective_date in date)
456 return number is
457 --
458 l_proc varchar2(72) := g_package||'get_custom_segment13';
459 --
460 begin
461 --
462 if g_debug then
463 hr_utility.set_location('Entering:'|| l_proc, 10);
464 end if;
465 --
466 return null;
467 --
468 if g_debug then
472
469 hr_utility.set_location(' Leaving:'|| l_proc, 99);
470 end if;
471 -- return null;
473 exception
474 when others then
475 hr_utility.set_location('Exception in '|| l_proc, 99);
476 raise;
477
478
479 end;
480 --
481 -- --------------------------------------------------------------------------
482 -- |-------------------------< get_custom_segment14 >-------------------------|
483 -- --------------------------------------------------------------------------
484 function get_custom_segment14(p_person_id in number
485 ,p_assignment_id in number
486 ,p_legislation_code in varchar2
487 ,p_group_pl_id in number
488 ,p_lf_evt_ocrd_dt in date
489 ,p_effective_date in date)
490 return number is
491 --
492 l_proc varchar2(72) := g_package||'get_custom_segment4';
493 --
494 begin
495 --
496 if g_debug then
497 hr_utility.set_location('Entering:'|| l_proc, 10);
498 end if;
499 --
500 return null;
501 --
502 if g_debug then
503 hr_utility.set_location(' Leaving:'|| l_proc, 99);
504 end if;
505 --
506
507 exception
508 when others then
509 hr_utility.set_location('Exception in '|| l_proc, 99);
510 raise;
511
512
513
514 end;
515 --
516 -- --------------------------------------------------------------------------
517 -- |-------------------------< get_custom_segment15 >-------------------------|
518 -- --------------------------------------------------------------------------
519 function get_custom_segment15(p_person_id in number
520 ,p_assignment_id in number
521 ,p_legislation_code in varchar2
522 ,p_group_pl_id in number
523 ,p_lf_evt_ocrd_dt in date
524 ,p_effective_date in date)
525 return number is
526 --
527 l_proc varchar2(72) := g_package||'get_custom_segment15';
528 --
529 begin
530 --
531 if g_debug then
532 hr_utility.set_location('Entering:'|| l_proc, 10);
533 end if;
534 --
535 return null;
536 --
537 if g_debug then
538 hr_utility.set_location(' Leaving:'|| l_proc, 99);
539 end if;
540 --
541 exception
542 when others then
543 hr_utility.set_location('Exception in '|| l_proc, 99);
544 raise;
545
546
547 end;
548 --
549
550 -- --------------------------------------------------------------------------
551 -- |-------------------------< get_custom_segment16 >-------------------------|
552 -- --------------------------------------------------------------------------
553 function get_custom_segment16(p_person_id in number
554 ,p_assignment_id in number
555 ,p_legislation_code in varchar2
556 ,p_group_pl_id in number
557 ,p_lf_evt_ocrd_dt in date
558 ,p_effective_date in date)
559 return number is
560 --
561 l_proc varchar2(72) := g_package||'get_custom_segment16';
562 --
563 begin
564 --
565 if g_debug then
566 hr_utility.set_location('Entering:'|| l_proc, 10);
567 end if;
568 --
569 return null;
570 --
571 if g_debug then
572 hr_utility.set_location(' Leaving:'|| l_proc, 99);
573 end if;
574 --
575 exception
576 when others then
577 hr_utility.set_location('Exception in '|| l_proc, 99);
578 raise;
579
580
581 end;
582 --
583 -- --------------------------------------------------------------------------
584 -- |-------------------------< get_custom_segment17 >-------------------------|
585 -- --------------------------------------------------------------------------
586 function get_custom_segment17(p_person_id in number
587 ,p_assignment_id in number
588 ,p_legislation_code in varchar2
589 ,p_group_pl_id in number
590 ,p_lf_evt_ocrd_dt in date
591 ,p_effective_date in date)
592 return number is
593 --
594 l_proc varchar2(72) := g_package||'get_custom_segment17';
595 --
596 begin
597 --
598 if g_debug then
599 hr_utility.set_location('Entering:'|| l_proc, 10);
600 end if;
601 --
602 return null;
603 --
604 if g_debug then
605 hr_utility.set_location(' Leaving:'|| l_proc, 99);
606 end if;
607 --
608 exception
609 when others then
610 hr_utility.set_location('Exception in '|| l_proc, 99);
611 raise;
612
613
614 end;
615 --
616 -- --------------------------------------------------------------------------
617 -- |-------------------------< get_custom_segment18 >-------------------------|
618 -- --------------------------------------------------------------------------
619 function get_custom_segment18(p_person_id in number
620 ,p_assignment_id in number
621 ,p_legislation_code in varchar2
622 ,p_group_pl_id in number
623 ,p_lf_evt_ocrd_dt in date
624 ,p_effective_date in date)
625 return number is
626 --
630 --
627 l_proc varchar2(72) := g_package||'get_custom_segment18';
628 --
629 begin
631 if g_debug then
632 hr_utility.set_location('Entering:'|| l_proc, 10);
633 end if;
634 --
635 return null;
636 --
637 if g_debug then
638 hr_utility.set_location(' Leaving:'|| l_proc, 99);
639 end if;
640 --
641 exception
642 when others then
643 hr_utility.set_location('Exception in '|| l_proc, 99);
644 raise;
645
646
647 end;
648 --
652 function get_custom_segment19(p_person_id in number
649 -- --------------------------------------------------------------------------
650 -- |-------------------------< get_custom_segment19 >-------------------------|
651 -- --------------------------------------------------------------------------
653 ,p_assignment_id in number
654 ,p_legislation_code in varchar2
655 ,p_group_pl_id in number
656 ,p_lf_evt_ocrd_dt in date
657 ,p_effective_date in date)
658 return number is
659 --
660 l_proc varchar2(72) := g_package||'get_custom_segment19';
661 --
662 begin
663 --
664 if g_debug then
665 hr_utility.set_location('Entering:'|| l_proc, 10);
666 end if;
667 --
668 return null;
669 --
670 if g_debug then
671 hr_utility.set_location(' Leaving:'|| l_proc, 99);
672 end if;
673 --
674 exception
675 when others then
676 hr_utility.set_location('Exception in '|| l_proc, 99);
677 raise;
678
679
680 end;
681 --
682 -- --------------------------------------------------------------------------
683 -- |-------------------------< get_custom_segment20 >-------------------------|
684 -- --------------------------------------------------------------------------
685 function get_custom_segment20(p_person_id in number
686 ,p_assignment_id in number
687 ,p_legislation_code in varchar2
688 ,p_group_pl_id in number
689 ,p_lf_evt_ocrd_dt in date
690 ,p_effective_date in date)
691 return number is
692 --
693 l_proc varchar2(72) := g_package||'get_custom_segment20';
694 --
695 begin
696 --
697 if g_debug then
698 hr_utility.set_location('Entering:'|| l_proc, 10);
699 end if;
700 --
701 return null;
702 --
703 if g_debug then
704 hr_utility.set_location(' Leaving:'|| l_proc, 99);
705 end if;
706 --
707 exception
708 when others then
709 hr_utility.set_location('Exception in '|| l_proc, 99);
710 raise;
711
712
713 end;
714 --
715
716
717
718 end BEN_CWB_CUSTOM_PERSON_PKG;
719
720