45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error
50: (p_api_name => l_proc
51: ,p_argument => 'workbench_item_code'
52: ,p_argument_value => p_workbench_item_code
53: );
73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA
79: );
80: --
81: -- Set the sessions legislation context in HR_SESSION_DATA
82: --
83: hr_api.set_legislation_context(l_legislation_code);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'|| l_proc, 20);
87: --
123: hr_utility.set_location('Entering:'|| l_proc, 10);
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --
127: hr_api.mandatory_arg_error
128: (p_api_name => l_proc
129: ,p_argument => 'workbench_item_code'
130: ,p_argument_value => p_workbench_item_code
131: );
130: ,p_argument_value => p_workbench_item_code
131: );
132: --
133: --
134: if (( nvl(per_wbt_bus.g_workbench_item_code, hr_api.g_varchar2)
135: = p_workbench_item_code)
136: and ( nvl(per_wbt_bus.g_language, hr_api.g_varchar2)
137: = p_language)) then
138: --
132: --
133: --
134: if (( nvl(per_wbt_bus.g_workbench_item_code, hr_api.g_varchar2)
135: = p_workbench_item_code)
136: and ( nvl(per_wbt_bus.g_language, hr_api.g_varchar2)
137: = p_language)) then
138: --
139: -- The legislation code has already been found with a previous
140: -- call to this function. Just return the value in the global