DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CPT_PKG dependencies on HZ_IMP_ERRORS

Line 51: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;

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);

Line 52: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_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);
56: TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);

Line 53: TYPE ERROR_MESSAGE_VALUE IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%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);
57: TYPE YEAR_COLUMN IS TABLE OF NUMBER(4);

Line 66: TYPE error_ids IS TABLE OF hz_imp_errors.error_id%TYPE;

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 */