APPS.BEN_CWB_PERSON_RATES_API dependencies on BEN_CWB_SUMMARY_PKG

Line 523: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(

519: l_rec_mx_val_d := p_rates_new.rec_mx_val / l_new_xchg_rt.rec_xchg_rt;
520: --
521: -- update the bdgt summary,
522: if l_new_xchg_rt.uses_bdgt_flag = 'Y' and l_elig_sal_val_d <> 0 then
523: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(
524: p_group_per_in_ler_id => p_rates_new.group_per_in_ler_id
525: ,p_elig_sal_change => l_elig_sal_val_d);
526: end if;
527: else

Line 555: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(

551: l_rec_mx_val_d := -(p_rates_old.rec_mx_val) / l_old_xchg_rt.rec_xchg_rt;
552: --
553: -- update the bdgt summary
554: if l_new_xchg_rt.uses_bdgt_flag = 'Y' and l_elig_sal_val_d <> 0 then
555: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(
556: p_group_per_in_ler_id => p_rates_new.group_per_in_ler_id
557: ,p_elig_sal_change => l_elig_sal_val_d);
558: end if;
559: end if; -- of elig_flg = 'Y'

Line 616: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(

612: -p_rates_old.rec_mx_val/l_old_xchg_rt.rec_xchg_rt);
613: --
614: -- update the bdgt summary,
615: if l_new_xchg_rt.uses_bdgt_flag = 'Y' and l_elig_sal_val_d <> 0 then
616: ben_cwb_summary_pkg.upd_summary_on_elig_sal_change(
617: p_group_per_in_ler_id => p_rates_new.group_per_in_ler_id
618: ,p_elig_sal_change => l_elig_sal_val_d);
619: end if;
620: end if; -- of check comare elig flags.

Line 639: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab

635: --There is a change in the record
636: l_immd_mgr := 1;
637: for mgr in csr_mgr_pil_ids(p_rates_new.group_per_in_ler_id)
638: loop
639: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
640: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
641: ,p_group_pl_id => p_rates_old.group_pl_id
642: ,p_group_oipl_id => p_rates_old.group_oipl_id
643: ,p_elig_count_direct => l_elig_count_d * l_immd_mgr

Line 679: ben_cwb_summary_pkg.save_pl_sql_tab;

675: -- manager's manager is stil a HLM (when made ineligible) or is now
676: -- a HLM (when made eligible).
677: --
678: if l_new_xchg_rt.uses_bdgt_flag = 'Y' and l_elig_count_d <> 0 then
679: ben_cwb_summary_pkg.save_pl_sql_tab;
680: ben_cwb_summary_pkg.clean_budget_data(
681: p_per_in_ler_id => p_rates_new.group_per_in_ler_id
682: ,p_lvl_up => 2);
683: ben_cwb_summary_pkg.save_pl_sql_tab;

Line 680: ben_cwb_summary_pkg.clean_budget_data(

676: -- a HLM (when made eligible).
677: --
678: if l_new_xchg_rt.uses_bdgt_flag = 'Y' and l_elig_count_d <> 0 then
679: ben_cwb_summary_pkg.save_pl_sql_tab;
680: ben_cwb_summary_pkg.clean_budget_data(
681: p_per_in_ler_id => p_rates_new.group_per_in_ler_id
682: ,p_lvl_up => 2);
683: ben_cwb_summary_pkg.save_pl_sql_tab;
684: end if;

Line 683: ben_cwb_summary_pkg.save_pl_sql_tab;

679: ben_cwb_summary_pkg.save_pl_sql_tab;
680: ben_cwb_summary_pkg.clean_budget_data(
681: p_per_in_ler_id => p_rates_new.group_per_in_ler_id
682: ,p_lvl_up => 2);
683: ben_cwb_summary_pkg.save_pl_sql_tab;
684: end if;
685: --
686: if g_debug then
687: hr_utility.set_location(' Leaving:'|| l_proc, 99);