APPS.HR_SALARY_SURVEY_LINE_API dependencies on PER_SALARY_SURVEY_LINES

Line 105: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;

101: -- Declare cursors and local variables
102: --
103: l_proc varchar2(72) := g_package||'create_salary_survey_line';
104: --
105: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
106: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
107: --
108: l_eot date := hr_general.End_of_time;
109: --

Line 106: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;

102: --
103: l_proc varchar2(72) := g_package||'create_salary_survey_line';
104: --
105: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
106: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
107: --
108: l_eot date := hr_general.End_of_time;
109: --
110: l_start_date date;

Line 115: c_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;

111: l_end_date date;
112: --
113: l_overlap_warning boolean := false;
114: --
115: c_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
116: --
117: cursor csr_date_overlap is
118: select salary_survey_line_id
119: from per_salary_survey_lines

Line 119: from per_salary_survey_lines

115: c_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
116: --
117: cursor csr_date_overlap is
118: select salary_survey_line_id
119: from per_salary_survey_lines
120: where l_start_date > start_date
121: and end_date is null
122: and survey_job_name_code = p_survey_job_name_code
123: and nvl(survey_region_code,hr_api.g_varchar2)

Line 267: update per_salary_survey_lines

263: if c_salary_survey_line_id is not null then
264: --
265: --
266: --
267: update per_salary_survey_lines
268: set end_date = (l_start_date - 1)
269: where salary_survey_line_id = c_salary_survey_line_id;
270: --
271: l_overlap_warning := true;

Line 615: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;

611: --
612: l_start_date date;
613: l_end_date date;
614: --
615: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
616: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
617: --
618: begin
619: --

Line 616: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;

612: l_start_date date;
613: l_end_date date;
614: --
615: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
616: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
617: --
618: begin
619: --
620: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 971: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;

967: -- Declare cursors and local variables
968: --
969: l_proc varchar2(72) := g_package||'delete_salary_survey_line';
970: --
971: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
972: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
973: --
974: begin
975: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 972: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;

968: --
969: l_proc varchar2(72) := g_package||'delete_salary_survey_line';
970: --
971: l_salary_survey_line_id per_salary_survey_lines.salary_survey_line_id%TYPE;
972: l_ssl_object_version_number per_salary_survey_lines.object_version_number%TYPE;
973: --
974: begin
975: hr_utility.set_location('Entering:'|| l_proc, 10);
976: --