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,
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,
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,
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,
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,
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: );
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: