1 PACKAGE HR_VIEW_ALERT_MESSAGES AUTHID CURRENT_USER AS
2 /* $Header: pervamsg.pkh 115.4 2003/05/16 14:22:14 akmistry noship $ */
3
4 /*----------------------------------------------------*/
5 /* Business Group Version overloaded version with 10 */
6 /* tokens */
7 /*----------------------------------------------------*/
8
9
10 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
11 ,p_token1 in varchar2
12 ,p_token2 in varchar2
13 ,p_token3 in varchar2
14 ,p_token4 in varchar2
15 ,p_token5 in varchar2
16 ,p_token6 in varchar2
17 ,p_token7 in varchar2
18 ,p_token8 in varchar2
19 ,p_token9 in varchar2
20 ,p_tokena in varchar2
21 ,p_business_group in number)
22 RETURN varchar2;
23
24 /*----------------------------------------------------*/
25 /* Business Group Version overloaded version with 9 */
26 /* tokens */
27 /*----------------------------------------------------*/
28
29
30 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
31 ,p_token1 in varchar2
32 ,p_token2 in varchar2
33 ,p_token3 in varchar2
34 ,p_token4 in varchar2
35 ,p_token5 in varchar2
36 ,p_token6 in varchar2
37 ,p_token7 in varchar2
38 ,p_token8 in varchar2
39 ,p_token9 in varchar2
40 ,p_business_group in number)
41 RETURN varchar2;
42
43 /*----------------------------------------------------*/
44 /* Business Group Version overloaded version with 8 */
45 /* tokens */
46 /*----------------------------------------------------*/
47
48
49 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
50 ,p_token1 in varchar2
51 ,p_token2 in varchar2
52 ,p_token3 in varchar2
53 ,p_token4 in varchar2
54 ,p_token5 in varchar2
55 ,p_token6 in varchar2
56 ,p_token7 in varchar2
57 ,p_token8 in varchar2
58 ,p_business_group in number)
59 RETURN varchar2;
60
61 /*----------------------------------------------------*/
62 /* Business Group Version overloaded version with 7 */
63 /* tokens */
64 /*----------------------------------------------------*/
65
66
67 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
68 ,p_token1 in varchar2
69 ,p_token2 in varchar2
70 ,p_token3 in varchar2
71 ,p_token4 in varchar2
72 ,p_token5 in varchar2
73 ,p_token6 in varchar2
74 ,p_token7 in varchar2
75 ,p_business_group in number)
76 RETURN varchar2;
77
78 /*----------------------------------------------------*/
79 /* Business Group Version overloaded version with 6 */
80 /* tokens */
81 /*----------------------------------------------------*/
82
83
84 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
85 ,p_token1 in varchar2
86 ,p_token2 in varchar2
87 ,p_token3 in varchar2
88 ,p_token4 in varchar2
89 ,p_token5 in varchar2
90 ,p_token6 in varchar2
91 ,p_business_group in number)
92 RETURN varchar2;
93
94 /*----------------------------------------------------*/
95 /* Business Group Version overloaded version with 5 */
96 /* tokens */
97 /*----------------------------------------------------*/
98
99
100 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
101 ,p_token1 in varchar2
102 ,p_token2 in varchar2
103 ,p_token3 in varchar2
104 ,p_token4 in varchar2
105 ,p_token5 in varchar2
106 ,p_business_group in number)
107 RETURN varchar2;
108
109 /*----------------------------------------------------*/
110 /* Business Group Version overloaded version with 4 */
111 /* tokens */
112 /*----------------------------------------------------*/
113
114
115 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
116 ,p_token1 in varchar2
117 ,p_token2 in varchar2
118 ,p_token3 in varchar2
119 ,p_token4 in varchar2
120 ,p_business_group in number)
121 RETURN varchar2;
122
123 /*----------------------------------------------------*/
124 /* Business Group Version overloaded version with 3 */
125 /* tokens */
126 /*----------------------------------------------------*/
127
128
129 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
130 ,p_token1 in varchar2
131 ,p_token2 in varchar2
132 ,p_token3 in varchar2
133 ,p_business_group in number)
134 RETURN varchar2;
135
136 /*----------------------------------------------------*/
137 /* Business Group Version overloaded version with 2 */
138 /* tokens */
139 /*----------------------------------------------------*/
140
141
142 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
143 ,p_token1 in varchar2
144 ,p_token2 in varchar2
145 ,p_business_group in number)
146 RETURN varchar2;
147
148 /*----------------------------------------------------*/
149 /* Business Group Version overloaded version with 1 */
150 /* token */
151 /*----------------------------------------------------*/
152
153
154 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
155 ,p_token1 in varchar2
156 ,p_business_group in number)
157 RETURN varchar2;
158
159 /*----------------------------------------------------*/
160 /* Business Group Version 0 tokens */
161 /* */
162 /*----------------------------------------------------*/
163
164
165 FUNCTION GET_MESSAGE_LNG_BG(p_message in varchar2
166 ,p_business_group in number)
167 RETURN varchar2;
168
169
170 /*----------------------------------------------------*/
171 /*Supervisor Version overloaded version with 12 tokens*/
172 /* */
173 /*----------------------------------------------------*/
174 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
175 ,p_token1 in varchar2
176 ,p_token2 in varchar2
177 ,p_token3 in varchar2
178 ,p_token4 in varchar2
179 ,p_token5 in varchar2
180 ,p_token6 in varchar2
181 ,p_token7 in varchar2
182 ,p_token8 in varchar2
183 ,p_token9 in varchar2
184 ,p_tokenA in varchar2
185 ,p_tokenB in varchar2
186 ,p_tokenC in varchar2
187 ,p_assignment_id in number)
188 RETURN VARCHAR2;
189
190 /*----------------------------------------------------*/
191 /*Supervisor Version overloaded version with 11 tokens*/
192 /* */
193 /*----------------------------------------------------*/
194 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
195 ,p_token1 in varchar2
196 ,p_token2 in varchar2
197 ,p_token3 in varchar2
198 ,p_token4 in varchar2
199 ,p_token5 in varchar2
200 ,p_token6 in varchar2
201 ,p_token7 in varchar2
202 ,p_token8 in varchar2
203 ,p_token9 in varchar2
204 ,p_tokenA in varchar2
205 ,p_tokenB in varchar2
206 ,p_assignment_id in number)
207 RETURN VARCHAR2;
208
209 /*----------------------------------------------------*/
210 /*Supervisor Version overloaded version with 10 tokens*/
211 /* */
212 /*----------------------------------------------------*/
213 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
214 ,p_token1 in varchar2
215 ,p_token2 in varchar2
216 ,p_token3 in varchar2
217 ,p_token4 in varchar2
218 ,p_token5 in varchar2
219 ,p_token6 in varchar2
220 ,p_token7 in varchar2
221 ,p_token8 in varchar2
222 ,p_token9 in varchar2
223 ,p_tokenA in varchar2
224 ,p_assignment_id in number)
225 RETURN varchar2;
226
227 /*----------------------------------------------------*/
228 /* Supervisor Version overloaded version with 9 tokens*/
229 /* */
230 /*----------------------------------------------------*/
231
232 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
233 ,p_token1 in varchar2
234 ,p_token2 in varchar2
235 ,p_token3 in varchar2
236 ,p_token4 in varchar2
237 ,p_token5 in varchar2
238 ,p_token6 in varchar2
239 ,p_token7 in varchar2
240 ,p_token8 in varchar2
241 ,p_token9 in varchar2
242 ,p_assignment_id in number)
243 RETURN varchar2;
244
245 /*----------------------------------------------------*/
246 /* Supervisor Version overloaded version with 8 tokens
247 /*
248 /*----------------------------------------------------*/
249
250 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
251 ,p_token1 in varchar2
252 ,p_token2 in varchar2
253 ,p_token3 in varchar2
254 ,p_token4 in varchar2
255 ,p_token5 in varchar2
256 ,p_token6 in varchar2
257 ,p_token7 in varchar2
258 ,p_token8 in varchar2
259 ,p_assignment_id in number)
260 RETURN varchar2;
261
262 /*----------------------------------------------------*/
263 /* Supervisor Version overloaded version with 7 tokens
264 /*
265 /*----------------------------------------------------*/
266
267 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
268 ,p_token1 in varchar2
269 ,p_token2 in varchar2
270 ,p_token3 in varchar2
271 ,p_token4 in varchar2
272 ,p_token5 in varchar2
273 ,p_token6 in varchar2
274 ,p_token7 in varchar2
275 ,p_assignment_id in number)
276 RETURN varchar2;
277
278 /*----------------------------------------------------*/
279 /* Supervisor Version overloaded version with 6 tokens
280 /*
281 /*----------------------------------------------------*/
282
283 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
284 ,p_token1 in varchar2
285 ,p_token2 in varchar2
286 ,p_token3 in varchar2
287 ,p_token4 in varchar2
288 ,p_token5 in varchar2
289 ,p_token6 in varchar2
290 ,p_assignment_id in number)
291 RETURN varchar2;
292
293 /*----------------------------------------------------*/
294 /* Supervisor Version overloaded version with 5 tokens
295 /*
296 /*----------------------------------------------------*/
297
298 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
299 ,p_token1 in varchar2
300 ,p_token2 in varchar2
301 ,p_token3 in varchar2
302 ,p_token4 in varchar2
303 ,p_token5 in varchar2
304 ,p_assignment_id in number)
305 RETURN varchar2;
306
307 /*----------------------------------------------------*/
308 /* Supervisor Version overloaded version with 4 tokens
309 /*
310 /*----------------------------------------------------*/
311
312 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
313 ,p_token1 in varchar2
314 ,p_token2 in varchar2
315 ,p_token3 in varchar2
316 ,p_token4 in varchar2
317 ,p_assignment_id in number)
318 RETURN varchar2;
319
320 /*----------------------------------------------------*/
321 /* Supervisor Version overloaded version with 3 tokens
322 /*
323 /*----------------------------------------------------*/
324
325 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
326 ,p_token1 in varchar2
327 ,p_token2 in varchar2
328 ,p_token3 in varchar2
329 ,p_assignment_id in number)
330 RETURN varchar2;
331
332 /*----------------------------------------------------*/
333 /* Supervisor Version overloaded version with 2 tokens
334 /*
335 /*----------------------------------------------------*/
336
337 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
338 ,p_token1 in varchar2
339 ,p_token2 in varchar2
340 ,p_assignment_id in number)
341 RETURN varchar2;
342
343 /*----------------------------------------------------*/
344 /* Supervisor Version overloaded version with 1 token
345 /*
346 /*----------------------------------------------------*/
347
348 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
352
349 ,p_token1 in varchar2
350 ,p_assignment_id in number)
351 RETURN varchar2;
353 /*----------------------------------------------------*/
354 /* Supervisor Version overloaded version with 0 tokens
355 /*
356 /*----------------------------------------------------*/
357
358 FUNCTION GET_MESSAGE_LNG_SUP(p_message in varchar2
359 ,p_assignment_id in number)
360 RETURN varchar2;
361
362 /*----------------------------------------------------*/
363 /* Primary Supervisor Version with 12 tokens
364 /*
365 /*----------------------------------------------------*/
366
367 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
368 ,p_token1 in varchar2
369 ,p_token2 in varchar2
370 ,p_token3 in varchar2
371 ,p_token4 in varchar2
372 ,p_token5 in varchar2
373 ,p_token6 in varchar2
374 ,p_token7 in varchar2
375 ,p_token8 in varchar2
376 ,p_token9 in varchar2
377 ,p_tokenA in varchar2
378 ,p_tokenB in varchar2
379 ,p_tokenC in varchar2
380 ,p_assignment_id in number)
381 RETURN varchar2;
382
383 /*----------------------------------------------------*/
384 /* Primary Supervisor Version with 11 tokens
385 /*
386 /*----------------------------------------------------*/
387
388 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
389 ,p_token1 in varchar2
390 ,p_token2 in varchar2
391 ,p_token3 in varchar2
392 ,p_token4 in varchar2
393 ,p_token5 in varchar2
394 ,p_token6 in varchar2
395 ,p_token7 in varchar2
396 ,p_token8 in varchar2
397 ,p_token9 in varchar2
398 ,p_tokenA in varchar2
399 ,p_tokenB in varchar2
400 ,p_assignment_id in number)
401 RETURN varchar2;
402
403 /*----------------------------------------------------*/
404 /* Primary Supervisor Version with 10 tokens
405 /*
406 /*----------------------------------------------------*/
407
408 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
409 ,p_token1 in varchar2
410 ,p_token2 in varchar2
411 ,p_token3 in varchar2
412 ,p_token4 in varchar2
413 ,p_token5 in varchar2
414 ,p_token6 in varchar2
415 ,p_token7 in varchar2
416 ,p_token8 in varchar2
417 ,p_token9 in varchar2
418 ,p_tokenA in varchar2
419 ,p_assignment_id in number)
420 RETURN varchar2;
421
422 /*----------------------------------------------------*/
423 /* Primary Supervisor Version overload with 9 tokens
424 /*
425 /*----------------------------------------------------*/
426
427 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
428 ,p_token1 in varchar2
429 ,p_token2 in varchar2
430 ,p_token3 in varchar2
431 ,p_token4 in varchar2
432 ,p_token5 in varchar2
433 ,p_token6 in varchar2
434 ,p_token7 in varchar2
435 ,p_token8 in varchar2
436 ,p_token9 in varchar2
437 ,p_assignment_id in number)
438 RETURN varchar2;
439
440 /*----------------------------------------------------*/
441 /* Primary Supervisor Version overload with 8 tokens
442 /*
443 /*----------------------------------------------------*/
444
445 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
446 ,p_token1 in varchar2
447 ,p_token2 in varchar2
448 ,p_token3 in varchar2
449 ,p_token4 in varchar2
450 ,p_token5 in varchar2
451 ,p_token6 in varchar2
452 ,p_token7 in varchar2
453 ,p_token8 in varchar2
454 ,p_assignment_id in number)
455 RETURN varchar2;
456
457 /*----------------------------------------------------*/
458 /* Primary Supervisor Version overload with 7 tokens
459 /*
460 /*----------------------------------------------------*/
461
462 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
463 ,p_token1 in varchar2
464 ,p_token2 in varchar2
465 ,p_token3 in varchar2
466 ,p_token4 in varchar2
467 ,p_token5 in varchar2
468 ,p_token6 in varchar2
469 ,p_token7 in varchar2
470 ,p_assignment_id in number)
474 /* Primary Supervisor Version overload with 6 tokens
471 RETURN varchar2;
472
473 /*----------------------------------------------------*/
475 /*
476 /*----------------------------------------------------*/
477
478 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
479 ,p_token1 in varchar2
480 ,p_token2 in varchar2
481 ,p_token3 in varchar2
482 ,p_token4 in varchar2
483 ,p_token5 in varchar2
484 ,p_token6 in varchar2
485 ,p_assignment_id in number)
486 RETURN varchar2;
487
488 /*----------------------------------------------------*/
489 /* Primary Supervisor Version overload with 5 tokens
490 /*
491 /*----------------------------------------------------*/
492
493 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
494 ,p_token1 in varchar2
495 ,p_token2 in varchar2
496 ,p_token3 in varchar2
497 ,p_token4 in varchar2
498 ,p_token5 in varchar2
499 ,p_assignment_id in number)
500 RETURN varchar2;
501
505 /*----------------------------------------------------*/
502 /*----------------------------------------------------*/
503 /* Primary Supervisor Version overload with 4 tokens
504 /*
506
507 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
508 ,p_token1 in varchar2
509 ,p_token2 in varchar2
510 ,p_token3 in varchar2
511 ,p_token4 in varchar2
512 ,p_assignment_id in number)
513 RETURN varchar2;
514
515 /*----------------------------------------------------*/
516 /* Primary Supervisor Version overload with 3 tokens
517 /*
518 /*----------------------------------------------------*/
519
520 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
521 ,p_token1 in varchar2
522 ,p_token2 in varchar2
523 ,p_token3 in varchar2
524 ,p_assignment_id in number)
525 RETURN varchar2;
526
527 /*----------------------------------------------------*/
528 /* Primary Supervisor Version overload with 2 tokens
529 /*
530 /*----------------------------------------------------*/
531
532 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
533 ,p_token1 in varchar2
534 ,p_token2 in varchar2
535 ,p_assignment_id in number)
536 RETURN varchar2;
537
538 /*----------------------------------------------------*/
539 /* Primary Supervisor Version overload with 1 token
540 /*
541 /*----------------------------------------------------*/
542
543 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
544 ,p_token1 in varchar2
545 ,p_assignment_id in number)
546 RETURN varchar2;
547
548 /*----------------------------------------------------*/
549 /* Primary Supervisor Version overload with 0 tokens
550 /*
551 /*----------------------------------------------------*/
552
553 FUNCTION GET_MESSAGE_LNG_PSUP(p_message in varchar2
554 ,p_assignment_id in number)
555 RETURN varchar2;
556
557 /*----------------------------------------------------*/
558 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
559 /* TWELVE TOKENS */
560 /*----------------------------------------------------*/
561
562 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
563 ,p_token1 in varchar2
564 ,p_token2 in varchar2
565 ,p_token3 in varchar2
566 ,p_token4 in varchar2
567 ,p_token5 in varchar2
568 ,p_token6 in varchar2
569 ,p_token7 in varchar2
570 ,p_token8 in varchar2
571 ,p_token9 in varchar2
572 ,p_tokenA in varchar2
573 ,p_tokenB in varchar2
574 ,p_tokenC in varchar2
575 ,p_person_id in number)
576 RETURN varchar2;
577
578 /*----------------------------------------------------*/
579 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
580 /* ELEVEN TOKENS */
581 /*----------------------------------------------------*/
582
583 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
584 ,p_token1 in varchar2
585 ,p_token2 in varchar2
586 ,p_token3 in varchar2
587 ,p_token4 in varchar2
588 ,p_token5 in varchar2
589 ,p_token6 in varchar2
590 ,p_token7 in varchar2
591 ,p_token8 in varchar2
592 ,p_token9 in varchar2
593 ,p_tokenA in varchar2
594 ,p_tokenB in varchar2
595 ,p_person_id in number)
596 RETURN varchar2;
597
598 /*----------------------------------------------------*/
599 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
600 /* TEN TOKENS */
601 /*----------------------------------------------------*/
602
603 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
604 ,p_token1 in varchar2
605 ,p_token2 in varchar2
606 ,p_token3 in varchar2
607 ,p_token4 in varchar2
608 ,p_token5 in varchar2
609 ,p_token6 in varchar2
610 ,p_token7 in varchar2
611 ,p_token8 in varchar2
612 ,p_token9 in varchar2
613 ,p_tokenA in varchar2
614 ,p_person_id in number)
615 RETURN varchar2;
616
617 /*----------------------------------------------------*/
618 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
619 /* NINE TOKENS */
620 /*----------------------------------------------------*/
621
622 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
623 ,p_token1 in varchar2
624 ,p_token2 in varchar2
625 ,p_token3 in varchar2
626 ,p_token4 in varchar2
630 ,p_token8 in varchar2
627 ,p_token5 in varchar2
628 ,p_token6 in varchar2
629 ,p_token7 in varchar2
631 ,p_token9 in varchar2
632 ,p_person_id in number)
633 RETURN varchar2;
634
635 /*----------------------------------------------------*/
636 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
637 /* 8 TOKENS */
638 /*----------------------------------------------------*/
639
640 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
641 ,p_token1 in varchar2
642 ,p_token2 in varchar2
643 ,p_token3 in varchar2
644 ,p_token4 in varchar2
645 ,p_token5 in varchar2
646 ,p_token6 in varchar2
647 ,p_token7 in varchar2
648 ,p_token8 in varchar2
649 ,p_person_id in number)
650 RETURN varchar2;
651
652 /*----------------------------------------------------*/
653 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
654 /* 7 TOKENS */
655 /*----------------------------------------------------*/
656
657 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
658 ,p_token1 in varchar2
659 ,p_token2 in varchar2
660 ,p_token3 in varchar2
661 ,p_token4 in varchar2
662 ,p_token5 in varchar2
663 ,p_token6 in varchar2
664 ,p_token7 in varchar2
665 ,p_person_id in number)
666 RETURN varchar2;
667
668 /*----------------------------------------------------*/
669 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
670 /* 6 TOKENS */
671 /*----------------------------------------------------*/
672
673 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
674 ,p_token1 in varchar2
675 ,p_token2 in varchar2
676 ,p_token3 in varchar2
677 ,p_token4 in varchar2
678 ,p_token5 in varchar2
679 ,p_token6 in varchar2
680 ,p_person_id in number)
681 RETURN varchar2;
682
683 /*----------------------------------------------------*/
684 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
685 /* 5 TOKENS */
686 /*----------------------------------------------------*/
687
688 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
689 ,p_token1 in varchar2
690 ,p_token2 in varchar2
691 ,p_token3 in varchar2
692 ,p_token4 in varchar2
693 ,p_token5 in varchar2
694 ,p_person_id in number)
695 RETURN varchar2;
696
697 /*----------------------------------------------------*/
698 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
699 /* 4 TOKENS */
700 /*----------------------------------------------------*/
701
702 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
703 ,p_token1 in varchar2
704 ,p_token2 in varchar2
705 ,p_token3 in varchar2
706 ,p_token4 in varchar2
707 ,p_person_id in number)
708 RETURN varchar2;
709
710 /*----------------------------------------------------*/
711 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
712 /* 3 TOKENS */
713 /*----------------------------------------------------*/
714
715 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
716 ,p_token1 in varchar2
717 ,p_token2 in varchar2
718 ,p_token3 in varchar2
719 ,p_person_id in number)
720 RETURN varchar2;
721
722 /*----------------------------------------------------*/
723 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
724 /* 2 TOKENS */
725 /*----------------------------------------------------*/
726
727 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
728 ,p_token1 in varchar2
729 ,p_token2 in varchar2
730 ,p_person_id in number)
731 RETURN varchar2;
732
733 /*----------------------------------------------------*/
734 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
735 /* 1 TOKEN */
736 /*----------------------------------------------------*/
737
738 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
739 ,p_token1 in varchar2
740 ,p_person_id in number)
741 RETURN varchar2;
742
743 /*----------------------------------------------------*/
744 /* Overloaded Version of GET_MESSAGE_LNG_PSN */
745 /* 0 TOKENs */
746 /*----------------------------------------------------*/
747
748 FUNCTION GET_MESSAGE_LNG_PSN(p_message in varchar2
752 /*----------------------------------------------------*/
749 ,p_person_id in number)
750 RETURN varchar2;
751
753 /* GET_MESSAGE_LNG_SUP_PSN overloaded functions */
754 /* */
755 /*----------------------------------------------------*/
756
757 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
758 ,p_token1 in varchar2
759 ,p_token2 in varchar2
760 ,p_token3 in varchar2
761 ,p_token4 in varchar2
762 ,p_token5 in varchar2
763 ,p_token6 in varchar2
764 ,p_token7 in varchar2
765 ,p_token8 in varchar2
766 ,p_token9 in varchar2
767 ,p_tokenA in varchar2
768 ,p_tokenB in varchar2
769 ,p_person_id in number)
770 RETURN VARCHAR2;
771
772 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
773 ,p_token1 in varchar2
774 ,p_token2 in varchar2
775 ,p_token3 in varchar2
776 ,p_token4 in varchar2
777 ,p_token5 in varchar2
778 ,p_token6 in varchar2
779 ,p_token7 in varchar2
780 ,p_token8 in varchar2
781 ,p_token9 in varchar2
782 ,p_tokenA in varchar2
783 ,p_person_id in number)
784 RETURN VARCHAR2;
785
786 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
787 ,p_token1 in varchar2
788 ,p_token2 in varchar2
789 ,p_token3 in varchar2
790 ,p_token4 in varchar2
791 ,p_token5 in varchar2
792 ,p_token6 in varchar2
793 ,p_token7 in varchar2
794 ,p_token8 in varchar2
795 ,p_token9 in varchar2
796 ,p_person_id in number)
797 RETURN VARCHAR2;
798
799 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
800 ,p_token1 in varchar2
801 ,p_token2 in varchar2
802 ,p_token3 in varchar2
803 ,p_token4 in varchar2
804 ,p_token5 in varchar2
805 ,p_token6 in varchar2
806 ,p_token7 in varchar2
807 ,p_token8 in varchar2
808 ,p_person_id in number)
809 RETURN VARCHAR2;
810
811 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
812 ,p_token1 in varchar2
813 ,p_token2 in varchar2
814 ,p_token3 in varchar2
815 ,p_token4 in varchar2
816 ,p_token5 in varchar2
817 ,p_token6 in varchar2
818 ,p_token7 in varchar2
819 ,p_person_id in number)
820 RETURN VARCHAR2;
821
822 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
823 ,p_token1 in varchar2
824 ,p_token2 in varchar2
825 ,p_token3 in varchar2
826 ,p_token4 in varchar2
827 ,p_token5 in varchar2
828 ,p_token6 in varchar2
829 ,p_person_id in number)
830 RETURN VARCHAR2;
831
832 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
833 ,p_token1 in varchar2
834 ,p_token2 in varchar2
835 ,p_token3 in varchar2
836 ,p_token4 in varchar2
837 ,p_token5 in varchar2
838 ,p_person_id in number)
839 RETURN VARCHAR2;
840
841 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
842 ,p_token1 in varchar2
843 ,p_token2 in varchar2
844 ,p_token3 in varchar2
845 ,p_token4 in varchar2
846 ,p_person_id in number)
847 RETURN VARCHAR2;
848
849 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
850 ,p_token1 in varchar2
851 ,p_token2 in varchar2
852 ,p_token3 in varchar2
853 ,p_person_id in number)
854 RETURN VARCHAR2;
855
856 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
857 ,p_token1 in varchar2
858 ,p_token2 in varchar2
859 ,p_person_id in number)
860 RETURN VARCHAR2;
861
862 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
863 ,p_token1 in varchar2
864 ,p_person_id in number)
865 RETURN VARCHAR2;
866
867 FUNCTION GET_MESSAGE_LNG_SUP_PSN(p_message in varchar2
868 ,p_person_id in number)
869 RETURN VARCHAR2;
870
872
871 END HR_VIEW_ALERT_MESSAGES; -- Package spec
[Home] [Help]