47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error
52: (p_api_name => l_proc
53: ,p_argument => 'solution_type_name'
54: ,p_argument_value => p_solution_type_name
55: );
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: end if;
81: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc
123: ,p_argument => 'solution_type_name'
124: ,p_argument_value => p_solution_type_name
125: );
123: ,p_argument => 'solution_type_name'
124: ,p_argument_value => p_solution_type_name
125: );
126: --
127: if ( nvl(per_slt_bus.g_solution_type_name, hr_api.g_varchar2)
128: = p_solution_type_name) then
129: --
130: -- The legislation code has already been found with a previous
131: -- call to this function. Just return the value in the global
215: hr_utility.set_location('Entering:'|| l_proc, 10);
216: --
217: -- Check mandatory parameters have been set
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc
221: ,p_argument => 'effective date'
222: ,p_argument_value => p_effective_date
223: );
232: (p_solution_type_name => p_solution_type_name
233: ,p_object_version_number => p_object_version_number
234: );
235: if ((l_api_updating
236: and nvl(per_slt_shd.g_old_rec.solution_category, hr_api.g_varchar2)
237: <> nvl(p_solution_category,hr_api.g_varchar2))
238: or
239: (NOT l_api_updating))
240: then
233: ,p_object_version_number => p_object_version_number
234: );
235: if ((l_api_updating
236: and nvl(per_slt_shd.g_old_rec.solution_category, hr_api.g_varchar2)
237: <> nvl(p_solution_category,hr_api.g_varchar2))
238: or
239: (NOT l_api_updating))
240: then
241: hr_utility.set_location(l_proc, 40);
248: -- lookup type 'PER_SOLUTION_CATEGORIES' with an enabled flag set to 'Y'
249: -- and that the effective date is between start date
250: -- active and end date active in HR_STANDARD_LOOKUPS.
251: --
252: if hr_api.not_exists_in_hrstanlookups
253: (p_effective_date => p_effective_date
254: ,p_lookup_type => 'PER_SOLUTION_CATEGORIES'
255: ,p_lookup_code => p_solution_category
256: )
316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'effective date'
323: ,p_argument_value => p_effective_date
324: );
322: ,p_argument => 'effective date'
323: ,p_argument_value => p_effective_date
324: );
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc
328: ,p_argument => 'updateable'
329: ,p_argument_value => p_updateable
330: );
337: (p_solution_type_name => p_solution_type_name
338: ,p_object_version_number => p_object_version_number
339: );
340: if ((l_api_updating
341: and nvl(per_slt_shd.g_old_rec.updateable, hr_api.g_varchar2)
342: <> nvl(p_updateable,hr_api.g_varchar2))
343: or
344: (NOT l_api_updating))
345: then
338: ,p_object_version_number => p_object_version_number
339: );
340: if ((l_api_updating
341: and nvl(per_slt_shd.g_old_rec.updateable, hr_api.g_varchar2)
342: <> nvl(p_updateable,hr_api.g_varchar2))
343: or
344: (NOT l_api_updating))
345: then
346: hr_utility.set_location(l_proc, 40);
353: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
354: -- and that the effective date is between start date
355: -- active and end date active in HR_STANDARD_LOOKUPS.
356: --
357: if hr_api.not_exists_in_hrstanlookups
358: (p_effective_date => p_effective_date
359: ,p_lookup_type => 'YES_NO'
360: ,p_lookup_code => p_updateable
361: )