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: --
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
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: --
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
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: --
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