1 package per_new_hire_pkg AUTHID CURRENT_USER as
2 /* $Header: pernhire.pkh 120.3.12020000.5 2012/09/03 09:16:40 agarai 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 ,p_medical_avail in varchar2 --#10014495
90 ,p_health_ins_date in date --#10014495
91 ,p_new_hire_indicator in varchar2 --#14532612
92 ) return varchar2;
93
94 function ny_1t_record
95 (
96 p_record_identifier in varchar2
97 ,p_number_of_employee in number
98 ) return varchar2;
99
100 function ny_1f_record
101 (
102 p_record_identifier in varchar2
103 ,p_number_of_employer in number
104 ) return varchar2;
105 function al_new_hire_record
106 (
107 p_national_identifier in varchar2
108 ,p_dir_acc_number in varchar2
109 ,p_date_of_hire in date
110 ,p_indicator in varchar2
111 ,p_first_name in varchar2
112 ,p_middle_name in varchar2
113 ,p_last_name in varchar2
114 ,p_emp_address_line1 in varchar2
115 ,p_emp_address_line2 in varchar2
116 ,p_emp_address_line3 in varchar2
117 ,p_emp_city in varchar2
118 ,p_emp_state in varchar2
119 ,p_emp_zip in varchar2
120 ,p_emp_zip_extension in varchar2
121 ,p_federal_id in varchar2
122 ,p_tax_unit_name in varchar2
123 ,p_loc_address_line1 in varchar2
124 ,p_loc_address_line2 in varchar2
125 ,p_loc_address_line3 in varchar2
126 ,p_loc_city in varchar2
127 ,p_loc_state in varchar2
128 ,p_loc_zip in varchar2
129 ,p_blanks in varchar2
130 ) return varchar2;
131 function fl_new_hire_record
132 (
133 p_record_identifier in varchar2
134 ,p_first_name in varchar2
135 ,p_middle_name in varchar2
136 ,p_last_name in varchar2
137 ,p_national_identifier in varchar2
138 ,p_emp_address_line1 in varchar2
139 ,p_emp_address_line2 in varchar2
140 ,p_emp_address_line3 in varchar2
141 ,p_emp_city in varchar2
142 ,p_emp_state in varchar2
143 ,p_emp_zip in varchar2
144 ,p_emp_zip_extension in varchar2
145 ,p_emp_country_code in varchar2
146 ,p_date_of_birth in date
147 ,p_date_of_hire in date
148 ,p_state_of_hire in varchar2
149 ,p_medical_insr_avail in varchar2 --#13082528
150 ,p_federal_id in varchar2
151 ,p_sit_company_state_id in varchar2
152 ,p_tax_unit_name in varchar2
153 ,p_loc_address_line1 in varchar2
154 ,p_loc_address_line2 in varchar2
155 ,p_loc_address_line3 in varchar2
156 ,p_loc_city in varchar2
157 ,p_loc_state in varchar2
158 ,p_loc_zip in varchar2
159 ,p_loc_zip_extension in varchar2
160 ,p_loc_country_code in varchar2
161 ,p_loc_phone in varchar2
162 ,p_loc_phone_extension in varchar2
163 ,p_loc_contact in varchar2
164 ,p_opt_address_line1 in varchar2
165 ,p_opt_address_line2 in varchar2
166 ,p_opt_address_line3 in varchar2
167 ,p_opt_city in varchar2
168 ,p_opt_state in varchar2
169 ,p_opt_zip in varchar2
170 ,p_opt_zip_extension in varchar2
171 ,p_opt_country_code in varchar2
172 ,p_opt_phone in varchar2
173 ,p_opt_phone_extension in varchar2
174 ,p_opt_contact in varchar2
175 ,p_multi_state in varchar2
176 ) return varchar2;
177
178 function il_new_hire_record
179 (
180 p_record_identifier in varchar2
181 ,p_national_identifier in varchar2
182 ,p_first_name in varchar2
183 ,p_middle_name in varchar2
184 ,p_last_name in varchar2
185 ,p_emp_address_line1 in varchar2
186 ,p_emp_address_line2 in varchar2
187 ,p_emp_city in varchar2
188 ,p_emp_state in varchar2
189 ,p_emp_zip in varchar2
190 ,p_emp_zip_extension in varchar2
191 ,p_date_of_hire in date
192 ,p_federal_id in varchar2
193 ,p_tax_unit_name in varchar2
194 ,p_loc_address_line1 in varchar2
195 ,p_loc_address_line2 in varchar2
196 ,p_loc_city in varchar2
197 ,p_loc_state in varchar2
198 ,p_loc_zip in varchar2
199 ,p_loc_zip_extension in varchar2
200 ,p_opt_address_line1 in varchar2
201 ,p_opt_address_line2 in varchar2
202 ,p_opt_city in varchar2
203 ,p_opt_state in varchar2
204 ,p_opt_zip in varchar2
205 ,p_opt_zip_extension in varchar2
206 ) return varchar2;
207
208 function tx_t4_record
209 (
210 p_record_identifier in varchar2
211 ,p_number_of_employee in number
212 ) return varchar2;
213
214 function tx_new_hire_record
215 (
216 p_record_identifier in varchar2
217 ,p_national_identifier in varchar2
218 ,p_first_name in varchar2
219 ,p_middle_name in varchar2
220 ,p_last_name in varchar2
221 ,p_emp_address_line1 in varchar2
222 ,p_emp_address_line2 in varchar2
223 ,p_emp_city in varchar2
224 ,p_emp_state in varchar2
225 ,p_emp_zip in varchar2
226 ,p_emp_zip_extension in varchar2
227 ,p_emp_country_code in varchar2
228 ,p_emp_country_name in varchar2
229 ,p_emp_country_zip in varchar2
230 ,p_date_of_birth in date
231 ,p_date_of_hire in date
232 ,p_state_of_hire in varchar2
233 ,p_federal_id in varchar2
234 ,p_state_ein in varchar2
235 ,p_tax_unit_name in varchar2
236 ,p_loc_address_line1 in varchar2
237 ,p_loc_address_line2 in varchar2
238 ,p_loc_address_line3 in varchar2
239 ,p_loc_city in varchar2
240 ,p_loc_state in varchar2
241 ,p_loc_zip in varchar2
242 ,p_loc_zip_extension in varchar2
243 ,p_loc_country_code in varchar2
244 ,p_loc_country_name in varchar2
245 ,p_loc_country_zip in varchar2
246 ,p_opt_address_line1 in varchar2
247 ,p_opt_address_line2 in varchar2
248 ,p_opt_address_line3 in varchar2
249 ,p_opt_city in varchar2
250 ,p_opt_state in varchar2
251 ,p_opt_zip in varchar2
252 ,p_opt_zip_extension in varchar2
253 ,p_opt_country_code in varchar2
254 ,p_opt_country_name in varchar2
255 ,p_opt_country_zip in varchar2
256 ,p_salary in varchar2
257 ,p_frequency in varchar2
258 ) return varchar2;
259 -- #10387522 start
260
261 function sc_header_record
262 (
263 p_federal_id in varchar2
264 ,p_tax_unit_name in varchar2
265 ,p_add_line1 in varchar2
266 ,p_add_line2 in varchar2
267 ,p_city in varchar2
268 ,p_state in varchar2
269 ,p_zip in varchar2
270 ,p_phone_no in varchar2
271 ,p_record_identifier in varchar2
272 ) return varchar2;
273
274 function sc_new_hire_record
275 (
276 p_national_identifier in varchar2
277 ,p_first_name in varchar2
278 ,p_middle_name in varchar2
279 ,p_last_name in varchar2
280 ,p_add_line1 in varchar2
281 ,p_add_line2 in varchar2
282 ,p_city in varchar2
283 ,p_state in varchar2
284 ,p_zip in varchar2
285 ,p_date_of_birth in date
286 ,p_date_of_hire in date
287 ,p_record_identifier in varchar2
288 ) return varchar2;
289
290 function mi_new_hire_record
291 (
292 p_national_identifier in varchar2
293 ,p_first_name in varchar2
294 ,p_middle_name in varchar2
295 ,p_last_name in varchar2
296 ,p_tax_unit_name in varchar2
297 ,p_federal_id in varchar2
298 ,p_loc_address_line1 in varchar2
299 ,p_loc_address_line2 in varchar2
300 ,p_loc_city in varchar2
301 ,p_loc_state in varchar2
302 ,p_loc_zip in varchar2
303 ,p_loc_zip_extension in varchar2
304 ,p_emp_address_line1 in varchar2
305 ,p_emp_address_line2 in varchar2
306 ,p_emp_city in varchar2
307 ,p_emp_state in varchar2
308 ,p_emp_zip in varchar2
309 ,p_emp_zip_extension in varchar2
310 ,p_date_of_birth in date
311 ,p_date_of_hire in date
312 ,p_dl_number in varchar2
313 ) return varchar2;
314 --
315 function oh_header_record
316 (
317 p_record_identifier in varchar2
318 ,p_report_date in date
319 ,p_number_of_employee in number
320 ) return varchar2;
321 --
322 function oh_new_hire_record
323 (
324 p_record_identifier in varchar2
325 ,p_national_identifier in varchar2
326 ,p_first_name in varchar2
327 ,p_middle_name in varchar2
328 ,p_last_name in varchar2
329 ,p_emp_address_line1 in varchar2
330 ,p_emp_address_line2 in varchar2
331 ,p_emp_address_line3 in varchar2
332 ,p_emp_city in varchar2
333 ,p_emp_state in varchar2
334 ,p_emp_zip in varchar2
335 ,p_emp_zip_extension in varchar2
336 ,p_emp_country_code in varchar2
337 ,p_emp_country_name in varchar2
338 ,p_emp_country_zip in varchar2
339 ,p_date_of_birth in date
340 ,p_date_of_hire in date
341 ,p_state_of_hire in varchar2
342 ,p_gender in varchar2
343 ,p_left_work in varchar2
344 ,p_federal_id in varchar2
345 ,p_inc_tax_credit in varchar2
346 ,p_state_ein in varchar2
347 ,p_tax_unit_name in varchar2
348 ,p_loc_address_line1 in varchar2
349 ,p_loc_address_line2 in varchar2
350 ,p_loc_address_line3 in varchar2
351 ,p_loc_city in varchar2
352 ,p_loc_state in varchar2
353 ,p_loc_zip in varchar2
354 ,p_loc_zip_extension in varchar2
355 ,p_loc_country_code in varchar2
356 ,p_loc_country_name in varchar2
357 ,p_loc_country_zip in varchar2
358 ,p_opt_address_line1 in varchar2
359 ,p_opt_address_line2 in varchar2
360 ,p_opt_address_line3 in varchar2
361 ,p_opt_city in varchar2
362 ,p_opt_state in varchar2
363 ,p_opt_zip in varchar2
364 ,p_opt_zip_extension in varchar2
365 ,p_opt_country_code in varchar2
366 ,p_opt_country_name in varchar2
367 ,p_opt_country_zip in varchar2
368 ,p_emp_ic in varchar2
369 ,p_ic_pay_date in date
370 ,p_ic_length in number
371 ) return varchar2;
372 --
373 function pa_new_hire_record
374 (
375 p_record_identifier in varchar2
376 ,p_federal_id in varchar2
377 ,p_tax_unit_name in varchar2
378 ,p_loc_address_line1 in varchar2
379 ,p_loc_address_line2 in varchar2
380 ,p_loc_address_line3 in varchar2
381 ,p_loc_city in varchar2
382 ,p_loc_state in varchar2
383 ,p_loc_zip in varchar2
384 ,p_loc_zip_extension in varchar2
385 ,p_contact_first_name in varchar2
386 ,p_contact_last_name in varchar2
387 ,p_contact_ph_no in varchar2
388 ,p_contact_ph_no_ext in number
389 ,p_national_identifier in varchar2
390 ,p_first_name in varchar2
391 ,p_middle_name in varchar2
392 ,p_last_name in varchar2
393 ,p_date_of_birth in date
394 ,p_state_of_hire in varchar2
395 ,p_date_of_hire in date
396 ,p_emp_address_line1 in varchar2
397 ,p_emp_address_line2 in varchar2
398 ,p_emp_address_line3 in varchar2
399 ,p_emp_city in varchar2
400 ,p_emp_state in varchar2
401 ,p_emp_zip in varchar2
402 ,p_emp_zip_extension in varchar2
403 ) return varchar2;
404 --
405 function ar_new_hire_record
406 (
407 p_record_identifier in varchar2
408 ,p_first_name in varchar2
409 ,p_middle_name in varchar2
410 ,p_last_name in varchar2
411 ,p_national_identifier in varchar2
412 ,p_emp_address_line1 in varchar2
413 ,p_emp_address_line2 in varchar2
414 ,p_emp_address_line3 in varchar2
415 ,p_emp_city in varchar2
416 ,p_emp_state in varchar2
417 ,p_emp_zip in varchar2
418 ,p_emp_zip_extension in varchar2
419 ,p_emp_country_code in varchar2
420 ,p_date_of_birth in date
421 ,p_date_of_hire in date
422 ,p_state_of_hire in varchar2
423 ,p_federal_id in varchar2
424 ,p_sit_company_state_id in varchar2
425 ,p_tax_unit_name in varchar2
426 ,p_loc_address_line1 in varchar2
427 ,p_loc_address_line2 in varchar2
428 ,p_loc_address_line3 in varchar2
429 ,p_loc_city in varchar2
430 ,p_loc_state in varchar2
431 ,p_loc_zip in varchar2
432 ,p_loc_zip_extension in varchar2
433 ,p_loc_country_code in varchar2
434 ,p_loc_phone in varchar2
435 ,p_loc_phone_extension in varchar2
436 ,p_loc_contact in varchar2
437 ,p_opt_address_line1 in varchar2
438 ,p_opt_address_line2 in varchar2
439 ,p_opt_address_line3 in varchar2
440 ,p_opt_city in varchar2
441 ,p_opt_state in varchar2
442 ,p_opt_zip in varchar2
443 ,p_opt_zip_extension in varchar2
444 ,p_opt_country_code in varchar2
445 ,p_opt_phone in varchar2
446 ,p_opt_phone_extension in varchar2
447 ,p_opt_contact in varchar2
448 ) return varchar2;
449 --
450 function md_new_hire_record
451 (
452 p_record_identifier in varchar2
453 ,p_first_name in varchar2
454 ,p_middle_name in varchar2
455 ,p_last_name in varchar2
456 ,p_national_identifier in varchar2
457 ,p_emp_address_line1 in varchar2
458 ,p_emp_address_line2 in varchar2
459 ,p_emp_address_line3 in varchar2
460 ,p_emp_city in varchar2
461 ,p_emp_state in varchar2
462 ,p_emp_zip in varchar2
463 ,p_emp_zip_extension in varchar2
464 ,p_emp_country_code in varchar2
465 ,p_date_of_birth in date
466 ,p_date_of_hire in date
467 ,p_state_of_hire in varchar2
468 ,p_medical_insr_avail in varchar2
469 ,p_federal_id in varchar2
470 ,p_suin_company_state_id in varchar2
471 ,p_tax_unit_name in varchar2
472 ,p_loc_address_line1 in varchar2
473 ,p_loc_address_line2 in varchar2
474 ,p_loc_address_line3 in varchar2
475 ,p_loc_city in varchar2
476 ,p_loc_state in varchar2
477 ,p_loc_zip in varchar2
478 ,p_loc_zip_extension in varchar2
479 ,p_loc_country_code in varchar2
480 ,p_loc_phone in varchar2
481 ,p_loc_phone_extension in varchar2
482 ,p_loc_contact in varchar2
483 ,p_gender in varchar2
484 ,p_loc_fax in varchar2
485 ,p_loc_email in varchar2
486 ,p_salary in varchar2
487 ,p_sal_frequency in varchar2
488 ) return varchar2;
489 --
490 function la_new_hire_record
491 (
492 p_first_name in varchar2
493 ,p_middle_name in varchar2
494 ,p_last_name in varchar2
495 ,p_suffix in varchar2
496 ,p_national_identifier in varchar2
497 ,p_emp_address_line1 in varchar2
498 ,p_emp_address_line2 in varchar2
499 ,p_emp_address_line3 in varchar2
500 ,p_emp_city in varchar2
501 ,p_emp_state in varchar2
502 ,p_emp_zip in varchar2
503 ,p_emp_zip_extension in varchar2
504 ,p_emp_country_code in varchar2
505 ,p_emp_country_name in varchar2
506 ,p_emp_country_zip in varchar2
507 ,p_emp_marital_status in varchar2
508 ,p_date_of_hire in date
509 ,p_tax_unit_name in varchar2
510 ,p_loc_address_line1 in varchar2
511 ,p_loc_address_line2 in varchar2
512 ,p_loc_address_line3 in varchar2
513 ,p_loc_city in varchar2
514 ,p_loc_state in varchar2
515 ,p_loc_zip in varchar2
516 ,p_loc_zip_extension in varchar2
517 ,p_loc_country_code in varchar2
518 ,p_loc_country_name in varchar2
519 ,p_loc_country_zip in varchar2
520 ,p_federal_id in varchar2
521 ,p_sit_company_state_id in varchar2
522 ,p_job in varchar2
523 ,p_salary in varchar2
524 ,p_sal_frequency in varchar2
525 ,p_state_of_hire in varchar2
526 ,p_date_of_birth in date
527 ,p_emp_insr_ind in varchar2
528 ,p_serv_address_line1 in varchar2
529 ,p_serv_address_line2 in varchar2
530 ,p_serv_address_line3 in varchar2
531 ,p_serv_city in varchar2
532 ,p_serv_state in varchar2
533 ,p_serv_zip in varchar2
534 ,p_serv_zip_extension in varchar2
535 ,p_serv_country_code in varchar2
536 ,p_serv_country_name in varchar2
537 ,p_serv_country_zip in varchar2
538 ,p_loc_contact_first_name in varchar2
539 ,p_loc_contact_last_name in varchar2
540 ,p_loc_phone in varchar2
541 ) return varchar2;
542 -- #10387522 end
543
544 function a03_ca_new_hire_header return varchar2;
545 function a03_il_new_hire_header return varchar2;
546 function a03_tx_new_hire_header return varchar2;
547 function a03_ny_new_hire_header return varchar2;
548 function a03_fl_new_hire_header return varchar2;
549 function a03_al_new_hire_header return varchar2;
550 -- #10387522 start
551 function a03_sc_new_hire_header return varchar2;
552 function a03_mi_new_hire_header return varchar2;
553 function a03_oh_new_hire_header return varchar2;
554 function a03_pa_new_hire_header return varchar2;
555 function a03_ar_new_hire_header return varchar2;
556 function a03_md_new_hire_header return varchar2;
557 function a03_la_new_hire_header return varchar2;
558 -- #10387522 end
559
560 function a03_ny_new_hire_record
561 (
562 p_national_identifier in varchar2
563 ,p_first_name in varchar2
564 ,p_middle_name in varchar2
565 ,p_last_name in varchar2
566 ,p_emp_address_line in varchar2
567 ,p_emp_city in varchar2
568 ,p_emp_state in varchar2
569 ,p_emp_zip in varchar2
570 ,p_date_of_hire in date
571 ,p_medical_avail in varchar2 --#10014495
572 ,p_health_ins_date in date --#10014495
573 ,p_new_hire_indicator in varchar2 --#14532612
574 ) return varchar2;
575
576 function a03_il_new_hire_record
577 (
578 p_national_identifier in varchar2
579 ,p_first_name in varchar2
580 ,p_middle_name in varchar2
581 ,p_last_name in varchar2
582 ,p_emp_address_line1 in varchar2
583 ,p_emp_address_line2 in varchar2
584 ,p_emp_city in varchar2
585 ,p_emp_state in varchar2
586 ,p_emp_zip in varchar2
587 ,p_emp_zip_extension in varchar2
588 ,p_date_of_hire in date
589 ,p_federal_id in varchar2
590 ,p_tax_unit_name in varchar2
591 ,p_loc_address_line1 in varchar2
592 ,p_loc_address_line2 in varchar2
593 ,p_loc_city in varchar2
594 ,p_loc_state in varchar2
595 ,p_loc_zip in varchar2
596 ,p_loc_zip_extension in varchar2
597 ) return varchar2;
598
599 function a03_fl_new_hire_record
600 (
601 p_national_identifier in varchar2
602 ,p_first_name in varchar2
603 ,p_middle_name in varchar2
604 ,p_last_name in varchar2
605 ,p_emp_address_line1 in varchar2
606 ,p_emp_address_line2 in varchar2
607 ,p_emp_address_line3 in varchar2
608 ,p_emp_city in varchar2
609 ,p_emp_state in varchar2
610 ,p_emp_zip in varchar2
611 ,p_emp_zip_extension in varchar2
612 ,p_emp_country_code in varchar2
613 ,p_date_of_birth in date
614 ,p_date_of_hire in date
615 ,p_state_of_hire in varchar2
616 ,p_medical_insr_avail in varchar2 --#13082528
617 ,p_federal_id in varchar2
618 ,p_state_ein in varchar2
619 ,p_tax_unit_name in varchar2
620 ,p_loc_address_line1 in varchar2
621 ,p_loc_address_line2 in varchar2
622 ,p_loc_address_line3 in varchar2
623 ,p_loc_city in varchar2
624 ,p_loc_state in varchar2
625 ,p_loc_zip in varchar2
626 ,p_loc_zip_extension in varchar2
627 ,p_loc_country_code in varchar2
628 ,p_contact_phone in varchar2
629 ,p_contact_phone_ext in varchar2
630 ,p_contact_name in varchar2
631 ,p_multi_state in varchar2
632 ) return varchar2;
633 function a03_al_new_hire_record
634 (
635 p_national_identifier in varchar2
636 ,p_first_name in varchar2
637 ,p_middle_name in varchar2
638 ,p_last_name in varchar2
639 ,p_emp_address_line1 in varchar2
640 ,p_emp_address_line2 in varchar2
641 ,p_emp_address_line3 in varchar2
642 ,p_emp_city in varchar2
643 ,p_emp_state in varchar2
644 ,p_emp_zip in varchar2
645 ,p_emp_zip_extension in varchar2
646 ,p_emp_country_code in varchar2
647 ,p_date_of_birth in date
648 ,p_date_of_hire in date
649 ,p_state_of_hire in varchar2
650 ,p_federal_id in varchar2
651 ,p_state_ein in varchar2
652 ,p_tax_unit_name in varchar2
653 ,p_loc_address_line1 in varchar2
654 ,p_loc_address_line2 in varchar2
655 ,p_loc_address_line3 in varchar2
656 ,p_loc_city in varchar2
657 ,p_loc_state in varchar2
658 ,p_loc_zip in varchar2
659 ,p_loc_zip_extension in varchar2
660 ,p_loc_country_code in varchar2
661 ,p_contact_phone in varchar2
662 ,p_contact_phone_ext in varchar2
663 ,p_contact_name in varchar2
664 ,p_multi_state in varchar2
665 ) return varchar2;
666
667 function a03_tx_new_hire_record
668 (
669 p_national_identifier in varchar2
670 ,p_first_name in varchar2
671 ,p_middle_name in varchar2
675 ,p_emp_address_line3 in varchar2
672 ,p_last_name in varchar2
673 ,p_emp_address_line1 in varchar2
674 ,p_emp_address_line2 in varchar2
676 ,p_emp_city in varchar2
677 ,p_emp_state in varchar2
678 ,p_emp_zip in varchar2
679 ,p_emp_zip_extension in varchar2
680 ,p_emp_country_code in varchar2
681 ,p_emp_country_name in varchar2
682 ,p_emp_country_zip in varchar2
683 ,p_date_of_birth in date
684 ,p_date_of_hire in date
685 ,p_state_of_hire in varchar2
686 ,p_federal_id in varchar2
687 ,p_state_ein in varchar2
688 ,p_tax_unit_name in varchar2
689 ,p_loc_address_line1 in varchar2
690 ,p_loc_address_line2 in varchar2
691 ,p_loc_address_line3 in varchar2
692 ,p_loc_city in varchar2
693 ,p_loc_state in varchar2
694 ,p_loc_zip in varchar2
695 ,p_loc_zip_extension in varchar2
696 ,p_loc_country_code in varchar2
697 ,p_loc_country_name in varchar2
698 ,p_loc_country_zip in varchar2
699 ) return varchar2;
700
701 function a03_ca_new_hire_record
702 (
703 p_national_identifier in varchar2
704 ,p_first_name in varchar2
705 ,p_middle_name in varchar2
706 ,p_last_name in varchar2
707 ,p_emp_address_line in varchar2
708 ,p_emp_city in varchar2
709 ,p_emp_state in varchar2
710 ,p_emp_zip in varchar2
711 ,p_emp_zip_extension in varchar2
712 ,p_date_of_hire in date
713 ) return varchar2;
714
715 -- #10387522 start
716 function a03_sc_new_hire_record
717 (
718 p_national_identifier in varchar2
719 ,p_first_name in varchar2
720 ,p_middle_name in varchar2
721 ,p_last_name in varchar2
722 ,p_emp_add_line1 in varchar2
723 ,p_emp_add_line2 in varchar2
724 ,p_emp_city in varchar2
725 ,p_emp_state in varchar2
726 ,p_emp_zip in varchar2
727 ,p_date_of_birth in date
728 ,p_date_of_hire in date
729 ) return varchar2;
730
731 function a03_mi_new_hire_record
732 (
733 p_national_identifier in varchar2
734 ,p_first_name in varchar2
735 ,p_middle_name in varchar2
736 ,p_last_name in varchar2
737 ,p_tax_unit_name in varchar2
738 ,p_federal_id in varchar2
739 ,p_loc_address_line1 in varchar2
740 ,p_loc_address_line2 in varchar2
741 ,p_loc_city in varchar2
742 ,p_loc_state in varchar2
743 ,p_loc_zip in varchar2
744 ,p_loc_zip_extension in varchar2
745 ,p_emp_address_line1 in varchar2
746 ,p_emp_address_line2 in varchar2
747 ,p_emp_city in varchar2
748 ,p_emp_state in varchar2
749 ,p_emp_zip in varchar2
750 ,p_emp_zip_extension in varchar2
751 ,p_date_of_birth in date
752 ,p_date_of_hire in date
753 ,p_dl_number in varchar2
754 ) return varchar2;
755
756 function a03_oh_new_hire_record
757 (
758 p_national_identifier in varchar2
759 ,p_first_name in varchar2
760 ,p_middle_name in varchar2
761 ,p_last_name in varchar2
762 ,p_emp_address_line1 in varchar2
763 ,p_emp_address_line2 in varchar2
764 ,p_emp_address_line3 in varchar2
765 ,p_emp_city in varchar2
766 ,p_emp_state in varchar2
767 ,p_emp_zip in varchar2
768 ,p_emp_zip_extension in varchar2
769 ,p_emp_country_code in varchar2
770 ,p_emp_country_name in varchar2
771 ,p_emp_country_zip in varchar2
772 ,p_date_of_birth in date
773 ,p_date_of_hire in date
774 ,p_state_of_hire in varchar2
775 ,p_gender in varchar2
776 ,p_left_work in varchar2
777 ,p_federal_id in varchar2
778 ,p_inc_tax_credit in varchar2
779 ,p_state_ein in varchar2
780 ,p_tax_unit_name in varchar2
781 ,p_loc_address_line1 in varchar2
782 ,p_loc_address_line2 in varchar2
783 ,p_loc_address_line3 in varchar2
784 ,p_loc_city in varchar2
785 ,p_loc_state in varchar2
786 ,p_loc_zip in varchar2
787 ,p_loc_zip_extension in varchar2
788 ,p_loc_country_code in varchar2
789 ,p_loc_country_name in varchar2
790 ,p_loc_country_zip in varchar2
791 ,p_opt_address_line1 in varchar2
792 ,p_opt_address_line2 in varchar2
793 ,p_opt_address_line3 in varchar2
794 ,p_opt_city in varchar2
795 ,p_opt_state in varchar2
796 ,p_opt_zip in varchar2
797 ,p_opt_zip_extension in varchar2
798 ,p_opt_country_code in varchar2
799 ,p_opt_country_name in varchar2
800 ,p_opt_country_zip in varchar2
801 ,p_emp_ic in varchar2
805 --
802 ,p_ic_pay_date in date
803 ,p_ic_length in number
804 ) return varchar2;
806 function a03_pa_new_hire_record
807 (
808 p_federal_id in varchar2
809 ,p_tax_unit_name in varchar2
810 ,p_loc_address_line1 in varchar2
811 ,p_loc_address_line2 in varchar2
812 ,p_loc_address_line3 in varchar2
813 ,p_loc_city in varchar2
814 ,p_loc_state in varchar2
815 ,p_loc_zip in varchar2
816 ,p_loc_zip_extension in varchar2
817 ,p_contact_first_name in varchar2
818 ,p_contact_last_name in varchar2
819 ,p_contact_ph_no in varchar2
820 ,p_contact_ph_no_ext in number
821 ,p_national_identifier in varchar2
822 ,p_first_name in varchar2
823 ,p_middle_name in varchar2
824 ,p_last_name in varchar2
825 ,p_date_of_birth in date
826 ,p_state_of_hire in varchar2
827 ,p_date_of_hire in date
828 ,p_emp_address_line1 in varchar2
829 ,p_emp_address_line2 in varchar2
830 ,p_emp_address_line3 in varchar2
831 ,p_emp_city in varchar2
832 ,p_emp_state in varchar2
833 ,p_emp_zip in varchar2
834 ,p_emp_zip_extension in varchar2
835 ) return varchar2;
836 --
837 function a03_ar_new_hire_record
838 (
839 p_national_identifier in varchar2
840 ,p_first_name in varchar2
841 ,p_middle_name in varchar2
842 ,p_last_name in varchar2
843 ,p_emp_address_line1 in varchar2
844 ,p_emp_address_line2 in varchar2
845 ,p_emp_address_line3 in varchar2
846 ,p_emp_city in varchar2
847 ,p_emp_state in varchar2
848 ,p_emp_zip in varchar2
849 ,p_emp_zip_extension in varchar2
850 ,p_emp_country_code in varchar2
851 ,p_date_of_birth in date
852 ,p_date_of_hire in date
853 ,p_state_of_hire in varchar2
854 ,p_federal_id in varchar2
855 ,p_state_ein in varchar2
856 ,p_tax_unit_name in varchar2
857 ,p_loc_address_line1 in varchar2
858 ,p_loc_address_line2 in varchar2
859 ,p_loc_address_line3 in varchar2
860 ,p_loc_city in varchar2
861 ,p_loc_state in varchar2
862 ,p_loc_zip in varchar2
863 ,p_loc_zip_extension in varchar2
864 ,p_loc_country_code in varchar2
865 ,p_contact_phone in varchar2
866 ,p_contact_phone_ext in varchar2
867 ,p_contact_name in varchar2
868 ) return varchar2;
869 --
870 function a03_md_new_hire_record
871 (
872 p_national_identifier in varchar2
873 ,p_first_name in varchar2
874 ,p_middle_name in varchar2
875 ,p_last_name in varchar2
876 ,p_emp_address_line1 in varchar2
877 ,p_emp_address_line2 in varchar2
878 ,p_emp_address_line3 in varchar2
879 ,p_emp_city in varchar2
880 ,p_emp_state in varchar2
881 ,p_emp_zip in varchar2
882 ,p_emp_zip_extension in varchar2
883 ,p_emp_country_code in varchar2
884 ,p_date_of_birth in date
885 ,p_date_of_hire in date
886 ,p_state_of_hire in varchar2
887 ,p_medical_insr_avail in varchar2
888 ,p_federal_id in varchar2
889 ,p_suin_company_state_id in varchar2
890 ,p_tax_unit_name in varchar2
891 ,p_loc_address_line1 in varchar2
892 ,p_loc_address_line2 in varchar2
893 ,p_loc_address_line3 in varchar2
894 ,p_loc_city in varchar2
895 ,p_loc_state in varchar2
896 ,p_loc_zip in varchar2
897 ,p_loc_zip_extension in varchar2
898 ,p_loc_country_code in varchar2
899 ,p_loc_phone in varchar2
900 ,p_loc_phone_extension in varchar2
901 ,p_loc_contact in varchar2
902 ,p_gender in varchar2
903 ,p_loc_fax in varchar2
904 ,p_loc_email in varchar2
905 ,p_salary in varchar2
906 ,p_sal_frequency in varchar2
907 ) return varchar2;
908 --
909 function a03_la_new_hire_record
910 (
911 p_first_name in varchar2
912 ,p_middle_name in varchar2
913 ,p_last_name in varchar2
914 ,p_suffix in varchar2
915 ,p_national_identifier in varchar2
916 ,p_emp_address_line1 in varchar2
917 ,p_emp_address_line2 in varchar2
918 ,p_emp_address_line3 in varchar2
919 ,p_emp_city in varchar2
920 ,p_emp_state in varchar2
921 ,p_emp_zip in varchar2
922 ,p_emp_zip_extension in varchar2
923 ,p_emp_country_code in varchar2
924 ,p_emp_country_name in varchar2
925 ,p_emp_country_zip in varchar2
926 ,p_emp_marital_status in varchar2
927 ,p_date_of_hire in date
928 ,p_tax_unit_name in varchar2
929 ,p_loc_address_line1 in varchar2
930 ,p_loc_address_line2 in varchar2
931 ,p_loc_address_line3 in varchar2
932 ,p_loc_city in varchar2
933 ,p_loc_state in varchar2
934 ,p_loc_zip in varchar2
935 ,p_loc_zip_extension in varchar2
936 ,p_loc_country_code in varchar2
937 ,p_loc_country_name in varchar2
938 ,p_loc_country_zip in varchar2
939 ,p_federal_id in varchar2
943 ,p_sal_frequency in varchar2
940 ,p_sit_company_state_id in varchar2
941 ,p_job in varchar2
942 ,p_salary in varchar2
944 ,p_state_of_hire in varchar2
945 ,p_date_of_birth in date
946 ,p_emp_insr_ind in varchar2
947 ,p_loc_contact_first_name in varchar2
948 ,p_loc_contact_last_name in varchar2
949 ,p_loc_phone in varchar2
950 ) return varchar2;
951 -- #10387522 end
952
953 PROCEDURE get_location_address
954 (
955 p_location_id in number
956 ,p_address out nocopy varchar2
957 ,p_city out nocopy varchar2
958 ,p_state out nocopy varchar2
959 ,p_zip out nocopy varchar2
960 ,p_zip_extension out nocopy varchar2
961 );
962
963 PROCEDURE get_location_address_3lines
964 (
965 p_location_id in number
966 ,p_address_line1 out nocopy varchar2
967 ,p_address_line2 out nocopy varchar2
968 ,p_address_line3 out nocopy varchar2
969 ,p_city out nocopy varchar2
970 ,p_state out nocopy varchar2
971 ,p_zip out nocopy varchar2
972 ,p_zip_extension out nocopy varchar2
973 ,p_country out nocopy varchar2
974 );
975
976 PROCEDURE get_employee_address
977 (
978 p_person_id in number
979 ,p_address out nocopy varchar2
980 ,p_city out nocopy varchar2
981 ,p_state out nocopy varchar2
982 ,p_zip out nocopy varchar2
983 ,p_zip_extension out nocopy varchar2
984 );
985
986 PROCEDURE get_employee_address_3lines
987 (
988 p_person_id in number
989 ,p_address_line1 out nocopy varchar2
990 ,p_address_line2 out nocopy varchar2
991 ,p_address_line3 out nocopy varchar2
992 ,p_city out nocopy varchar2
993 ,p_state out nocopy varchar2
994 ,p_zip out nocopy varchar2
995 ,p_zip_extension out nocopy varchar2
996 ,p_country out nocopy varchar2
997 );
998 --
999 procedure get_new_hire_contact(
1000 p_person_id in number
1001 ,p_business_group_id in number
1002 ,p_report_date in date
1003 ,p_contact_name out nocopy varchar2
1004 ,p_contact_title out nocopy varchar2
1005 ,p_contact_phone out nocopy varchar2
1006 ) ;
1007 --
1008 --#10387522 Start
1009 procedure get_new_hire_contact_name(
1010 p_person_id in number
1011 ,p_business_group_id in number
1012 ,p_report_date in date
1013 ,p_contact_first_name out nocopy varchar2
1014 ,p_contact_last_name out nocopy varchar2
1015 ) ;
1016 procedure check_min_length(
1017 p_string in varchar2
1018 ,p_length in number
1019 ,p_field in varchar2
1020 ,p_state in varchar2
1021 );
1022
1023 function remove_special_characters(
1024 p_string IN varchar2,
1025 p_allowed IN varchar2 default NULL)
1026 return varchar2;
1027
1028 FUNCTION md_get_salary (
1029 p_business_group_id in NUMBER,
1030 p_assignment_id in NUMBER,
1031 p_report_date in DATE,
1032 p_frequency out nocopy varchar2
1033 ) return NUMBER;
1034 --#10387522 end
1035 --
1036 --
1037 end per_new_hire_pkg;