56: end if;
57: --
58: -- Ensure that all the mandatory parameter are not null
59: --
60: hr_api.mandatory_arg_error
61: (p_api_name => l_proc
62: ,p_argument => 'comp_notification_id'
63: ,p_argument_value => p_comp_notification_id
64: );
61: (p_api_name => l_proc
62: ,p_argument => 'comp_notification_id'
63: ,p_argument_value => p_comp_notification_id
64: );
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'object_version_number'
68: ,p_argument_value => p_object_version_number
69: );
90: close csr_sec_grp;
91: --
92: -- Set the security_group_id in CLIENT_INFO
93: --
94: hr_api.set_security_group_id
95: (p_security_group_id => l_security_group_id
96: );
97: --
98: -- Set the sessions legislation context in HR_SESSION_DATA
96: );
97: --
98: -- Set the sessions legislation context in HR_SESSION_DATA
99: --
100: hr_api.set_legislation_context(l_legislation_code);
101: end if;
102: --
103: if g_debug then
104: hr_utility.set_location(' Leaving:'|| l_proc, 20);
144: end if;
145: --
146: -- Ensure that all the mandatory parameter are not null
147: --
148: hr_api.mandatory_arg_error
149: (p_api_name => l_proc
150: ,p_argument => 'comp_notification_id'
151: ,p_argument_value => p_comp_notification_id
152: );
149: (p_api_name => l_proc
150: ,p_argument => 'comp_notification_id'
151: ,p_argument_value => p_comp_notification_id
152: );
153: hr_api.mandatory_arg_error
154: (p_api_name => l_proc
155: ,p_argument => 'object_version_number'
156: ,p_argument_value => p_object_version_number
157: );
155: ,p_argument => 'object_version_number'
156: ,p_argument_value => p_object_version_number
157: );
158: --
159: if (( nvl(hxc_han_bus.g_comp_notification_id, hr_api.g_number)
160: = p_comp_notification_id)
161: and ( nvl(hxc_han_bus.g_object_version_number, hr_api.g_number)
162: = p_object_version_number)) then
163: --
157: );
158: --
159: if (( nvl(hxc_han_bus.g_comp_notification_id, hr_api.g_number)
160: = p_comp_notification_id)
161: and ( nvl(hxc_han_bus.g_object_version_number, hr_api.g_number)
162: = p_object_version_number)) then
163: --
164: -- The legislation code has already been found with a previous
165: -- call to this function. Just return the value in the global