1 PACKAGE HZ_IMP_LOAD_CODE_ASSIGNMENTS AS
2 /*$Header: ARHLCDAS.pls 120.9 2005/10/30 04:20:16 appldev noship $*/
3
4 /* HZ_IMP_CLASSIFICS_INT columns */
5 TYPE BATCH_ID IS TABLE OF HZ_IMP_CLASSIFICS_INT.BATCH_ID%TYPE;
6 TYPE PARTY_ORIG_SYSTEM IS TABLE OF HZ_IMP_CLASSIFICS_INT.PARTY_ORIG_SYSTEM%TYPE;
7 TYPE PARTY_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CLASSIFICS_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
8 TYPE CLASS_CATEGORY IS TABLE OF HZ_IMP_CLASSIFICS_INT.CLASS_CATEGORY%TYPE;
9 TYPE CLASS_CODE IS TABLE OF HZ_IMP_CLASSIFICS_INT.CLASS_CODE%TYPE;
10 TYPE START_DATE_ACTIVE IS TABLE OF HZ_IMP_CLASSIFICS_INT.START_DATE_ACTIVE%TYPE;
11 TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CLASSIFICS_INT.INSERT_UPDATE_FLAG%TYPE;
12 TYPE END_DATE_ACTIVE IS TABLE OF HZ_IMP_CLASSIFICS_INT.END_DATE_ACTIVE%TYPE;
13 TYPE RANK IS TABLE OF HZ_IMP_CLASSIFICS_INT.RANK%TYPE;
14 TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CLASSIFICS_INT.INTERFACE_STATUS%TYPE;
15 TYPE ERROR_ID IS TABLE OF HZ_IMP_CLASSIFICS_INT.ERROR_ID%TYPE;
16 TYPE CREATION_DATE IS TABLE OF HZ_IMP_CLASSIFICS_INT.CREATION_DATE%TYPE;
17 TYPE CREATED_BY IS TABLE OF HZ_IMP_CLASSIFICS_INT.CREATED_BY%TYPE;
18 TYPE LAST_UPDATE_DATE IS TABLE OF HZ_IMP_CLASSIFICS_INT.LAST_UPDATE_DATE%TYPE;
19 TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_CLASSIFICS_INT.LAST_UPDATED_BY%TYPE;
20 TYPE LAST_UPDATE_LOGIN IS TABLE OF HZ_IMP_CLASSIFICS_INT.LAST_UPDATE_LOGIN%TYPE;
21 TYPE REQUEST_ID IS TABLE OF HZ_IMP_CLASSIFICS_INT.REQUEST_ID%TYPE;
22 TYPE PROGRAM_APPLICATION_ID IS TABLE OF HZ_IMP_CLASSIFICS_INT.PROGRAM_APPLICATION_ID%TYPE;
23 TYPE PROGRAM_ID IS TABLE OF HZ_IMP_CLASSIFICS_INT.PROGRAM_ID%TYPE;
24 TYPE PROGRAM_UPDATE_DATE IS TABLE OF HZ_IMP_CLASSIFICS_INT.PROGRAM_UPDATE_DATE%TYPE;
25 TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CLASSIFICS_INT.CREATED_BY_MODULE%TYPE;
26
27 TYPE CODE_ASSIGNMENT_ID IS TABLE OF HZ_CODE_ASSIGNMENTS.CODE_ASSIGNMENT_ID%TYPE;
28 TYPE OWNER_TABLE_ID IS TABLE OF HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID%TYPE;
29 TYPE PARTY_TYPE IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_TYPE%TYPE;
30
31 TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
32 TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
33 TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);
34 TYPE YEAR_COLUMN IS TABLE OF NUMBER(4);
35 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
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;
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 (
53 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
54 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
55 ,X_MSG_COUNT OUT NOCOPY NUMBER
56 ,X_MSG_DATA OUT NOCOPY VARCHAR2 );
57
58 END HZ_IMP_LOAD_CODE_ASSIGNMENTS;