DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_PARTIES_PKG dependencies on HZ_IMP_ERRORS

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

57: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_PARTIES_INT.INTERFACE_STATUS%TYPE;
58: TYPE ERROR_ID IS TABLE OF HZ_IMP_PARTIES_INT.ERROR_ID%TYPE;
59: TYPE OLD_OSR IS TABLE OF HZ_IMP_PARTIES_SG.OLD_ORIG_SYSTEM_REFERENCE%TYPE;
60: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_PARTIES_INT.CREATED_BY_MODULE%TYPE;
61: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
62: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
63: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
64: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
65: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);

Line 62: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;

58: TYPE ERROR_ID IS TABLE OF HZ_IMP_PARTIES_INT.ERROR_ID%TYPE;
59: TYPE OLD_OSR IS TABLE OF HZ_IMP_PARTIES_SG.OLD_ORIG_SYSTEM_REFERENCE%TYPE;
60: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_PARTIES_INT.CREATED_BY_MODULE%TYPE;
61: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
62: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
63: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
64: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
65: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
66: TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);

Line 63: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;

59: TYPE OLD_OSR IS TABLE OF HZ_IMP_PARTIES_SG.OLD_ORIG_SYSTEM_REFERENCE%TYPE;
60: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_PARTIES_INT.CREATED_BY_MODULE%TYPE;
61: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
62: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
63: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
64: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
65: TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
66: TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);
67: TYPE YEAR_COLUMN IS TABLE OF NUMBER(4);

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

73:
74: TYPE RefCurType IS REF CURSOR;
75:
76: /* Validation error columns */
77: TYPE error_ids IS TABLE OF hz_imp_errors.error_id%TYPE;
78: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
79: TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
80:
81: PROCEDURE load_parties (