[Home] [Help]
1: package body ben_back_out_life_event as
2: /* $Header: benbolfe.pkb 120.59 2011/12/13 11:43:25 amnaraya noship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+
468:
469: */
470: ----------------------------------------------------------------------------------------------------------
471: --
472: g_package varchar2(80) := 'ben_back_out_life_event';
473:
474: --Start AMN bug 12732878
475: /*Added a global record to keep track of the old elig_per_id to new elig_per_id mapping.
476: This is used while creating elig_per_opt_f record.*/
534: order by lf_evt_ocrd_dt desc ;
535:
536: l_prev_pil_id number;
537: begin
538: hr_utility.set_location( 'Entering ben_back_out_life_event.update_epe', 1999 );
539: hr_utility.set_location( 'p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 1999 );
540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );
541: open c_get_pil_id(p_prtt_enrt_rslt_id);
542: fetch c_get_pil_id into l_upd_epe;
716:
717: for l_fut_dtd_cntct_pils_rec in get_fut_dtd_cntct_pils
718: (p_person_id)
719: loop
720: ben_back_out_life_event.back_out_life_events
721: (p_per_in_ler_id => l_fut_dtd_cntct_pils_rec.per_in_ler_id,
722: p_bckt_per_in_ler_id => p_per_in_ler_id,
723: p_bckt_stat_cd => p_bckt_stat_cd,
724: p_business_group_id => p_business_group_id,
727:
728: for l_contacts_pils_rec in get_contacts_pils(p_person_id, p_csd_by_ptnl_ler_for_per_id)
729: loop
730: --
731: ben_back_out_life_event.back_out_life_events
732: (p_per_in_ler_id => l_contacts_pils_rec.per_in_ler_id,
733: p_bckt_per_in_ler_id => p_per_in_ler_id,
734: p_bckt_stat_cd => p_bckt_stat_cd,
735: p_business_group_id => p_business_group_id,
7341: fnd_msg_pub.add;
7342: --
7343: end back_out_life_events_ss;
7344: --
7345: end ben_back_out_life_event;