APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_WK_LOC_PRTE_API

Line 172: BEN_ELIG_WK_LOC_PRTE_API.delete_ELIG_WK_LOC_PRTE(

168: where eligy_prfl_id = p_elig_prfl_id
169: and p_effective_date between effective_start_date and effective_end_date;
170: hr_utility.set_location('pk selected is'||l_pk,100);
171:
172: BEN_ELIG_WK_LOC_PRTE_API.delete_ELIG_WK_LOC_PRTE(
173: p_elig_wk_loc_prte_id => l_pk
174: ,p_effective_start_date => l_esd
175: ,p_effective_end_date => l_eed
176: ,p_object_version_number => l_ovn

Line 2490: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(

2486: end if;
2487: if l_loc_flag = 'Y' then
2488: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);
2489: hr_utility.set_location('location id is'||r_elp.information232,20);
2490: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(
2491: P_EFFECTIVE_DATE => l_effective_date
2492: ,P_BUSINESS_GROUP_ID => p_business_group_id
2493: ,P_ELIGY_PRFL_ID => l_elp_id
2494: ,P_ELIG_WK_LOC_PRTE_ID => l_pk

Line 2709: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(

2705: p_effective_date => l_effective_date);
2706: end if;
2707: if l_loc_flag = 'Y' and l_old_loc_flag is null and r_elp.information222 is null then
2708: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);
2709: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(
2710: P_EFFECTIVE_DATE => l_effective_date
2711: ,P_BUSINESS_GROUP_ID => p_business_group_id
2712: ,P_ELIGY_PRFL_ID => l_elp_id
2713: ,P_ELIG_WK_LOC_PRTE_ID => l_pk