DBA Data[Home] [Help]

APPS.BEN_XCL_BUS dependencies on HR_API

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

47: (p_ext_chg_evt_log_id => p_ext_chg_evt_log_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_ext_chg_evt_log_id,hr_api.g_number)
52: <> ben_xcl_shd.g_old_rec.ext_chg_evt_log_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_chg_evt_log_id => p_ext_chg_evt_log_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_xcl_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_xcl_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_xcl_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_xcl_shd.g_old_rec.chg_evt_cd,hr_api.g_varchar2)

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

Line 206: if hr_api.not_exists_in_hr_lookups

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

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

234: --
235: -- Call all supporting business operations
236: --
237: --
238: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
239: --
240: chk_ext_chg_evt_log_id
241: (p_ext_chg_evt_log_id => p_rec.ext_chg_evt_log_id,
242: p_object_version_number => p_rec.object_version_number);

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

263: --
264: -- Call all supporting business operations
265: --
266: --
267: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
268: --
269: chk_ext_chg_evt_log_id
270: (p_ext_chg_evt_log_id => p_rec.ext_chg_evt_log_id,
271: p_object_version_number => p_rec.object_version_number);

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

322: hr_utility.set_location('Entering:'|| l_proc, 10);
323: --
324: -- Ensure that all the mandatory parameter are not null
325: --
326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'ext_chg_evt_log_id',
328: p_argument_value => p_ext_chg_evt_log_id);
329: --
330: open csr_leg_code;