783: if g_debug then
784: hr_utility.set_location('Entering:'|| l_proc, 10);
785: end if;
786: --
787: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
788: 'update_person_info';
789: ben_manage_cwb_life_events.g_error_log_rec.step_number := 77;
790: --
791: -- Set the person id in ben_cwb_person_info to correct values from -1.
785: end if;
786: --
787: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
788: 'update_person_info';
789: ben_manage_cwb_life_events.g_error_log_rec.step_number := 77;
790: --
791: -- Set the person id in ben_cwb_person_info to correct values from -1.
792: open csr_person_ids;
793: fetch csr_person_ids bulk collect into l_group_per_in_ler_id_tab
803:
804: --
805: -- Run Dynamic Calculations.
806: --
807: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
808: 'run_dynamic_calc';
809: ben_manage_cwb_life_events.g_error_log_rec.step_number := 78;
810: --
811: for i in l_group_per_in_ler_id_tab.first..
805: -- Run Dynamic Calculations.
806: --
807: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
808: 'run_dynamic_calc';
809: ben_manage_cwb_life_events.g_error_log_rec.step_number := 78;
810: --
811: for i in l_group_per_in_ler_id_tab.first..
812: l_group_per_in_ler_id_tab.last loop
813: ben_cwb_dyn_calc_pkg.run_dynamic_calculations(
1379: if g_debug then
1380: hr_utility.set_location('Entering:'|| l_proc, 10);
1381: end if;
1382: --
1383: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1384: 'refresh_summary_group_pl';
1385: ben_manage_cwb_life_events.g_error_log_rec.step_number := 711;
1386: --
1387: check_refresh_jobs(p_group_pl_id => p_group_pl_id
1381: end if;
1382: --
1383: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1384: 'refresh_summary_group_pl';
1385: ben_manage_cwb_life_events.g_error_log_rec.step_number := 711;
1386: --
1387: check_refresh_jobs(p_group_pl_id => p_group_pl_id
1388: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt);
1389: --
1973: if g_debug then
1974: hr_utility.set_location(l_proc, 15);
1975: end if;
1976: -- call the refresh_summary_group_pl to improve performance
1977: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1978: 'refresh_summary_group_pl';
1979: ben_manage_cwb_life_events.g_error_log_rec.step_number := 71;
1980: --
1981: refresh_summary_group_pl(p_group_pl_id, p_lf_evt_ocrd_dt);
1975: end if;
1976: -- call the refresh_summary_group_pl to improve performance
1977: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1978: 'refresh_summary_group_pl';
1979: ben_manage_cwb_life_events.g_error_log_rec.step_number := 71;
1980: --
1981: refresh_summary_group_pl(p_group_pl_id, p_lf_evt_ocrd_dt);
1982: --
1983: return;
1987: if g_debug then
1988: hr_utility.set_location(l_proc, 20);
1989: end if;
1990: --
1991: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1992: 'refresh_summary_persons';
1993: ben_manage_cwb_life_events.g_error_log_rec.step_number := 72;
1994: --
1995: -- Insert an empty summary row for each managers. This summary row
1989: end if;
1990: --
1991: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
1992: 'refresh_summary_persons';
1993: ben_manage_cwb_life_events.g_error_log_rec.step_number := 72;
1994: --
1995: -- Insert an empty summary row for each managers. This summary row
1996: -- will contain only the group_per_in_ler_id, group_pl_id, group_oipl_id,
1997: -- person_id and lf_evt_ocrd_dt