DBA Data[Home] [Help]

APPS.BEN_PRO_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 18: from ben_ptnl_ler_for_per

14: cursor le_exists(p_person_id in number
15: ,p_ler_id in number
16: ,p_lf_evt_ocrd_dt in date) is
17: select 'Y'
18: from ben_ptnl_ler_for_per
19: where person_id = p_person_id
20: and ler_id = p_ler_id
21: and ptnl_ler_for_per_stat_cd = 'DTCTD'
22: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 893: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

889: if le_exists%notfound then
890: hr_utility.set_location(' Entering: ben_pro_trigger5', 60);
891:
892: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
893: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
894: (p_validate => false
895: ,p_ptnl_ler_for_per_id => l_ptnl_id
896: ,p_ntfn_dt => l_system_date
897: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 920: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

916: if le_exists%notfound then
917: hr_utility.set_location(' Entering: ben_pro_trigger5', 60);
918:
919: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
920: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
921: (p_validate => false
922: ,p_ptnl_ler_for_per_id => l_ptnl_id
923: ,p_ntfn_dt => l_system_date
924: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 1322: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1318: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
1319: fetch le_exists into l_le_exists;
1320: if le_exists%notfound then
1321: hr_utility.set_location(' Calling create_ptnl_ler_for_per ', 60);
1322: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1323: (p_validate => false
1324: ,p_ptnl_ler_for_per_id => l_ptnl_id
1325: ,p_ntfn_dt => l_system_date
1326: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date