APPS.BEN_DRR_BUS dependencies on HR_API

Line 52: and nvl(p_dsgn_rqmt_rlshp_typ_id,hr_api.g_number)

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

Line 129: and nvl(p_dsgn_rqmt_id,hr_api.g_number)

125: (p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_dsgn_rqmt_id,hr_api.g_number)
130: <> nvl(ben_drr_shd.g_old_rec.dsgn_rqmt_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table

Line 130: <> nvl(ben_drr_shd.g_old_rec.dsgn_rqmt_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_dsgn_rqmt_id,hr_api.g_number)
130: <> nvl(ben_drr_shd.g_old_rec.dsgn_rqmt_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if dsgn_rqmt_id value exists in ben_dsgn_rqmt_f table
134: --

Line 234: <> nvl(ben_drr_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)

230: p_object_version_number => p_object_version_number);
231: --
232: if (l_api_updating
233: and p_rlshp_typ_cd
234: <> nvl(ben_drr_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)
235: or not l_api_updating)
236: and p_rlshp_typ_cd is not null then
237: --
238: -- check if value of lookup falls within lookup type.

Line 241: if hr_api.not_exists_in_hr_lookups

237: --
238: -- check if value of lookup falls within lookup type.
239: --
240: /* Commented the following code for Bug 3686523
241: if hr_api.not_exists_in_hr_lookups
242: (p_lookup_type => 'CONTACT',
243: p_lookup_code => p_rlshp_typ_cd,
244: p_effective_date => p_effective_date) then
245: --

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

366: --
367: -- Call all supporting business operations
368: --
369: --
370: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
371: --
372: chk_dsgn_rqmt_rlshp_typ_id
373: (p_dsgn_rqmt_rlshp_typ_id => p_rec.dsgn_rqmt_rlshp_typ_id,
374: p_object_version_number => p_rec.object_version_number);

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

404: --
405: -- Call all supporting business operations
406: --
407: --
408: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
409: --
410: chk_dsgn_rqmt_rlshp_typ_id
411: (p_dsgn_rqmt_rlshp_typ_id => p_rec.dsgn_rqmt_rlshp_typ_id,
412: p_object_version_number => p_rec.object_version_number);

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

472: hr_utility.set_location('Entering:'|| l_proc, 10);
473: --
474: -- Ensure that all the mandatory parameter are not null
475: --
476: hr_api.mandatory_arg_error(p_api_name => l_proc,
477: p_argument => 'dsgn_rqmt_rlshp_typ_id',
478: p_argument_value => p_dsgn_rqmt_rlshp_typ_id);
479: --
480: open csr_leg_code;