DBA Data[Home] [Help]

APPS.PER_COBRA_ECI dependencies on HR_API

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

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

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

3280: -- Check if the enrollment is still valid as of the validation start
3281: -- and end dates.
3282: --
3283: if (p_object_version_number is not null
3284: and (nvl(p_effective_start_date,hr_api.g_date)
3285: <> g_old_rec.effective_start_date
3286: or nvl(p_effective_end_date,hr_api.g_date)
3287: <> g_old_rec.effective_end_date)) then
3288: --

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

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

Line 3778: when hr_api.object_locked then

3774: hr_utility.raise_error;
3775: end if;
3776: --
3777: exception
3778: when hr_api.object_locked then
3779: --
3780: -- The object is locked therefore we need to supply a meaningful
3781: -- error message.
3782: --