52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error
57: (p_api_name => l_proc
58: ,p_argument => 'component_name'
59: ,p_argument_value => p_component_name
60: );
57: (p_api_name => l_proc
58: ,p_argument => 'component_name'
59: ,p_argument_value => p_component_name
60: );
61: hr_api.mandatory_arg_error
62: (p_api_name => l_proc
63: ,p_argument => 'solution_type_name'
64: ,p_argument_value => p_solution_type_name
65: );
62: (p_api_name => l_proc
63: ,p_argument => 'solution_type_name'
64: ,p_argument_value => p_solution_type_name
65: );
66: hr_api.mandatory_arg_error
67: (p_api_name => l_proc
68: ,p_argument => 'legislation_code'
69: ,p_argument_value => p_legislation_code
70: );
92: close csr_sec_grp;
93: --
94: -- Set the security_group_id in CLIENT_INFO
95: --
96: hr_api.set_security_group_id
97: (p_security_group_id => l_security_group_id
98: );
99: end if;
100: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Ensure that all the mandatory parameter are not null
133: --
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc
136: ,p_argument => 'component_name'
137: ,p_argument_value => p_component_name
138: );
135: (p_api_name => l_proc
136: ,p_argument => 'component_name'
137: ,p_argument_value => p_component_name
138: );
139: hr_api.mandatory_arg_error
140: (p_api_name => l_proc
141: ,p_argument => 'solution_type_name'
142: ,p_argument_value => p_solution_type_name
143: );
141: ,p_argument => 'solution_type_name'
142: ,p_argument_value => p_solution_type_name
143: );
144: --
145: if (( nvl(per_stc_bus.g_component_name, hr_api.g_varchar2)
146: = p_component_name)
147: and ( nvl(per_stc_bus.g_solution_type_name, hr_api.g_varchar2)
148: = p_solution_type_name)) then
149: --
143: );
144: --
145: if (( nvl(per_stc_bus.g_component_name, hr_api.g_varchar2)
146: = p_component_name)
147: and ( nvl(per_stc_bus.g_solution_type_name, hr_api.g_varchar2)
148: = p_solution_type_name)) then
149: --
150: -- The legislation code has already been found with a previous
151: -- call to this function. Just return the value in the global
292: hr_utility.set_location('Entering:'|| l_proc, 10);
293: --
294: -- Check mandatory parameters have been set
295: --
296: hr_api.mandatory_arg_error
297: (p_api_name => l_proc
298: ,p_argument => 'effective date'
299: ,p_argument_value => p_effective_date
300: );
298: ,p_argument => 'effective date'
299: ,p_argument_value => p_effective_date
300: );
301: --
302: hr_api.mandatory_arg_error
303: (p_api_name => l_proc
304: ,p_argument => 'updateable'
305: ,p_argument_value => p_updateable
306: );
316: ,p_legislation_code => p_legislation_code
317: ,p_object_version_number => p_object_version_number
318: );
319: if ((l_api_updating
320: and nvl(per_stc_shd.g_old_rec.updateable, hr_api.g_varchar2)
321: <> nvl(p_updateable,hr_api.g_varchar2))
322: or
323: (NOT l_api_updating))
324: then
317: ,p_object_version_number => p_object_version_number
318: );
319: if ((l_api_updating
320: and nvl(per_stc_shd.g_old_rec.updateable, hr_api.g_varchar2)
321: <> nvl(p_updateable,hr_api.g_varchar2))
322: or
323: (NOT l_api_updating))
324: then
325: hr_utility.set_location(l_proc, 40);
332: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
333: -- and that the effective date is between start date
334: -- active and end date active in HR_STANDARD_LOOKUPS.
335: --
336: if hr_api.not_exists_in_hrstanlookups
337: (p_effective_date => p_effective_date
338: ,p_lookup_type => 'YES_NO'
339: ,p_lookup_code => p_updateable
340: )
404: hr_utility.set_location('Entering:'|| l_proc, 10);
405: --
406: -- Check mandatory parameters have been set
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'effective date'
411: ,p_argument_value => p_effective_date
412: );
410: ,p_argument => 'effective date'
411: ,p_argument_value => p_effective_date
412: );
413: --
414: hr_api.mandatory_arg_error
415: (p_api_name => l_proc
416: ,p_argument => 'extensible'
417: ,p_argument_value => p_extensible
418: );
428: ,p_legislation_code => p_legislation_code
429: ,p_object_version_number => p_object_version_number
430: );
431: if ((l_api_updating
432: and nvl(per_stc_shd.g_old_rec.extensible, hr_api.g_varchar2)
433: <> nvl(p_extensible,hr_api.g_varchar2))
434: or
435: (NOT l_api_updating))
436: then
429: ,p_object_version_number => p_object_version_number
430: );
431: if ((l_api_updating
432: and nvl(per_stc_shd.g_old_rec.extensible, hr_api.g_varchar2)
433: <> nvl(p_extensible,hr_api.g_varchar2))
434: or
435: (NOT l_api_updating))
436: then
437: hr_utility.set_location(l_proc, 40);
444: -- lookup type 'YES_NO' with an enabled flag set to 'Y'
445: -- and that the effective date is between start date
446: -- active and end date active in HR_STANDARD_LOOKUPS.
447: --
448: if hr_api.not_exists_in_hrstanlookups
449: (p_effective_date => p_effective_date
450: ,p_lookup_type => 'YES_NO'
451: ,p_lookup_code => p_extensible
452: )