36: TYPE FLAG_COLUMN IS TABLE OF VARCHAR2(1);
37: TYPE DATE_COLUMN IS TABLE OF DATE;
38:
39:
40: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
41: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
42: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
43:
44: TYPE RefCurType IS REF CURSOR;
37: TYPE DATE_COLUMN IS TABLE OF DATE;
38:
39:
40: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
41: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
42: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
43:
44: TYPE RefCurType IS REF CURSOR;
45:
38:
39:
40: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
41: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
42: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
43:
44: TYPE RefCurType IS REF CURSOR;
45:
46:
44: TYPE RefCurType IS REF CURSOR;
45:
46:
47: /* Validation error columns */
48: TYPE error_ids IS TABLE OF hz_imp_errors.error_id%TYPE;
49: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
50: TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
51:
52: PROCEDURE load_code_assignments (