DBA Data[Home] [Help]

APPS.PER_PEOPLE3_PKG dependencies on HR_EMPLOYEE_APPLICANT_API

Line 281: ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable ) is

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);

Line 528: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable

524: procedure vacancy_chk(p_person_id NUMBER
525: ,p_fire_warning in out nocopy VARCHAR2
526: ,p_vacancy_id in out nocopy NUMBER
527: -- #2381925
528: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
529: --
530: ) is
531: --
532: -- Check all Vacanicies person has applied for and check for

Line 575: if hr_employee_applicant_api.is_convert(p_table,l_asg_id) then

571: begin
572: -- 2381925: Verify if vacancy is over-subscribed ONLY if applicant
573: -- assignment is being hired.
574: --
575: if hr_employee_applicant_api.is_convert(p_table,l_asg_id) then
576:
577: select vacancy_id
578: into l_dummy_id
579: from per_all_vacancies pav