[Home] [Help]
35: 18 Jun 98 jcarpent 115.4 Added business group to everything
36: Changed out nocopy parameters
37: 23 Jun 98 jcarpent 115.5 Check status code for per_in_ler.
38: 08 Jul 98 Jmohapat 115.6 added batch who columns to api
39: calls(ben_prtt_enrt_result_api.
40: create/update_enrollment,
41: ben_enrt_bnft_api. updateenrt_bnft
42: 24 Jul 98 jcarpent 115.7 Fixed message removed fnd_message.get
43: 28 Jul 98 jcarpent 115.8 Added flex fields.
5838: --
5839: --This is the action item completion in future case.
5840: --
5841: hr_utility.set_location('p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id,500);
5842: ben_prtt_enrt_result_api.delete_prtt_enrt_result
5843: (p_validate => false,
5844: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
5845: p_effective_start_date => l_effective_start_date,
5846: p_effective_end_date => l_effective_end_date,
5904: --
5905: hr_utility.set_location('l_pen_curr.prtt_enrt_rslt_id ' || l_pen_curr_interim.prtt_enrt_rslt_id,99);
5906: --
5907: IF l_pen_curr_interim.prtt_enrt_rslt_id IS NOT NULL THEN
5908: ben_prtt_enrt_result_api.delete_prtt_enrt_result
5909: (p_validate => false,
5910: p_prtt_enrt_rslt_id => l_pen_curr_interim.prtt_enrt_rslt_id,
5911: p_effective_start_date => l_effective_start_date,
5912: p_effective_end_date => l_effective_end_date,
6365: end if;
6366: -- end of bug 5555269
6367: end if;
6368:
6369: ben_prtt_enrt_result_api.delete_prtt_enrt_result
6370: (p_validate => false,
6371: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
6372: p_effective_start_date => l_effective_start_date,
6373: p_effective_end_date => l_effective_end_date,
6503: ,p_effective_date => p_effective_date
6504: );
6505: end if;
6506: -----Bug 7374973
6507: ben_PRTT_ENRT_RESULT_api.update_enrollment(
6508: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
6509: ,p_effective_start_date => p_effective_start_date
6510: ,p_effective_end_date => p_effective_end_date
6511: ,p_enrt_mthd_cd => p_enrt_mthd_cd
6729: fetch c_get_pil_enrt into l_get_prev_pil_enrt;
6730: if c_get_pil_enrt%found then
6731: hr_utility.set_location('previous enr found',2);
6732: hr_utility.set_location('previous prtt_enrt_rslt ' ||l_get_prev_pil_enrt.prtt_enrt_rslt_id,2);
6733: ben_prtt_enrt_result_api.delete_prtt_enrt_result
6734: (p_validate => false,
6735: p_prtt_enrt_rslt_id => l_get_prev_pil_enrt.prtt_enrt_rslt_id,
6736: p_effective_start_date => l_effective_start_date,
6737: p_effective_end_date => l_effective_end_date,
6755: if c_bkup_pen_rec%found then
6756: hr_utility.set_location('bkup record found : ' || l_object_version_number,99);
6757:
6758: --Update the pen record with the current pil to previous pil
6759: ben_prtt_enrt_result_api.update_prtt_enrt_result
6760: (p_validate => FALSE
6761: ,p_prtt_enrt_rslt_id => l_check_enrt_same_pil.prtt_enrt_rslt_id
6762: ,p_effective_start_date => l_effective_start_date
6763: ,p_effective_end_date => l_effective_end_date
6784: end if;
6785: ----End of Bug 9139820
6786: --
6787: hr_utility.set_location('l_global_epe_rec.enrt_cvg_strt_dt' ||l_global_epe_rec.enrt_cvg_strt_dt,2);
6788: ben_PRTT_ENRT_RESULT_api.update_enrollment(
6789: p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
6790: ,p_effective_start_date => p_effective_start_date
6791: ,p_effective_end_date => p_effective_end_date
6792: ,p_enrt_mthd_cd => p_enrt_mthd_cd
6876: fetch c_delink_interim into
6877: l_delink_interim.prtt_enrt_rslt_id,
6878: l_delink_interim.object_version_number ;
6879: if c_delink_interim%found then
6880: ben_prtt_enrt_result_api.update_prtt_enrt_result
6881: (p_validate => FALSE,
6882: p_prtt_enrt_rslt_id => l_delink_interim.prtt_enrt_rslt_id,
6883: p_effective_start_date => l_dlink_effective_start_date,
6884: p_effective_end_date => l_dlink_effective_end_date,
7207: );
7208: end if;
7209: close c_prtt_enrt_rslt_adj;
7210: --
7211: ben_prtt_enrt_result_api.update_prtt_enrt_result
7212: (p_validate => FALSE,
7213: p_prtt_enrt_rslt_id => l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id,
7214: p_effective_start_date => l_effective_start_date,
7215: p_effective_end_date => l_effective_end_date,
7259: ,l_ptip_id ) loop
7260: hr_utility.set_location('uxx Adjusting Coverage for '||l_global_epe_rec.enrt_cvg_strt_dt,10);
7261: --
7262: --
7263: ben_prtt_enrt_result_api.update_prtt_enrt_result
7264: (p_validate => FALSE,
7265: p_prtt_enrt_rslt_id => l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id,
7266: p_effective_start_date => l_effective_start_date,
7267: p_effective_end_date => l_effective_end_date,
7327: hr_utility.set_location('p_called_from sspnd: '||p_called_from_sspnd,1);
7328: hr_utility.set_location('l_prtt_enrt_interim_id : '||l_prtt_enrt_interim_id,1);
7329: hr_utility.set_location('l_curr_enrt_cvg_strt_dt: '||l_curr_enrt_cvg_strt_dt,2);
7330: ------Bug 8596122
7331: ben_PRTT_ENRT_RESULT_api.create_enrollment
7332: (p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
7333: ,P_prtt_enrt_rslt_id_o => p_prtt_enrt_rslt_id
7334: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
7335: ,p_assignment_id => l_assignment_id --Bug 2172036
7521: open c_pen_exists(p_prtt_enrt_rslt_id);
7522: fetch c_pen_exists into l_dummy_char ;
7523: if c_pen_exists%found then
7524: --
7525: ben_PRTT_ENRT_RESULT_api.delete_enrollment(
7526: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
7527: ,p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
7528: ,p_business_group_id => l_global_epe_rec.business_group_id
7529: ,p_effective_start_date => p_effective_start_date
7980: else
7981: l_datetrack_mode := p_datetrack_mode;
7982: end if;
7983: --
7984: ben_PRTT_ENRT_RESULT_api.delete_enrollment(
7985: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
7986: ,p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
7987: ,p_business_group_id => l_global_epe_rec.business_group_id
7988: ,p_effective_start_date => p_effective_start_date