1 package per_new_hire_pkg as
2 /* $Header: pernhire.pkh 120.1.12010000.2 2008/08/06 09:35:01 ubhat ship $ */
3
4 --
5 -- Changed to return converted characters because of Reports'
6 -- convert function bug.
7 -- When running Reports, user have to run in the environment
8 -- without character conversion, that is, nls_characterset
9 -- must always be the same as DB characterset.
10 -- But user do not have to care about this because Reports runs
11 -- by Concurrent Manager whose nls_characterset is always be the
12 -- same as DB characterset.
13 --
14 procedure char_set_init
15 (
16 p_character_set in varchar2
17 );
18
19 function ca_e4_record
20 (
21 p_record_identifier in varchar2
22 ,p_federal_id in varchar2
23 ,p_sit_company_state_id in varchar2
24 ,p_branch_code in varchar2
25 ,p_tax_unit_name in varchar2
26 ,p_street_address in varchar2
27 ,p_city in varchar2
28 ,p_state in varchar2
29 ,p_zip in varchar2
30 ,p_zip_extension in varchar2 default null
31 ) return varchar2;
32
33 function ca_w4_record
34 (
35 p_record_identifier in varchar2
36 ,p_national_identifier in varchar2
37 ,p_first_name in varchar2
38 ,p_middle_name in varchar2
39 ,p_last_name in varchar2
40 ,p_street_address in varchar2
41 ,p_city in varchar2
42 ,p_state in varchar2
43 ,p_zip in varchar2
44 ,p_zip_extension in varchar2 default null
45 ,p_date_of_hire in date
46 ) return varchar2;
47
48 function ca_t4_record
49 (
50 p_record_identifier in varchar2
51 ,p_number_of_employee in number
52 ) return varchar2;
53
54 function ny_1a_record
55 (
56 p_record_identifier in varchar2
57 ,p_creation_date in varchar2
58 ,p_federal_id in varchar2
59 ,p_tax_unit_name in varchar2
60 ,p_street_address in varchar2
61 ,p_city in varchar2
62 ,p_state in varchar2
63 ,p_zip in varchar2
64 ) return varchar2;
65
66 function ny_1e_record
67 (
68 p_record_identifier in varchar2
69 ,p_federal_id in varchar2
70 ,p_tax_unit_name in varchar2
71 ,p_street_address in varchar2
72 ,p_city in varchar2
73 ,p_state in varchar2
74 ,p_zip in varchar2
75 ) return varchar2;
76
77 function ny_1h_record
78 (
79 p_record_identifier in varchar2
80 ,p_national_identifier in varchar2
81 ,p_first_name in varchar2
82 ,p_middle_name in varchar2
83 ,p_last_name in varchar2
84 ,p_street_address in varchar2
85 ,p_city in varchar2
86 ,p_state in varchar2
87 ,p_zip in varchar2
88 ,p_date_of_hire in date
89 ) return varchar2;
90
91 function ny_1t_record
92 (
93 p_record_identifier in varchar2
94 ,p_number_of_employee in number
95 ) return varchar2;
96
97 function ny_1f_record
98 (
99 p_record_identifier in varchar2
100 ,p_number_of_employer in number
101 ) return varchar2;
102 function al_new_hire_record
103 (
104 p_national_identifier in varchar2
105 ,p_dir_acc_number in varchar2
106 ,p_date_of_hire in date
107 ,p_indicator in varchar2
108 ,p_first_name in varchar2
109 ,p_middle_name in varchar2
110 ,p_last_name in varchar2
111 ,p_emp_address_line1 in varchar2
112 ,p_emp_address_line2 in varchar2
113 ,p_emp_address_line3 in varchar2
114 ,p_emp_city in varchar2
115 ,p_emp_state in varchar2
116 ,p_emp_zip in varchar2
117 ,p_emp_zip_extension in varchar2
118 ,p_federal_id in varchar2
119 ,p_tax_unit_name in varchar2
120 ,p_loc_address_line1 in varchar2
121 ,p_loc_address_line2 in varchar2
122 ,p_loc_address_line3 in varchar2
123 ,p_loc_city in varchar2
124 ,p_loc_state in varchar2
125 ,p_loc_zip in varchar2
126 ,p_blanks in varchar2
127 ) return varchar2;
128 function fl_new_hire_record
129 (
130 p_record_identifier in varchar2
131 ,p_first_name in varchar2
132 ,p_middle_name in varchar2
133 ,p_last_name in varchar2
134 ,p_national_identifier in varchar2
135 ,p_emp_address_line1 in varchar2
136 ,p_emp_address_line2 in varchar2
137 ,p_emp_address_line3 in varchar2
138 ,p_emp_city in varchar2
139 ,p_emp_state in varchar2
140 ,p_emp_zip in varchar2
141 ,p_emp_zip_extension in varchar2
142 ,p_emp_country_code in varchar2
143 ,p_date_of_birth in date
144 ,p_date_of_hire in date
145 ,p_state_of_hire in varchar2
146 ,p_federal_id in varchar2
147 ,p_sit_company_state_id in varchar2
148 ,p_tax_unit_name in varchar2
149 ,p_loc_address_line1 in varchar2
150 ,p_loc_address_line2 in varchar2
151 ,p_loc_address_line3 in varchar2
152 ,p_loc_city in varchar2
153 ,p_loc_state in varchar2
154 ,p_loc_zip in varchar2
155 ,p_loc_zip_extension in varchar2
156 ,p_loc_country_code in varchar2
157 ,p_loc_phone in varchar2
158 ,p_loc_phone_extension in varchar2
159 ,p_loc_contact in varchar2
160 ,p_opt_address_line1 in varchar2
161 ,p_opt_address_line2 in varchar2
162 ,p_opt_address_line3 in varchar2
163 ,p_opt_city in varchar2
164 ,p_opt_state in varchar2
165 ,p_opt_zip in varchar2
166 ,p_opt_zip_extension in varchar2
167 ,p_opt_country_code in varchar2
168 ,p_opt_phone in varchar2
169 ,p_opt_phone_extension in varchar2
170 ,p_opt_contact in varchar2
171 ,p_multi_state in varchar2
172 ) return varchar2;
173
174 function il_new_hire_record
175 (
176 p_record_identifier in varchar2
177 ,p_national_identifier in varchar2
178 ,p_first_name in varchar2
179 ,p_middle_name in varchar2
180 ,p_last_name in varchar2
181 ,p_emp_address_line1 in varchar2
182 ,p_emp_address_line2 in varchar2
183 ,p_emp_city in varchar2
184 ,p_emp_state in varchar2
185 ,p_emp_zip in varchar2
186 ,p_emp_zip_extension in varchar2
187 ,p_date_of_hire in date
188 ,p_federal_id in varchar2
189 ,p_tax_unit_name in varchar2
190 ,p_loc_address_line1 in varchar2
191 ,p_loc_address_line2 in varchar2
192 ,p_loc_city in varchar2
193 ,p_loc_state in varchar2
194 ,p_loc_zip in varchar2
195 ,p_loc_zip_extension in varchar2
196 ,p_opt_address_line1 in varchar2
197 ,p_opt_address_line2 in varchar2
198 ,p_opt_city in varchar2
199 ,p_opt_state in varchar2
200 ,p_opt_zip in varchar2
201 ,p_opt_zip_extension in varchar2
202 ) return varchar2;
203
204 function tx_t4_record
205 (
206 p_record_identifier in varchar2
207 ,p_number_of_employee in number
208 ) return varchar2;
209
210 function tx_new_hire_record
211 (
212 p_record_identifier in varchar2
213 ,p_national_identifier in varchar2
214 ,p_first_name in varchar2
215 ,p_middle_name in varchar2
216 ,p_last_name in varchar2
217 ,p_emp_address_line1 in varchar2
218 ,p_emp_address_line2 in varchar2
219 ,p_emp_city in varchar2
220 ,p_emp_state in varchar2
221 ,p_emp_zip in varchar2
222 ,p_emp_zip_extension in varchar2
223 ,p_emp_country_code in varchar2
224 ,p_emp_country_name in varchar2
225 ,p_emp_country_zip in varchar2
226 ,p_date_of_birth in date
227 ,p_date_of_hire in date
228 ,p_state_of_hire in varchar2
229 ,p_federal_id in varchar2
230 ,p_state_ein in varchar2
231 ,p_tax_unit_name in varchar2
232 ,p_loc_address_line1 in varchar2
233 ,p_loc_address_line2 in varchar2
234 ,p_loc_address_line3 in varchar2
235 ,p_loc_city in varchar2
236 ,p_loc_state in varchar2
237 ,p_loc_zip in varchar2
238 ,p_loc_zip_extension in varchar2
239 ,p_loc_country_code in varchar2
240 ,p_loc_country_name in varchar2
241 ,p_loc_country_zip in varchar2
242 ,p_opt_address_line1 in varchar2
243 ,p_opt_address_line2 in varchar2
244 ,p_opt_address_line3 in varchar2
245 ,p_opt_city in varchar2
246 ,p_opt_state in varchar2
247 ,p_opt_zip in varchar2
248 ,p_opt_zip_extension in varchar2
249 ,p_opt_country_code in varchar2
250 ,p_opt_country_name in varchar2
251 ,p_opt_country_zip in varchar2
252 ,p_salary in varchar2
253 ,p_frequency in varchar2
254 ) return varchar2;
255
256
257 function a03_ca_new_hire_header return varchar2;
258 function a03_il_new_hire_header return varchar2;
259 function a03_tx_new_hire_header return varchar2;
260 function a03_ny_new_hire_header return varchar2;
261 function a03_fl_new_hire_header return varchar2;
262 function a03_al_new_hire_header return varchar2;
263
264 function a03_ny_new_hire_record
265 (
266 p_national_identifier in varchar2
267 ,p_first_name in varchar2
268 ,p_middle_name in varchar2
269 ,p_last_name in varchar2
270 ,p_emp_address_line in varchar2
271 ,p_emp_city in varchar2
272 ,p_emp_state in varchar2
273 ,p_emp_zip in varchar2
274 ,p_date_of_hire in date
275 ) return varchar2;
276
277 function a03_il_new_hire_record
278 (
279 p_national_identifier in varchar2
280 ,p_first_name in varchar2
281 ,p_middle_name in varchar2
282 ,p_last_name in varchar2
283 ,p_emp_address_line1 in varchar2
284 ,p_emp_address_line2 in varchar2
285 ,p_emp_city in varchar2
286 ,p_emp_state in varchar2
287 ,p_emp_zip in varchar2
288 ,p_emp_zip_extension in varchar2
289 ,p_date_of_hire in date
290 ,p_federal_id in varchar2
291 ,p_tax_unit_name in varchar2
292 ,p_loc_address_line1 in varchar2
293 ,p_loc_address_line2 in varchar2
294 ,p_loc_city in varchar2
295 ,p_loc_state in varchar2
296 ,p_loc_zip in varchar2
297 ,p_loc_zip_extension in varchar2
298 ) return varchar2;
299
300 function a03_fl_new_hire_record
301 (
302 p_national_identifier in varchar2
303 ,p_first_name in varchar2
304 ,p_middle_name in varchar2
305 ,p_last_name in varchar2
306 ,p_emp_address_line1 in varchar2
307 ,p_emp_address_line2 in varchar2
308 ,p_emp_address_line3 in varchar2
309 ,p_emp_city in varchar2
310 ,p_emp_state in varchar2
311 ,p_emp_zip in varchar2
312 ,p_emp_zip_extension in varchar2
313 ,p_emp_country_code in varchar2
314 ,p_date_of_birth in date
315 ,p_date_of_hire in date
316 ,p_state_of_hire in varchar2
317 ,p_federal_id in varchar2
318 ,p_state_ein in varchar2
319 ,p_tax_unit_name in varchar2
320 ,p_loc_address_line1 in varchar2
321 ,p_loc_address_line2 in varchar2
322 ,p_loc_address_line3 in varchar2
323 ,p_loc_city in varchar2
324 ,p_loc_state in varchar2
325 ,p_loc_zip in varchar2
326 ,p_loc_zip_extension in varchar2
327 ,p_loc_country_code in varchar2
328 ,p_contact_phone in varchar2
329 ,p_contact_phone_ext in varchar2
330 ,p_contact_name in varchar2
331 ,p_multi_state in varchar2
332 ) return varchar2;
333 function a03_al_new_hire_record
334 (
335 p_national_identifier in varchar2
336 ,p_first_name in varchar2
337 ,p_middle_name in varchar2
338 ,p_last_name in varchar2
339 ,p_emp_address_line1 in varchar2
340 ,p_emp_address_line2 in varchar2
341 ,p_emp_address_line3 in varchar2
342 ,p_emp_city in varchar2
343 ,p_emp_state in varchar2
344 ,p_emp_zip in varchar2
345 ,p_emp_zip_extension in varchar2
346 ,p_emp_country_code in varchar2
347 ,p_date_of_birth in date
348 ,p_date_of_hire in date
349 ,p_state_of_hire in varchar2
350 ,p_federal_id in varchar2
354 ,p_loc_address_line2 in varchar2
351 ,p_state_ein in varchar2
352 ,p_tax_unit_name in varchar2
353 ,p_loc_address_line1 in varchar2
355 ,p_loc_address_line3 in varchar2
356 ,p_loc_city in varchar2
357 ,p_loc_state in varchar2
358 ,p_loc_zip in varchar2
359 ,p_loc_zip_extension in varchar2
360 ,p_loc_country_code in varchar2
361 ,p_contact_phone in varchar2
362 ,p_contact_phone_ext in varchar2
363 ,p_contact_name in varchar2
364 ,p_multi_state in varchar2
365 ) return varchar2;
366
367 function a03_tx_new_hire_record
368 (
369 p_national_identifier in varchar2
370 ,p_first_name in varchar2
371 ,p_middle_name in varchar2
372 ,p_last_name in varchar2
373 ,p_emp_address_line1 in varchar2
374 ,p_emp_address_line2 in varchar2
375 ,p_emp_address_line3 in varchar2
376 ,p_emp_city in varchar2
377 ,p_emp_state in varchar2
378 ,p_emp_zip in varchar2
379 ,p_emp_zip_extension in varchar2
380 ,p_emp_country_code in varchar2
381 ,p_emp_country_name in varchar2
382 ,p_emp_country_zip in varchar2
383 ,p_date_of_birth in date
384 ,p_date_of_hire in date
385 ,p_state_of_hire in varchar2
389 ,p_loc_address_line1 in varchar2
386 ,p_federal_id in varchar2
387 ,p_state_ein in varchar2
388 ,p_tax_unit_name in varchar2
390 ,p_loc_address_line2 in varchar2
391 ,p_loc_address_line3 in varchar2
392 ,p_loc_city in varchar2
393 ,p_loc_state in varchar2
394 ,p_loc_zip in varchar2
395 ,p_loc_zip_extension in varchar2
396 ,p_loc_country_code in varchar2
397 ,p_loc_country_name in varchar2
398 ,p_loc_country_zip in varchar2
399 ) return varchar2;
400
401 function a03_ca_new_hire_record
402 (
403 p_national_identifier in varchar2
404 ,p_first_name in varchar2
405 ,p_middle_name in varchar2
406 ,p_last_name in varchar2
407 ,p_emp_address_line in varchar2
408 ,p_emp_city in varchar2
409 ,p_emp_state in varchar2
410 ,p_emp_zip in varchar2
411 ,p_emp_zip_extension in varchar2
412 ,p_date_of_hire in date
413 ) return varchar2;
414
415 PROCEDURE get_location_address
416 (
417 p_location_id in number
418 ,p_address out nocopy varchar2
419 ,p_city out nocopy varchar2
420 ,p_state out nocopy varchar2
421 ,p_zip out nocopy varchar2
422 ,p_zip_extension out nocopy varchar2
423 );
424
425 PROCEDURE get_location_address_3lines
426 (
427 p_location_id in number
428 ,p_address_line1 out nocopy varchar2
429 ,p_address_line2 out nocopy varchar2
430 ,p_address_line3 out nocopy varchar2
431 ,p_city out nocopy varchar2
432 ,p_state out nocopy varchar2
433 ,p_zip out nocopy varchar2
434 ,p_zip_extension out nocopy varchar2
435 ,p_country out nocopy varchar2
436 );
437
438 PROCEDURE get_employee_address
439 (
440 p_person_id in number
441 ,p_address out nocopy varchar2
442 ,p_city out nocopy varchar2
443 ,p_state out nocopy varchar2
444 ,p_zip out nocopy varchar2
445 ,p_zip_extension out nocopy varchar2
446 );
447
448 PROCEDURE get_employee_address_3lines
449 (
450 p_person_id in number
451 ,p_address_line1 out nocopy varchar2
452 ,p_address_line2 out nocopy varchar2
453 ,p_address_line3 out nocopy varchar2
454 ,p_city out nocopy varchar2
455 ,p_state out nocopy varchar2
456 ,p_zip out nocopy varchar2
457 ,p_zip_extension out nocopy varchar2
458 ,p_country out nocopy varchar2
459 );
460 --
464 ,p_report_date in date
461 procedure get_new_hire_contact(
462 p_person_id in number
463 ,p_business_group_id in number
465 ,p_contact_name out nocopy varchar2
466 ,p_contact_title out nocopy varchar2
467 ,p_contact_phone out nocopy varchar2
468 ) ;
469 end per_new_hire_pkg;