PACKAGE: APPS.GHR_MASS_ACTIONS_PKG

Source

1 PACKAGE GHR_MASS_ACTIONS_PKG  AS
2 /* $Header: ghmasact.pkh 120.0.12000000.1 2007/03/27 10:11:56 managarw noship $ */
3 
4 -- create the record types here
5 type duty_station_rec_type is record
6 (duty_station_id       ghr_duty_stations_v.duty_station_id%type,
7  duty_station_code     ghr_duty_stations_v.duty_station_code%type,
8  duty_station_desc     ghr_duty_stations_v.duty_station_desc%type
9 );
10 
11 type emp_rec_type is record
12 (person_id             per_people_f.person_id%type,
13  first_name            per_people_f.first_name%type,
14  last_name             per_people_f.last_name%type,
15  middle_names          per_people_f.middle_names%type,
16  date_of_birth         per_people_f.date_of_birth%type,
17  national_identifier   per_people_f.national_identifier%type,
18  assignment_id         per_assignments_f.assignment_id%type
19  );
20 
21 procedure get_noa_id_desc
22 (
23  p_noa_code	       in	ghr_nature_of_actions.code%type,
24  p_effective_date	 in   date default trunc(sysdate),
25  p_noa_id	       out nocopy  ghr_nature_of_actions.nature_of_action_id%type,
26  p_noa_desc	       out nocopy  ghr_nature_of_actions.description%type
27  );
28 procedure get_remark_id_desc
29 (
30  p_remark_code	 in	ghr_nature_of_actions.code%type,
31  p_effective_date	 in   date default trunc(sysdate),
32  p_remark_id	 out nocopy  ghr_nature_of_actions.nature_of_action_id%type,
33  p_remark_desc	 out nocopy  ghr_nature_of_actions.description%type
34 );
35 
36 procedure emp_rec_to_sf52_rec
37 (p_emp_rec         in      ghr_mass_actions_pkg.emp_rec_type,
38  p_sf52_rec        in out nocopy  ghr_pa_requests%rowtype
39 ) ;
40 
41 procedure asg_sf52_rec_to_sf52_rec
42 (p_asg_sf52_rec    in      ghr_api.asg_sf52_type,
43  p_sf52_rec        in out nocopy  ghr_pa_requests%rowtype
44 );
45 
46 procedure pos_grp1_rec_to_sf52_rec
47 (p_pos_grp1_rec    in      ghr_api.pos_grp1_type,
48  p_sf52_rec        in out nocopy  ghr_pa_requests%rowtype
49 );
50 
51 procedure pay_calc_rec_to_sf52_rec
52 (p_pay_calc_rec  in      ghr_pay_calc.pay_calc_out_rec_type,
53  p_sf52_rec      in out nocopy  ghr_pa_requests%rowtype
54 );
55 
56 procedure duty_station_rec_to_sf52_rec
57 (p_duty_station_rec         in      ghr_mass_actions_pkg.duty_station_rec_type,
58  p_sf52_rec                 in out nocopy  ghr_pa_requests%rowtype
59 );
60 
61 procedure replace_insertion_values
62 (p_desc                in varchar2,
63  p_information1        in varchar2 default null,
64  p_information2        in varchar2 default null,
65  p_information3        in varchar2 default null,
66  p_information4        in varchar2 default null,
67  p_information5        in varchar2 default null,
68  p_desc_out            out nocopy varchar2
69 );
70 
71 Procedure get_personnel_off_groupbox
72 (p_position_id         in       ghr_pa_requests.from_position_id%type,
73  p_effective_date      in       date default trunc(sysdate),
74  p_groupbox_id         out nocopy      ghr_groupboxes.groupbox_id%type,
75  p_routing_group_id    out nocopy      ghr_routing_groups.routing_group_id%type
76 );
77 
78 Procedure get_personnel_officer_name
79 (p_personnel_office_id  in  ghr_pa_requests.personnel_office_id%TYPE,
80  p_person_full_name     out nocopy varchar2,
81  p_approving_off_work_title out nocopy varchar2);
82 
83 
84 end ghr_mass_actions_pkg;
85