1 PACKAGE GHR_MTI_INT_INSERT AUTHID CURRENT_USER AS
2 /* $Header: ghrmtins.pkh 120.1.12010000.2 2009/08/07 09:41:12 utokachi ship $ */
3
4 g_package constant varchar2(33) := ' ghr_mti_int_insert.';
5 g_log_enabled boolean := TRUE;
6
7 procedure main_convert(
8 p_transfer_name IN varchar2,
9 p_process_date IN date,
10 p_effective_date IN date,
11 p_source IN varchar2,
12 p_status IN varchar2,
13 p_person_id IN OUT NOCOPY number,
14 p_inter_bg_transfer IN varchar2,
15 p_date_of_birth IN date,
16 p_effective_end_date IN date,
17 p_effective_start_date IN date,
18 p_first_name IN varchar2,
19 p_full_name IN varchar2,
20 p_last_name IN varchar2,
21 p_marital_status IN varchar2,
22 p_middle_names IN varchar2,
23 p_national_identifier IN varchar2,
24 p_nationality IN varchar2,
25 p_rehire_reason IN varchar2,
26 p_sex IN varchar2,
27 p_start_date IN date,
28 p_title IN varchar2,
29 p_work_telephone IN varchar2,
30 p_citizenship IN varchar2,
31 p_veterans_preference IN varchar2,
32 p_veterans_preference_for_RIF IN varchar2,
33 p_veterans_status IN varchar2,
34 p_appointment_type IN varchar2,
35 p_type_of_employment IN varchar2,
36 p_race_or_national_origin IN varchar2,
37 p_agency_code_transfer_from IN varchar2,
38 p_orig_appointment_auth_code_1 IN varchar2,
39 p_orig_appt_auth_code_1_desc IN varchar2,--Bug# 8724192
40 p_orig_appointment_auth_code_2 IN varchar2,
41 p_orig_appt_auth_code_2_desc IN varchar2,--Bug# 8724192
42 p_handicap_code IN varchar2,
43 p_service_comp_date IN date,
44 -- Bug 2412656 Added FERS Coverage
45 p_fers_coverage IN VARCHAR2,
46 p_previous_retirement_coverage IN varchar2,
47 p_frozen_service IN varchar2,
48 p_Creditable_Military_Service IN varchar2,
49 p_flsa_category IN varchar2,
50 p_bargaining_unit_status IN varchar2,
51 p_functional_class IN varchar2,
52 p_position_working_title IN varchar2,
53 p_supervisory_status IN varchar2,
54 p_position_occupied IN varchar2,
55 p_appropriation_code1 IN varchar2,
56 p_appropriation_code2 IN varchar2,
57 p_total_salary IN number,
58 p_basic_salary_rate IN number,
59 p_locality_adjustment IN number,
60 p_adjusted_basic_pay IN number,
61 p_other_pay IN number,
62 p_fegli IN varchar2,
63 p_retirement_plan IN varchar2,
64 p_retention_allowance IN number,
65 p_staffing_differential IN number,
66 p_supervisory_differential IN number,
67 p_wgi_date_due IN date,
68 p_fegli_desc IN varchar2,
69 p_retirement_plan_desc IN varchar2,
70 p_au_overtime IN number,
71 p_availability_pay IN number,
72 p_auo_premium_pay_indicator IN varchar2,
73 p_ap_premium_pay_indicator IN varchar2,
74 p_to_position_id IN number,
75 p_from_grade_or_level IN varchar2,
76 p_from_pay_plan IN varchar2,
77 p_from_position_title IN varchar2,
78 p_from_position_seq_num IN number,
79 p_duty_station_code IN varchar2,
80 p_duty_station_desc IN varchar2,
81 p_from_step_or_rate IN varchar2,
82 p_tenure IN varchar2,
83 p_annuitant_indicator IN varchar2,
84 p_pay_rate_determinant IN varchar2,
85 p_work_schedule IN varchar2,
86 p_part_time_hours IN number,
87 p_date_arrivd_personnel_office IN date,
88 p_non_disclosure_agmt_status IN varchar2,
89 p_part_time_indicator IN varchar2,
90 p_qualif_standards_waiver IN varchar2,
91 p_education_level IN varchar2,
92 p_academic_discipline IN varchar2,
93 p_year_degree_attained IN varchar2 ,
94 -- Changes 4093771
95 p_to_total_salary IN number,
96 p_to_basic_salary_rate IN number,
97 p_to_adjusted_basic_pay IN number,
98 -- End Changes 4093771
99 --Begin Bug# 8724192
100 p_assignment_nte_start_date IN date,
101 p_assignment_nte IN date
102 --end Bug# 8724192
103 );
104
105 procedure Update_Process_Flag(
106 p_transfer_name IN varchar2,
107 p_include_error IN varchar2,
108 p_override_prev_selection IN varchar2,
109 p_value IN varchar2);
110
111 procedure map_mtv_to_people_f(
112 p_transfer_name IN varchar2,
113 p_inter_bg_transfer IN varchar2,
114 p_effective_date IN date,
115 p_person_id IN number,
116 p_date_of_birth IN date,
117 p_effective_end_date IN date,
118 p_effective_start_date IN date,
119 p_first_name IN varchar2,
120 p_full_name IN varchar2,
121 p_last_name IN varchar2,
122 p_marital_status IN varchar2,
123 p_middle_names IN varchar2,
124 p_national_identifier IN varchar2,
125 p_nationality IN varchar2,
126 p_rehire_reason IN varchar2,
127 p_sex IN varchar2,
128 p_start_date IN date,
129 p_title IN varchar2,
130 p_work_telephone IN varchar2,
131 p_action IN varchar2 );
132
133 procedure map_mtv_to_people_ei1(
134 p_transfer_name IN varchar2,
135 p_effective_date IN date,
136 p_person_id IN number,
137 p_citizenship IN varchar2,
138 p_veterans_preference IN varchar2,
139 p_veterans_preference_for_RIF IN varchar2,
140 p_veterans_status IN varchar2,
141 p_action IN varchar2 );
142
143 procedure map_mtv_to_people_ei2(
144 p_transfer_name IN varchar2,
145 p_effective_date IN date,
146 p_person_id IN number,
147 p_appointment_type IN varchar2,
148 p_type_of_employment IN varchar2,
149 p_race_or_national_origin IN varchar2,
150 -- p_agency_code_transfer_from IN varchar2,
151 p_orig_appointment_auth_code_1 IN varchar2,
152 p_orig_appt_auth_code_1_desc IN varchar2, --Bug# 8724192
153 p_orig_appointment_auth_code_2 IN varchar2,
154 p_orig_appt_auth_code_2_desc IN varchar2, --Bug# 8724192
155 p_handicap_code IN varchar2,
156 p_action IN varchar2 );
157
158 procedure map_mtv_to_people_ei3(
159 p_transfer_name IN varchar2,
160 p_effective_date IN date,
161 p_person_id IN number,
162 p_service_comp_date IN date,
163 p_action IN varchar2 );
164
165 procedure map_mtv_to_people_ei4(
166 p_transfer_name IN varchar2,
167 p_effective_date IN date,
168 p_person_id IN number,
169 -- Bug 2412656 Added FERS Coverage
170 p_fers_coverage IN VARCHAR2,
171 p_previous_retirement_coverage IN varchar2,
172 p_frozen_service IN varchar2,
173 p_action IN varchar2 );
174
175 procedure map_mtv_to_people_ei5(
176 p_transfer_name IN varchar2,
177 p_effective_date IN date,
178 p_person_id IN number,
179 p_creditable_military_service IN varchar2,
180 p_action IN varchar2 );
181
182 procedure map_mtv_to_position_ei1(
183 p_transfer_name IN varchar2,
184 p_person_id IN number,
185 p_effective_date IN date,
186 p_flsa_category IN varchar2,
187 p_bargaining_unit_status IN varchar2,
188 p_functional_class IN varchar2,
189 p_position_working_title IN varchar2,
190 p_supervisory_status IN varchar2,
191 p_action IN varchar2 );
192
193 procedure map_mtv_to_position_ei2(
194 p_transfer_name IN varchar2,
195 p_person_id IN number,
196 p_effective_date IN date,
197 p_position_occupied IN varchar2,
198 p_appropriation_code1 IN varchar2,
199 p_appropriation_code2 IN varchar2,
200 p_action IN varchar2 );
201
202 procedure map_mtv_to_element_entries(
203 p_transfer_name IN varchar2,
204 p_person_id IN number,
205 p_effective_date IN date,
206 p_total_salary IN number,
207 p_basic_salary_rate IN number,
208 p_locality_adjustment IN number,
209 p_adjusted_basic_pay IN number,
210 p_other_pay IN number,
211 p_fegli IN varchar2,
212 p_retirement_plan IN varchar2,
213 p_retention_allowance IN number,
214 p_staffing_differential IN number,
215 p_supervisory_differential IN number,
216 p_wgi_date_due IN date,
217 p_fegli_desc IN varchar2,
218 p_retirement_plan_desc IN varchar2,
219 p_au_overtime IN number,
220 p_availability_pay IN number,
221 p_auo_premium_pay_indicator IN varchar2,
222 p_ap_premium_pay_indicator IN varchar2,
223 -- changes 4093771
224 p_to_total_salary IN number,
225 p_to_basic_salary_rate IN number,
226 p_to_adjusted_basic_pay IN number,
227 -- End changes 4093771
228 p_action IN varchar2 );
229
230 procedure map_mtv_to_misc(
231 p_transfer_name IN varchar2,
232 p_person_id IN number,
233 p_effective_date IN date,
234 p_to_position_id IN number,
235 p_from_grade_or_level IN varchar2,
236 p_from_pay_plan IN varchar2,
237 p_from_position_title IN varchar2,
238 p_from_position_seq_num IN number,
239 p_duty_station_code IN varchar2,
240 p_duty_station_desc IN varchar2,
241 p_from_agency_code IN varchar2,
242 p_action IN varchar2 );
243
244 procedure map_mtv_to_assign_ei1(
245 p_transfer_name IN varchar2,
246 p_person_id IN number,
247 p_effective_date IN date,
248 p_from_step_or_rate IN varchar2,
249 p_tenure IN varchar2,
250 p_annuitant_indicator IN varchar2,
251 p_pay_rate_determinant IN varchar2,
252 p_work_schedule IN varchar2,
253 p_part_time_hours IN number ,
254 p_action IN varchar2 );
255
256 procedure map_mtv_to_assign_ei2(
257 p_transfer_name IN varchar2,
258 p_person_id IN number,
259 p_effective_date IN date,
260 p_date_arrivd_personnel_office IN date,
261 p_non_disclosure_agmt_status IN varchar2,
262 p_part_time_indicator IN varchar2,
263 p_qualif_standards_waiver IN varchar2,
264 p_action IN varchar2 );
265
266 --Begin Bug# 8724192
267 procedure map_mtv_to_assign_ei3(
268 p_transfer_name IN varchar2,
269 p_person_id IN number,
270 p_effective_date IN date,
271 p_assignment_nte_start_date IN date,
272 p_assignment_nte IN date,
273 p_action IN varchar2 );
274 --End Bug# 8724192
275
276 procedure map_mtv_to_special_info(
277 p_transfer_name IN varchar2,
278 p_effective_date IN date,
279 p_person_id IN number,
280 p_education_level IN varchar2,
281 p_academic_discipline IN varchar2,
282 p_year_degree_attained IN varchar2,
283 p_action IN varchar2 );
284
285 procedure map_mtv_to_assign_f(
286 p_transfer_name IN varchar2,
287 p_effective_date IN date,
288 p_assignment_id IN number);
289
290 procedure map_mtv_to_position(
291 p_transfer_name IN varchar2,
292 p_person_id IN number,
293 p_effective_date IN date,
294 p_position_id IN number);
295
296 function Submit_MTI_Request (
297 P_DESCRIPTION IN VARCHAR2,
298 P_ARGUMENT1 IN VARCHAR2,
299 P_ARGUMENT2 IN VARCHAR2)
300 RETURN NUMBER;
301
302 Procedure set_process_flag(
303 p_mt_name in varchar2,
304 p_mt_person_id in number,
305 p_mt_status in varchar2);
306
307 FUNCTION get_lookup_meaning(
308 p_lookup_type hr_lookups.lookup_type%TYPE
309 ,p_lookup_code hr_lookups.lookup_code%TYPE)
310 RETURN VARCHAR2;
311
312 -- Removed reference because it failed to compile
313 -- for 8i pragma are not required (see bug# 1014743)
314 -- pragma restrict_references (get_lookup_meaning, WNDS, WNPS);
315
316
317
318 end ghr_mti_int_insert;
[Home] [Help]