DBA Data[Home] [Help]

APPS.BEN_GOS_BUS dependencies on HR_API

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

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

Line 120: <> nvl(ben_gos_shd.g_old_rec.typ_cd,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_typ_cd
120: <> nvl(ben_gos_shd.g_old_rec.typ_cd,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_typ_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.

Line 128: if hr_api.not_exists_in_hr_lookups

124: -- check if value of lookup falls within lookup type.
125: --
126: hr_utility.set_location('In:'||l_proc||'lookup_code='||p_typ_cd,8);
127:
128: if hr_api.not_exists_in_hr_lookups
129: (p_lookup_type => 'BEN_GD_R_SVC_TYP',
130: p_lookup_code => p_typ_cd,
131: p_effective_date => p_effective_date) then
132: --

Line 186: and gd_or_svc_typ_id <> nvl(p_gd_or_svc_typ_id, hr_api.g_number)

182: cursor csr_name is
183: select null
184: from BEN_GD_OR_SVC_TYP
185: where name = p_name
186: and gd_or_svc_typ_id <> nvl(p_gd_or_svc_typ_id, hr_api.g_number)
187: and business_group_id + 0 = p_business_group_id;
188: --
189: Begin
190: --

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

238: --
239: -- Call all supporting business operations
240: --
241: --
242: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
243: --
244: chk_gd_or_svc_typ_id
245: (p_gd_or_svc_typ_id => p_rec.gd_or_svc_typ_id,
246: p_object_version_number => p_rec.object_version_number);

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

273: --
274: -- Call all supporting business operations
275: --
276: --
277: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
278: --
279: chk_gd_or_svc_typ_id
280: (p_gd_or_svc_typ_id => p_rec.gd_or_svc_typ_id,
281: p_object_version_number => p_rec.object_version_number);

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

338: hr_utility.set_location('Entering:'|| l_proc, 10);
339: --
340: -- Ensure that all the mandatory parameter are not null
341: --
342: hr_api.mandatory_arg_error(p_api_name => l_proc,
343: p_argument => 'gd_or_svc_typ_id',
344: p_argument_value => p_gd_or_svc_typ_id);
345: --
346: open csr_leg_code;