44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument => 'supplied_resource_id'
51: ,p_argument_value => p_supplied_resource_id
52: );
72: close csr_sec_grp;
73: --
74: -- Set the security_group_id in CLIENT_INFO
75: --
76: hr_api.set_security_group_id
77: (p_security_group_id => l_security_group_id
78: );
79: --
80: -- Set the sessions legislation context in HR_SESSION_DATA
78: );
79: --
80: -- Set the sessions legislation context in HR_SESSION_DATA
81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc
121: ,p_argument => 'supplied_resource_id'
122: ,p_argument_value => p_supplied_resource_id
123: );
122: ,p_argument_value => p_supplied_resource_id
123: );
124: --
125: --
126: if (( nvl(ota_srt_bus.g_supplied_resource_id, hr_api.g_number)
127: = p_supplied_resource_id)
128: and ( nvl(ota_srt_bus.g_language, hr_api.g_varchar2)
129: = p_language)) then
130: --
124: --
125: --
126: if (( nvl(ota_srt_bus.g_supplied_resource_id, hr_api.g_number)
127: = p_supplied_resource_id)
128: and ( nvl(ota_srt_bus.g_language, hr_api.g_varchar2)
129: = p_language)) then
130: --
131: -- The legislation code has already been found with a previous
132: -- call to this function. Just return the value in the global
263: l_business_group_id := p_business_group_id ;
264: l_resource_type := p_resource_type ;
265: end if;
266: --
267: hr_api.mandatory_arg_error(g_package,'business_group',l_business_group_id);
268: --
269: open csr_tsr;
270: fetch csr_tsr into l_dummy;
271: l_tsr_exists := csr_tsr%found;