[Home] [Help]
PACKAGE: APPS.PAY_PSD_BUS
Source
1 Package pay_psd_bus as
2 /* $Header: pypsdrhi.pkh 120.0 2005/10/14 06:40 mseshadr noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Sets the security_group_id in CLIENT_INFO for the appropriate business
11 -- group context.
12 --
13 -- Prerequisites:
14 -- The primary key identified by p_sii_details_id
15 -- already exists.
16 --
17 -- In Arguments:
18 -- p_sii_details_id
19 --
20 --
21 -- Post Success:
22 -- The security_group_id will be set in CLIENT_INFO.
23 --
24 -- Post Failure:
25 -- An error is raised if the value does not exist.
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 -- ---------------------------------------------------------------------------
32 procedure set_security_group_id
33 (p_sii_details_id in number
34 ,p_associated_column1 in varchar2 default null
35 );
36 --
37 --
38 -- ---------------------------------------------------------------------------
39 -- |---------------------< return_legislation_code >-------------------------|
40 -- ---------------------------------------------------------------------------
41 -- {Start Of Comments}
42 --
43 -- Description:
44 -- Return the legislation code for a specific primary key value
45 --
46 -- Prerequisites:
47 -- The primary key identified by p_sii_details_id
48 -- already exists.
49 --
50 -- In Arguments:
51 -- p_sii_details_id
52 --
53 --
54 -- Post Success:
55 -- The business group's legislation code will be returned.
56 --
57 -- Post Failure:
58 -- An error is raised if the value does not exist.
59 --
60 -- Access Status:
61 -- Internal Development Use Only.
62 --
63 -- {End Of Comments}
64 -- ---------------------------------------------------------------------------
65 FUNCTION return_legislation_code
66 (p_sii_details_id in number
67 ) RETURN varchar2;
68 --
69 --
70 -- ----------------------------------------------------------------------------
71 -- |-----------------------< chk_contract_category >--------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This procedure validates the Contract Category.
77 --
78 -- Prerequisites:
79 --
80 --
81 -- In Parameters:
82 -- p_sii_details_id
83 -- p_effective_date
84 -- p_contract_category
85 -- p_validation_start_date
86 -- p_validation_end_date
87 -- p_object_version_number
88 --
89 -- Post Success:
90 -- Processing continues.
91 --
92 -- Post Failure:
93 -- An error is raised if the validation fails.
94 --
95 --
96 -- Access Status:
97 -- Internal Development Use Only.
98 --
99 -- {End Of Comments}
100 -- ----------------------------------------------------------------------------
101 Procedure chk_contract_category
102 (p_sii_details_id in number
103 ,p_effective_date in date
104 ,p_contract_category in varchar2
105 ,p_validation_start_date in date
106 ,p_validation_end_date in date
107 ,p_object_version_number in number
108 );
109
110
111 -- ----------------------------------------------------------------------------
112 -- |-----------------------< chk_business_group_id >--------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start Of Comments}
115 --
116 -- Description:
117 -- This procedure validates the Business Group Id.
118 --
119 -- Prerequisites:
120 --
121 --
122 -- In Parameters:
123 -- p_sii_details_id
124 -- p_effective_date
125 -- p_business_group_id
126 -- p_validation_start_date
127 -- p_validation_end_date
128 -- p_object_version_number
129 --
130 -- Post Success:
131 -- Processing continues.
132 --
133 -- Post Failure:
134 -- An error is raised if the validation fails.
135 --
136 --
137 -- Access Status:
138 -- Internal Development Use Only.
139 --
140 -- {End Of Comments}
141 -- ----------------------------------------------------------------------------
142 Procedure chk_business_group_id
143 (p_sii_details_id in number
144 ,p_effective_date in date
145 ,p_business_group_id in number
146 ,p_validation_start_date in date
147 ,p_validation_end_date in date
148 ,p_object_version_number in number
149 );
150
151 --
152 -- ----------------------------------------------------------------------------
153 -- |-------------------------< chk_per_asg_id >-------------------------------|
154 -- ----------------------------------------------------------------------------
155 -- {Start Of Comments}
156 --
157 -- Description:
158 -- This procedure validates the Person/Assignment Id.
159 --
160 -- Prerequisites:
161 --
162 --
163 -- In Parameters:
164 -- p_effective_date
165 -- p_per_or_asg_id
166 -- p_contract_category
167 -- p_business_group_id
168 -- p_object_version_number
169 --
170 -- Post Success:
171 -- Processing continues.
172 --
173 -- Post Failure:
174 -- An error is raised if the validation fails.
175 --
176 --
177 -- Access Status:
178 -- Internal Development Use Only.
179 --
180 -- {End Of Comments}
181 -- ----------------------------------------------------------------------------
182 Procedure chk_per_asg_id
183 (p_effective_date in date
184 ,p_per_or_asg_id in number
185 ,p_contract_category in varchar2
186 ,p_business_group_id in number
187 ,p_object_version_number in number
188 );
189 --
190 --
191 -- ----------------------------------------------------------------------------
192 -- |------------------< chk_emp_social_security_info >------------------------|
193 -- ----------------------------------------------------------------------------
194 -- {Start Of Comments}
195 --
196 -- Description:
197 -- This procedure validates the Employee Social Security Information values.
198 --
199 -- Prerequisites:
200 --
201 --
202 -- In Parameters:
203 -- p_sii_details_id
204 -- p_effective_date
205 -- p_emp_social_security_info
206 -- p_object_version_number
207 --
208 -- Post Success:
209 -- Processing continues.
210 --
211 -- Post Failure:
212 -- An error is raised if the validation fails.
213 --
214 --
215 -- Access Status:
216 -- Internal Development Use Only.
217 --
218 -- {End Of Comments}
219 -- ----------------------------------------------------------------------------
220 Procedure chk_emp_social_security_info
221 (p_sii_details_id in number
222 ,p_effective_date in date
223 ,p_emp_social_security_info in varchar2
224 ,p_object_version_number in number
225 );
226 --
227 --
228 -- ----------------------------------------------------------------------------
229 -- |--------------------< chk_old_age_contribution >--------------------------|
230 -- ----------------------------------------------------------------------------
231 -- {Start Of Comments}
232 --
233 -- Description:
234 -- This procedure validates the Old Age Contribution values.
235 --
236 -- Prerequisites:
237 --
238 --
239 -- In Parameters:
240 -- p_sii_details_id
241 -- p_effective_date
242 -- p_old_age_contribution
243 -- p_validation_start_date
244 -- p_validation_end_date
245 -- p_object_version_number
246 -- p_contract_category
247 --
248 -- Post Success:
249 -- Processing continues.
250 --
251 -- Post Failure:
252 -- An error is raised if the validation fails.
253 --
254 --
255 -- Access Status:
256 -- Internal Development Use Only.
257 --
258 -- {End Of Comments}
259 -- ----------------------------------------------------------------------------
260 Procedure chk_old_age_contribution
261 (p_sii_details_id in number
262 ,p_effective_date in date
263 ,p_old_age_contribution in varchar2
264 ,p_validation_start_date in date
265 ,p_validation_end_date in date
266 ,p_object_version_number in number
267 ,p_contract_category in varchar2
268 );
269 --
270 --
271 -- ----------------------------------------------------------------------------
272 -- |--------------------< chk_pension_contribution >--------------------------|
273 -- ----------------------------------------------------------------------------
274 -- {Start Of Comments}
275 --
276 -- Description:
277 -- This procedure validates the Pension Contribution values.
278 --
279 -- Prerequisites:
280 --
281 --
282 -- In Parameters:
283 -- p_sii_details_id
284 -- p_effective_date
285 -- p_pension_contribution
286 -- p_validation_start_date
287 -- p_validation_end_date
288 -- p_object_version_number
289 -- p_contract_category
290 --
291 -- Post Success:
292 -- Processing continues.
293 --
294 -- Post Failure:
295 -- An error is raised if the validation fails.
296 --
297 --
298 -- Access Status:
299 -- Internal Development Use Only.
300 --
301 -- {End Of Comments}
302 -- ----------------------------------------------------------------------------
303 Procedure chk_pension_contribution
304 (p_sii_details_id in number
305 ,p_effective_date in date
306 ,p_pension_contribution in varchar2
307 ,p_validation_start_date in date
308 ,p_validation_end_date in date
309 ,p_object_version_number in number
310 ,p_contract_category in varchar2
311 );
312 --
313 --
314 -- ----------------------------------------------------------------------------
315 -- |-------------------< chk_sickness_contribution >--------------------------|
316 -- ----------------------------------------------------------------------------
317 -- {Start Of Comments}
318 --
319 -- Description:
320 -- This procedure validates the Sickness Contribution values.
321 --
322 -- Prerequisites:
323 --
324 --
325 -- In Parameters:
326 -- p_sii_details_id
327 -- p_effective_date
328 -- p_sickness_contribution
329 -- p_validation_start_date
330 -- p_validation_end_date
331 -- p_object_version_number
332 -- p_contract_category
333 --
334 -- Post Success:
335 -- Processing continues.
336 --
337 -- Post Failure:
338 -- An error is raised if the validation fails.
339 --
340 --
341 -- Access Status:
342 -- Internal Development Use Only.
343 --
344 -- {End Of Comments}
345 -- ----------------------------------------------------------------------------
346 Procedure chk_sickness_contribution
347 (p_sii_details_id in number
348 ,p_effective_date in date
349 ,p_sickness_contribution in varchar2
353 ,p_contract_category in varchar2
350 ,p_validation_start_date in date
351 ,p_validation_end_date in date
352 ,p_object_version_number in number
354 );
355 --
356 --
357 -- ----------------------------------------------------------------------------
358 -- |-------------------< chk_work_injury_contribution >-----------------------|
359 -- ----------------------------------------------------------------------------
360 -- {Start Of Comments}
361 --
362 -- Description:
363 -- This procedure validates the Work Injury Contribution values.
364 --
365 -- Prerequisites:
366 --
367 --
368 -- In Parameters:
369 -- p_sii_details_id
370 -- p_effective_date
371 -- p_work_injury_contribution
372 -- p_validation_start_date
373 -- p_validation_end_date
374 -- p_object_version_number
375 -- p_contract_category
376 --
377 -- Post Success:
378 -- Processing continues.
379 --
380 -- Post Failure:
381 -- An error is raised if the validation fails.
382 --
383 --
384 -- Access Status:
385 -- Internal Development Use Only.
386 --
387 -- {End Of Comments}
388 -- ----------------------------------------------------------------------------
389 Procedure chk_work_injury_contribution
390 (p_sii_details_id in number
391 ,p_effective_date in date
392 ,p_work_injury_contribution in varchar2
393 ,p_validation_start_date in date
394 ,p_validation_end_date in date
395 ,p_object_version_number in number
396 ,p_contract_category in varchar2
397 );
398 --
399 --
400 -- ----------------------------------------------------------------------------
401 -- |--------------------< chk_labor_contribution >----------------------------|
402 -- ----------------------------------------------------------------------------
403 -- {Start Of Comments}
404 --
405 -- Description:
406 -- This procedure validates the Labor Contribution values.
407 --
408 -- Prerequisites:
409 --
410 --
411 -- In Parameters:
412 -- p_sii_details_id
413 -- p_effective_date
414 -- p_labor_contribution
415 -- p_validation_start_date
416 -- p_validation_end_date
417 -- p_object_version_number
418 -- p_contract_category
419 --
420 -- Post Success:
421 -- Processing continues.
422 --
423 -- Post Failure:
424 -- An error is raised if the validation fails.
425 --
426 --
427 -- Access Status:
428 -- Internal Development Use Only.
429 --
430 -- {End Of Comments}
431 -- ----------------------------------------------------------------------------
432 Procedure chk_labor_contribution
433 (p_sii_details_id in number
434 ,p_effective_date in date
435 ,p_labor_contribution in varchar2
436 ,p_validation_start_date in date
437 ,p_validation_end_date in date
438 ,p_object_version_number in number
439 ,p_contract_category in varchar2
440 );
441 --
442 --
443 -- ----------------------------------------------------------------------------
444 -- |--------------------< chk_health_contribution >---------------------------|
445 -- ----------------------------------------------------------------------------
446 -- {Start Of Comments}
447 --
448 -- Description:
449 -- This procedure validates the Health Contribution values.
450 --
451 -- Prerequisites:
452 --
453 --
454 -- In Parameters:
455 -- p_sii_details_id
456 -- p_effective_date
457 -- p_health_contribution
458 -- p_validation_start_date
459 -- p_validation_end_date
460 -- p_object_version_number
461 -- p_contract_category
462 --
463 -- Post Success:
464 -- Processing continues.
465 --
466 -- Post Failure:
467 -- An error is raised if the validation fails.
468 --
469 --
470 -- Access Status:
471 -- Internal Development Use Only.
472 --
473 -- {End Of Comments}
474 -- ----------------------------------------------------------------------------
475 Procedure chk_health_contribution
476 (p_sii_details_id in number
477 ,p_effective_date in date
478 ,p_health_contribution in varchar2
479 ,p_validation_start_date in date
480 ,p_validation_end_date in date
481 ,p_object_version_number in number
482 ,p_contract_category in varchar2
483 );
484 --
485 --
486 -- ----------------------------------------------------------------------------
487 -- |-----------------< chk_unemployment_contribution >------------------------|
488 -- ----------------------------------------------------------------------------
489 -- {Start Of Comments}
490 --
491 -- Description:
492 -- This procedure validates the Unemployment Contribution values.
493 --
494 -- Prerequisites:
495 --
496 --
497 -- In Parameters:
498 -- p_sii_details_id
499 -- p_effective_date
500 -- p_unemployment_contribution
501 -- p_validation_start_date
502 -- p_validation_end_date
503 -- p_object_version_number
504 -- p_contract_category
505 --
506 -- Post Success:
507 -- Processing continues.
508 --
509 -- Post Failure:
510 -- An error is raised if the validation fails.
511 --
512 --
513 -- Access Status:
514 -- Internal Development Use Only.
515 --
516 -- {End Of Comments}
517 -- ----------------------------------------------------------------------------
518 Procedure chk_unemployment_contribution
519 (p_sii_details_id in number
523 ,p_validation_end_date in date
520 ,p_effective_date in date
521 ,p_unemployment_contribution in varchar2
522 ,p_validation_start_date in date
524 ,p_object_version_number in number
525 ,p_contract_category in varchar2
526 );
527 --
528 -- ----------------------------------------------------------------------------
529 -- |----------------< chk_old_age_cont_end_reason >---------------------------|
530 -- ----------------------------------------------------------------------------
531 -- {Start Of Comments}
532 --
533 -- Description:
534 -- This procedure validates the Old Age Contribution End Reason values.
535 --
536 -- Prerequisites:
537 --
538 --
539 -- In Parameters:
540 -- p_sii_details_id
541 -- p_effective_date
542 -- p_old_age_contribution
543 -- p_old_age_cont_end_reason
544 -- p_validation_start_date
545 -- p_validation_end_date
546 -- p_object_version_number
547 --
548 -- Post Success:
549 -- Processing continues.
550 --
551 -- Post Failure:
552 -- An error is raised if the validation fails.
553 --
554 --
555 -- Access Status:
556 -- Internal Development Use Only.
557 --
558 -- {End Of Comments}
559 -- ----------------------------------------------------------------------------
560 Procedure chk_old_age_cont_end_reason
561 (p_sii_details_id in number
562 ,p_effective_date in date
563 ,p_old_age_contribution in varchar2
564 ,p_old_age_cont_end_reason in varchar2
565 ,p_validation_start_date in date
566 ,p_validation_end_date in date
567 ,p_object_version_number in number
568 );
569 --
570 --
571 -- ----------------------------------------------------------------------------
572 -- |------------------< chk_pension_cont_end_reason >-------------------------|
573 -- ----------------------------------------------------------------------------
574 -- {Start Of Comments}
575 --
576 -- Description:
577 -- This procedure validates the Pension Contribution End Reason values.
578 --
579 -- Prerequisites:
580 --
581 --
582 -- In Parameters:
583 -- p_sii_details_id
584 -- p_effective_date
585 -- p_pension_contribution
586 -- p_pension_cont_end_reason
587 -- p_validation_start_date
588 -- p_validation_end_date
589 -- p_object_version_number
590 --
591 -- Post Success:
592 -- Processing continues.
593 --
594 -- Post Failure:
595 -- An error is raised if the validation fails.
596 --
597 --
598 -- Access Status:
599 -- Internal Development Use Only.
600 --
601 -- {End Of Comments}
602 -- ----------------------------------------------------------------------------
603 Procedure chk_pension_cont_end_reason
604 (p_sii_details_id in number
605 ,p_effective_date in date
606 ,p_pension_contribution in varchar2
607 ,p_pension_cont_end_reason in varchar2
608 ,p_validation_start_date in date
609 ,p_validation_end_date in date
610 ,p_object_version_number in number
611 );
612
613 -- ----------------------------------------------------------------------------
614 -- |-------------------< chk_sickness_cont_end_reason >-----------------------|
615 -- ----------------------------------------------------------------------------
616 -- {Start Of Comments}
617 --
618 -- Description:
619 -- This procedure validates the Sickness Contribution End Reason values.
620 --
621 -- Prerequisites:
622 --
623 --
624 -- In Parameters:
625 -- p_sii_details_id
626 -- p_effective_date
627 -- p_sickness_contribution
628 -- p_sickness_cont_end_reason
629 -- p_validation_start_date
630 -- p_validation_end_date
631 -- p_object_version_number
632 --
633 -- Post Success:
634 -- Processing continues.
635 --
636 -- Post Failure:
637 -- An error is raised if the validation fails.
638 --
639 --
640 -- Access Status:
641 -- Internal Development Use Only.
642 --
643 -- {End Of Comments}
644 -- ----------------------------------------------------------------------------
645 Procedure chk_sickness_cont_end_reason
646 (p_sii_details_id in number
647 ,p_effective_date in date
648 ,p_sickness_contribution in varchar2
649 ,p_sickness_cont_end_reason in varchar2
650 ,p_validation_start_date in date
651 ,p_validation_end_date in date
652 ,p_object_version_number in number
653 );
654
655 -- ----------------------------------------------------------------------------
656 -- |-------------------< chk_work_injury_cont_end >---------------------------|
657 -- ----------------------------------------------------------------------------
658 -- {Start Of Comments}
659 --
660 -- Description:
661 -- This procedure validates the Work Injury Contribution End Reason values.
662 --
663 -- Prerequisites:
664 --
665 --
666 -- In Parameters:
667 -- p_sii_details_id
668 -- p_effective_date
669 -- p_work_injury_contribution
670 -- p_work_injury_cont_end_reason
671 -- p_validation_start_date
672 -- p_validation_end_date
673 -- p_object_version_number
674 --
675 -- Post Success:
676 -- Processing continues.
677 --
678 -- Post Failure:
679 -- An error is raised if the validation fails.
680 --
681 --
682 -- Access Status:
683 -- Internal Development Use Only.
684 --
688 (p_sii_details_id in number
685 -- {End Of Comments}
686 -- ----------------------------------------------------------------------------
687 Procedure chk_work_injury_cont_end
689 ,p_effective_date in date
690 ,p_work_injury_contribution in varchar2
691 ,p_work_injury_cont_end_reason in varchar2
692 ,p_validation_start_date in date
693 ,p_validation_end_date in date
694 ,p_object_version_number in number
695 );
696
697 -- ----------------------------------------------------------------------------
698 -- |---------------< chk_labor_fund_cont_end_reason >-------------------------|
699 -- -----------------------------------------------------------------------------
700 -- {Start Of Comments}
701 --
702 -- Description:
703 -- This procedure validates the Labor Fund Contribution End Reason values.
704 --
705 -- Prerequisites:
706 --
707 --
708 -- In Parameters:
709 -- p_sii_details_id
710 -- p_effective_date
711 -- p_labor_contribution
712 -- p_labor_fund_cont_end_reason
713 -- p_validation_start_date
714 -- p_validation_end_date
715 -- p_object_version_number
716 --
717 -- Post Success:
718 -- Processing continues.
719 --
720 -- Post Failure:
721 -- An error is raised if the validation fails.
722 --
723 --
724 -- Access Status:
725 -- Internal Development Use Only.
726 --
727 -- {End Of Comments}
728 -- ----------------------------------------------------------------------------
729 Procedure chk_labor_fund_cont_end_reason
730 (p_sii_details_id in number
731 ,p_effective_date in date
732 ,p_labor_contribution in varchar2
733 ,p_labor_fund_cont_end_reason in varchar2
734 ,p_validation_start_date in date
735 ,p_validation_end_date in date
736 ,p_object_version_number in number
737 );
738
739 -- ----------------------------------------------------------------------------
740 -- |------------------< chk_health_cont_end_reason >--------------------------|
741 -- ----------------------------------------------------------------------------
742 -- {Start Of Comments}
743 --
744 -- Description:
745 -- This procedure validates the Health Contribution End Reason values.
746 --
747 -- Prerequisites:
748 --
749 --
750 -- In Parameters:
751 -- p_sii_details_id
752 -- p_effective_date
753 -- p_health_contribution
754 -- p_health_cont_end_reason
755 -- p_validation_start_date
756 -- p_validation_end_date
757 -- p_object_version_number
758 --
759 -- Post Success:
760 -- Processing continues.
761 --
762 -- Post Failure:
763 -- An error is raised if the validation fails.
764 --
765 --
766 -- Access Status:
767 -- Internal Development Use Only.
768 --
769 -- {End Of Comments}
770 -- ----------------------------------------------------------------------------
771 Procedure chk_health_cont_end_reason
772 (p_sii_details_id in number
773 ,p_effective_date in date
774 ,p_health_contribution in varchar2
775 ,p_health_cont_end_reason in varchar2
776 ,p_validation_start_date in date
777 ,p_validation_end_date in date
778 ,p_object_version_number in number
779 );
780
781 -- ----------------------------------------------------------------------------
782 -- |-------------------< chk_unemployment_cont_end >--------------------------|
783 -- ----------------------------------------------------------------------------
784 -- {Start Of Comments}
785 --
786 -- Description:
787 -- This procedure validates the Unemployment Contribution End Reason values.
788 --
789 -- Prerequisites:
790 --
791 --
792 -- In Parameters:
793 -- p_sii_details_id
794 -- p_effective_date
795 -- p_unemployment_contribution
796 -- p_unemployment_cont_end_reason
797 -- p_validation_start_date
798 -- p_validation_end_date
799 -- p_object_version_number
800 --
801 -- Post Success:
802 -- Processing continues.
803 --
804 -- Post Failure:
805 -- An error is raised if the validation fails.
806 --
807 --
808 -- Access Status:
809 -- Internal Development Use Only.
810 --
811 -- {End Of Comments}
812 -- ----------------------------------------------------------------------------
813 Procedure chk_unemployment_cont_end
814 (p_sii_details_id in number
815 ,p_effective_date in date
816 ,p_unemployment_contribution in varchar2
817 ,p_unemployment_cont_end_reason in varchar2
818 ,p_validation_start_date in date
819 ,p_validation_end_date in date
820 ,p_object_version_number in number
821 );
822
823 --
824 --
825 -- ----------------------------------------------------------------------------
826 -- |---------------------------< insert_validate >----------------------------|
827 -- ----------------------------------------------------------------------------
828 -- {Start Of Comments}
829 --
830 -- Description:
831 -- This procedure controls the execution of all insert business rules
832 -- validation.
833 --
834 -- Prerequisites:
835 -- This private procedure is called from ins procedure.
836 --
837 -- In Parameters:
838 -- A Pl/Sql record structre.
839 --
840 -- Post Success:
841 -- Processing continues.
842 --
843 -- Post Failure:
844 -- If a business rules fails the error will not be handled by this procedure
845 -- unless explicity coded.
846 --
847 -- Developer Implementation Notes:
848 -- For insert, your business rules should be executed from this procedure and
849 -- should ideally (unless really necessary) just be straight procedure or
850 -- function calls. Try and avoid using conditional branching logic.
851 --
852 -- Access Status:
853 -- Internal Row Handler Use Only.
854 --
855 -- {End Of Comments}
856 -- ----------------------------------------------------------------------------
857 Procedure insert_validate
858 (p_rec in pay_psd_shd.g_rec_type
859 ,p_effective_date in date
860 ,p_datetrack_mode in varchar2
861 ,p_validation_start_date in date
862 ,p_validation_end_date in date
863 );
864 --
865 -- ----------------------------------------------------------------------------
866 -- |---------------------------< update_validate >----------------------------|
867 -- ----------------------------------------------------------------------------
868 -- {Start Of Comments}
869 --
870 -- Description:
871 -- This procedure controls the execution of all update business rules
872 -- validation.
873 --
874 -- Prerequisites:
875 -- This private procedure is called from upd procedure.
876 --
877 -- In Parameters:
878 -- A Pl/Sql record structre.
879 --
880 -- Post Success:
881 -- Processing continues.
882 --
883 -- Post Failure:
884 -- If a business rules fails the error will not be handled by this procedure
885 -- unless explicity coded.
886 --
887 -- Developer Implementation Notes:
888 -- For update, your business rules should be executed from this procedure and
889 -- should ideally (unless really necessary) just be straight procedure or
890 -- function calls. Try and avoid using conditional branching logic.
891 --
892 -- Access Status:
893 -- Internal Row Handler Use Only.
894 --
895 -- {End Of Comments}
896 -- ----------------------------------------------------------------------------
897 Procedure update_validate
898 (p_rec in pay_psd_shd.g_rec_type
899 ,p_effective_date in date
900 ,p_datetrack_mode in varchar2
901 ,p_validation_start_date in date
902 ,p_validation_end_date in date
903 );
904 --
905 -- ----------------------------------------------------------------------------
906 -- |---------------------------< delete_validate >----------------------------|
907 -- ----------------------------------------------------------------------------
908 -- {Start Of Comments}
909 --
910 -- Description:
911 -- This procedure controls the execution of all delete business rules
912 -- validation.
913 --
914 -- Prerequisites:
915 -- This private procedure is called from del procedure.
916 --
917 -- In Parameters:
918 -- A Pl/Sql record structure.
919 --
920 -- Post Success:
921 -- Processing continues.
922 --
923 -- Post Failure:
924 -- If a business rules fails the error will not be handled by this procedure
925 -- unless explicity coded.
926 --
927 -- Developer Implementation Notes:
928 -- For delete, your business rules should be executed from this procedure and
929 -- should ideally (unless really necessary) just be straight procedure or
930 -- function calls. Try and avoid using conditional branching logic.
931 --
932 -- Access Status:
933 -- Internal Row Handler Use Only.
934 --
935 -- {End Of Comments}
936 -- ----------------------------------------------------------------------------
937 Procedure delete_validate
938 (p_rec in pay_psd_shd.g_rec_type
939 ,p_effective_date in date
940 ,p_datetrack_mode in varchar2
941 ,p_validation_start_date in date
942 ,p_validation_end_date in date
943 );
944
945 --
946 -- ----------------------------------------------------------------------------
947 -- |---------------------< get_contribution_values >--------------------------|
948 -- ----------------------------------------------------------------------------
949 -- {Start Of Comments}
950 --
951 -- Description:
952 -- This procedure derives the various Contribution values when the 'Employee
953 -- Social Security Information' value is passed in.
954 --
955 -- Prerequisites:
956 --
957 --
958 -- In Parameters:
959 -- p_emp_social_security_info
960 -- p_effective_date
961 --
962 -- In/Out Parameters
963 -- p_old_age_contribution
964 -- p_pension_contribution
965 -- p_sickness_contribution
966 -- p_work_injury_contribution
967 -- p_labor_contribution
968 -- p_health_contribution
969 -- p_unemployment_contribution
970 --
971 --
972 -- Post Success:
973 -- Processing continues.
974 --
975 -- Post Failure:
976 -- An error is raised if the validation fails.
977 --
978 --
979 -- Access Status:h
980 -- Internal Development Use Only.
981 --
982 -- {End Of Comments}
983 -- ----------------------------------------------------------------------------
984 Procedure get_contribution_values
985 (p_effective_date in date
986 ,p_emp_social_security_info in varchar2
987 ,p_old_age_contribution in out nocopy varchar2
988 ,p_pension_contribution in out nocopy varchar2
989 ,p_sickness_contribution in out nocopy varchar2
990 ,p_work_injury_contribution in out nocopy varchar2
991 ,p_labor_contribution in out nocopy varchar2
992 ,p_health_contribution in out nocopy varchar2
993 ,p_unemployment_contribution in out nocopy varchar2);
994 --
995 --
996 end pay_psd_bus;