APPS.BEN_EPR_BUS dependencies on HR_API

Line 51: and nvl(p_enrt_prem_id,hr_api.g_number)

47: (p_enrt_prem_id => p_enrt_prem_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_enrt_prem_id,hr_api.g_number)
52: <> ben_epr_shd.g_old_rec.enrt_prem_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_actl_prem_id,hr_api.g_number)

124: (p_enrt_prem_id => p_enrt_prem_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_actl_prem_id,hr_api.g_number)
129: <> nvl(ben_epr_shd.g_old_rec.actl_prem_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if actl_prem_id value exists in ben_actl_prem_f table

Line 129: <> nvl(ben_epr_shd.g_old_rec.actl_prem_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_actl_prem_id,hr_api.g_number)
129: <> nvl(ben_epr_shd.g_old_rec.actl_prem_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if actl_prem_id value exists in ben_actl_prem_f table
133: --

Line 203: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)

199: (p_enrt_prem_id => p_enrt_prem_id,
200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
204: <> nvl(ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
205: or not l_api_updating) and
206: p_elig_per_elctbl_chc_id is not null then
207: --

Line 204: <> nvl(ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_elig_per_elctbl_chc_id,hr_api.g_number)
204: <> nvl(ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
205: or not l_api_updating) and
206: p_elig_per_elctbl_chc_id is not null then
207: --
208: -- check if elig_per_elctbl_chc_id value exists in ben_elig_per_elctbl_chc table

Line 279: and nvl(p_enrt_bnft_id,hr_api.g_number)

275: (p_enrt_prem_id => p_enrt_prem_id,
276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_enrt_bnft_id,hr_api.g_number)
280: <> nvl(ben_epr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_enrt_bnft_id is not null then
283: --

Line 280: <> nvl(ben_epr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_enrt_bnft_id,hr_api.g_number)
280: <> nvl(ben_epr_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_enrt_bnft_id is not null then
283: --
284: -- check if enrt_bnft_id value exists in ben_enrt_bnft table

Line 321: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

317: --
318: -- Call all supporting business operations
319: --
320: --
321: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
322: --
323: chk_enrt_prem_id
324: (p_enrt_prem_id => p_rec.enrt_prem_id,
325: p_object_version_number => p_rec.object_version_number);

Line 353: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

349: --
350: -- Call all supporting business operations
351: --
352: --
353: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
354: --
355: chk_enrt_prem_id
356: (p_enrt_prem_id => p_rec.enrt_prem_id,
357: p_object_version_number => p_rec.object_version_number);

Line 415: hr_api.mandatory_arg_error(p_api_name => l_proc,

411: hr_utility.set_location('Entering:'|| l_proc, 10);
412: --
413: -- Ensure that all the mandatory parameter are not null
414: --
415: hr_api.mandatory_arg_error(p_api_name => l_proc,
416: p_argument => 'enrt_prem_id',
417: p_argument_value => p_enrt_prem_id);
418: --
419: open csr_leg_code;