[Home] [Help]
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
285: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
286: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
287: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',null,null,'ORGANIZATION_NAME',null,null,'E',
288: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
289: 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;
290: REC_STATUS := 'E';
291: end if;
292: PARTY_NAME:=ORGANIZATION_NAME;
293: -- dbms_output.put_line('registration type'||REGISTRATION_TYPE);
303: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
304: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',CONTROL_YR,null,'CONTROL_YR',null,ORGANIZATION_NAME,'E',
305: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
306:
307: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
308: ' and party_rec_id = '||PARTY_REC_ID;
309: REC_STATUS := 'E';
310: end;
311: end if;
320: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
321: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',EMPLOYEES_TOTAL,null,'EMPLOYEES_TOTAL',null,ORGANIZATION_NAME,'E',
322: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
323:
324: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
325: ' and party_rec_id = '||PARTY_REC_ID;
326: REC_STATUS := 'E';
327: end;
328: end if;
337: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
338: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',INCORP_YEAR,null,'INCORP_YEAR',null,ORGANIZATION_NAME,'E',
339: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
340:
341: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
342: ' and party_rec_id = '||PARTY_REC_ID;
343: REC_STATUS := 'E';
344: end;
345: end if;
355: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
356: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',TOTAL_PAYMENTS,null,'TOTAL_PAYMENTS',null,ORGANIZATION_NAME,'E',
357: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
358:
359: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
360: ' and party_rec_id = '||PARTY_REC_ID;
361: REC_STATUS := 'E';
362: end;
363: end if;
372: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
373: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',YEAR_ESTABLISHED,null,'YEAR_ESTABLISHED',null,ORGANIZATION_NAME,'E',
374: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
375:
376: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
377: ' and party_rec_id = '||PARTY_REC_ID;
378: REC_STATUS := 'E';
379: end;
380: end if;
388: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
389: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',LEGAL_STATUS,null,'LEGAL_STATUS','LEGAL_STATUS',ORGANIZATION_NAME,'E',
390: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
391:
392: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
393: ' and party_rec_id = '||PARTY_REC_ID;
394: REC_STATUS := 'E';
395: end if;
396: close legal_status_code;
404: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
405: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
406: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',HQ_BRANCH_IND,null,'HQ_BRANCH_IND','HQ_BRANCH_IND',ORGANIZATION_NAME,'E',
407: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
408: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
409: ' and party_rec_id = '||PARTY_REC_ID;
410: REC_STATUS := 'E';
411: end if;
412: close hq_branch;
420: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
421: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
422: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',FISCAL_YEAREND_MONTH,null,'FISCAL_YEAREND_MONTH','MONTH',ORGANIZATION_NAME,'E',
423: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
424: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
425: ' and party_rec_id = '||PARTY_REC_ID;
426: REC_STATUS := 'E';
427: end if;
428: close FISCAL_YREND_MONTH;
438: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
439: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
440: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',REGISTRATION_TYPE,null,'REGISTRATION_TYPE','REGISTRATION_TYPE',ORGANIZATION_NAME,'E',
441: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
442: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
443: ' and party_rec_id = '||PARTY_REC_ID;
444: REC_STATUS := 'E';
445: end if;
446: close REGISTRY_TYPE;
454: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
455: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
456: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',OOB_IND,null,'OOB_IND','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
457: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
458: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
459: ' and party_rec_id = '||PARTY_REC_ID;
460: REC_STATUS := 'E';
461: end if;
462: end if;
469: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
470: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
471: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',BRANCH_FLAG,null,'BRANCH_FLAG','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
472: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
473: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
474: ' and party_rec_id = '||PARTY_REC_ID;
475: REC_STATUS := 'E';
476: end if;
477: end if;
484: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
485: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
486: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PARENT_SUB_IND,null,'PARENT_SUB_IND','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
487: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
488: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
489: ' and party_rec_id = '||PARTY_REC_ID;
490: REC_STATUS := 'E';
491: end if;
492: end if;
499: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
500: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
501: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PUBLIC_PRIVATE_OWNERSHIP_FLAG,null,'PUBLIC_PRIVATE_OWNERSHIP_FLAG','IMC_CSV_Y_OR_N',ORGANIZATION_NAME,'E',
502: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
503: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
504: ' and party_rec_id = '||PARTY_REC_ID;
505: REC_STATUS := 'E';
506: end if;
507: end if;
515: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
516: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',null,null,'PERSON_FIRST_NAME',null,null,'E',
517: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
518:
519: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
520: ' and party_rec_id = '||PARTY_REC_ID;
521: REC_STATUS := 'E';
522: else
523: if (ORGANIZATION_NAME is not null) then
537: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
538: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',PERSONAL_INCOME,null,'PERSONAL_INCOME',null,PARTY_NAME,'E',
539: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
540:
541: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
542: ' and party_rec_id = '||PARTY_REC_ID;
543: REC_STATUS := 'E';
544: end;
545: end if;
554: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
555: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',HOUSEHOLD_INCOME,null,'HOUSEHOLD_INCOME',null,PARTY_NAME,'E',
556: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
557:
558: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
559: ' and party_rec_id = '||PARTY_REC_ID;
560: REC_STATUS := 'E';
561: end;
562: end if;
570: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
571: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
572: loadId,batchId,PARTY_REC_ID,'DATA_TYPE',HOUSEHOLD_SIZE,null,'HOUSEHOLD_SIZE',null,PARTY_NAME,'E',
573: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
574: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
575: ' and party_rec_id = '||PARTY_REC_ID;
576: REC_STATUS := 'E';
577: end;
578: end if;
588: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
589: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',DATE_OF_BIRTH,null,'DATE_OF_BIRTH',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
590: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
591:
592: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
593: ' and party_rec_id = '||PARTY_REC_ID;
594: REC_STATUS := 'E';
595: end;
596: end if;
605: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
606: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',DATE_OF_DEATH,null,'DATE_OF_DEATH',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
607: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
608:
609: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
610: ' and party_rec_id = '||PARTY_REC_ID;
611: REC_STATUS := 'E';
612: end;
613: end if;
622: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
623: loadId,batchId,PARTY_REC_ID,'DATE_FORMAT',MARITAL_STATUS_EFFECTIVE_DATE,null,'MARITAL_STATUS_EFFECTIVE_DATE',null,PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
624: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
625:
626: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
627: ' and party_rec_id = '||PARTY_REC_ID;
628: REC_STATUS := 'E';
629: end;
630: end if;
637: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
638: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
639: 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',
640: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
641: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
642: ' and party_rec_id = '||PARTY_REC_ID;
643: REC_STATUS := 'E';
644: end if;
645: close contact_title;
653: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
654: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
655: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',MARITAL_STATUS,null,'MARITAL_STATUS','MARITAL_STATUS',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
656: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
657: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
658: ' and party_rec_id = '||PARTY_REC_ID;
659: REC_STATUS := 'E';
660: end if;
661: close marry_status;
669: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
670: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
671: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',RENT_OWN_IND,null,'RENT_OWN_IND','OWN_RENT_IND',PERSON_FIRST_NAME||' '||PERSON_LAST_NAME,'E',
672: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
673: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
674: ' and party_rec_id = '||PARTY_REC_ID;
675: REC_STATUS := 'E';
676: end if;
677: close own_rent;
685: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
686: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
687: 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',
688: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
689: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
690: ' and party_rec_id = '||PARTY_REC_ID;
691: REC_STATUS := 'E';
692: end if;
693: end if;
700: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
701: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
702: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',ADDRESS1,null,'ADDRESS1',null,PARTY_NAME,'E',
703: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
704: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
705: ' and party_rec_id = '||PARTY_REC_ID;
706: REC_STATUS := 'E';
707: end if;
708:
714: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
715: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
716: loadId,batchId,PARTY_REC_ID,'VALUE_ERROR',COUNTRY,null,'COUNTRY',null,PARTY_NAME,'E',
717: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
718: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
719: ' and party_rec_id = '||PARTY_REC_ID;
720: REC_STATUS := 'E';
721: end if;
722: close country_code;
725: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
726: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
727: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',COUNTRY,null,'COUNTRY',null,PARTY_NAME,'E',
728: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
729: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
730: ' and party_rec_id = '||PARTY_REC_ID;
731: REC_STATUS := 'E';
732: end if;
733:
739: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
740: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
741: loadId,batchId,PARTY_REC_ID,'VALUE_ERROR',LANGUAGE,null,'LANGUAGE',null,PARTY_NAME,'E',
742: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
743: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
744: ' and party_rec_id = '||PARTY_REC_ID;
745: REC_STATUS := 'E';
746: end if;
747: close language_code;
758: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
759: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
760: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',PHONE_LINE_TYPE,null,'PHONE_LINE_TYPE','PHONE_LINE_TYPE',PARTY_NAME,'E',
761: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
762: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
763: ' and party_rec_id = '||PARTY_REC_ID;
764: REC_STATUS := 'E';
765: end if;
766: close ph_line_type;
775: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
776: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
777: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CONTACT_POINT_TYPE,null,'CONTACT_POINT_TYPE','COMMUNICATION_TYPE',PARTY_NAME,'E',
778: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
779: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
780: ' and party_rec_id = '||PARTY_REC_ID;
781: REC_STATUS := 'E';
782: end if;
783: close contact_pnt_type;
787: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
788: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
789: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',PHONE_NUMBER,null,'PHONE_NUMBER',null,PARTY_NAME,'E',
790: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
791: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
792: ' and party_rec_id = '||PARTY_REC_ID;
793: REC_STATUS := 'E';
794: end if;
795:
798: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
799: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
800: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',PHONE_NUMBER,null,'PHONE_NUMBER',null,PARTY_NAME,'E',
801: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
802: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
803: ' and party_rec_id = '||PARTY_REC_ID;
804: REC_STATUS := 'E';
805: end if;
806:
809: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
810: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
811: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',EMAIL_ADDRESS,null,'EMAIL_ADDRESS',null,PARTY_NAME,'E',
812: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
813: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
814: ' and party_rec_id = '||PARTY_REC_ID;
815: REC_STATUS := 'E';
816: end if;
817:
820: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
821: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
822: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',URL,null,'URL',null,PARTY_NAME,'E',
823: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
824: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
825: ' and party_rec_id = '||PARTY_REC_ID;
826: REC_STATUS := 'E';
827: end if;
828:
831: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
832: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
833: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',TELEX_NUMBER,null,'TELEX_NUMBER',null,PARTY_NAME,'E',
834: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
835: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
836: ' and party_rec_id = '||PARTY_REC_ID;
837: REC_STATUS := 'E';
838: end if;
839:
847: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
848: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
849: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',CLASS_CATEGORY,null,'CLASS_CATEGORY','SIC_CODE_TYPE',PARTY_NAME,'E',
850: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
851: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
852: ' and party_rec_id = '||PARTY_REC_ID;
853: REC_STATUS := 'E';
854: else
855: open clss_category(CLASS_CATEGORY);
860: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
861: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
862: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CLASS_CATEGORY,null,'CLASS_CATEGORY','SIC_CODE_TYPE',PARTY_NAME,'E',
863: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
864: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
865: ' and party_rec_id = '||PARTY_REC_ID;
866: REC_STATUS := 'E';
867: else
868: if (CLASS_CODE is null) then
870: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
871: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
872: loadId,batchId,PARTY_REC_ID,'MANDATORY_FIELDS',CLASS_CODE,null,'CLASS_CODE',CLASS_CATEGORY,PARTY_NAME,'E',
873: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
874: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
875: ' and party_rec_id = '||PARTY_REC_ID;
876: REC_STATUS := 'E';
877: else
878: open clss_code(CLASS_CATEGORY,CLASS_CODE);
883: LOAD_ID,BATCH_ID,PARTY_REC_ID,ERROR_TYPE,ERROR_VALUE,NEW_VALUE,ATTRIBUTE_ERRORED,LOOKUP_ERROR,PARTY_NAME,ERROR_STATUS,
884: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) values(
885: loadId,batchId,PARTY_REC_ID,'LOOKUP_ERROR',CLASS_CODE,null,'CLASS_CODE',CLASS_CATEGORY,PARTY_NAME,'E',
886: SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
887: execute immediate 'update imc_csv_interface_fields set rec_status=''E'' where load_id ='||loadId||' and batch_id = '||batchId||
888: ' and party_rec_id = '||PARTY_REC_ID;
889: REC_STATUS := 'E';
890: end if;
891: end if;
1075: values(batchId,'CSV',PARTY_ORIG_SYSTEM_REFERENCE,CLASS_CATEGORY,CLASS_CODE,SYSDATE,SYSDATE,FND_GLOBAL.user_id,
1076: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id);
1077: end if;
1078: --dbms_output.put_line('before the update to rec status to P');
1079: execute immediate 'delete from imc_csv_interface_fields where load_id ='||loadId||' and batch_id = '||batchId||
1080: ' and party_rec_id = '||PARTY_REC_ID;
1081: end if;
1082: end loop;
1083: close get_details;