66: TYPE FLAG_COLUMN IS TABLE OF VARCHAR2(1);
67: TYPE DATE_COLUMN IS TABLE OF DATE;
68:
69:
70: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
71: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
72: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
73:
74: TYPE RefCurType IS REF CURSOR;
67: TYPE DATE_COLUMN IS TABLE OF DATE;
68:
69:
70: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
71: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
72: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
73:
74: TYPE RefCurType IS REF CURSOR;
75:
68:
69:
70: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
71: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
72: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
73:
74: TYPE RefCurType IS REF CURSOR;
75:
76:
74: TYPE RefCurType IS REF CURSOR;
75:
76:
77: /* Validation error columns */
78: TYPE ERROR_IDS IS TABLE OF hz_imp_errors.error_id%TYPE;
79: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
80: TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
81:
82: /* Data load G_MISS values */