DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_POSTAL_ZIP_RATE_API

Line 5258: BEN_POSTAL_ZIP_RATE_API.CREATE_POSTAL_ZIP_RATE(

5254:
5255: if l_first_rec and not l_update then
5256: -- Call Create routine.
5257: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F CREATE_POSTAL_ZIP_RATE ',20);
5258: BEN_POSTAL_ZIP_RATE_API.CREATE_POSTAL_ZIP_RATE(
5259: --
5260: P_VALIDATE => false
5261: ,P_EFFECTIVE_DATE => l_effective_date
5262: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 5350: BEN_POSTAL_ZIP_RATE_API.UPDATE_POSTAL_ZIP_RATE(

5346: IF l_update OR l_dml_operation <> 'UPDATE' THEN
5347: --UPD END
5348: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5349: hr_utility.set_location(' BEN_PSTL_ZIP_RT_F UPDATE_POSTAL_ZIP_RATE ',30);
5350: BEN_POSTAL_ZIP_RATE_API.UPDATE_POSTAL_ZIP_RATE(
5351: --
5352: P_VALIDATE => false
5353: ,P_EFFECTIVE_DATE => l_effective_date
5354: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 5408: BEN_POSTAL_ZIP_RATE_API.delete_POSTAL_ZIP_RATE(

5404: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
5405: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
5406: trunc(l_max_eed) = r_PZR.information3) then
5407: --
5408: BEN_POSTAL_ZIP_RATE_API.delete_POSTAL_ZIP_RATE(
5409: --
5410: p_validate => false
5411: ,p_pstl_zip_rt_id => l_pstl_zip_rt_id
5412: ,p_effective_start_date => l_effective_start_date