1: PACKAGE pqp_alien_expat_taxation_pkg AUTHID DEFINER AS
2: /* $Header: pqalnexp.pkh 120.0.12010000.1 2008/07/28 11:07:48 appldev ship $ */
3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
2: /* $Header: pqalnexp.pkh 120.0.12010000.1 2008/07/28 11:07:48 appldev ship $ */
3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,
17: address_line1 hr_locations.address_line_1%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,
17: address_line1 hr_locations.address_line_1%TYPE ,
18: address_line2 hr_locations.address_line_2%TYPE ,
46: *****/
47:
48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
47:
48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,
58: gross_amount NUMBER ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,
58: gross_amount NUMBER ,
59: withholding_allowance
81: *****/
82:
83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
82:
83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,
93: primary_activity_code VARCHAR2(100) ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,
93: primary_activity_code VARCHAR2(100) ,
94: visa_start_date DATE ,
100: /*****
101: The above Record Type stores the data selected of the visa information
102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
101: The above Record Type stores the data selected of the visa information
102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,
102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,
110: institution_indiv_id VARCHAR2(15) ,
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,
110: institution_indiv_id VARCHAR2(15) ,
111: date_of_birth DATE ,
163: The above Record Type stores the message for error processing
164: *****/
165: TYPE t_error_rec_type IS RECORD
166: (
167: person_id per_people_f.person_id%TYPE ,
168: process_event_id pay_process_events.process_event_id%TYPE
169: );
170:
171: TYPE t_error_tab_type IS TABLE OF t_error_rec_type INDEX BY BINARY_INTEGER;