55: -- Declare cursors and local variables
56: --
57: --
58: l_proc varchar2(72) := g_package||'create_assessment';
59: l_assessment_id per_assessments.assessment_id%TYPE;
60: l_object_version_number per_assessments.object_version_number%TYPE;
61: --
62: begin
63: hr_utility.set_location('Entering:'|| l_proc, 5);
56: --
57: --
58: l_proc varchar2(72) := g_package||'create_assessment';
59: l_assessment_id per_assessments.assessment_id%TYPE;
60: l_object_version_number per_assessments.object_version_number%TYPE;
61: --
62: begin
63: hr_utility.set_location('Entering:'|| l_proc, 5);
64: --
305: --
306: -- Declare cursors and local variables
307: --
308: l_proc varchar2(72) := g_package||'update_assessment';
309: l_object_version_number per_assessments.object_version_number%TYPE;
310: --
311: lv_object_version_number per_assessments.object_version_number%TYPE := p_object_version_number ;
312: --
313: begin
307: --
308: l_proc varchar2(72) := g_package||'update_assessment';
309: l_object_version_number per_assessments.object_version_number%TYPE;
310: --
311: lv_object_version_number per_assessments.object_version_number%TYPE := p_object_version_number ;
312: --
313: begin
314: hr_utility.set_location('Entering:'|| l_proc, 5);
315: --