PACKAGE BODY: APPS.PER_HR_ASG_PKG

Source

1 PACKAGE BODY PER_HR_ASG_PKG AS
2 /* $Header: peper05t.pkb 115.2 99/07/18 14:14:53 porting ship $ */
3 --
4 procedure get_vacancy_details ( p_vacancy_id      in number,
5 				p_vacancy_name    in out varchar2,
6 				p_recruiter_id    in out number,
7 				p_recruiter_name  in out varchar2,
8 				p_org_id	  in out number,
9 				p_org_name	  in out varchar2,
10 				p_people_group_id in out number,
11 				p_job_id	  in out number,
12 				p_job_name	  in out varchar2,
13 				p_pos_id	  in out number,
14 				p_pos_name	  in out varchar2,
15 				p_grade_id	  in out number,
16 				p_grade_name	  in out varchar2,
17 				p_location_id     in out number,
18 				p_location_code   in out varchar2) is
19 
20 l_recruiter_number PER_ALL_PEOPLE.EMPLOYEE_NUMBER%TYPE;
21 
22 begin
23 --
24     per_applicant_pkg.get_vacancy_details ( p_vacancy_id,
25 				           p_vacancy_name,
26 				           p_recruiter_id,
27 				           p_recruiter_name,
28 				           p_org_id,
29 				           p_org_name,
30 				           p_people_group_id ,
31 				           p_job_id,
32 				           p_job_name,
33 				           p_pos_id,
34 				           p_pos_name,
35 				           p_grade_id,
36 				           p_grade_name,
37 				           p_location_id,
38 				           p_location_code,
39                                            l_recruiter_number   ) ;
40 --
41 end get_vacancy_details ;
42 --
43 --
44 --
45 --
46 function chk_job_org_pos_comb ( p_job_id        in number,
47 				p_org_id        in number,
48 				p_pos_id        in number,
49 				p_date_received in date    ) return boolean is
50 begin
51 --
52     return( per_applicant_pkg.chk_job_org_pos_comb ( p_job_id ,
53 	                                             p_org_id ,
54 				                     p_pos_id ,
55 				                     p_date_received  ) ) ;
56 --
57 end chk_job_org_pos_comb ;
58 --
59 --
60 --
61 procedure exists_val_grd_for_pos_and_job ( p_business_group_id  in number,
62 					   p_date_received      in date,
63 					   p_job_id             in number,
64 					   p_exists_grd_for_job out boolean,
65 					   p_pos_id             in number,
66 					   p_exists_grd_for_pos out boolean ) is
67 begin
68 --
69   per_applicant_pkg.exists_val_grd_for_pos_and_job ( p_business_group_id ,
70 					             p_date_received     ,
71 					             p_job_id            ,
72 					             p_exists_grd_for_job,
73 					             p_pos_id            ,
74 					             p_exists_grd_for_pos) ;
75 --
76 end exists_val_grd_for_pos_and_job ;
77 --
78 --
79 END PER_HR_ASG_PKG ;