eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_SUMMARY_PKG dependencies on BEN_CWB_UTILS

Line 617: l_sum_rec.elig_count_direct := ben_cwb_utils.add_number_with_null_check

613: hr_utility.set_location(l_proc, 50);
614: end if;
615: --
616: --Now, add the values
617: l_sum_rec.elig_count_direct := ben_cwb_utils.add_number_with_null_check
618: (l_sum_rec.elig_count_direct,pending_rec.elig_count_direct);
619: l_sum_rec.elig_count_all := ben_cwb_utils.add_number_with_null_check
620: (l_sum_rec.elig_count_all,pending_rec.elig_count_all);
621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check

Line 619: l_sum_rec.elig_count_all := ben_cwb_utils.add_number_with_null_check

615: --
616: --Now, add the values
617: l_sum_rec.elig_count_direct := ben_cwb_utils.add_number_with_null_check
618: (l_sum_rec.elig_count_direct,pending_rec.elig_count_direct);
619: l_sum_rec.elig_count_all := ben_cwb_utils.add_number_with_null_check
620: (l_sum_rec.elig_count_all,pending_rec.elig_count_all);
621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
622: (l_sum_rec.emp_recv_count_direct,pending_rec.emp_recv_count_direct);
623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check

Line 621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check

617: l_sum_rec.elig_count_direct := ben_cwb_utils.add_number_with_null_check
618: (l_sum_rec.elig_count_direct,pending_rec.elig_count_direct);
619: l_sum_rec.elig_count_all := ben_cwb_utils.add_number_with_null_check
620: (l_sum_rec.elig_count_all,pending_rec.elig_count_all);
621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
622: (l_sum_rec.emp_recv_count_direct,pending_rec.emp_recv_count_direct);
623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
624: (l_sum_rec.emp_recv_count_all,pending_rec.emp_recv_count_all);
625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check

619: l_sum_rec.elig_count_all := ben_cwb_utils.add_number_with_null_check
620: (l_sum_rec.elig_count_all,pending_rec.elig_count_all);
621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
622: (l_sum_rec.emp_recv_count_direct,pending_rec.emp_recv_count_direct);
623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
624: (l_sum_rec.emp_recv_count_all,pending_rec.emp_recv_count_all);
625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
626: (l_sum_rec.elig_sal_val_direct,pending_rec.elig_sal_val_direct);
627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check

Line 625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

621: l_sum_rec.emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
622: (l_sum_rec.emp_recv_count_direct,pending_rec.emp_recv_count_direct);
623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
624: (l_sum_rec.emp_recv_count_all,pending_rec.emp_recv_count_all);
625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
626: (l_sum_rec.elig_sal_val_direct,pending_rec.elig_sal_val_direct);
627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
628: (l_sum_rec.elig_sal_val_all,pending_rec.elig_sal_val_all);
629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check

623: l_sum_rec.emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
624: (l_sum_rec.emp_recv_count_all,pending_rec.emp_recv_count_all);
625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
626: (l_sum_rec.elig_sal_val_direct,pending_rec.elig_sal_val_direct);
627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
628: (l_sum_rec.elig_sal_val_all,pending_rec.elig_sal_val_all);
629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check
630: (l_sum_rec.ws_val_direct,pending_rec.ws_val_direct);
631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check

Line 629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check

625: l_sum_rec.elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
626: (l_sum_rec.elig_sal_val_direct,pending_rec.elig_sal_val_direct);
627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
628: (l_sum_rec.elig_sal_val_all,pending_rec.elig_sal_val_all);
629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check
630: (l_sum_rec.ws_val_direct,pending_rec.ws_val_direct);
631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check
632: (l_sum_rec.ws_val_all,pending_rec.ws_val_all);
633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check

627: l_sum_rec.elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
628: (l_sum_rec.elig_sal_val_all,pending_rec.elig_sal_val_all);
629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check
630: (l_sum_rec.ws_val_direct,pending_rec.ws_val_direct);
631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check
632: (l_sum_rec.ws_val_all,pending_rec.ws_val_all);
633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
634: (l_sum_rec.ws_bdgt_val_direct,pending_rec.ws_bdgt_val_direct);
635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check

Line 633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

629: l_sum_rec.ws_val_direct :=ben_cwb_utils.add_number_with_null_check
630: (l_sum_rec.ws_val_direct,pending_rec.ws_val_direct);
631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check
632: (l_sum_rec.ws_val_all,pending_rec.ws_val_all);
633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
634: (l_sum_rec.ws_bdgt_val_direct,pending_rec.ws_bdgt_val_direct);
635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
636: (l_sum_rec.ws_bdgt_val_all,pending_rec.ws_bdgt_val_all);
637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check

Line 635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check

631: l_sum_rec.ws_val_all :=ben_cwb_utils.add_number_with_null_check
632: (l_sum_rec.ws_val_all,pending_rec.ws_val_all);
633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
634: (l_sum_rec.ws_bdgt_val_direct,pending_rec.ws_bdgt_val_direct);
635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
636: (l_sum_rec.ws_bdgt_val_all,pending_rec.ws_bdgt_val_all);
637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
638: (l_sum_rec.ws_bdgt_iss_val_direct,pending_rec.ws_bdgt_iss_val_direct);
639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check

Line 637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check

633: l_sum_rec.ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
634: (l_sum_rec.ws_bdgt_val_direct,pending_rec.ws_bdgt_val_direct);
635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
636: (l_sum_rec.ws_bdgt_val_all,pending_rec.ws_bdgt_val_all);
637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
638: (l_sum_rec.ws_bdgt_iss_val_direct,pending_rec.ws_bdgt_iss_val_direct);
639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
640: (l_sum_rec.ws_bdgt_iss_val_all,pending_rec.ws_bdgt_iss_val_all);
641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check

635: l_sum_rec.ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
636: (l_sum_rec.ws_bdgt_val_all,pending_rec.ws_bdgt_val_all);
637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
638: (l_sum_rec.ws_bdgt_iss_val_direct,pending_rec.ws_bdgt_iss_val_direct);
639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
640: (l_sum_rec.ws_bdgt_iss_val_all,pending_rec.ws_bdgt_iss_val_all);
641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
642: (l_sum_rec.bdgt_val_direct,pending_rec.bdgt_val_direct);
643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

637: l_sum_rec.ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
638: (l_sum_rec.ws_bdgt_iss_val_direct,pending_rec.ws_bdgt_iss_val_direct);
639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
640: (l_sum_rec.ws_bdgt_iss_val_all,pending_rec.ws_bdgt_iss_val_all);
641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
642: (l_sum_rec.bdgt_val_direct,pending_rec.bdgt_val_direct);
643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
644: (l_sum_rec.bdgt_iss_val_direct,pending_rec.bdgt_iss_val_direct);
645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check

639: l_sum_rec.ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
640: (l_sum_rec.ws_bdgt_iss_val_all,pending_rec.ws_bdgt_iss_val_all);
641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
642: (l_sum_rec.bdgt_val_direct,pending_rec.bdgt_val_direct);
643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
644: (l_sum_rec.bdgt_iss_val_direct,pending_rec.bdgt_iss_val_direct);
645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
646: (l_sum_rec.stat_sal_val_direct,pending_rec.stat_sal_val_direct);
647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check

Line 645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

641: l_sum_rec.bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
642: (l_sum_rec.bdgt_val_direct,pending_rec.bdgt_val_direct);
643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
644: (l_sum_rec.bdgt_iss_val_direct,pending_rec.bdgt_iss_val_direct);
645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
646: (l_sum_rec.stat_sal_val_direct,pending_rec.stat_sal_val_direct);
647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
648: (l_sum_rec.stat_sal_val_all,pending_rec.stat_sal_val_all);
649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check

643: l_sum_rec.bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
644: (l_sum_rec.bdgt_iss_val_direct,pending_rec.bdgt_iss_val_direct);
645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
646: (l_sum_rec.stat_sal_val_direct,pending_rec.stat_sal_val_direct);
647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
648: (l_sum_rec.stat_sal_val_all,pending_rec.stat_sal_val_all);
649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
650: (l_sum_rec.oth_comp_val_direct,pending_rec.oth_comp_val_direct);
651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check

Line 649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

645: l_sum_rec.stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
646: (l_sum_rec.stat_sal_val_direct,pending_rec.stat_sal_val_direct);
647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
648: (l_sum_rec.stat_sal_val_all,pending_rec.stat_sal_val_all);
649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
650: (l_sum_rec.oth_comp_val_direct,pending_rec.oth_comp_val_direct);
651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
652: (l_sum_rec.oth_comp_val_all,pending_rec.oth_comp_val_all);
653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check

647: l_sum_rec.stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
648: (l_sum_rec.stat_sal_val_all,pending_rec.stat_sal_val_all);
649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
650: (l_sum_rec.oth_comp_val_direct,pending_rec.oth_comp_val_direct);
651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
652: (l_sum_rec.oth_comp_val_all,pending_rec.oth_comp_val_all);
653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
654: (l_sum_rec.tot_comp_val_direct,pending_rec.tot_comp_val_direct);
655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check

Line 653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

649: l_sum_rec.oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
650: (l_sum_rec.oth_comp_val_direct,pending_rec.oth_comp_val_direct);
651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
652: (l_sum_rec.oth_comp_val_all,pending_rec.oth_comp_val_all);
653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
654: (l_sum_rec.tot_comp_val_direct,pending_rec.tot_comp_val_direct);
655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
656: (l_sum_rec.tot_comp_val_all,pending_rec.tot_comp_val_all);
657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check

651: l_sum_rec.oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
652: (l_sum_rec.oth_comp_val_all,pending_rec.oth_comp_val_all);
653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
654: (l_sum_rec.tot_comp_val_direct,pending_rec.tot_comp_val_direct);
655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
656: (l_sum_rec.tot_comp_val_all,pending_rec.tot_comp_val_all);
657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check
658: (l_sum_rec.rec_val_direct,pending_rec.rec_val_direct);
659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check

Line 657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check

653: l_sum_rec.tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
654: (l_sum_rec.tot_comp_val_direct,pending_rec.tot_comp_val_direct);
655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
656: (l_sum_rec.tot_comp_val_all,pending_rec.tot_comp_val_all);
657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check
658: (l_sum_rec.rec_val_direct,pending_rec.rec_val_direct);
659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check
660: (l_sum_rec.rec_val_all,pending_rec.rec_val_all);
661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check

655: l_sum_rec.tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
656: (l_sum_rec.tot_comp_val_all,pending_rec.tot_comp_val_all);
657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check
658: (l_sum_rec.rec_val_direct,pending_rec.rec_val_direct);
659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check
660: (l_sum_rec.rec_val_all,pending_rec.rec_val_all);
661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
662: (l_sum_rec.rec_mn_val_direct,pending_rec.rec_mn_val_direct);
663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check

Line 661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check

657: l_sum_rec.rec_val_direct :=ben_cwb_utils.add_number_with_null_check
658: (l_sum_rec.rec_val_direct,pending_rec.rec_val_direct);
659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check
660: (l_sum_rec.rec_val_all,pending_rec.rec_val_all);
661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
662: (l_sum_rec.rec_mn_val_direct,pending_rec.rec_mn_val_direct);
663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
664: (l_sum_rec.rec_mn_val_all,pending_rec.rec_mn_val_all);
665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check

659: l_sum_rec.rec_val_all :=ben_cwb_utils.add_number_with_null_check
660: (l_sum_rec.rec_val_all,pending_rec.rec_val_all);
661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
662: (l_sum_rec.rec_mn_val_direct,pending_rec.rec_mn_val_direct);
663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
664: (l_sum_rec.rec_mn_val_all,pending_rec.rec_mn_val_all);
665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
666: (l_sum_rec.rec_mx_val_direct,pending_rec.rec_mx_val_direct);
667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check

Line 665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check

661: l_sum_rec.rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
662: (l_sum_rec.rec_mn_val_direct,pending_rec.rec_mn_val_direct);
663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
664: (l_sum_rec.rec_mn_val_all,pending_rec.rec_mn_val_all);
665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
666: (l_sum_rec.rec_mx_val_direct,pending_rec.rec_mx_val_direct);
667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
668: (l_sum_rec.rec_mx_val_all,pending_rec.rec_mx_val_all);
669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check

663: l_sum_rec.rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
664: (l_sum_rec.rec_mn_val_all,pending_rec.rec_mn_val_all);
665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
666: (l_sum_rec.rec_mx_val_direct,pending_rec.rec_mx_val_direct);
667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
668: (l_sum_rec.rec_mx_val_all,pending_rec.rec_mx_val_all);
669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
670: (l_sum_rec.misc1_val_direct,pending_rec.misc1_val_direct);
671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check

Line 669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check

665: l_sum_rec.rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
666: (l_sum_rec.rec_mx_val_direct,pending_rec.rec_mx_val_direct);
667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
668: (l_sum_rec.rec_mx_val_all,pending_rec.rec_mx_val_all);
669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
670: (l_sum_rec.misc1_val_direct,pending_rec.misc1_val_direct);
671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check
672: (l_sum_rec.misc1_val_all,pending_rec.misc1_val_all);
673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check

667: l_sum_rec.rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
668: (l_sum_rec.rec_mx_val_all,pending_rec.rec_mx_val_all);
669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
670: (l_sum_rec.misc1_val_direct,pending_rec.misc1_val_direct);
671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check
672: (l_sum_rec.misc1_val_all,pending_rec.misc1_val_all);
673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
674: (l_sum_rec.misc2_val_direct,pending_rec.misc2_val_direct);
675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check

Line 673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check

669: l_sum_rec.misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
670: (l_sum_rec.misc1_val_direct,pending_rec.misc1_val_direct);
671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check
672: (l_sum_rec.misc1_val_all,pending_rec.misc1_val_all);
673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
674: (l_sum_rec.misc2_val_direct,pending_rec.misc2_val_direct);
675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check
676: (l_sum_rec.misc2_val_all,pending_rec.misc2_val_all);
677: l_sum_rec.misc3_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check

671: l_sum_rec.misc1_val_all :=ben_cwb_utils.add_number_with_null_check
672: (l_sum_rec.misc1_val_all,pending_rec.misc1_val_all);
673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
674: (l_sum_rec.misc2_val_direct,pending_rec.misc2_val_direct);
675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check
676: (l_sum_rec.misc2_val_all,pending_rec.misc2_val_all);
677: l_sum_rec.misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
678: (l_sum_rec.misc3_val_direct,pending_rec.misc3_val_direct);
679: l_sum_rec.misc3_val_all :=ben_cwb_utils.add_number_with_null_check

Line 677: l_sum_rec.misc3_val_direct :=ben_cwb_utils.add_number_with_null_check

673: l_sum_rec.misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
674: (l_sum_rec.misc2_val_direct,pending_rec.misc2_val_direct);
675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check
676: (l_sum_rec.misc2_val_all,pending_rec.misc2_val_all);
677: l_sum_rec.misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
678: (l_sum_rec.misc3_val_direct,pending_rec.misc3_val_direct);
679: l_sum_rec.misc3_val_all :=ben_cwb_utils.add_number_with_null_check
680: (l_sum_rec.misc3_val_all,pending_rec.misc3_val_all);
681:

Line 679: l_sum_rec.misc3_val_all :=ben_cwb_utils.add_number_with_null_check

675: l_sum_rec.misc2_val_all :=ben_cwb_utils.add_number_with_null_check
676: (l_sum_rec.misc2_val_all,pending_rec.misc2_val_all);
677: l_sum_rec.misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
678: (l_sum_rec.misc3_val_direct,pending_rec.misc3_val_direct);
679: l_sum_rec.misc3_val_all :=ben_cwb_utils.add_number_with_null_check
680: (l_sum_rec.misc3_val_all,pending_rec.misc3_val_all);
681:
682: -- Now delete the record from ben_cwb_summary as it is already
683: -- consolidated

Line 1775: ,p_ws_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check

1771: update_or_insert_pl_sql_tab
1772: (p_group_per_in_ler_id => p_group_per_in_ler_id
1773: ,p_group_pl_id => l_group_pl_id_tab(i)
1774: ,p_group_oipl_id => l_group_oipl_id_tab(i)
1775: ,p_ws_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check
1776: (l_ws_bdgt_val_direct_tab(i),
1777: -l_old_ws_bdgt_val_direct_tab(i))
1778: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check
1779: (l_ws_bdgt_val_all_tab(i),

Line 1778: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check

1774: ,p_group_oipl_id => l_group_oipl_id_tab(i)
1775: ,p_ws_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check
1776: (l_ws_bdgt_val_direct_tab(i),
1777: -l_old_ws_bdgt_val_direct_tab(i))
1778: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check
1779: (l_ws_bdgt_val_all_tab(i),
1780: -l_old_ws_bdgt_val_all_tab(i))
1781: ,p_ws_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check
1782: (l_ws_bdgt_iss_val_direct_tab(i),

Line 1781: ,p_ws_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check

1777: -l_old_ws_bdgt_val_direct_tab(i))
1778: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check
1779: (l_ws_bdgt_val_all_tab(i),
1780: -l_old_ws_bdgt_val_all_tab(i))
1781: ,p_ws_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check
1782: (l_ws_bdgt_iss_val_direct_tab(i),
1783: -l_old_ws_bdgt_iss_val_dir_tab(i))
1784: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check
1785: (l_ws_bdgt_iss_val_all_tab(i),

Line 1784: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check

1780: -l_old_ws_bdgt_val_all_tab(i))
1781: ,p_ws_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check
1782: (l_ws_bdgt_iss_val_direct_tab(i),
1783: -l_old_ws_bdgt_iss_val_dir_tab(i))
1784: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check
1785: (l_ws_bdgt_iss_val_all_tab(i),
1786: -l_old_ws_bdgt_iss_val_all_tab(i))
1787: ,p_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check
1788: (l_bdgt_val_direct_tab(i),

Line 1787: ,p_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check

1783: -l_old_ws_bdgt_iss_val_dir_tab(i))
1784: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check
1785: (l_ws_bdgt_iss_val_all_tab(i),
1786: -l_old_ws_bdgt_iss_val_all_tab(i))
1787: ,p_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check
1788: (l_bdgt_val_direct_tab(i),
1789: -l_old_bdgt_val_direct_tab(i))
1790: ,p_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check
1791: (l_bdgt_iss_val_direct_tab(i),

Line 1790: ,p_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check

1786: -l_old_ws_bdgt_iss_val_all_tab(i))
1787: ,p_bdgt_val_direct => ben_cwb_utils.add_number_with_null_check
1788: (l_bdgt_val_direct_tab(i),
1789: -l_old_bdgt_val_direct_tab(i))
1790: ,p_bdgt_iss_val_direct => ben_cwb_utils.add_number_with_null_check
1791: (l_bdgt_iss_val_direct_tab(i),
1792: -l_old_bdgt_iss_val_direct_tab(i)));
1793: else
1794: update_or_insert_pl_sql_tab

Line 1798: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check

1794: update_or_insert_pl_sql_tab
1795: (p_group_per_in_ler_id => p_group_per_in_ler_id
1796: ,p_group_pl_id => l_group_pl_id_tab(i)
1797: ,p_group_oipl_id => l_group_oipl_id_tab(i)
1798: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check
1799: (l_ws_bdgt_val_all_tab(i),
1800: -l_old_ws_bdgt_val_all_tab(i))
1801: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check
1802: (l_ws_bdgt_iss_val_all_tab(i),

Line 1801: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check

1797: ,p_group_oipl_id => l_group_oipl_id_tab(i)
1798: ,p_ws_bdgt_val_all => ben_cwb_utils.add_number_with_null_check
1799: (l_ws_bdgt_val_all_tab(i),
1800: -l_old_ws_bdgt_val_all_tab(i))
1801: ,p_ws_bdgt_iss_val_all => ben_cwb_utils.add_number_with_null_check
1802: (l_ws_bdgt_iss_val_all_tab(i),
1803: -l_old_ws_bdgt_iss_val_all_tab(i)));
1804: end if;
1805: end loop;

Line 2276: g_summary_rec(j).elig_count_direct := ben_cwb_utils.add_number_with_null_check

2272: hr_utility.set_location(l_proc, 30);
2273: end if;
2274: --
2275: -- record alredy exists. So update the summary
2276: g_summary_rec(j).elig_count_direct := ben_cwb_utils.add_number_with_null_check
2277: (g_summary_rec(j).elig_count_direct,p_elig_count_direct);
2278: g_summary_rec(j).elig_count_all := ben_cwb_utils.add_number_with_null_check
2279: (g_summary_rec(j).elig_count_all,p_elig_count_all);
2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check

Line 2278: g_summary_rec(j).elig_count_all := ben_cwb_utils.add_number_with_null_check

2274: --
2275: -- record alredy exists. So update the summary
2276: g_summary_rec(j).elig_count_direct := ben_cwb_utils.add_number_with_null_check
2277: (g_summary_rec(j).elig_count_direct,p_elig_count_direct);
2278: g_summary_rec(j).elig_count_all := ben_cwb_utils.add_number_with_null_check
2279: (g_summary_rec(j).elig_count_all,p_elig_count_all);
2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
2281: (g_summary_rec(j).emp_recv_count_direct,p_emp_recv_count_direct);
2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check

Line 2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check

2276: g_summary_rec(j).elig_count_direct := ben_cwb_utils.add_number_with_null_check
2277: (g_summary_rec(j).elig_count_direct,p_elig_count_direct);
2278: g_summary_rec(j).elig_count_all := ben_cwb_utils.add_number_with_null_check
2279: (g_summary_rec(j).elig_count_all,p_elig_count_all);
2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
2281: (g_summary_rec(j).emp_recv_count_direct,p_emp_recv_count_direct);
2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
2283: (g_summary_rec(j).emp_recv_count_all,p_emp_recv_count_all);
2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check

2278: g_summary_rec(j).elig_count_all := ben_cwb_utils.add_number_with_null_check
2279: (g_summary_rec(j).elig_count_all,p_elig_count_all);
2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
2281: (g_summary_rec(j).emp_recv_count_direct,p_emp_recv_count_direct);
2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
2283: (g_summary_rec(j).emp_recv_count_all,p_emp_recv_count_all);
2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2285: (g_summary_rec(j).elig_sal_val_direct,p_elig_sal_val_direct);
2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check

Line 2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

2280: g_summary_rec(j).emp_recv_count_direct := ben_cwb_utils.add_number_with_null_check
2281: (g_summary_rec(j).emp_recv_count_direct,p_emp_recv_count_direct);
2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
2283: (g_summary_rec(j).emp_recv_count_all,p_emp_recv_count_all);
2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2285: (g_summary_rec(j).elig_sal_val_direct,p_elig_sal_val_direct);
2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
2287: (g_summary_rec(j).elig_sal_val_all,p_elig_sal_val_all);
2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check

2282: g_summary_rec(j).emp_recv_count_all :=ben_cwb_utils.add_number_with_null_check
2283: (g_summary_rec(j).emp_recv_count_all,p_emp_recv_count_all);
2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2285: (g_summary_rec(j).elig_sal_val_direct,p_elig_sal_val_direct);
2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
2287: (g_summary_rec(j).elig_sal_val_all,p_elig_sal_val_all);
2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check
2289: (g_summary_rec(j).ws_val_direct,p_ws_val_direct);
2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check

2284: g_summary_rec(j).elig_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2285: (g_summary_rec(j).elig_sal_val_direct,p_elig_sal_val_direct);
2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
2287: (g_summary_rec(j).elig_sal_val_all,p_elig_sal_val_all);
2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check
2289: (g_summary_rec(j).ws_val_direct,p_ws_val_direct);
2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check
2291: (g_summary_rec(j).ws_val_all,p_ws_val_all);
2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check

2286: g_summary_rec(j).elig_sal_val_all := ben_cwb_utils.add_number_with_null_check
2287: (g_summary_rec(j).elig_sal_val_all,p_elig_sal_val_all);
2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check
2289: (g_summary_rec(j).ws_val_direct,p_ws_val_direct);
2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check
2291: (g_summary_rec(j).ws_val_all,p_ws_val_all);
2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2293: (g_summary_rec(j).ws_bdgt_val_direct,p_ws_bdgt_val_direct);
2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

2288: g_summary_rec(j).ws_val_direct :=ben_cwb_utils.add_number_with_null_check
2289: (g_summary_rec(j).ws_val_direct,p_ws_val_direct);
2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check
2291: (g_summary_rec(j).ws_val_all,p_ws_val_all);
2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2293: (g_summary_rec(j).ws_bdgt_val_direct,p_ws_bdgt_val_direct);
2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
2295: (g_summary_rec(j).ws_bdgt_val_all,p_ws_bdgt_val_all);
2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check

Line 2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check

2290: g_summary_rec(j).ws_val_all :=ben_cwb_utils.add_number_with_null_check
2291: (g_summary_rec(j).ws_val_all,p_ws_val_all);
2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2293: (g_summary_rec(j).ws_bdgt_val_direct,p_ws_bdgt_val_direct);
2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
2295: (g_summary_rec(j).ws_bdgt_val_all,p_ws_bdgt_val_all);
2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
2297: (g_summary_rec(j).ws_bdgt_iss_val_direct,p_ws_bdgt_iss_val_direct);
2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check

2292: g_summary_rec(j).ws_bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2293: (g_summary_rec(j).ws_bdgt_val_direct,p_ws_bdgt_val_direct);
2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
2295: (g_summary_rec(j).ws_bdgt_val_all,p_ws_bdgt_val_all);
2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
2297: (g_summary_rec(j).ws_bdgt_iss_val_direct,p_ws_bdgt_iss_val_direct);
2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
2299: (g_summary_rec(j).ws_bdgt_iss_val_all,p_ws_bdgt_iss_val_all);
2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check

2294: g_summary_rec(j).ws_bdgt_val_all :=ben_cwb_utils.add_number_with_null_check
2295: (g_summary_rec(j).ws_bdgt_val_all,p_ws_bdgt_val_all);
2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
2297: (g_summary_rec(j).ws_bdgt_iss_val_direct,p_ws_bdgt_iss_val_direct);
2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
2299: (g_summary_rec(j).ws_bdgt_iss_val_all,p_ws_bdgt_iss_val_all);
2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2301: (g_summary_rec(j).bdgt_val_direct,p_bdgt_val_direct);
2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check

2296: g_summary_rec(j).ws_bdgt_iss_val_direct := ben_cwb_utils.add_number_with_null_check
2297: (g_summary_rec(j).ws_bdgt_iss_val_direct,p_ws_bdgt_iss_val_direct);
2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
2299: (g_summary_rec(j).ws_bdgt_iss_val_all,p_ws_bdgt_iss_val_all);
2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2301: (g_summary_rec(j).bdgt_val_direct,p_bdgt_val_direct);
2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
2303: (g_summary_rec(j).bdgt_iss_val_direct,p_bdgt_iss_val_direct);
2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check

2298: g_summary_rec(j).ws_bdgt_iss_val_all :=ben_cwb_utils.add_number_with_null_check
2299: (g_summary_rec(j).ws_bdgt_iss_val_all,p_ws_bdgt_iss_val_all);
2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2301: (g_summary_rec(j).bdgt_val_direct,p_bdgt_val_direct);
2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
2303: (g_summary_rec(j).bdgt_iss_val_direct,p_bdgt_iss_val_direct);
2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2305: (g_summary_rec(j).stat_sal_val_direct,p_stat_sal_val_direct);
2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check

2300: g_summary_rec(j).bdgt_val_direct :=ben_cwb_utils.add_number_with_null_check
2301: (g_summary_rec(j).bdgt_val_direct,p_bdgt_val_direct);
2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
2303: (g_summary_rec(j).bdgt_iss_val_direct,p_bdgt_iss_val_direct);
2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2305: (g_summary_rec(j).stat_sal_val_direct,p_stat_sal_val_direct);
2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
2307: (g_summary_rec(j).stat_sal_val_all,p_stat_sal_val_all);
2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check

2302: g_summary_rec(j).bdgt_iss_val_direct :=ben_cwb_utils.add_number_with_null_check
2303: (g_summary_rec(j).bdgt_iss_val_direct,p_bdgt_iss_val_direct);
2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2305: (g_summary_rec(j).stat_sal_val_direct,p_stat_sal_val_direct);
2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
2307: (g_summary_rec(j).stat_sal_val_all,p_stat_sal_val_all);
2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2309: (g_summary_rec(j).oth_comp_val_direct,p_oth_comp_val_direct);
2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

2304: g_summary_rec(j).stat_sal_val_direct :=ben_cwb_utils.add_number_with_null_check
2305: (g_summary_rec(j).stat_sal_val_direct,p_stat_sal_val_direct);
2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
2307: (g_summary_rec(j).stat_sal_val_all,p_stat_sal_val_all);
2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2309: (g_summary_rec(j).oth_comp_val_direct,p_oth_comp_val_direct);
2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2311: (g_summary_rec(j).oth_comp_val_all,p_oth_comp_val_all);
2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check

2306: g_summary_rec(j).stat_sal_val_all :=ben_cwb_utils.add_number_with_null_check
2307: (g_summary_rec(j).stat_sal_val_all,p_stat_sal_val_all);
2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2309: (g_summary_rec(j).oth_comp_val_direct,p_oth_comp_val_direct);
2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2311: (g_summary_rec(j).oth_comp_val_all,p_oth_comp_val_all);
2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2313: (g_summary_rec(j).tot_comp_val_direct,p_tot_comp_val_direct);
2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check

2308: g_summary_rec(j).oth_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2309: (g_summary_rec(j).oth_comp_val_direct,p_oth_comp_val_direct);
2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2311: (g_summary_rec(j).oth_comp_val_all,p_oth_comp_val_all);
2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2313: (g_summary_rec(j).tot_comp_val_direct,p_tot_comp_val_direct);
2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2315: (g_summary_rec(j).tot_comp_val_all,p_tot_comp_val_all);
2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check

2310: g_summary_rec(j).oth_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2311: (g_summary_rec(j).oth_comp_val_all,p_oth_comp_val_all);
2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2313: (g_summary_rec(j).tot_comp_val_direct,p_tot_comp_val_direct);
2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2315: (g_summary_rec(j).tot_comp_val_all,p_tot_comp_val_all);
2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check
2317: (g_summary_rec(j).rec_val_direct,p_rec_val_direct);
2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check

2312: g_summary_rec(j).tot_comp_val_direct :=ben_cwb_utils.add_number_with_null_check
2313: (g_summary_rec(j).tot_comp_val_direct,p_tot_comp_val_direct);
2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2315: (g_summary_rec(j).tot_comp_val_all,p_tot_comp_val_all);
2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check
2317: (g_summary_rec(j).rec_val_direct,p_rec_val_direct);
2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check
2319: (g_summary_rec(j).rec_val_all,p_rec_val_all);
2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check

2314: g_summary_rec(j).tot_comp_val_all :=ben_cwb_utils.add_number_with_null_check
2315: (g_summary_rec(j).tot_comp_val_all,p_tot_comp_val_all);
2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check
2317: (g_summary_rec(j).rec_val_direct,p_rec_val_direct);
2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check
2319: (g_summary_rec(j).rec_val_all,p_rec_val_all);
2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
2321: (g_summary_rec(j).rec_mn_val_direct,p_rec_mn_val_direct);
2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check

2316: g_summary_rec(j).rec_val_direct :=ben_cwb_utils.add_number_with_null_check
2317: (g_summary_rec(j).rec_val_direct,p_rec_val_direct);
2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check
2319: (g_summary_rec(j).rec_val_all,p_rec_val_all);
2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
2321: (g_summary_rec(j).rec_mn_val_direct,p_rec_mn_val_direct);
2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
2323: (g_summary_rec(j).rec_mn_val_all,p_rec_mn_val_all);
2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check

2318: g_summary_rec(j).rec_val_all :=ben_cwb_utils.add_number_with_null_check
2319: (g_summary_rec(j).rec_val_all,p_rec_val_all);
2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
2321: (g_summary_rec(j).rec_mn_val_direct,p_rec_mn_val_direct);
2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
2323: (g_summary_rec(j).rec_mn_val_all,p_rec_mn_val_all);
2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
2325: (g_summary_rec(j).rec_mx_val_direct,p_rec_mx_val_direct);
2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check

2320: g_summary_rec(j).rec_mn_val_direct :=ben_cwb_utils.add_number_with_null_check
2321: (g_summary_rec(j).rec_mn_val_direct,p_rec_mn_val_direct);
2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
2323: (g_summary_rec(j).rec_mn_val_all,p_rec_mn_val_all);
2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
2325: (g_summary_rec(j).rec_mx_val_direct,p_rec_mx_val_direct);
2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
2327: (g_summary_rec(j).rec_mx_val_all,p_rec_mx_val_all);
2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check

2322: g_summary_rec(j).rec_mn_val_all :=ben_cwb_utils.add_number_with_null_check
2323: (g_summary_rec(j).rec_mn_val_all,p_rec_mn_val_all);
2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
2325: (g_summary_rec(j).rec_mx_val_direct,p_rec_mx_val_direct);
2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
2327: (g_summary_rec(j).rec_mx_val_all,p_rec_mx_val_all);
2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
2329: (g_summary_rec(j).misc1_val_direct,p_misc1_val_direct);
2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check

2324: g_summary_rec(j).rec_mx_val_direct :=ben_cwb_utils.add_number_with_null_check
2325: (g_summary_rec(j).rec_mx_val_direct,p_rec_mx_val_direct);
2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
2327: (g_summary_rec(j).rec_mx_val_all,p_rec_mx_val_all);
2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
2329: (g_summary_rec(j).misc1_val_direct,p_misc1_val_direct);
2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check
2331: (g_summary_rec(j).misc1_val_all,p_misc1_val_all);
2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check

2326: g_summary_rec(j).rec_mx_val_all :=ben_cwb_utils.add_number_with_null_check
2327: (g_summary_rec(j).rec_mx_val_all,p_rec_mx_val_all);
2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
2329: (g_summary_rec(j).misc1_val_direct,p_misc1_val_direct);
2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check
2331: (g_summary_rec(j).misc1_val_all,p_misc1_val_all);
2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
2333: (g_summary_rec(j).misc2_val_direct,p_misc2_val_direct);
2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check

2328: g_summary_rec(j).misc1_val_direct :=ben_cwb_utils.add_number_with_null_check
2329: (g_summary_rec(j).misc1_val_direct,p_misc1_val_direct);
2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check
2331: (g_summary_rec(j).misc1_val_all,p_misc1_val_all);
2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
2333: (g_summary_rec(j).misc2_val_direct,p_misc2_val_direct);
2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check
2335: (g_summary_rec(j).misc2_val_all,p_misc2_val_all);
2336: g_summary_rec(j).misc3_val_direct :=ben_cwb_utils.add_number_with_null_check

Line 2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check

2330: g_summary_rec(j).misc1_val_all :=ben_cwb_utils.add_number_with_null_check
2331: (g_summary_rec(j).misc1_val_all,p_misc1_val_all);
2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
2333: (g_summary_rec(j).misc2_val_direct,p_misc2_val_direct);
2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check
2335: (g_summary_rec(j).misc2_val_all,p_misc2_val_all);
2336: g_summary_rec(j).misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
2337: (g_summary_rec(j).misc3_val_direct,p_misc3_val_direct);
2338: g_summary_rec(j).misc3_val_all :=ben_cwb_utils.add_number_with_null_check

Line 2336: g_summary_rec(j).misc3_val_direct :=ben_cwb_utils.add_number_with_null_check

2332: g_summary_rec(j).misc2_val_direct :=ben_cwb_utils.add_number_with_null_check
2333: (g_summary_rec(j).misc2_val_direct,p_misc2_val_direct);
2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check
2335: (g_summary_rec(j).misc2_val_all,p_misc2_val_all);
2336: g_summary_rec(j).misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
2337: (g_summary_rec(j).misc3_val_direct,p_misc3_val_direct);
2338: g_summary_rec(j).misc3_val_all :=ben_cwb_utils.add_number_with_null_check
2339: (g_summary_rec(j).misc3_val_all,p_misc3_val_all);
2340: g_summary_rec(j).person_id:=nvl(p_person_id,g_summary_rec(j).person_id);

Line 2338: g_summary_rec(j).misc3_val_all :=ben_cwb_utils.add_number_with_null_check

2334: g_summary_rec(j).misc2_val_all :=ben_cwb_utils.add_number_with_null_check
2335: (g_summary_rec(j).misc2_val_all,p_misc2_val_all);
2336: g_summary_rec(j).misc3_val_direct :=ben_cwb_utils.add_number_with_null_check
2337: (g_summary_rec(j).misc3_val_direct,p_misc3_val_direct);
2338: g_summary_rec(j).misc3_val_all :=ben_cwb_utils.add_number_with_null_check
2339: (g_summary_rec(j).misc3_val_all,p_misc3_val_all);
2340: g_summary_rec(j).person_id:=nvl(p_person_id,g_summary_rec(j).person_id);
2341: g_summary_rec(j).lf_evt_ocrd_dt:=nvl(p_lf_evt_ocrd_dt,g_summary_rec(j).lf_evt_ocrd_dt);
2342: else

Line 2845: ,p_elig_sal_val_all => - ben_cwb_utils.add_number_with_null_check

2841: -(nvl(l_emp_recv_count_tab(i),0) +
2842: nvl(l_emp_recv_count_all_tab(i),0))
2843: ,p_elig_sal_val_direct => -(l_elig_sal_val_tab(i)) *
2844: l_immd_mgr
2845: ,p_elig_sal_val_all => - ben_cwb_utils.add_number_with_null_check
2846: (l_elig_sal_val_tab(i),
2847: l_elig_sal_val_all_tab(i))
2848: ,p_ws_val_direct =>-(l_ws_val_tab(i)) * l_immd_mgr
2849: ,p_ws_val_all => - ben_cwb_utils.add_number_with_null_check

Line 2849: ,p_ws_val_all => - ben_cwb_utils.add_number_with_null_check

2845: ,p_elig_sal_val_all => - ben_cwb_utils.add_number_with_null_check
2846: (l_elig_sal_val_tab(i),
2847: l_elig_sal_val_all_tab(i))
2848: ,p_ws_val_direct =>-(l_ws_val_tab(i)) * l_immd_mgr
2849: ,p_ws_val_all => - ben_cwb_utils.add_number_with_null_check
2850: (l_ws_val_tab(i),
2851: l_ws_val_all_tab(i))
2852: ,p_stat_sal_val_direct => -(l_stat_sal_val_tab(i)) *
2853: l_immd_mgr

Line 2854: ,p_stat_sal_val_all => - ben_cwb_utils.add_number_with_null_check

2850: (l_ws_val_tab(i),
2851: l_ws_val_all_tab(i))
2852: ,p_stat_sal_val_direct => -(l_stat_sal_val_tab(i)) *
2853: l_immd_mgr
2854: ,p_stat_sal_val_all => - ben_cwb_utils.add_number_with_null_check
2855: (l_stat_sal_val_tab(i),
2856: l_stat_sal_val_all_tab(i))
2857: ,p_oth_comp_val_direct => -(l_oth_comp_val_tab(i)) *
2858: l_immd_mgr

Line 2859: ,p_oth_comp_val_all => - ben_cwb_utils.add_number_with_null_check

2855: (l_stat_sal_val_tab(i),
2856: l_stat_sal_val_all_tab(i))
2857: ,p_oth_comp_val_direct => -(l_oth_comp_val_tab(i)) *
2858: l_immd_mgr
2859: ,p_oth_comp_val_all => - ben_cwb_utils.add_number_with_null_check
2860: (l_oth_comp_val_tab(i),
2861: l_oth_comp_val_all_tab(i))
2862: ,p_tot_comp_val_direct => -(l_tot_comp_val_tab(i)) *
2863: l_immd_mgr

Line 2864: ,p_tot_comp_val_all => - ben_cwb_utils.add_number_with_null_check

2860: (l_oth_comp_val_tab(i),
2861: l_oth_comp_val_all_tab(i))
2862: ,p_tot_comp_val_direct => -(l_tot_comp_val_tab(i)) *
2863: l_immd_mgr
2864: ,p_tot_comp_val_all => - ben_cwb_utils.add_number_with_null_check
2865: (l_tot_comp_val_tab(i),
2866: l_tot_comp_val_all_tab(i))
2867: ,p_rec_val_direct => -(l_rec_val_tab(i)) *
2868: l_immd_mgr

Line 2869: ,p_rec_val_all => - ben_cwb_utils.add_number_with_null_check

2865: (l_tot_comp_val_tab(i),
2866: l_tot_comp_val_all_tab(i))
2867: ,p_rec_val_direct => -(l_rec_val_tab(i)) *
2868: l_immd_mgr
2869: ,p_rec_val_all => - ben_cwb_utils.add_number_with_null_check
2870: (l_rec_val_tab(i),
2871: l_rec_val_all_tab(i))
2872: ,p_rec_mn_val_direct => -(l_rec_mn_val_tab(i)) *
2873: l_immd_mgr

Line 2874: ,p_rec_mn_val_all => - ben_cwb_utils.add_number_with_null_check

2870: (l_rec_val_tab(i),
2871: l_rec_val_all_tab(i))
2872: ,p_rec_mn_val_direct => -(l_rec_mn_val_tab(i)) *
2873: l_immd_mgr
2874: ,p_rec_mn_val_all => - ben_cwb_utils.add_number_with_null_check
2875: (l_rec_mn_val_tab(i),
2876: l_rec_mn_val_all_tab(i))
2877: ,p_rec_mx_val_direct => -(l_rec_mx_val_tab(i)) *
2878: l_immd_mgr

Line 2879: ,p_rec_mx_val_all => - ben_cwb_utils.add_number_with_null_check

2875: (l_rec_mn_val_tab(i),
2876: l_rec_mn_val_all_tab(i))
2877: ,p_rec_mx_val_direct => -(l_rec_mx_val_tab(i)) *
2878: l_immd_mgr
2879: ,p_rec_mx_val_all => - ben_cwb_utils.add_number_with_null_check
2880: (l_rec_mx_val_tab(i),
2881: l_rec_mx_val_all_tab(i))
2882: ,p_misc1_val_direct => -(l_misc1_val_tab(i)) *
2883: l_immd_mgr

Line 2884: ,p_misc1_val_all => - ben_cwb_utils.add_number_with_null_check

2880: (l_rec_mx_val_tab(i),
2881: l_rec_mx_val_all_tab(i))
2882: ,p_misc1_val_direct => -(l_misc1_val_tab(i)) *
2883: l_immd_mgr
2884: ,p_misc1_val_all => - ben_cwb_utils.add_number_with_null_check
2885: (l_misc1_val_tab(i),
2886: l_misc1_val_all_tab(i))
2887: ,p_misc2_val_direct => -(l_misc2_val_tab(i)) *
2888: l_immd_mgr

Line 2889: ,p_misc2_val_all => - ben_cwb_utils.add_number_with_null_check

2885: (l_misc1_val_tab(i),
2886: l_misc1_val_all_tab(i))
2887: ,p_misc2_val_direct => -(l_misc2_val_tab(i)) *
2888: l_immd_mgr
2889: ,p_misc2_val_all => - ben_cwb_utils.add_number_with_null_check
2890: (l_misc2_val_tab(i),
2891: l_misc2_val_all_tab(i))
2892: ,p_misc3_val_direct => -(l_misc3_val_all_tab(i)) *
2893: l_immd_mgr

Line 2894: ,p_misc3_val_all => - ben_cwb_utils.add_number_with_null_check

2890: (l_misc2_val_tab(i),
2891: l_misc2_val_all_tab(i))
2892: ,p_misc3_val_direct => -(l_misc3_val_all_tab(i)) *
2893: l_immd_mgr
2894: ,p_misc3_val_all => - ben_cwb_utils.add_number_with_null_check
2895: (l_misc3_val_tab(i),
2896: l_misc3_val_all_tab(i))
2897: );
2898: end loop;

Line 2938: ,p_elig_sal_val_all => ben_cwb_utils.add_number_with_null_check

2934: (nvl(l_emp_recv_count_tab(i),0) +
2935: nvl(l_emp_recv_count_all_tab(i),0))
2936: ,p_elig_sal_val_direct => (l_elig_sal_val_tab(i)) *
2937: l_immd_mgr
2938: ,p_elig_sal_val_all => ben_cwb_utils.add_number_with_null_check
2939: (l_elig_sal_val_tab(i),
2940: l_elig_sal_val_all_tab(i))
2941: ,p_ws_val_direct =>(l_ws_val_tab(i)) * l_immd_mgr
2942: ,p_ws_val_all => ben_cwb_utils.add_number_with_null_check

Line 2942: ,p_ws_val_all => ben_cwb_utils.add_number_with_null_check

2938: ,p_elig_sal_val_all => ben_cwb_utils.add_number_with_null_check
2939: (l_elig_sal_val_tab(i),
2940: l_elig_sal_val_all_tab(i))
2941: ,p_ws_val_direct =>(l_ws_val_tab(i)) * l_immd_mgr
2942: ,p_ws_val_all => ben_cwb_utils.add_number_with_null_check
2943: (l_ws_val_tab(i),
2944: l_ws_val_all_tab(i))
2945: ,p_stat_sal_val_direct => (l_stat_sal_val_tab(i)) *
2946: l_immd_mgr

Line 2947: ,p_stat_sal_val_all => ben_cwb_utils.add_number_with_null_check

2943: (l_ws_val_tab(i),
2944: l_ws_val_all_tab(i))
2945: ,p_stat_sal_val_direct => (l_stat_sal_val_tab(i)) *
2946: l_immd_mgr
2947: ,p_stat_sal_val_all => ben_cwb_utils.add_number_with_null_check
2948: (l_stat_sal_val_tab(i),
2949: l_stat_sal_val_all_tab(i))
2950: ,p_oth_comp_val_direct => (l_oth_comp_val_tab(i)) *
2951: l_immd_mgr

Line 2952: ,p_oth_comp_val_all => ben_cwb_utils.add_number_with_null_check

2948: (l_stat_sal_val_tab(i),
2949: l_stat_sal_val_all_tab(i))
2950: ,p_oth_comp_val_direct => (l_oth_comp_val_tab(i)) *
2951: l_immd_mgr
2952: ,p_oth_comp_val_all => ben_cwb_utils.add_number_with_null_check
2953: (l_oth_comp_val_tab(i),
2954: l_oth_comp_val_all_tab(i))
2955: ,p_tot_comp_val_direct => (l_tot_comp_val_tab(i)) *
2956: l_immd_mgr

Line 2957: ,p_tot_comp_val_all => ben_cwb_utils.add_number_with_null_check

2953: (l_oth_comp_val_tab(i),
2954: l_oth_comp_val_all_tab(i))
2955: ,p_tot_comp_val_direct => (l_tot_comp_val_tab(i)) *
2956: l_immd_mgr
2957: ,p_tot_comp_val_all => ben_cwb_utils.add_number_with_null_check
2958: (l_tot_comp_val_tab(i),
2959: l_tot_comp_val_all_tab(i))
2960: ,p_rec_val_direct => (l_rec_val_tab(i)) *
2961: l_immd_mgr

Line 2962: ,p_rec_val_all => ben_cwb_utils.add_number_with_null_check

2958: (l_tot_comp_val_tab(i),
2959: l_tot_comp_val_all_tab(i))
2960: ,p_rec_val_direct => (l_rec_val_tab(i)) *
2961: l_immd_mgr
2962: ,p_rec_val_all => ben_cwb_utils.add_number_with_null_check
2963: (l_rec_val_tab(i),
2964: l_rec_val_all_tab(i))
2965: ,p_rec_mn_val_direct => (l_rec_mn_val_tab(i)) *
2966: l_immd_mgr

Line 2967: ,p_rec_mn_val_all => ben_cwb_utils.add_number_with_null_check

2963: (l_rec_val_tab(i),
2964: l_rec_val_all_tab(i))
2965: ,p_rec_mn_val_direct => (l_rec_mn_val_tab(i)) *
2966: l_immd_mgr
2967: ,p_rec_mn_val_all => ben_cwb_utils.add_number_with_null_check
2968: (l_rec_mn_val_tab(i),
2969: l_rec_mn_val_all_tab(i))
2970: ,p_rec_mx_val_direct => (l_rec_mx_val_tab(i)) *
2971: l_immd_mgr

Line 2972: ,p_rec_mx_val_all => ben_cwb_utils.add_number_with_null_check

2968: (l_rec_mn_val_tab(i),
2969: l_rec_mn_val_all_tab(i))
2970: ,p_rec_mx_val_direct => (l_rec_mx_val_tab(i)) *
2971: l_immd_mgr
2972: ,p_rec_mx_val_all => ben_cwb_utils.add_number_with_null_check
2973: (l_rec_mx_val_tab(i),
2974: l_rec_mx_val_all_tab(i))
2975: ,p_misc1_val_direct => (l_misc1_val_tab(i)) *
2976: l_immd_mgr

Line 2977: ,p_misc1_val_all => ben_cwb_utils.add_number_with_null_check

2973: (l_rec_mx_val_tab(i),
2974: l_rec_mx_val_all_tab(i))
2975: ,p_misc1_val_direct => (l_misc1_val_tab(i)) *
2976: l_immd_mgr
2977: ,p_misc1_val_all => ben_cwb_utils.add_number_with_null_check
2978: (l_misc1_val_tab(i),
2979: l_misc1_val_all_tab(i))
2980: ,p_misc2_val_direct => (l_misc2_val_tab(i)) *
2981: l_immd_mgr

Line 2982: ,p_misc2_val_all => ben_cwb_utils.add_number_with_null_check

2978: (l_misc1_val_tab(i),
2979: l_misc1_val_all_tab(i))
2980: ,p_misc2_val_direct => (l_misc2_val_tab(i)) *
2981: l_immd_mgr
2982: ,p_misc2_val_all => ben_cwb_utils.add_number_with_null_check
2983: (l_misc2_val_tab(i),
2984: l_misc2_val_all_tab(i))
2985: ,p_misc3_val_direct => (l_misc3_val_all_tab(i)) *
2986: l_immd_mgr

Line 2987: ,p_misc3_val_all => ben_cwb_utils.add_number_with_null_check

2983: (l_misc2_val_tab(i),
2984: l_misc2_val_all_tab(i))
2985: ,p_misc3_val_direct => (l_misc3_val_all_tab(i)) *
2986: l_immd_mgr
2987: ,p_misc3_val_all => ben_cwb_utils.add_number_with_null_check
2988: (l_misc3_val_tab(i),
2989: l_misc3_val_all_tab(i))
2990: );
2991: end loop;