DBA Data[Home] [Help]

APPS.BEN_CLA_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_age_fctr_id,hr_api.g_number)

119: (p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_age_fctr_id,hr_api.g_number)
124: <> nvl(ben_cla_shd.g_old_rec.age_fctr_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if age_fctr_id value exists in ben_age_fctr table

Line 124: <> nvl(ben_cla_shd.g_old_rec.age_fctr_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_age_fctr_id,hr_api.g_number)
124: <> nvl(ben_cla_shd.g_old_rec.age_fctr_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if age_fctr_id value exists in ben_age_fctr table
128: --

Line 198: and nvl(p_los_fctr_id,hr_api.g_number)

194: (p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_los_fctr_id,hr_api.g_number)
199: <> nvl(ben_cla_shd.g_old_rec.los_fctr_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if los_fctr_id value exists in ben_los_fctr table

Line 199: <> nvl(ben_cla_shd.g_old_rec.los_fctr_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_los_fctr_id,hr_api.g_number)
199: <> nvl(ben_cla_shd.g_old_rec.los_fctr_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if los_fctr_id value exists in ben_los_fctr table
203: --

Line 347: and nvl(p_name,hr_api.g_varchar2)

343: -- p_effective_date => p_effective_date,
344: p_object_version_number => p_object_version_number);
345: --
346: if (l_api_updating
347: and nvl(p_name,hr_api.g_varchar2)
348: <> ben_cla_shd.g_old_rec.name
349: or not l_api_updating)
350: and p_name is not null then
351: --

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

449: --
450: -- Call all supporting business operations
451: --
452: --
453: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
454: --
455: chk_cmbn_age_los_fctr_id
456: (p_cmbn_age_los_fctr_id => p_rec.cmbn_age_los_fctr_id,
457: p_object_version_number => p_rec.object_version_number);

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

494: --
495: -- Call all supporting business operations
496: --
497: --
498: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
499: --
500: chk_cmbn_age_los_fctr_id
501: (p_cmbn_age_los_fctr_id => p_rec.cmbn_age_los_fctr_id,
502: p_object_version_number => p_rec.object_version_number);

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

572: hr_utility.set_location('Entering:'|| l_proc, 10);
573: --
574: -- Ensure that all the mandatory parameter are not null
575: --
576: hr_api.mandatory_arg_error(p_api_name => l_proc,
577: p_argument => 'cmbn_age_los_fctr_id',
578: p_argument_value => p_cmbn_age_los_fctr_id);
579: --
580: open csr_leg_code;