4: p_init_msg_list VARCHAR2(25) := FND_API.G_FALSE;
5: x_return_status VARCHAR2(50);
6: x_msg_count NUMBER;
7: x_msg_data VARCHAR2(100);
8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;
9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
5: x_return_status VARCHAR2(50);
6: x_msg_count NUMBER;
7: x_msg_data VARCHAR2(100);
8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;
9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
6: x_msg_count NUMBER;
7: x_msg_data VARCHAR2(100);
8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;
9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
7: x_msg_data VARCHAR2(100);
8: load_id imc_csv_interface_fields.LOAD_ID%TYPE;
9: BATCH_ID imc_csv_interface_fields.BATCH_ID%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
10: PARTY_REC_ID imc_csv_interface_fields.PARTY_REC_ID%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
11: REC_STATUS imc_csv_interface_fields.REC_STATUS%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
12: PARTY_ORIG_SYSTEM HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
13: PARTY_ORIG_SYSTEM_REFERENCE HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
14: PARTY_TYPE imc_csv_interface_fields.PARTY_TYPE%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
15: ORGANIZATION_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
16: CEO_NAME imc_csv_interface_fields.CEO_NAME%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
17: CEO_TITLE imc_csv_interface_fields.CEO_TITLE%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
18: PRINCIPAL_NAME imc_csv_interface_fields.PRINCIPAL_NAME%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
19: PRINCIPAL_TITLE imc_csv_interface_fields.PRINCIPAL_TITLE%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
20: LEGAL_STATUS imc_csv_interface_fields.LEGAL_STATUS%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
21: CONTROL_YR imc_csv_interface_fields.CONTROL_YR%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
22: EMPLOYEES_TOTAL imc_csv_interface_fields.EMPLOYEES_TOTAL%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
23: HQ_BRANCH_IND imc_csv_interface_fields.HQ_BRANCH_IND%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
24: BRANCH_FLAG imc_csv_interface_fields.BRANCH_FLAG%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
25: OOB_IND imc_csv_interface_fields.OOB_IND%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
26: TAX_REFERENCE imc_csv_interface_fields.TAX_REFERENCE%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
27: GSA_INDICATOR_FLAG imc_csv_interface_fields.GSA_INDICATOR_FLAG%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
28: JGZZ_FISCAL_CODE imc_csv_interface_fields.JGZZ_FISCAL_CODE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
29: ANALYSIS_FY imc_csv_interface_fields.ANALYSIS_FY%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
30: FISCAL_YEAREND_MONTH imc_csv_interface_fields.FISCAL_YEAREND_MONTH%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
31: CURR_FY_POTENTIAL_REVENUE imc_csv_interface_fields.CURR_FY_POTENTIAL_REVENUE%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
32: NEXT_FY_POTENTIAL_REVENUE imc_csv_interface_fields.NEXT_FY_POTENTIAL_REVENUE%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
33: YEAR_ESTABLISHED imc_csv_interface_fields.YEAR_ESTABLISHED%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
34: MISSION_STATEMENT imc_csv_interface_fields.MISSION_STATEMENT%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
35: ORGANIZATION_TYPE imc_csv_interface_fields.ORGANIZATION_TYPE%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
36: BUSINESS_SCOPE imc_csv_interface_fields.BUSINESS_SCOPE%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
37: KNOWN_AS imc_csv_interface_fields.KNOWN_AS%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
38: KNOWN_AS2 imc_csv_interface_fields.KNOWN_AS2%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
39: KNOWN_AS3 imc_csv_interface_fields.KNOWN_AS3%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
40: KNOWN_AS4 imc_csv_interface_fields.KNOWN_AS4%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
41: KNOWN_AS5 imc_csv_interface_fields.KNOWN_AS5%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
42: LOCAL_BUS_IDEN_TYPE imc_csv_interface_fields.LOCAL_BUS_IDEN_TYPE%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
43: LOCAL_BUS_IDENTIFIER imc_csv_interface_fields.LOCAL_BUS_IDENTIFIER%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
44: PREF_FUNCTIONAL_CURRENCY imc_csv_interface_fields.PREF_FUNCTIONAL_CURRENCY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
45: REGISTRATION_TYPE imc_csv_interface_fields.REGISTRATION_TYPE%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
46: PARENT_SUB_IND imc_csv_interface_fields.PARENT_SUB_IND%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
47: INCORP_YEAR imc_csv_interface_fields.INCORP_YEAR%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
48: PUBLIC_PRIVATE_OWNERSHIP_FLAG imc_csv_interface_fields.PUBLIC_PRIVATE_OWNERSHIP_FLAG%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
49: TOTAL_PAYMENTS imc_csv_interface_fields.TOTAL_PAYMENTS%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
50: DUNS_NUMBER_C imc_csv_interface_fields.DUNS_NUMBER_C%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
51: CLASS_CODE imc_csv_interface_fields.CLASS_CODE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
52: CLASS_CATEGORY imc_csv_interface_fields.CLASS_CATEGORY%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
53: PERSON_PRE_NAME_ADJUNCT imc_csv_interface_fields.PERSON_PRE_NAME_ADJUNCT%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
54: PERSON_FIRST_NAME imc_csv_interface_fields.PERSON_FIRST_NAME%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
55: PERSON_MIDDLE_NAME imc_csv_interface_fields.PERSON_MIDDLE_NAME%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
56: PERSON_LAST_NAME imc_csv_interface_fields.PERSON_LAST_NAME%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
57: PERSON_NAME_SUFFIX imc_csv_interface_fields.PERSON_NAME_SUFFIX%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
58: PERSON_TITLE imc_csv_interface_fields.PERSON_TITLE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
59: PERSON_ACADEMIC_TITLE imc_csv_interface_fields.PERSON_ACADEMIC_TITLE%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
60: PERSON_PREVIOUS_LAST_NAME imc_csv_interface_fields.PERSON_PREVIOUS_LAST_NAME%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
61: PERSON_INITIALS imc_csv_interface_fields.PERSON_INITIALS%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
62: PERSON_NAME_PHONETIC imc_csv_interface_fields.PERSON_NAME_PHONETIC%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
63: PERSON_FIRST_NAME_PHONETIC imc_csv_interface_fields.PERSON_FIRST_NAME_PHONETIC%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
64: PERSON_MIDDLE_NAME_PHONETIC imc_csv_interface_fields.PERSON_MIDDLE_NAME_PHONETIC%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
65: PERSON_LAST_NAME_PHONETIC imc_csv_interface_fields.PERSON_LAST_NAME_PHONETIC%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
66: PERSON_IDEN_TYPE imc_csv_interface_fields.PERSON_IDEN_TYPE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
67: PERSON_IDENTIFIER imc_csv_interface_fields.PERSON_IDENTIFIER%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
68: DATE_OF_BIRTH imc_csv_interface_fields.DATE_OF_BIRTH%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
69: PLACE_OF_BIRTH imc_csv_interface_fields.PLACE_OF_BIRTH%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
70: DATE_OF_DEATH imc_csv_interface_fields.DATE_OF_DEATH%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
71: GENDER imc_csv_interface_fields.GENDER%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
72: DECLARED_ETHNICITY imc_csv_interface_fields.DECLARED_ETHNICITY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
73: MARITAL_STATUS imc_csv_interface_fields.MARITAL_STATUS%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
74: MARITAL_STATUS_EFFECTIVE_DATE imc_csv_interface_fields.MARITAL_STATUS_EFFECTIVE_DATE%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
75: PERSONAL_INCOME imc_csv_interface_fields.PERSONAL_INCOME%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
76: HEAD_OF_HOUSEHOLD_FLAG imc_csv_interface_fields.HEAD_OF_HOUSEHOLD_FLAG%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
77: HOUSEHOLD_INCOME imc_csv_interface_fields.HOUSEHOLD_INCOME%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
78: HOUSEHOLD_SIZE imc_csv_interface_fields.HOUSEHOLD_SIZE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
79: RENT_OWN_IND imc_csv_interface_fields.RENT_OWN_IND%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
80: COUNTRY imc_csv_interface_fields.COUNTRY%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
81: ADDRESS1 imc_csv_interface_fields.ADDRESS1%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
82: ADDRESS2 imc_csv_interface_fields.ADDRESS2%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
83: ADDRESS3 imc_csv_interface_fields.ADDRESS3%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
84: ADDRESS4 imc_csv_interface_fields.ADDRESS4%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
85: CITY imc_csv_interface_fields.CITY%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
86: POSTAL_CODE imc_csv_interface_fields.POSTAL_CODE%TYPE;
87: STATE imc_csv_interface_fields.STATE%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
88: PROVINCE imc_csv_interface_fields.PROVINCE%TYPE;
89: COUNTY imc_csv_interface_fields.COUNTY%TYPE;
90: ADDRESS_LINES_PHONETIC imc_csv_interface_fields.ADDRESS_LINES_PHONETIC%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
91: LOCATION_DIRECTIONS HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
92: DESCRIPTION imc_csv_interface_fields.DESCRIPTION%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
93: SALES_TAX_GEOCODE HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
94: PRIMARY_FLAG HZ_IMP_ADDRESSES_INT.PRIMARY_FLAG%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
95: PARTY_SITE_NAME imc_csv_interface_fields.PARTY_SITE_NAME%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
96: CONTACT_POINT_TYPE imc_csv_interface_fields.CONTACT_POINT_TYPE%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
97: EMAIL_FORMAT imc_csv_interface_fields.EMAIL_FORMAT%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
98: EMAIL_ADDRESS imc_csv_interface_fields.EMAIL_ADDRESS%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
99: PHONE_AREA_CODE imc_csv_interface_fields.PHONE_AREA_CODE%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
100: PHONE_COUNTRY_CODE imc_csv_interface_fields.PHONE_COUNTRY_CODE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
101: PHONE_NUMBER imc_csv_interface_fields.PHONE_NUMBER%TYPE;
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
102: PHONE_EXTENSION imc_csv_interface_fields.PHONE_EXTENSION%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
103: PHONE_LINE_TYPE imc_csv_interface_fields.PHONE_LINE_TYPE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
104: TELEX_NUMBER imc_csv_interface_fields.TELEX_NUMBER%TYPE;
105: WEB_TYPE imc_csv_interface_fields.WEB_TYPE%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
106: URL imc_csv_interface_fields.URL%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
107: RAW_PHONE_NUMBER imc_csv_interface_fields.RAW_PHONE_NUMBER%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
108: CONTACT_POINT_PURPOSE imc_csv_interface_fields.CONTACT_POINT_PURPOSE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
109: IDENTIFYING_ADDRESS_FLAG VARCHAR2(100);
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
110: LANGUAGE imc_csv_interface_fields.LANGUAGE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
111: DEPARTMENT_CODE imc_csv_interface_fields.DEPARTMENT_CODE%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
112: DEPARTMENT imc_csv_interface_fields.DEPARTMENT%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
113: TITLE imc_csv_interface_fields.TITLE%TYPE;
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
114: JOB_TITLE imc_csv_interface_fields.JOB_TITLE%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
115: LINE_OF_BUSINESS imc_csv_interface_fields.LINE_OF_BUSINESS%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%TYPE;
116: CREATION_DATE imc_csv_interface_fields.CREATION_DATE%TYPE;
117: CREATED_BY imc_csv_interface_fields.CREATED_BY%TYPE;
118: LAST_UPDATE_DATE imc_csv_interface_fields.LAST_UPDATE_DATE%TYPE;
119: LAST_UPDATED_BY imc_csv_interface_fields.LAST_UPDATED_BY%TYPE;
120: LAST_UPDATE_LOGIN imc_csv_interface_fields.LAST_UPDATE_LOGIN%TYPE;
121:
122: date_format imc_csv_load_details.DATE_FORMAT%TYPE;
123: ADDRESS_FLAG imc_csv_load_details.ADDRESS_FLAG%TYPE;
124: CONTACT_POINTS_FLAG imc_csv_load_details.CONTACT_POINTS_FLAG%TYPE;
142: CNT_ORIG_SYSTEM_REFERENCE number;
143: CNTORG_ORIG_SYSTEM_REFERENCE number;
144: SITE_ORIG_SYSTEM_REFERENCE number;
145: CP_ORIG_SYSTEM_REFERENCE number;
146: PARTY_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
147:
148: TYPE org_cnt_rec_type IS RECORD (
149: org_name imc_csv_interface_fields.ORGANIZATION_NAME%TYPE,
150: original_sys_ref NUMBER);
145: CP_ORIG_SYSTEM_REFERENCE number;
146: PARTY_NAME imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
147:
148: TYPE org_cnt_rec_type IS RECORD (
149: org_name imc_csv_interface_fields.ORGANIZATION_NAME%TYPE,
150: original_sys_ref NUMBER);
151:
152: TYPE org_contact_type IS TABLE OF org_cnt_rec_type INDEX BY BINARY_INTEGER;
153:
152: TYPE org_contact_type IS TABLE OF org_cnt_rec_type INDEX BY BINARY_INTEGER;
153:
154: org_contact org_contact_type;
155: org_contact_rec org_cnt_rec_type;
156: old_org_name imc_csv_interface_fields.ORGANIZATION_NAME%TYPE;
157: orig_sys_ref NUMBER;
158: old_contact_org VARCHAR2(100);
159: i NUMBER;
160:
174: PROVINCE,COUNTY,ADDRESS_LINES_PHONETIC,DESCRIPTION,LANGUAGE,PARTY_SITE_NAME,CONTACT_POINT_TYPE,EMAIL_FORMAT,
175: EMAIL_ADDRESS,PHONE_AREA_CODE,PHONE_COUNTRY_CODE,PHONE_NUMBER,PHONE_EXTENSION,PHONE_LINE_TYPE,WEB_TYPE,URL,
176: RAW_PHONE_NUMBER,CONTACT_POINT_PURPOSE,CLASS_CATEGORY,CLASS_CODE,DEPARTMENT_CODE,DEPARTMENT,TITLE,JOB_TITLE,
177: TELEX_NUMBER,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN
178: from imc_csv_interface_fields where load_id = loadId and batch_id=batchId
179: and (rec_status='E' OR nvl(rec_status,'NULL')='NULL');
180:
181: cursor get_load_details(loadId number, batchId number) is
182: select date_format,ADDRESS_FLAG,CONTACT_POINTS_FLAG,CLASSIFICATION_FLAG
280: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
281: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
282: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',null,null,'ORGANIZATION_NAME',null,null,'E',
283: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
284: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||' and party_rec_id = '||PARTY_REC_ID;
285: REC_STATUS := 'E';
286: end if;
287: PARTY_NAME:=ORGANIZATION_NAME;
288: -- dbms_output.put_line('registration type'||REGISTRATION_TYPE);
298: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
299: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',CONTROL_YR,null,'CONTROL_YR',null,ORGANIZATION_NAME,'E',
300: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
301:
302: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
303: ' and party_rec_id = '||PARTY_REC_ID;
304: REC_STATUS := 'E';
305: end;
306: end if;
315: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
316: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',EMPLOYEES_TOTAL,null,'EMPLOYEES_TOTAL',null,ORGANIZATION_NAME,'E',
317: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
318:
319: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
320: ' and party_rec_id = '||PARTY_REC_ID;
321: REC_STATUS := 'E';
322: end;
323: end if;
332: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
333: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',INCORP_YEAR,null,'INCORP_YEAR',null,ORGANIZATION_NAME,'E',
334: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
335:
336: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
337: ' and party_rec_id = '||PARTY_REC_ID;
338: REC_STATUS := 'E';
339: end;
340: end if;
350: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
351: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',TOTAL_PAYMENTS,null,'TOTAL_PAYMENTS',null,ORGANIZATION_NAME,'E',
352: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
353:
354: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
355: ' and party_rec_id = '||PARTY_REC_ID;
356: REC_STATUS := 'E';
357: end;
358: end if;
367: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
368: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',YEAR_ESTABLISHED,null,'YEAR_ESTABLISHED',null,ORGANIZATION_NAME,'E',
369: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
370:
371: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
372: ' and party_rec_id = '||PARTY_REC_ID;
373: REC_STATUS := 'E';
374: end;
375: end if;
383: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
384: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',LEGAL_STATUS,null,'LEGAL_STATUS','LEGAL_STATUS',ORGANIZATION_NAME,'E',
385: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
386:
387: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
388: ' and party_rec_id = '||PARTY_REC_ID;
389: REC_STATUS := 'E';
390: end if;
391: close legal_status_code;
399: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
400: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
401: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',HQ_BRANCH_IND,null,'HQ_BRANCH_IND','HQ_BRANCH_IND',ORGANIZATION_NAME,'E',
402: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
403: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
404: ' and party_rec_id = '||PARTY_REC_ID;
405: REC_STATUS := 'E';
406: end if;
407: close hq_branch;
415: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
416: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
417: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',FISCAL_YEAREND_MONTH,null,'FISCAL_YEAREND_MONTH','MONTH',ORGANIZATION_NAME,'E',
418: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
419: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
420: ' and party_rec_id = '||PARTY_REC_ID;
421: REC_STATUS := 'E';
422: end if;
423: close FISCAL_YREND_MONTH;
433: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
434: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
435: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',REGISTRATION_TYPE,null,'REGISTRATION_TYPE','REGISTRATION_TYPE',ORGANIZATION_NAME,'E',
436: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
437: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
438: ' and party_rec_id = '||PARTY_REC_ID;
439: REC_STATUS := 'E';
440: end if;
441: close REGISTRY_TYPE;
449: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
450: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
451: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',OOB_IND,null,'OOB_IND','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
452: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
453: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
454: ' and party_rec_id = '||PARTY_REC_ID;
455: REC_STATUS := 'E';
456: end if;
457: end if;
464: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
465: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
466: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',BRANCH_FLAG,null,'BRANCH_FLAG','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
467: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
468: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
469: ' and party_rec_id = '||PARTY_REC_ID;
470: REC_STATUS := 'E';
471: end if;
472: end if;
479: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
480: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
481: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PARENT_SUB_IND,null,'PARENT_SUB_IND','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
482: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
483: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
484: ' and party_rec_id = '||PARTY_REC_ID;
485: REC_STATUS := 'E';
486: end if;
487: end if;
494: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
495: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
496: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PUBLIC_PRIVATE_OWNERSHIP_FLAG,null,'PUBLIC_PRIVATE_OWNERSHIP_FLAG','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
497: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
498: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
499: ' and party_rec_id = '||PARTY_REC_ID;
500: REC_STATUS := 'E';
501: end if;
502: end if;
510: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
511: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',null,null,'PERSON_FIRST_NAME',null,null,'E',
512: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
513:
514: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
515: ' and party_rec_id = '||PARTY_REC_ID;
516: REC_STATUS := 'E';
517: else
518: if (ORGANIZATION_NAME is not null) then
532: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
533: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',PERSONAL_INCOME,null,'PERSONAL_INCOME',null,PARTY_NAME,'E',
534: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
535:
536: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
537: ' and party_rec_id = '||PARTY_REC_ID;
538: REC_STATUS := 'E';
539: end;
540: end if;
549: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
550: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',HOUSEHOLD_INCOME,null,'HOUSEHOLD_INCOME',null,PARTY_NAME,'E',
551: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
552:
553: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
554: ' and party_rec_id = '||PARTY_REC_ID;
555: REC_STATUS := 'E';
556: end;
557: end if;
565: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
566: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
567: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',HOUSEHOLD_SIZE,null,'HOUSEHOLD_SIZE',null,PARTY_NAME,'E',
568: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
569: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
570: ' and party_rec_id = '||PARTY_REC_ID;
571: REC_STATUS := 'E';
572: end;
573: end if;
583: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
584: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',DATE_OF_BIRTH,null,'DATE_OF_BIRTH',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
585: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
586:
587: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
588: ' and party_rec_id = '||PARTY_REC_ID;
589: REC_STATUS := 'E';
590: end;
591: end if;
600: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
601: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',DATE_OF_DEATH,null,'DATE_OF_DEATH',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
602: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
603:
604: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
605: ' and party_rec_id = '||PARTY_REC_ID;
606: REC_STATUS := 'E';
607: end;
608: end if;
617: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
618: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',MARITAL_STATUS_EFFECTIVE_DATE,null,'MARITAL_STATUS_EFFECTIVE_DATE',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
619: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
620:
621: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
622: ' and party_rec_id = '||PARTY_REC_ID;
623: REC_STATUS := 'E';
624: end;
625: end if;
632: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
633: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
634: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PERSON_PRE_NAME_ADJUNCT,null,'PERSON_PRE_NAME_ADJUNCT','CONTACT_TITLE',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
635: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
636: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
637: ' and party_rec_id = '||PARTY_REC_ID;
638: REC_STATUS := 'E';
639: end if;
640: close contact_title;
648: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
649: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
650: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',MARITAL_STATUS,null,'MARITAL_STATUS','MARITAL_STATUS',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
651: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
652: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
653: ' and party_rec_id = '||PARTY_REC_ID;
654: REC_STATUS := 'E';
655: end if;
656: close marry_status;
664: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
665: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
666: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',RENT_OWN_IND,null,'RENT_OWN_IND','OWN_RENT_IND',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
667: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
668: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
669: ' and party_rec_id = '||PARTY_REC_ID;
670: REC_STATUS := 'E';
671: end if;
672: close own_rent;
680: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
681: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
682: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',HEAD_OF_HOUSEHOLD_FLAG,null,'HEAD_OF_HOUSEHOLD_FLAG','IMC_CSV_Y_OR_N',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
683: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
684: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
685: ' and party_rec_id = '||PARTY_REC_ID;
686: REC_STATUS := 'E';
687: end if;
688: end if;
695: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
696: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
697: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',ADDRESS1,null,'ADDRESS1',null,PARTY_NAME,'E',
698: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
699: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
700: ' and party_rec_id = '||PARTY_REC_ID;
701: REC_STATUS := 'E';
702: end if;
703:
709: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
710: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
711: loadId,batchId,PARTY_REC_ID,'VALUE_ERROR',COUNTRY,null,'COUNTRY',null,PARTY_NAME,'E',
712: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
713: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
714: ' and party_rec_id = '||PARTY_REC_ID;
715: REC_STATUS := 'E';
716: end if;
717: close country_code;
720: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
721: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
722: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',COUNTRY,null,'COUNTRY',null,PARTY_NAME,'E',
723: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
724: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
725: ' and party_rec_id = '||PARTY_REC_ID;
726: REC_STATUS := 'E';
727: end if;
728:
734: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
735: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
736: loadId,batchId,PARTY_REC_ID,'VALUE_ERROR',LANGUAGE,null,'LANGUAGE',null,PARTY_NAME,'E',
737: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
738: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
739: ' and party_rec_id = '||PARTY_REC_ID;
740: REC_STATUS := 'E';
741: end if;
742: close language_code;
754: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
755: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
756: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CONTACT_POINT_TYPE,null,'CONTACT_POINT_TYPE','COMMUNICATION_TYPE',PARTY_NAME,'E',
757: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
758: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
759: ' and party_rec_id = '||PARTY_REC_ID;
760: REC_STATUS := 'E';
761: end if;
762: close contact_pnt_type;
766: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
767: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
768: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',PHONE_NUMBER,null,'PHONE_NUMBER',null,PARTY_NAME,'E',
769: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
770: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
771: ' and party_rec_id = '||PARTY_REC_ID;
772: REC_STATUS := 'E';
773: end if;
774:
777: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
778: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
779: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',PHONE_NUMBER,null,'PHONE_NUMBER',null,PARTY_NAME,'E',
780: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
781: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
782: ' and party_rec_id = '||PARTY_REC_ID;
783: REC_STATUS := 'E';
784: end if;
785:
788: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
789: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
790: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',EMAIL_ADDRESS,null,'EMAIL_ADDRESS',null,PARTY_NAME,'E',
791: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
792: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
793: ' and party_rec_id = '||PARTY_REC_ID;
794: REC_STATUS := 'E';
795: end if;
796:
799: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
800: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
801: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',URL,null,'URL',null,PARTY_NAME,'E',
802: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
803: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
804: ' and party_rec_id = '||PARTY_REC_ID;
805: REC_STATUS := 'E';
806: end if;
807:
810: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
811: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
812: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',TELEX_NUMBER,null,'TELEX_NUMBER',null,PARTY_NAME,'E',
813: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
814: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
815: ' and party_rec_id = '||PARTY_REC_ID;
816: REC_STATUS := 'E';
817: end if;
818:
826: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
827: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
828: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',CLASS_CATEGORY,null,'CLASS_CATEGORY','SIC_CODE_TYPE',PARTY_NAME,'E',
829: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
830: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
831: ' and party_rec_id = '||PARTY_REC_ID;
832: REC_STATUS := 'E';
833: else
834: open clss_category(CLASS_CATEGORY);
839: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
840: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
841: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CLASS_CATEGORY,null,'CLASS_CATEGORY','SIC_CODE_TYPE',PARTY_NAME,'E',
842: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
843: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
844: ' and party_rec_id = '||PARTY_REC_ID;
845: REC_STATUS := 'E';
846: else
847: if (CLASS_CODE is null) then
849: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
850: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
851: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',CLASS_CODE,null,'CLASS_CODE',CLASS_CATEGORY,PARTY_NAME,'E',
852: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
853: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
854: ' and party_rec_id = '||PARTY_REC_ID;
855: REC_STATUS := 'E';
856: else
857: open clss_code(CLASS_CATEGORY,CLASS_CODE);
862: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
863: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
864: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CLASS_CODE,null,'CLASS_CODE',CLASS_CATEGORY,PARTY_NAME,'E',
865: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
866: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
867: ' and party_rec_id = '||PARTY_REC_ID;
868: REC_STATUS := 'E';
869: end if;
870: end if;
1053: values(batchId,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CLASS_CATEGORY,CLASS_CODE,SYSDATE,SYSDATE,FND_GLOBAL.user_id,
1054: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
1055: end if;
1056: --dbms_output.put_line('before the update to rec status to P');
1057: execute immediate 'delete from imc_csv_interface_fields where load_id ='||loadId||' and batch_id = '||batchId||
1058: ' and party_rec_id = '||PARTY_REC_ID;
1059: end if;
1060: end loop;
1061: close get_details;