1 package PER_HR_ASG_PKG AUTHID CURRENT_USER as
2 /* $Header: peper05t.pkh 115.0 99/07/18 14:14:56 porting ship $ */
3 --
4 -- Name
5 -- get_vacancy_details
6 -- Notes
7 -- See PER_APPLICANT_PKG for details
8 procedure get_vacancy_details ( p_vacancy_id in number,
9 p_vacancy_name in out varchar2,
10 p_recruiter_id in out number,
11 p_recruiter_name in out varchar2,
12 p_org_id in out number,
13 p_org_name in out varchar2,
14 p_people_group_id in out number,
15 p_job_id in out number,
16 p_job_name in out varchar2,
17 p_pos_id in out number,
18 p_pos_name in out varchar2,
19 p_grade_id in out number,
20 p_grade_name in out varchar2,
21 p_location_id in out number,
22 p_location_code in out varchar2 ) ;
23
24 --
25 -- Name
26 -- chk_job_org_pos_comb
27 -- Notes
28 -- See PER_APPLICANT_PKG for details
29 function chk_job_org_pos_comb ( p_job_id in number,
30 p_org_id in number,
31 p_pos_id in number,
32 p_date_received in date ) return boolean ;
33 -- Name
34 -- exists_val_grd_for_pos_and_job
35 -- Notes
36 -- See PER_APPLICANT_PKG for details
37 procedure exists_val_grd_for_pos_and_job ( p_business_group_id in number,
38 p_date_received in date,
39 p_job_id in number,
40 p_exists_grd_for_job out boolean,
41 p_pos_id in number,
42 p_exists_grd_for_pos out boolean );
43
44 end PER_HR_ASG_PKG ;
[Home] [Help]