DBA Data[Home] [Help]

APPS.BEN_ACT_BUS dependencies on HR_API

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

54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Ensure that all the mandatory parameter are not null
57: --
58: hr_api.mandatory_arg_error(p_api_name => l_proc,
59: p_argument => 'person_action_id',
60: p_argument_value =>p_person_action_id);
61: --
62: open csr_leg_code;

Line 127: and nvl(p_person_action_id,hr_api.g_number)

123: (p_person_action_id => p_person_action_id,
124: p_object_version_number => p_object_version_number);
125: --
126: if (l_api_updating
127: and nvl(p_person_action_id,hr_api.g_number)
128: <> ben_act_shd.g_old_rec.person_action_id) then
129: --
130: -- raise error as PK has changed
131: --

Line 199: and nvl(p_benefit_action_id,hr_api.g_number)

195: (p_person_action_id => p_person_action_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_benefit_action_id,hr_api.g_number)
200: <> nvl(ben_act_shd.g_old_rec.benefit_action_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if benefit_action_id value exists in ben_benefit_actions table

Line 200: <> nvl(ben_act_shd.g_old_rec.benefit_action_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_benefit_action_id,hr_api.g_number)
200: <> nvl(ben_act_shd.g_old_rec.benefit_action_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if benefit_action_id value exists in ben_benefit_actions table
204: --

Line 271: <> nvl(ben_act_shd.g_old_rec.action_status_cd,hr_api.g_varchar2)

267: p_object_version_number => p_object_version_number);
268: --
269: if (l_api_updating
270: and p_action_status_cd
271: <> nvl(ben_act_shd.g_old_rec.action_status_cd,hr_api.g_varchar2)
272: or not l_api_updating) then
273: --
274: -- check if value of lookup falls within lookup type.
275: --

Line 277: if hr_api.not_exists_in_hr_lookups

273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: --
277: if hr_api.not_exists_in_hr_lookups
278: (p_lookup_type => 'BEN_ACTN_STAT',
279: p_lookup_code => p_action_status_cd,
280: p_effective_date => p_effective_date) then
281: --