DBA Data[Home] [Help]

APPS.BEN_CRP_BUS dependencies on HR_API

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

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

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

119: (p_cbr_per_in_ler_id => p_cbr_per_in_ler_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_cbr_quald_bnf_id,hr_api.g_number)
124: <> nvl(ben_crp_shd.g_old_rec.cbr_quald_bnf_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if cbr_quald_bnf_id value exists in ben_cbr_quald_bnf table

Line 124: <> nvl(ben_crp_shd.g_old_rec.cbr_quald_bnf_id,hr_api.g_number)

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

Line 195: <> nvl(ben_crp_shd.g_old_rec.init_evt_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_init_evt_flag
195: <> nvl(ben_crp_shd.g_old_rec.init_evt_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_init_evt_flag,
204: p_effective_date => p_effective_date) then
205: --

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

232: --
233: -- Call all supporting business operations
234: --
235: --
236: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
237: --
238: chk_cbr_per_in_ler_id
239: (p_cbr_per_in_ler_id => p_rec.cbr_per_in_ler_id,
240: p_object_version_number => p_rec.object_version_number);

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

266: --
267: -- Call all supporting business operations
268: --
269: --
270: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
271: --
272: chk_cbr_per_in_ler_id
273: (p_cbr_per_in_ler_id => p_rec.cbr_per_in_ler_id,
274: p_object_version_number => p_rec.object_version_number);

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

330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Ensure that all the mandatory parameter are not null
333: --
334: hr_api.mandatory_arg_error(p_api_name => l_proc,
335: p_argument => 'cbr_per_in_ler_id',
336: p_argument_value => p_cbr_per_in_ler_id);
337: --
338: open csr_leg_code;