APPS.BEN_CWB_PERSON_RATES_API dependencies on BEN_CWB_UTILS

Line 580: l_ws_val_d := ben_cwb_utils.add_number_with_null_check

576: if (nvl(p_rates_new.ws_val,0) = 0 and nvl(p_rates_old.ws_val,0)<>0) then
577: -- The employee WS value is cleared. So reduce the emp_recv_count
578: l_emp_recv_count_d := -1;
579: end if;
580: l_ws_val_d := ben_cwb_utils.add_number_with_null_check
581: (p_rates_new.ws_val/l_new_xchg_rt.ws_xchg_rt,
582: -p_rates_old.ws_val/l_old_xchg_rt.ws_xchg_rt);
583: l_elig_sal_val_d := ben_cwb_utils.add_number_with_null_check
584: (p_rates_new.elig_sal_val/l_new_xchg_rt.elig_sal_xchg_rt,

Line 583: l_elig_sal_val_d := ben_cwb_utils.add_number_with_null_check

579: end if;
580: l_ws_val_d := ben_cwb_utils.add_number_with_null_check
581: (p_rates_new.ws_val/l_new_xchg_rt.ws_xchg_rt,
582: -p_rates_old.ws_val/l_old_xchg_rt.ws_xchg_rt);
583: l_elig_sal_val_d := ben_cwb_utils.add_number_with_null_check
584: (p_rates_new.elig_sal_val/l_new_xchg_rt.elig_sal_xchg_rt,
585: -p_rates_old.elig_sal_val/l_old_xchg_rt.elig_sal_xchg_rt);
586: l_stat_sal_val_d := ben_cwb_utils.add_number_with_null_check
587: (p_rates_new.stat_sal_val/l_new_xchg_rt.stat_sal_xchg_rt,

Line 586: l_stat_sal_val_d := ben_cwb_utils.add_number_with_null_check

582: -p_rates_old.ws_val/l_old_xchg_rt.ws_xchg_rt);
583: l_elig_sal_val_d := ben_cwb_utils.add_number_with_null_check
584: (p_rates_new.elig_sal_val/l_new_xchg_rt.elig_sal_xchg_rt,
585: -p_rates_old.elig_sal_val/l_old_xchg_rt.elig_sal_xchg_rt);
586: l_stat_sal_val_d := ben_cwb_utils.add_number_with_null_check
587: (p_rates_new.stat_sal_val/l_new_xchg_rt.stat_sal_xchg_rt,
588: -p_rates_old.stat_sal_val/l_old_xchg_rt.stat_sal_xchg_rt);
589: l_oth_comp_val_d := ben_cwb_utils.add_number_with_null_check
590: (p_rates_new.oth_comp_val/l_new_xchg_rt.oth_comp_xchg_rt,

Line 589: l_oth_comp_val_d := ben_cwb_utils.add_number_with_null_check

585: -p_rates_old.elig_sal_val/l_old_xchg_rt.elig_sal_xchg_rt);
586: l_stat_sal_val_d := ben_cwb_utils.add_number_with_null_check
587: (p_rates_new.stat_sal_val/l_new_xchg_rt.stat_sal_xchg_rt,
588: -p_rates_old.stat_sal_val/l_old_xchg_rt.stat_sal_xchg_rt);
589: l_oth_comp_val_d := ben_cwb_utils.add_number_with_null_check
590: (p_rates_new.oth_comp_val/l_new_xchg_rt.oth_comp_xchg_rt,
591: -p_rates_old.oth_comp_val/l_old_xchg_rt.oth_comp_xchg_rt);
592: l_tot_comp_val_d := ben_cwb_utils.add_number_with_null_check
593: (p_rates_new.tot_comp_val/l_new_xchg_rt.tot_comp_xchg_rt,

Line 592: l_tot_comp_val_d := ben_cwb_utils.add_number_with_null_check

588: -p_rates_old.stat_sal_val/l_old_xchg_rt.stat_sal_xchg_rt);
589: l_oth_comp_val_d := ben_cwb_utils.add_number_with_null_check
590: (p_rates_new.oth_comp_val/l_new_xchg_rt.oth_comp_xchg_rt,
591: -p_rates_old.oth_comp_val/l_old_xchg_rt.oth_comp_xchg_rt);
592: l_tot_comp_val_d := ben_cwb_utils.add_number_with_null_check
593: (p_rates_new.tot_comp_val/l_new_xchg_rt.tot_comp_xchg_rt,
594: -p_rates_old.tot_comp_val/l_old_xchg_rt.tot_comp_xchg_rt);
595: l_misc1_val_d := ben_cwb_utils.add_number_with_null_check
596: (p_rates_new.misc1_val/l_new_xchg_rt.misc1_xchg_rt,

Line 595: l_misc1_val_d := ben_cwb_utils.add_number_with_null_check

591: -p_rates_old.oth_comp_val/l_old_xchg_rt.oth_comp_xchg_rt);
592: l_tot_comp_val_d := ben_cwb_utils.add_number_with_null_check
593: (p_rates_new.tot_comp_val/l_new_xchg_rt.tot_comp_xchg_rt,
594: -p_rates_old.tot_comp_val/l_old_xchg_rt.tot_comp_xchg_rt);
595: l_misc1_val_d := ben_cwb_utils.add_number_with_null_check
596: (p_rates_new.misc1_val/l_new_xchg_rt.misc1_xchg_rt,
597: -p_rates_old.misc1_val/l_old_xchg_rt.misc1_xchg_rt);
598: l_misc2_val_d := ben_cwb_utils.add_number_with_null_check
599: (p_rates_new.misc2_val/l_new_xchg_rt.misc2_xchg_rt,

Line 598: l_misc2_val_d := ben_cwb_utils.add_number_with_null_check

594: -p_rates_old.tot_comp_val/l_old_xchg_rt.tot_comp_xchg_rt);
595: l_misc1_val_d := ben_cwb_utils.add_number_with_null_check
596: (p_rates_new.misc1_val/l_new_xchg_rt.misc1_xchg_rt,
597: -p_rates_old.misc1_val/l_old_xchg_rt.misc1_xchg_rt);
598: l_misc2_val_d := ben_cwb_utils.add_number_with_null_check
599: (p_rates_new.misc2_val/l_new_xchg_rt.misc2_xchg_rt,
600: -p_rates_old.misc2_val/l_old_xchg_rt.misc2_xchg_rt);
601: l_misc3_val_d := ben_cwb_utils.add_number_with_null_check
602: (p_rates_new.misc3_val/l_new_xchg_rt.misc3_xchg_rt,

Line 601: l_misc3_val_d := ben_cwb_utils.add_number_with_null_check

597: -p_rates_old.misc1_val/l_old_xchg_rt.misc1_xchg_rt);
598: l_misc2_val_d := ben_cwb_utils.add_number_with_null_check
599: (p_rates_new.misc2_val/l_new_xchg_rt.misc2_xchg_rt,
600: -p_rates_old.misc2_val/l_old_xchg_rt.misc2_xchg_rt);
601: l_misc3_val_d := ben_cwb_utils.add_number_with_null_check
602: (p_rates_new.misc3_val/l_new_xchg_rt.misc3_xchg_rt,
603: -p_rates_old.misc3_val/l_old_xchg_rt.misc3_xchg_rt);
604: l_rec_val_d := ben_cwb_utils.add_number_with_null_check
605: (p_rates_new.rec_val/l_new_xchg_rt.rec_xchg_rt,

Line 604: l_rec_val_d := ben_cwb_utils.add_number_with_null_check

600: -p_rates_old.misc2_val/l_old_xchg_rt.misc2_xchg_rt);
601: l_misc3_val_d := ben_cwb_utils.add_number_with_null_check
602: (p_rates_new.misc3_val/l_new_xchg_rt.misc3_xchg_rt,
603: -p_rates_old.misc3_val/l_old_xchg_rt.misc3_xchg_rt);
604: l_rec_val_d := ben_cwb_utils.add_number_with_null_check
605: (p_rates_new.rec_val/l_new_xchg_rt.rec_xchg_rt,
606: -p_rates_old.rec_val/l_old_xchg_rt.rec_xchg_rt);
607: l_rec_mn_val_d := ben_cwb_utils.add_number_with_null_check
608: (p_rates_new.rec_mn_val/l_new_xchg_rt.rec_xchg_rt,

Line 607: l_rec_mn_val_d := ben_cwb_utils.add_number_with_null_check

603: -p_rates_old.misc3_val/l_old_xchg_rt.misc3_xchg_rt);
604: l_rec_val_d := ben_cwb_utils.add_number_with_null_check
605: (p_rates_new.rec_val/l_new_xchg_rt.rec_xchg_rt,
606: -p_rates_old.rec_val/l_old_xchg_rt.rec_xchg_rt);
607: l_rec_mn_val_d := ben_cwb_utils.add_number_with_null_check
608: (p_rates_new.rec_mn_val/l_new_xchg_rt.rec_xchg_rt,
609: -p_rates_old.rec_mn_val/l_old_xchg_rt.rec_xchg_rt);
610: l_rec_mx_val_d := ben_cwb_utils.add_number_with_null_check
611: (p_rates_new.rec_mx_val/l_new_xchg_rt.rec_xchg_rt,

Line 610: l_rec_mx_val_d := ben_cwb_utils.add_number_with_null_check

606: -p_rates_old.rec_val/l_old_xchg_rt.rec_xchg_rt);
607: l_rec_mn_val_d := ben_cwb_utils.add_number_with_null_check
608: (p_rates_new.rec_mn_val/l_new_xchg_rt.rec_xchg_rt,
609: -p_rates_old.rec_mn_val/l_old_xchg_rt.rec_xchg_rt);
610: l_rec_mx_val_d := ben_cwb_utils.add_number_with_null_check
611: (p_rates_new.rec_mx_val/l_new_xchg_rt.rec_xchg_rt,
612: -p_rates_old.rec_mx_val/l_old_xchg_rt.rec_xchg_rt);
613: --
614: -- update the bdgt summary,