DBA Data[Home] [Help]

APPS.HRWSECI dependencies on HR_API

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

2580: hr_utility.set_location('Entering:'||l_proc, 5);
2581: --
2582: if (p_object_version_number is not null and
2583: p_cobra_dependent_id
2584: <> nvl(g_old_rec.cobra_dependent_id,hr_api.g_number)) then
2585: --
2586: -- raise error as PK has changed
2587: --
2588: hr_utility.set_message(801,'HR_52271_CDP_PK_INV');

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

2646: -- Check if the enrollment is still valid as of the validation start
2647: -- and end dates.
2648: --
2649: if (p_object_version_number is not null
2650: and (nvl(p_effective_start_date,hr_api.g_date)
2651: <> g_old_rec.effective_start_date
2652: or nvl(p_effective_end_date,hr_api.g_date)
2653: <> g_old_rec.effective_end_date)) then
2654: --

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

2648: --
2649: if (p_object_version_number is not null
2650: and (nvl(p_effective_start_date,hr_api.g_date)
2651: <> g_old_rec.effective_start_date
2652: or nvl(p_effective_end_date,hr_api.g_date)
2653: <> g_old_rec.effective_end_date)) then
2654: --
2655: -- The dates have changed i.e. an update has occured or correction
2656: -- so make sure that the dependent effective dates are within the

Line 3134: when hr_api.object_locked then

3130: hr_utility.raise_error;
3131: end if;
3132: --
3133: exception
3134: when hr_api.object_locked then
3135: --
3136: -- The object is locked therefore we need to supply a meaningful
3137: -- error message.
3138: --