1 PACKAGE GHR_MTO_PKG AUTHID CURRENT_USER AS
2 /* $Header: ghmtoexe.pkh 120.1 2010/04/09 05:14:30 vmididho ship $ */
3
4 mass_error EXCEPTION;
5
6
7 PROCEDURE execute_mto (p_errbuf out NOCOPY varchar2,
8 p_retcode out NOCOPY number,
9 p_mass_transfer_id in number,
10 p_action in varchar2,
11 p_show_vacant_pos in varchar2 default 'NO');
12
13 procedure purge_processed_recs(p_session_id in number,
14 p_err_buf out NOCOPY varchar2);
15
16 /*
17 PROCEDURE get_duty_station_id (p_duty_station_code IN ghr_duty_stations_v.duty_station_code%TYPE
18 ,p_effective_date IN DATE
19 ,p_duty_station_id OUT ghr_duty_stations_v.duty_station_id%TYPE);
20 */
21
22 --Bug # 9329643 added employee number
23 procedure pop_dtls_from_pa_req(p_person_id in number,p_effective_date in date,
24 p_mass_transfer_id in number, p_employee_number in varchar2);
25
26
27 function check_select_flg(p_position_id in number,
28 p_action in varchar2,
29 p_effective_date in date,
30 p_mtfr_id in number,
31 p_sel_flg in out NOCOPY varchar2)
32 return boolean;
33
34 procedure purge_old_data (p_mass_transfer_id in number);
35
36 procedure ins_upd_pos_extra_info
37 (p_position_id in number,p_effective_date in date,
38 p_sel_flag in varchar2, p_comment in varchar2,
39 p_mtfr_id in number);
40
41 procedure update_sel_flg (p_position_id in number,p_effective_date in date);
42
43 FUNCTION check_eligibility(p_org_structure_id in varchar2,
44 p_office_symbol in varchar2,
45 p_personnel_office_id in varchar2,
46 p_agency_sub_element_code in varchar2,
47 p_duty_station_id in number,
48 p_l_org_structure_id in varchar2,
49 p_l_office_symbol in varchar2,
50 p_l_personnel_office_id in varchar2,
51 p_l_agency_sub_element_code in varchar2,
52 p_l_duty_station_id in number,
53 p_occ_series_code in varchar2,
54 p_mass_transfer_id in number,
55 p_action in varchar2,
56 p_effective_date in date,
57 p_person_id in number,
58 p_assign_type in varchar2 default 'ASSIGNED')
59 return boolean;
60
61
62 procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
63 p_effective_date in date,
64 p_personnel_office_id out NOCOPY varchar2,
65 p_org_structure_id out NOCOPY varchar2,
66 p_office_symbol out NOCOPY varchar2,
67 p_position_organization out NOCOPY varchar2,
68 p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype);
69
70 procedure get_pos_grp2_ddf (p_position_id in per_assignments_f.position_id%type,
71 p_effective_date in date,
72 p_org_func_code out NOCOPY varchar2,
73 p_appropriation_code1 out NOCOPY varchar2,
74 p_appropriation_code2 out NOCOPY varchar2,
75 p_pos_ei_data OUT NOCOPY per_position_extra_info%rowtype);
76
77 PROCEDURE get_extra_info_comments
78 (p_position_id in number,
79 p_effective_date in date,
80 p_sel_flag in out NOCOPY varchar2,
81 p_comments in out NOCOPY varchar2,
82 p_mtfr_id in out NOCOPY number);
83
84 procedure create_mass_act_prev (
85 p_effective_date in date,
86 p_date_of_birth in date,
87 p_full_name in varchar2,
88 p_national_identifier in varchar2,
89 --Bug # 9329643
90 p_employee_number in varchar2,
91 p_duty_station_code in varchar2,
92 p_duty_station_desc in varchar2,
93 p_personnel_office_id in varchar2,
94 p_position_id in per_assignments_f.position_id%type,
95 p_position_title in varchar2,
96 p_position_number in varchar2,
97 p_position_seq_no in varchar2,
98 p_org_structure_id in varchar2,
99 p_agency_sub_element_code in varchar2,
100 p_person_id in number,
101 p_mass_transfer_id in number,
102 p_sel_flg in varchar2,
103 p_grade_or_level in varchar2,
104 p_step_or_rate in varchar2,
105 p_pay_plan in varchar2,
106 p_occ_series in varchar2,
107 p_office_symbol in varchar2,
108 p_organization_id in number,
109 p_organization_name in varchar2,
110 p_positions_organization in varchar2 default null,
111 t_personnel_office_id in varchar2 default null,
112 t_sub_element_code in varchar2 default null,
113 t_duty_station_id in number default null,
114 t_duty_station_code in varchar2 default null,
115 t_duty_station_desc in varchar2 default null,
116 t_office_symbol in varchar2 default null,
117 t_payroll_office_id in varchar2 default null,
118 t_org_func_code in varchar2 default null,
119 t_appropriation_code1 in varchar2 default null,
120 t_appropriation_code2 in varchar2 default null,
121 t_position_organization in varchar2 default null,
122 p_to_agency_code in varchar2,
123 p_tenure in varchar2,
124 p_pay_rate_determinant in varchar2,
128
125 p_action in varchar2,
126 p_assignment_id in number);
127
129 PROCEDURE assign_to_sf52_rec(
130 p_person_id in number,
131 p_first_name in varchar2,
132 p_last_name in varchar2,
133 p_middle_names in varchar2,
134 p_national_identifier in varchar2,
135 p_date_of_birth in date,
136 p_effective_date in date,
137 p_assignment_id in number,
138 p_tenure in varchar2,
139 p_step_or_rate in varchar2,
140 p_annuitant_indicator in varchar2,
141 p_pay_rate_determinant in varchar2,
142 p_work_schedule in varchar2,
143 p_part_time_hour in varchar2,
144 p_flsa_category in varchar2,
145 p_bargaining_unit_status in varchar2,
146 p_functional_class in varchar2,
147 p_supervisory_status in varchar2,
148 p_personnel_office_id in varchar2,
149 p_sub_element_code in varchar2,
150 p_duty_station_id in number,
151 p_duty_station_code in ghr_pa_requests.duty_station_code%type,
155 p_org_func_code in varchar2,
152 p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
153 p_office_symbol in varchar2,
154 p_payroll_office_id in varchar2,
156 p_appropriation_code1 in varchar2,
157 p_appropriation_code2 in varchar2,
158 p_position_organization in varchar2,
159 p_first_noa_information1 in varchar2,
160 p_to_position_org_line1 in varchar2, -- AVR
161 p_lac_sf52_rec in ghr_pa_requests%rowtype,
162 p_sf52_rec out NOCOPY ghr_pa_requests%rowtype);
163
164 procedure pr (msg varchar2,par1 in varchar2 default null,
165 par2 in varchar2 default null);
166
167 PROCEDURE get_to_agency (p_person_id in number,
168 p_effective_date in date,
169 p_agency_code out NOCOPY varchar2);
170
171 function get_mto_name(p_mto_id in number) return varchar2;
172
173 procedure upd_ext_info_to_null(p_position_id in number);
174
175 PROCEDURE upd_ext_info_api (p_person_id in number,
176 p_agency_code in varchar2,
177 p_effective_date in date);
178
179
180 END GHR_MTO_PKG;