16: g_events g_events_table;
17: g_included_events g_events_table;
18: all_expressions_parsed exception;
19: --
20: g_rec benutils.g_batch_ler_rec;
21: --
22: procedure build_life_event_set(p_person_id in number,
23: p_business_group_id in number,
24: p_mode in varchar2,
332: p_rec => l_ass_rec);
333: --
334: end if;
335: --
336: l_outputs := benutils.formula
337: (p_formula_id => p_events.eval_rl,
338: p_effective_date => p_effective_date,
339: p_business_group_id => p_business_group_id,
340: p_ler_id => p_events.eval_ler_id,
376: p_rec => l_ass_rec);
377: --
378: end if;
379: --
380: l_outputs := benutils.formula
381: (p_formula_id => p_events.eval_ler_det_rl,
382: p_effective_date => p_effective_date,
383: p_business_group_id => p_business_group_id,
384: p_ler_id => p_events.eval_ler_id,
520: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
521: fnd_message.set_token('NAME',l_pil_rec.name);
522: fnd_message.set_token('OCCURRED_DATE',l_pil_rec.lf_evt_ocrd_dt);
523: fnd_message.set_token('NOTIFICATION_DATE',l_pil_rec.ntfn_dt);
524: benutils.write(fnd_message.get);
525: --
526: end loop;
527: close get_all_fut_pils;
528: --
568: fnd_message.set_name('BEN','BEN_92433_ACTIVE_LER_BCKDT');
569: fnd_message.set_token('NAME',l_ler_rec.name);
570: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).lf_evt_ocrd_dt);
571: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).ntfn_dt);
572: benutils.write(fnd_message.get);
573: --
574: g_rec.person_id := p_person_id;
575: g_rec.ler_id := g_included_events(l_count).ler_id;
576: g_rec.lf_evt_ocrd_dt := g_included_events(l_count).lf_evt_ocrd_dt;
588: g_rec.cvrge_rt_prem_flag := 'N';
589: g_rec.business_group_id := p_business_group_id;
590: g_rec.effective_date := p_effective_date;
591: --
592: benutils.write(p_rec => g_rec);
593: --
594: elsif l_operation = 'V' then
595: --
596: -- Update the life event and set its status to voided
613: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
614: lf_evt_ocrd_dt);
615: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
616: ntfn_dt);
617: benutils.write(fnd_message.get);
618: else
619: if (g_included_events(l_count).ler_id = p_events.eval_ler_id) then
620: hr_utility.set_location('Event not voided '||g_included_events(l_count).ler_id, 50);
621: hr_utility.set_location('p_events.eval_ler_id '||p_events.eval_ler_id, 50);
655: fnd_message.set_token('OCCURRED_DATE',g_included_events(l_count).
656: lf_evt_ocrd_dt);
657: fnd_message.set_token('NOTIFICATION_DATE',g_included_events(l_count).
658: ntfn_dt);
659: benutils.write(fnd_message.get);
660: --
661: end if;
662: --
663: end if;