23: -- Declare cursors and local variables
24: --
25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin
24: --
25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
25: l_proc varchar2(72) := g_package||'CREATE_SOLUTION_SET';
26: l_effective_date date;
27: l_solution_set_name PER_SOLUTION_SETS.SOLUTION_SET_NAME%TYPE;
28: l_user_id PER_SOLUTION_SETS.USER_ID%TYPE;
29: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
30: --
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
149: -- Declare cursors and local variables
150: --
151: l_proc varchar2(72) := g_package||'UPDATE_SOLUTION_SET';
152: l_effective_date date;
153: l_object_version_number PER_SOLUTION_SETS.OBJECT_VERSION_NUMBER%TYPE;
154: --
155: begin
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: --