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 370: ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable ) is

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

Line 632: ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable

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

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

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