754: -- GLOBALCWB : Populate data into ben_cwb_group_hrchy,
755: -- ben_cwb_person_tasks, ben_cwb_person_info if the per in ler
756: -- created is group per in ler.
757: --
758: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := null;
759: if benutils.g_benefit_action_id is not null then
760: --
761: benutils.get_batch_parameters
762: (p_benefit_action_id => benutils.g_benefit_action_id,
761: benutils.get_batch_parameters
762: (p_benefit_action_id => benutils.g_benefit_action_id,
763: p_rec => l_rec);
764: --
765: ben_manage_cwb_life_events.get_group_plan_info(
766: p_pl_id => l_rec.pl_id,
767: p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt,
768: p_business_group_id => l_rec.business_group_id);
769: --
766: p_pl_id => l_rec.pl_id,
767: p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt,
768: p_business_group_id => l_rec.business_group_id);
769: --
770: hr_utility.set_location(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,1234);
771: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
767: p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt,
768: p_business_group_id => l_rec.business_group_id);
769: --
770: hr_utility.set_location(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,1234);
771: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
775: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
769: --
770: hr_utility.set_location(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,1234);
771: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
775: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
776: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
777: p_effective_date => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
771: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
775: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
776: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
777: p_effective_date => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
778: p_manager_id => l_ws_mgr_id,
779: p_assignment_id => l_assignment_id ) ;
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
775: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
776: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
777: p_effective_date => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
778: p_manager_id => l_ws_mgr_id,
779: p_assignment_id => l_assignment_id ) ;
780: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,
775: p_hrchy_to_use_cd => ben_manage_cwb_life_events.g_cache_group_plan_rec.hrchy_to_use_cd,
776: p_pos_structure_version_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.pos_structure_version_id,
777: p_effective_date => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
778: p_manager_id => l_ws_mgr_id,
779: p_assignment_id => l_assignment_id ) ;
780: --
781: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
782: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
783: end if;
784: end if;
785: --
786: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);
787: ben_Person_Life_Event_api.create_Person_Life_Event_perf
788: (p_validate => false
789: ,p_per_in_ler_id => l_curr_per_in_ler_id
790: ,p_ler_id => p_ler_id
793: ,p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
794: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
795: ,p_business_group_id => p_business_group_id
796: ,p_ntfn_dt => trunc(sysdate) -- p_ptnl_rec.ntfn_dt
797: ,p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
798: ,p_ws_mgr_id => l_ws_mgr_id
799: ,p_assignment_id => l_assignment_id
800: ,p_object_version_number => l_object_version_number
801: ,p_effective_date => p_effective_date
806: ,p_procd_dt => l_procd_dt
807: ,p_strtd_dt => l_strtd_dt
808: ,p_voidd_dt => l_voidd_dt);
809: --
810: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
811: --
812: -- Per in ler created is a group per in ler so populate other
813: -- plan design tables.
814: --
811: --
812: -- Per in ler created is a group per in ler so populate other
813: -- plan design tables.
814: --
815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
812: -- Per in ler created is a group per in ler so populate other
813: -- plan design tables.
814: --
815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
820: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
814: --
815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
820: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
821: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
822: end if;
815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
820: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
821: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
822: end if;
823: --
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
820: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
821: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
822: end if;
823: --
824: g_rec.person_id := p_person_id;
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
820: p_group_business_group_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_business_group_id,
821: p_group_ler_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_ler_id);
822: end if;
823: --
824: g_rec.person_id := p_person_id;
825: g_rec.ler_id := p_ler_id;