DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_POSTAL_ZIP_RANGE_API

Line 8008: BEN_POSTAL_ZIP_RANGE_API.CREATE_POSTAL_ZIP_RANGE(

8004:
8005: if l_first_rec and not l_update then
8006: -- Call Create routine.
8007: hr_utility.set_location(' BEN_PSTL_ZIP_RNG_F CREATE_POSTAL_ZIP_RANGE ',20);
8008: BEN_POSTAL_ZIP_RANGE_API.CREATE_POSTAL_ZIP_RANGE(
8009: --
8010: P_VALIDATE => false
8011: ,P_EFFECTIVE_DATE => l_effective_date
8012: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 8098: BEN_POSTAL_ZIP_RANGE_API.UPDATE_POSTAL_ZIP_RANGE(

8094: --UPD END
8095: -- Call Update routine for the pk_id created in prev run .
8096: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8097: hr_utility.set_location(' BEN_PSTL_ZIP_RNG_F UPDATE_POSTAL_ZIP_RANGE ',30);
8098: BEN_POSTAL_ZIP_RANGE_API.UPDATE_POSTAL_ZIP_RANGE(
8099: --
8100: P_VALIDATE => false
8101: ,P_EFFECTIVE_DATE => l_effective_date
8102: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 8154: BEN_POSTAL_ZIP_RANGE_API.delete_POSTAL_ZIP_RANGE(

8150: if (trunc(l_max_eed) <> trunc(hr_api.g_eot) and
8151: trunc(l_max_eed) <> l_effective_end_date and /* Bug 4302963 */
8152: trunc(l_max_eed) = r_RZR.information3) then
8153: --
8154: BEN_POSTAL_ZIP_RANGE_API.delete_POSTAL_ZIP_RANGE(
8155: --
8156: p_validate => false
8157: ,p_pstl_zip_rng_id => l_pstl_zip_rng_id
8158: ,p_effective_start_date => l_effective_start_date