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