APPS.BEN_XRE_BUS dependencies on HR_API

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

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

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

124: (p_ext_rslt_err_id => p_ext_rslt_err_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_xre_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table

Line 129: <> nvl(ben_xre_shd.g_old_rec.person_id,hr_api.g_number)

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

Line 200: <> nvl(ben_xre_shd.g_old_rec.typ_cd,hr_api.g_varchar2)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and p_typ_cd
200: <> nvl(ben_xre_shd.g_old_rec.typ_cd,hr_api.g_varchar2)
201: or not l_api_updating)
202: and p_typ_cd is not null then
203: --
204: -- check if value of lookup falls within lookup type.

Line 206: if hr_api.not_exists_in_hr_lookups

202: and p_typ_cd is not null then
203: --
204: -- check if value of lookup falls within lookup type.
205: --
206: if hr_api.not_exists_in_hr_lookups
207: (p_lookup_type => 'BEN_EXT_ERR_TYP',
208: p_lookup_code => p_typ_cd,
209: p_effective_date => p_effective_date) then
210: --

Line 274: and nvl(p_ext_rslt_id, hr_api.g_number)

270: (p_ext_rslt_err_id => p_ext_rslt_err_id,
271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_ext_rslt_id, hr_api.g_number)
275: <> nvl(ben_xre_shd.g_old_rec.ext_rslt_id, hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if ext_rslt_id value exists in ben_ext_rslt table

Line 275: <> nvl(ben_xre_shd.g_old_rec.ext_rslt_id, hr_api.g_number)

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_ext_rslt_id, hr_api.g_number)
275: <> nvl(ben_xre_shd.g_old_rec.ext_rslt_id, hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if ext_rslt_id value exists in ben_ext_rslt table
279: --

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

313: --
314: -- Call all supporting business operations
315: --
316: --
317: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
318: --
319: chk_ext_rslt_err_id
320: (p_ext_rslt_err_id => p_rec.ext_rslt_err_id,
321: p_object_version_number => p_rec.object_version_number);

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

347: --
348: -- Call all supporting business operations
349: --
350: --
351: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
352: --
353: chk_ext_rslt_err_id
354: (p_ext_rslt_err_id => p_rec.ext_rslt_err_id,
355: 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 => 'ext_rslt_err_id',
417: p_argument_value => p_ext_rslt_err_id);
418: --
419: open csr_leg_code;