25: -- Declare cursors and local variables
26: --
27: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_TYPE_CMPT';
28: l_effective_date date;
29: l_component_name PER_SOLUTION_TYPE_CMPTS.COMPONENT_NAME%TYPE;
30: l_solution_type_name PER_SOLUTION_TYPE_CMPTS.SOLUTION_TYPE_NAME%TYPE;
31: l_legislation_code PER_SOLUTION_TYPE_CMPTS.LEGISLATION_CODE%TYPE;
32: l_object_version_number PER_SOLUTION_TYPE_CMPTS.OBJECT_VERSION_NUMBER%TYPE;
33: --
26: --
27: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_TYPE_CMPT';
28: l_effective_date date;
29: l_component_name PER_SOLUTION_TYPE_CMPTS.COMPONENT_NAME%TYPE;
30: l_solution_type_name PER_SOLUTION_TYPE_CMPTS.SOLUTION_TYPE_NAME%TYPE;
31: l_legislation_code PER_SOLUTION_TYPE_CMPTS.LEGISLATION_CODE%TYPE;
32: l_object_version_number PER_SOLUTION_TYPE_CMPTS.OBJECT_VERSION_NUMBER%TYPE;
33: --
34: begin
27: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_TYPE_CMPT';
28: l_effective_date date;
29: l_component_name PER_SOLUTION_TYPE_CMPTS.COMPONENT_NAME%TYPE;
30: l_solution_type_name PER_SOLUTION_TYPE_CMPTS.SOLUTION_TYPE_NAME%TYPE;
31: l_legislation_code PER_SOLUTION_TYPE_CMPTS.LEGISLATION_CODE%TYPE;
32: l_object_version_number PER_SOLUTION_TYPE_CMPTS.OBJECT_VERSION_NUMBER%TYPE;
33: --
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
28: l_effective_date date;
29: l_component_name PER_SOLUTION_TYPE_CMPTS.COMPONENT_NAME%TYPE;
30: l_solution_type_name PER_SOLUTION_TYPE_CMPTS.SOLUTION_TYPE_NAME%TYPE;
31: l_legislation_code PER_SOLUTION_TYPE_CMPTS.LEGISLATION_CODE%TYPE;
32: l_object_version_number PER_SOLUTION_TYPE_CMPTS.OBJECT_VERSION_NUMBER%TYPE;
33: --
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
161: -- Declare cursors and local variables
162: --
163: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION_TYPE_CMPT';
164: l_effective_date date;
165: l_object_version_number PER_SOLUTION_TYPE_CMPTS.OBJECT_VERSION_NUMBER%TYPE;
166: --
167: begin
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --