57: end if;
58: --
59: -- Ensure that all the mandatory parameter are not null
60: --
61: hr_api.mandatory_arg_error
62: (p_api_name => l_proc
63: ,p_argument => 'locker_type_owner_id'
64: ,p_argument_value => p_locker_type_owner_id
65: );
62: (p_api_name => l_proc
63: ,p_argument => 'locker_type_owner_id'
64: ,p_argument_value => p_locker_type_owner_id
65: );
66: hr_api.mandatory_arg_error
67: (p_api_name => l_proc
68: ,p_argument => 'locker_type_requestor_id'
69: ,p_argument_value => p_locker_type_requestor_id
70: );
85: close csr_sec_grp;
86: --
87: -- Set the security_group_id in CLIENT_INFO
88: --
89: hr_api.set_security_group_id
90: (p_security_group_id => l_security_group_id
91: );
92: --
93: -- Set the sessions legislation context in HR_SESSION_DATA
141: end if;
142: --
143: -- Ensure that all the mandatory parameter are not null
144: --
145: hr_api.mandatory_arg_error
146: (p_api_name => l_proc
147: ,p_argument => 'locker_type_owner_id'
148: ,p_argument_value => p_locker_type_owner_id
149: );
146: (p_api_name => l_proc
147: ,p_argument => 'locker_type_owner_id'
148: ,p_argument_value => p_locker_type_owner_id
149: );
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'locker_type_requestor_id'
153: ,p_argument_value => p_locker_type_requestor_id
154: );
152: ,p_argument => 'locker_type_requestor_id'
153: ,p_argument_value => p_locker_type_requestor_id
154: );
155: --
156: if (( nvl(hxc_lkr_bus.g_locker_type_owner_id, hr_api.g_number)
157: = p_locker_type_owner_id)
158: and ( nvl(hxc_lkr_bus.g_locker_type_requestor_id, hr_api.g_number)
159: = p_locker_type_requestor_id)) then
160: --
154: );
155: --
156: if (( nvl(hxc_lkr_bus.g_locker_type_owner_id, hr_api.g_number)
157: = p_locker_type_owner_id)
158: and ( nvl(hxc_lkr_bus.g_locker_type_requestor_id, hr_api.g_number)
159: = p_locker_type_requestor_id)) then
160: --
161: -- The legislation code has already been found with a previous
162: -- call to this function. Just return the value in the global