47: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
48: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
49: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
50:
51: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
52: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
53: TYPE ERROR_MESSAGE_VALUE IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
54: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
55: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
48: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
49: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
50:
51: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
52: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
53: TYPE ERROR_MESSAGE_VALUE IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
54: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
55: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
56: TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);
49: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
50:
51: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
52: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
53: TYPE ERROR_MESSAGE_VALUE IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
54: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
55: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
56: TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);
57: TYPE YEAR_COLUMN IS TABLE OF NUMBER(4);
62: TYPE RefCurType IS REF CURSOR;
63:
64:
65: /* Validation error columns */
66: TYPE error_ids IS TABLE OF hz_imp_errors.error_id%TYPE;
67: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
68: TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
69:
70: /* Data load G_MISS values */