1627: (p_group_pl_id => p_group_pl_id
1628: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1629: --
1630: hr_utility.set_location('Refreshing Summary ',20);
1631: ben_cwb_summary_pkg.refresh_summary_group_pl
1632: (p_group_pl_id => p_group_pl_id
1633: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1634: --
1635: hr_utility.set_location('Refreshing Summary Complete',30);
2051: and lvl_num > 0;
2052: --
2053: begin
2054: --
2055: ben_cwb_summary_pkg.save_pl_sql_tab;
2056: for summs in csr_summary loop
2057: for mgr in csr_mgr_pil_ids loop
2058: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
2059: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
2054: --
2055: ben_cwb_summary_pkg.save_pl_sql_tab;
2056: for summs in csr_summary loop
2057: for mgr in csr_mgr_pil_ids loop
2058: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
2059: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
2060: ,p_group_pl_id => summs.group_pl_id
2061: ,p_group_oipl_id => summs.group_oipl_id
2062: ,p_elig_count_all => -summs.elig_count_all
2078: delete ben_cwb_summary
2079: where rowid = summs.rowid;
2080: end loop;
2081:
2082: ben_cwb_summary_pkg.save_pl_sql_tab;
2083:
2084: end delete_summary;
2085: --
2086: procedure p_backout_global_cwb_event