1: PACKAGE HZ_IMP_LOAD_ORG_CONTACT_PKG AUTHID CURRENT_USER AS
2: /*$Header: ARHLORCS.pls 120.9 2008/10/23 11:17:02 idali ship $*/
3:
4: /* HZ_IMP_CONTACTS_INT columns */
5:
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
2: /*$Header: ARHLORCS.pls 120.9 2008/10/23 11:17:02 idali ship $*/
3:
4: /* HZ_IMP_CONTACTS_INT columns */
5:
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
3:
4: /* HZ_IMP_CONTACTS_INT columns */
5:
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
4: /* HZ_IMP_CONTACTS_INT columns */
5:
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
5:
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
6: TYPE batch_id IS TABLE OF HZ_IMP_CONTACTS_INT.BATCH_ID%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
7: TYPE contact_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
8: TYPE contact_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
9: TYPE sub_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
10: TYPE sub_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.SUB_ORIG_SYSTEM_REFERENCE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
11: TYPE obj_orig_system IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
12: TYPE obj_orig_system_reference IS TABLE OF HZ_IMP_CONTACTS_INT.OBJ_ORIG_SYSTEM_REFERENCE%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
13: TYPE insert_update_flag IS TABLE OF HZ_IMP_CONTACTS_INT.INSERT_UPDATE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
14: TYPE contact_number IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_NUMBER%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
15: TYPE department_code IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT_CODE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
16: TYPE department IS TABLE OF HZ_IMP_CONTACTS_INT.DEPARTMENT%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
17: TYPE title IS TABLE OF HZ_IMP_CONTACTS_INT.TITLE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
18: TYPE job_title IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
19: TYPE job_title_code IS TABLE OF HZ_IMP_CONTACTS_INT.JOB_TITLE_CODE%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
20: TYPE decision_maker_flag IS TABLE OF HZ_IMP_CONTACTS_INT.DECISION_MAKER_FLAG%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
21: TYPE reference_use_flag IS TABLE OF HZ_IMP_CONTACTS_INT.REFERENCE_USE_FLAG%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
22: TYPE comments IS TABLE OF HZ_IMP_CONTACTS_INT.COMMENTS%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
23: TYPE relationship_type IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_TYPE%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
24: TYPE relationship_code IS TABLE OF HZ_IMP_CONTACTS_INT.RELATIONSHIP_CODE%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
25: TYPE start_date IS TABLE OF HZ_IMP_CONTACTS_INT.START_DATE%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
26: TYPE end_date IS TABLE OF HZ_IMP_CONTACTS_INT.END_DATE%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
27: TYPE rel_comments IS TABLE OF HZ_IMP_CONTACTS_INT.REL_COMMENTS%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
28: TYPE attribute_category IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE_CATEGORY%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
29: TYPE attribute IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE1%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
30: TYPE attribute2 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE2%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
31: TYPE attribute3 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE3%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
32: TYPE attribute4 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE4%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
33: TYPE attribute5 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE5%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
34: TYPE attribute6 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE6%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
35: TYPE attribute7 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE7%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
36: TYPE attribute8 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE8%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
37: TYPE attribute9 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE9%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
38: TYPE attribute10 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE10%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
39: TYPE attribute11 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE11%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
40: TYPE attribute12 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE12%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
41: TYPE attribute13 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE13%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
42: TYPE attribute14 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE14%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
43: TYPE attribute15 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE15%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
51: TYPE created_by_module IS TABLE OF HZ_IMP_CONTACTS_INT.CREATED_BY_MODULE%TYPE;
44: TYPE attribute16 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE16%TYPE;
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
51: TYPE created_by_module IS TABLE OF HZ_IMP_CONTACTS_INT.CREATED_BY_MODULE%TYPE;
52:
45: TYPE attribute17 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE17%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
51: TYPE created_by_module IS TABLE OF HZ_IMP_CONTACTS_INT.CREATED_BY_MODULE%TYPE;
52:
53: TYPE party_id IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
46: TYPE attribute18 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE18%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
51: TYPE created_by_module IS TABLE OF HZ_IMP_CONTACTS_INT.CREATED_BY_MODULE%TYPE;
52:
53: TYPE party_id IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
54: TYPE party_name IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;
47: TYPE attribute19 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE19%TYPE;
48: TYPE attribute20 IS TABLE OF HZ_IMP_CONTACTS_INT.ATTRIBUTE20%TYPE;
49: TYPE interface_status IS TABLE OF HZ_IMP_CONTACTS_INT.INTERFACE_STATUS%TYPE;
50: TYPE error_id IS TABLE OF HZ_IMP_CONTACTS_INT.ERROR_ID%TYPE;
51: TYPE created_by_module IS TABLE OF HZ_IMP_CONTACTS_INT.CREATED_BY_MODULE%TYPE;
52:
53: TYPE party_id IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
54: TYPE party_name IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;
55: TYPE party_type IS TABLE OF HZ_PARTIES.PARTY_TYPE%TYPE;