APPS.PER_COBRA_ECI dependencies on HR_API

Line 3213: <> nvl(g_old_rec.cobra_dependent_id,hr_api.g_number)) then

3209: hr_utility.set_location('Entering:'||l_proc, 5);
3210: --
3211: if (p_object_version_number is not null and
3212: p_cobra_dependent_id
3213: <> nvl(g_old_rec.cobra_dependent_id,hr_api.g_number)) then
3214: --
3215: -- raise error as PK has changed
3216: --
3217: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');

Line 3279: and (nvl(p_effective_start_date,hr_api.g_date)

3275: -- Check if the enrollment is still valid as of the validation start
3276: -- and end dates.
3277: --
3278: if (p_object_version_number is not null
3279: and (nvl(p_effective_start_date,hr_api.g_date)
3280: <> g_old_rec.effective_start_date
3281: or nvl(p_effective_end_date,hr_api.g_date)
3282: <> g_old_rec.effective_end_date)) then
3283: --

Line 3281: or nvl(p_effective_end_date,hr_api.g_date)

3277: --
3278: if (p_object_version_number is not null
3279: and (nvl(p_effective_start_date,hr_api.g_date)
3280: <> g_old_rec.effective_start_date
3281: or nvl(p_effective_end_date,hr_api.g_date)
3282: <> g_old_rec.effective_end_date)) then
3283: --
3284: -- The dates have changed i.e. an update has occured or correction
3285: -- so make sure that the dependent effective dates are within the

Line 3773: when hr_api.object_locked then

3769: hr_utility.raise_error;
3770: end if;
3771: --
3772: exception
3773: when hr_api.object_locked then
3774: --
3775: -- The object is locked therefore we need to supply a meaningful
3776: -- error message.
3777: --