46: -- Declare cursors and local variables
47: --
48: l_proc varchar2(72) := g_package||'create_salary_survey';
49: --
50: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
51: l_object_version_number per_salary_surveys.object_version_number%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: l_proc varchar2(72) := g_package||'create_salary_survey';
49: --
50: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
51: l_object_version_number per_salary_surveys.object_version_number%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
265: -- Declare cursors and local variables
266: --
267: l_proc varchar2(72) := g_package||'update_salary_survey';
268: --
269: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
270: l_object_version_number per_salary_surveys.object_version_number%TYPE;
271: l_temp_ovn number := p_object_version_number;
272: --
273: begin
266: --
267: l_proc varchar2(72) := g_package||'update_salary_survey';
268: --
269: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
270: l_object_version_number per_salary_surveys.object_version_number%TYPE;
271: l_temp_ovn number := p_object_version_number;
272: --
273: begin
274: hr_utility.set_location('Entering:'|| l_proc, 10);
456: -- Declare cursors and local variables
457: --
458: l_proc varchar2(72) := g_package||'delete_salary_survey';
459: --
460: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
461: l_object_version_number per_salary_surveys.object_version_number%TYPE;
462: --
463: begin
464: hr_utility.set_location('Entering:'|| l_proc, 10);
457: --
458: l_proc varchar2(72) := g_package||'delete_salary_survey';
459: --
460: l_salary_survey_id per_salary_surveys.salary_survey_id%TYPE;
461: l_object_version_number per_salary_surveys.object_version_number%TYPE;
462: --
463: begin
464: hr_utility.set_location('Entering:'|| l_proc, 10);
465: --