277: --
278: --overloaded procedure added for bug 5403222
279: procedure check_future_apl(p_person_id NUMBER
280: ,p_hire_date DATE
281: ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable ) is
282: --
283: -- Local Variables
284: --
285: l_dummy VARCHAR2(1);
366: end;
367:
368: procedure fpt_check_future_apl(p_person_id NUMBER
369: ,p_hire_date DATE
370: ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable ) is
371: --
372: -- Local Variables
373: --
374: l_dummy VARCHAR2(1);
628: procedure vacancy_chk(p_person_id NUMBER
629: ,p_fire_warning in out nocopy VARCHAR2
630: ,p_vacancy_id in out nocopy NUMBER
631: -- #2381925
632: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
633: --
634: ) is
635: --
636: -- Check all Vacanicies person has applied for and check for
675: begin
676: -- 2381925: Verify if vacancy is over-subscribed ONLY if applicant
677: -- assignment is being hired.
678: --
679: if hr_employee_applicant_api.is_convert(p_table,l_asg_id) then
680:
681: select vacancy_id
682: into l_dummy_id
683: from per_all_vacancies pav