APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_SVC_AREA_PRTE_API

Line 156: BEN_ELIG_SVC_AREA_PRTE_API.delete_ELIG_SVC_AREA_PRTE(

152: where eligy_prfl_id = p_elig_prfl_id
153: and p_effective_date between effective_start_date and effective_end_date;
154: hr_utility.set_location('pk selected is'||l_pk,100);
155:
156: BEN_ELIG_SVC_AREA_PRTE_API.delete_ELIG_SVC_AREA_PRTE(
157: p_elig_svc_area_prte_id => l_pk
158: ,p_effective_start_date => l_esd
159: ,p_effective_end_date => l_eed
160: ,p_object_version_number => l_ovn

Line 2475: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(

2471: end if;
2472: if l_sa_flag = 'Y' then
2473: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);
2474: hr_utility.set_location('serv area id is'||r_elp.information237,20);
2475: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(
2476: P_EFFECTIVE_DATE => l_effective_date
2477: ,P_BUSINESS_GROUP_ID => p_business_group_id
2478: ,P_ELIGY_PRFL_ID => l_elp_id
2479: ,P_ELIG_SVC_AREA_PRTE_ID => l_pk

Line 2691: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(

2687: p_effective_date => l_effective_date);
2688: end if;
2689: if l_sa_flag = 'Y' and l_old_sa_flag is null and r_elp.information227 is null then
2690: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);
2691: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(
2692: P_EFFECTIVE_DATE => l_effective_date
2693: ,P_BUSINESS_GROUP_ID => p_business_group_id
2694: ,P_ELIGY_PRFL_ID => l_elp_id
2695: ,P_ELIG_SVC_AREA_PRTE_ID => l_pk