APPS.PER_ASP_BUS dependencies on HR_API

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

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

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

119: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_security_profile_id,hr_api.g_number)
124: <> nvl(per_asp_shd.g_old_rec.security_profile_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if security_profile_id value exists in per_security_profiles table

Line 124: <> nvl(per_asp_shd.g_old_rec.security_profile_id,hr_api.g_number)

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

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

195: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_business_group_id,hr_api.g_number)
200: <> nvl(per_asp_shd.g_old_rec.business_group_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if business_group_id value exists in per_business_groups view

Line 200: <> nvl(per_asp_shd.g_old_rec.business_group_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_business_group_id,hr_api.g_number)
200: <> nvl(per_asp_shd.g_old_rec.business_group_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if business_group_id value exists in per_business_groups view
204: --

Line 373: hr_api.argument_changed_error

369: hr_utility.set_location(l_proc, 90);
370: --
371: EXCEPTION
372: WHEN l_error THEN
373: hr_api.argument_changed_error
374: (p_api_name => l_proc
375: ,p_argument => l_argument
376: );
377: WHEN OTHERS THEN