DBA Data[Home] [Help]

APPS.BEN_PER_ASG_EIT_LER dependencies on BEN_CREATE_PTNL_LER_FOR_PER

Line 334: ben_create_ptnl_ler_for_per.create_ptnl_ler_event

330: if l_type = 'P' then --1
331: open le_exists(nvl(p_new.person_id,p_old.person_id),l_ler_id,l_lf_evt_ocrd_date);
332: fetch le_exists into l_le_exists;
333: if le_exists%notfound then --1.1
334: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
335: (p_validate => false
336: ,p_ptnl_ler_for_per_id => l_ptnl_id
337: ,p_ntfn_dt => l_system_date
338: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 359: ben_create_ptnl_ler_for_per.create_ptnl_ler_event

355: exit when get_contacts%notfound;
356: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
357: fetch le_exists into l_le_exists;
358: if le_exists%notfound then --1.2
359: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
360: (p_validate => false
361: ,p_ptnl_ler_for_per_id => l_ptnl_id
362: ,p_ntfn_dt => l_system_date
363: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 724: ben_create_ptnl_ler_for_per.create_ptnl_ler_event

720: if l_type = 'P' then --1
721: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
722: fetch le_exists into l_le_exists;
723: if le_exists%notfound then --1.1
724: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
725: (p_validate => false
726: ,p_ptnl_ler_for_per_id => l_ptnl_id
727: ,p_ntfn_dt => l_system_date
728: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 749: ben_create_ptnl_ler_for_per.create_ptnl_ler_event

745: exit when get_contacts%notfound;
746: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
747: fetch le_exists into l_le_exists;
748: if le_exists%notfound then --1.2
749: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
750: (p_validate => false
751: ,p_ptnl_ler_for_per_id => l_ptnl_id
752: ,p_ntfn_dt => l_system_date
753: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date