1 package body HR_ASG_PKG as
2 /* $Header: hrasg.pkb 115.0 99/07/17 16:33:52 porting ship $ */
3 /*
4 ===========================================================================
5 | Copyright (c) 1996 Oracle Corporation |
6 | All rights reserved. |
7 ===========================================================================
8 Name
9 HR Libraries server-side agent
10 Purpose
11 Agent handles all server-side traffic to and from forms libraries. This
12 is particularly necessary because we wish to avoid the situation where
13 a form and its libraries both refer to the same server-side package.
14 Forms/libraries appears to be unable to cope with this situation in
15 circumstances which we cannot yet define.
16 History
17 21 Apr 95 N Simpson Created
18 110.1 03 Sep 97 Khabibul Fixed problem with 255 chars line width
19 */
20 function chk_job_org_pos_comb ( p_job_id in number,
21 p_org_id in number,
22 p_pos_id in number,
23 p_date_received in date ) return boolean is
24 --
25 begin
26 --
27 return (per_hr_asg_pkg.chk_job_org_pos_comb (
28 p_job_id,
29 p_org_id,
30 p_pos_id,
31 p_date_received));
32 --
33 end chk_job_org_pos_comb;
34 --
35 procedure exists_val_grd_for_pos_and_job ( p_business_group_id in number,
36 p_date_received in date,
37 p_job_id in number,
38 p_exists_grd_for_job out boolean,
39 p_pos_id in number,
40 p_exists_grd_for_pos out boolean )
41 is
42 begin
43 --
44 per_hr_asg_pkg.exists_val_grd_for_pos_and_job (
45 p_business_group_id,
46 p_date_received,
47 p_job_id,
48 p_exists_grd_for_job,
49 p_pos_id,
50 p_exists_grd_for_pos);
51 --
52 end exists_val_grd_for_pos_and_job;
53 --
54 procedure get_vacancy_details ( p_vacancy_id in number,
55 p_vacancy_name in out varchar2,
56 p_recruiter_id in out number,
57 p_recruiter_name in out varchar2,
58 p_org_id in out number,
59 p_org_name in out varchar2,
60 p_people_group_id in out number,
61 p_job_id in out number,
62 p_job_name in out varchar2,
63 p_pos_id in out number,
64 p_pos_name in out varchar2,
65 p_grade_id in out number,
66 p_grade_name in out varchar2,
67 p_location_id in out number,
68 p_location_code in out varchar2 ) is
69 --
70 begin
71 --
72 per_hr_asg_pkg.get_vacancy_details (
73 p_vacancy_id,
74 p_vacancy_name,
75 p_recruiter_id,
76 p_recruiter_name,
77 p_org_id,
78 p_org_name,
79 p_people_group_id,
80 p_job_id,
81 p_job_name,
82 p_pos_id,
83 p_pos_name,
84 p_grade_id,
85 p_grade_name,
86 p_location_id,
87 p_location_code);
88 --
89 end get_vacancy_details;
90 --
91 end hr_asg_pkg;