1701: p_recruiter_number in out nocopy varchar2 ) is
1702:
1703: l_proc varchar2(20) := 'get_vacancy_details';
1704: l_manager_id per_vacancies.manager_id%TYPE;
1705: l_manager_name per_all_people_f.full_name%TYPE;
1706: l_manager_number per_all_people_f.employee_number%TYPE;
1707:
1708: begin
1709: --
1702:
1703: l_proc varchar2(20) := 'get_vacancy_details';
1704: l_manager_id per_vacancies.manager_id%TYPE;
1705: l_manager_name per_all_people_f.full_name%TYPE;
1706: l_manager_number per_all_people_f.employee_number%TYPE;
1707:
1708: begin
1709: --
1710: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1778: --
1779: cursor get_recruiter is
1780: select per.full_name
1781: ,per.employee_number
1782: from per_all_people per
1783: where per.person_id = p_recruiter_id;
1784: --
1785: cursor get_job is
1786: select x.name
1807: -- Start changes for bug 8678206
1808: cursor get_manager is
1809: select per.full_name
1810: ,per.employee_number
1811: from per_all_people per
1812: where per.person_id = p_manager_id;
1813: -- End changes for bug 8678206
1814: --
1815: l_proc varchar2(20) := 'get_vacancy_details';
1956: p_grade_name in out nocopy varchar2,
1957: p_location_id in out nocopy number,
1958: p_location_code in out nocopy varchar2) is
1959:
1960: l_recruiter_number PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
1961:
1962: begin
1963: get_vacancy_details (p_vacancy_id => p_vacancy_id,
1964: p_vacancy_name => p_vacancy_name,
2000:
2001: --
2002: l_proc varchar2(20):= 'set_vac_from_rec_act';
2003: l_manager_id per_vacancies.manager_id%TYPE;
2004: l_manager_name per_all_people_f.full_name%TYPE;
2005: l_manager_number per_all_people_f.employee_number%TYPE;
2006: --
2007:
2008: begin
2001: --
2002: l_proc varchar2(20):= 'set_vac_from_rec_act';
2003: l_manager_id per_vacancies.manager_id%TYPE;
2004: l_manager_name per_all_people_f.full_name%TYPE;
2005: l_manager_number per_all_people_f.employee_number%TYPE;
2006: --
2007:
2008: begin
2009: --
2057: p_manager_name in out nocopy varchar2,
2058: p_manager_number in out nocopy varchar2) is
2059: -- End changes for bug 8678206
2060:
2061: l_recruiter_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
2062:
2063: l_proc varchar2(20) := 'set_vac_from_rec_act';
2064:
2065: begin
2231: p_applicant_number in number ) is
2232: l_dummy_number number ;
2233: cursor c1 is
2234: SELECT 1
2235: FROM PER_ALL_PEOPLE_F
2236: WHERE APPLICANT_NUMBER = p_applicant_number
2237: AND business_group_id + 0 = p_business_group_id ;
2238: begin
2239: --
2253: --
2254: l_dummy_number number := NULL ;
2255: cursor c1 is
2256: select 1
2257: from per_all_people_f
2258: where person_id = p_person_id
2259: group by person_id having count(*) > 1 ;
2260: --
2261: cursor c2 is