[Home] [Help]
32: ptn.ptnl_ler_for_per_stat_cd,
33: ptn.lf_evt_ocrd_dt,
34: ptn.ntfn_dt,
35: ptn.object_version_number
36: from ben_ptnl_ler_for_per ptn,
37: ben_ler_f ler
38: where ptn.business_group_id = p_business_group_id
39: and ptn.person_id = p_person_id
40: and ptn.ler_id = ler.ler_id
275:
276:
277: --Added for Bug 7583015
278: cursor c_chk_evt_procd is
279: select ptnl_ler_for_per_id from ben_ptnl_ler_for_per
280: where person_id=p_person_id
281: and business_group_id=p_events.business_group_id
282: and ler_id=p_events.eval_ler_id
283: and ptnl_ler_for_per_stat_cd in ('PROCD','STRTD')
295: --End 7583015
296:
297: /*Bug 9372154*/
298: cursor c_ler_status(c_ptnl_id number) is
299: select 'Y' from ben_ptnl_ler_for_per
300: where ptnl_ler_for_per_id=c_ptnl_id
301: and ptnl_ler_for_per_stat_cd in ('DTCTD','UNPROCD');
302: l_flag1 varchar2(1);
303:
303:
304: --Start bug 12538701
305: cursor c_ptnl_ler_for_per_ovn(c_ptnl_ler_for_per_id number) is
306: SELECT object_version_number
307: FROM ben_ptnl_ler_for_per
308: WHERE ptnl_ler_for_per_id = c_ptnl_ler_for_per_id;
309: l_new_object_version_number number(15);
310: --End bug 12538701
311:
553: if l_lf_evt_ocrd_dt <> g_included_events(l_count).lf_evt_ocrd_dt then
554: open c_ptnl_ler_for_per_ovn(g_included_events(l_count).ptnl_ler_for_per_id);
555: fetch c_ptnl_ler_for_per_ovn into l_new_object_version_number;
556: close c_ptnl_ler_for_per_ovn;
557: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
558: (p_ptnl_ler_for_per_id => g_included_events(l_count).
559: ptnl_ler_for_per_id,
560: p_effective_date => p_effective_date,
561: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
597: --
598: /* Bug 7583015: Added if else condition.VOIDD if not winning LE, else backout the winning LE to UNPROCD*/
599: if(g_included_events(l_count).ler_id <> p_events.eval_ler_id) then
600: hr_utility.set_location('In V VOIDD ', 50);
601: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
602: (p_ptnl_ler_for_per_id => g_included_events(l_count).
603: ptnl_ler_for_per_id,
604: p_ptnl_ler_for_per_stat_cd => 'VOIDD',
605: p_voidd_dt => p_effective_date,
628: open c_ler_status(g_included_events(l_count).ptnl_ler_for_per_id);
629: fetch c_ler_status into l_flag1;
630: if(c_ler_status%found) then
631: hr_utility.set_location('Winner LE is not processed ', 50);
632: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
633: (p_ptnl_ler_for_per_id => g_included_events(l_count).
634: ptnl_ler_for_per_id,
635: p_effective_date => p_effective_date,
636: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
642: end if;
643: --
644: elsif l_operation = 'D' then
645: --
646: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
647: (p_ptnl_ler_for_per_id => g_included_events(l_count).
648: ptnl_ler_for_per_id,
649: p_effective_date => p_effective_date,
650: p_object_version_number => g_included_events(l_count).
667: -- Now lets create the new collapsed life event
668: --
669: /* Bug 7583015: Added if else condition for creating the potential*/
670: if(not l_flag) then
671: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
672: (p_validate => false,
673: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
674: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
675: p_ptnl_ler_for_per_stat_cd => 'DTCTD',
702: end if;
703: close c_get_pil_id;
704: else
705: close c_chk_evt_procd;
706: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
707: (p_validate => false,
708: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
709: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
710: p_ptnl_ler_for_per_stat_cd => 'DTCTD',