25: 25-Mar-04 rpgupta 115.7 Changed logic for person selection to work like
26: participation process.
27: 26-Mar-04 pbodla 115.8 Added code to delete
28: BEN_CWB_PERSON_INFO,
29: BEN_CWB_SUMMARY,
30: ben_cwb_pl_dsgn
31: 26-Mar-04 pbodla 115.9 l_ocrd_date need to be passed to
32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
33: 27-Apr-04 rpgupta 115.13 bug 3517726 - elete records in ben_cwb_person_rates
1532: (p_group_pl_id => p_group_pl_id
1533: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1534: --
1535: hr_utility.set_location('Refreshing Summary ',20);
1536: ben_cwb_summary_pkg.refresh_summary_group_pl
1537: (p_group_pl_id => p_group_pl_id
1538: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1539: --
1540: commit;
1946: procedure delete_summary(p_group_per_in_ler_id in number) is
1947: --
1948: cursor csr_summary is
1949: select rowid, s.*
1950: from ben_cwb_summary s
1951: where s.group_per_in_ler_id = p_group_per_in_ler_id;
1952: --
1953: cursor csr_mgr_pil_ids is
1954: select mgr_per_in_ler_id
1957: and lvl_num > 0;
1958: --
1959: begin
1960: --
1961: ben_cwb_summary_pkg.save_pl_sql_tab;
1962: for summs in csr_summary loop
1963: for mgr in csr_mgr_pil_ids loop
1964: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
1965: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
1960: --
1961: ben_cwb_summary_pkg.save_pl_sql_tab;
1962: for summs in csr_summary loop
1963: for mgr in csr_mgr_pil_ids loop
1964: ben_cwb_summary_pkg.update_or_insert_pl_sql_tab
1965: (p_group_per_in_ler_id => mgr.mgr_per_in_ler_id
1966: ,p_group_pl_id => summs.group_pl_id
1967: ,p_group_oipl_id => summs.group_oipl_id
1968: ,p_elig_count_all => -summs.elig_count_all
1980: ,p_misc1_val_all => -summs.misc1_val_all
1981: ,p_misc2_val_all => -summs.misc2_val_all
1982: ,p_misc3_val_all => -summs.misc3_val_all);
1983: end loop;
1984: delete ben_cwb_summary
1985: where rowid = summs.rowid;
1986: end loop;
1987:
1988: ben_cwb_summary_pkg.save_pl_sql_tab;
1984: delete ben_cwb_summary
1985: where rowid = summs.rowid;
1986: end loop;
1987:
1988: ben_cwb_summary_pkg.save_pl_sql_tab;
1989:
1990: end delete_summary;
1991: --
1992: procedure p_backout_global_cwb_event