57: hr_utility.set_location('Entering:'|| l_proc, 10);
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 => 'forum_id'
64: ,p_argument_value => p_forum_id
65: );
62: (p_api_name => l_proc
63: ,p_argument => 'forum_id'
64: ,p_argument_value => p_forum_id
65: );
66: hr_api.mandatory_arg_error
67: (p_api_name => l_proc
68: ,p_argument => 'object_id'
69: ,p_argument_value => p_object_id
70: );
67: (p_api_name => l_proc
68: ,p_argument => 'object_id'
69: ,p_argument_value => p_object_id
70: );
71: hr_api.mandatory_arg_error
72: (p_api_name => l_proc
73: ,p_argument => 'object_type'
74: ,p_argument_value => p_object_type
75: );
98: close csr_sec_grp;
99: --
100: -- Set the security_group_id in CLIENT_INFO
101: --
102: hr_api.set_security_group_id
103: (p_security_group_id => l_security_group_id
104: );
105: --
106: -- Set the sessions legislation context in HR_SESSION_DATA
104: );
105: --
106: -- Set the sessions legislation context in HR_SESSION_DATA
107: --
108: hr_api.set_legislation_context(l_legislation_code);
109: end if;
110: --
111: hr_utility.set_location(' Leaving:'|| l_proc, 20);
112: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Ensure that all the mandatory parameter are not null
153: --
154: hr_api.mandatory_arg_error
155: (p_api_name => l_proc
156: ,p_argument => 'forum_id'
157: ,p_argument_value => p_forum_id
158: );
155: (p_api_name => l_proc
156: ,p_argument => 'forum_id'
157: ,p_argument_value => p_forum_id
158: );
159: hr_api.mandatory_arg_error
160: (p_api_name => l_proc
161: ,p_argument => 'object_id'
162: ,p_argument_value => p_object_id
163: );
160: (p_api_name => l_proc
161: ,p_argument => 'object_id'
162: ,p_argument_value => p_object_id
163: );
164: hr_api.mandatory_arg_error
165: (p_api_name => l_proc
166: ,p_argument => 'object_type'
167: ,p_argument_value => p_object_type
168: );
166: ,p_argument => 'object_type'
167: ,p_argument_value => p_object_type
168: );
169: --
170: if (( nvl(ota_foi_bus.g_forum_id, hr_api.g_number)
171: = p_forum_id)
172: and ( nvl(ota_foi_bus.g_object_id, hr_api.g_number)
173: = p_object_id)
174: and ( nvl(ota_foi_bus.g_object_type, hr_api.g_varchar2)
168: );
169: --
170: if (( nvl(ota_foi_bus.g_forum_id, hr_api.g_number)
171: = p_forum_id)
172: and ( nvl(ota_foi_bus.g_object_id, hr_api.g_number)
173: = p_object_id)
174: and ( nvl(ota_foi_bus.g_object_type, hr_api.g_varchar2)
175: = p_object_type)) then
176: --
170: if (( nvl(ota_foi_bus.g_forum_id, hr_api.g_number)
171: = p_forum_id)
172: and ( nvl(ota_foi_bus.g_object_id, hr_api.g_number)
173: = p_object_id)
174: and ( nvl(ota_foi_bus.g_object_type, hr_api.g_varchar2)
175: = p_object_type)) then
176: --
177: -- The legislation code has already been found with a previous
178: -- call to this function. Just return the value in the global