62: procedure check_date_from(p_job_id in number,
63: p_date_from in date) is
64: --
65: cursor csr_date_from is select null
66: from per_valid_grades vg
67: where vg.job_id = p_job_id
68: and p_date_from > vg.date_from;
69: --
70: g_dummy_number number;
133: p_early_date_to in out nocopy boolean,
134: p_early_date_from in out nocopy boolean) is
135: --
136: cursor csr_date_to is select null
137: from per_valid_grades vg
138: where vg.business_group_id + 0 = p_business_group_id
139: and vg.job_id = p_job_id
140: and nvl(vg.date_to, p_end_of_time) > p_date_to;
141: --
139: and vg.job_id = p_job_id
140: and nvl(vg.date_to, p_end_of_time) > p_date_to;
141: --
142: cursor csr_date_from is select null
143: from per_valid_grades vg
144: where vg.business_group_id + 0 = p_business_group_id
145: and vg.job_id = p_job_id
146: and vg.date_from > p_date_to;
147: --
176: -- job where the end date of the job is earlier than the end
177: -- date of the valid grade.or the previous end dates matched.
178: --
179: --
180: update per_valid_grades vg
181: set vg.date_to =
182: (select least(nvl(p_date_to, p_end_of_time),
183: nvl(g.date_to, p_end_of_time))
184: from per_grades g
208: -- has been made earlier than the start date of the
209: -- valid grade.
210: --
211: --
212: delete from per_valid_grades vg
213: where vg.business_group_id + 0 = p_business_group_id
214: and vg.job_id = p_job_id
215: and vg.date_from > p_date_to;
216: --
238: where a.job_id = p_job_id
239: and a.job_id is not null;
240: --
241: cursor csr_grade is select null
242: from per_valid_grades vg1
243: where vg1.business_group_id + 0 = p_business_group_id
244: and vg1.job_id = p_job_id;
245: --
246: cursor csr_requirement is select null
290: l_rows_fetched NUMBER;
291: --
292: begin
293: --
294: -- Check there are no values in per_valid_grades, per_job_requirements,
295: -- per_job_evaluations, per_career_path_elements (check on parent and
296: -- subordinate id), hr_all_positions_f, per_budget_elements,
297: -- PER_all_assignments, per_vacancies_f, per_element_links_f
298: --