1 PACKAGE HZ_IMP_LOAD_CONTACT_ROLE_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLOCRS.pls 120.6 2005/10/30 03:53:00 appldev noship $*/
3 /* ARHLOCRS.pls */
4 TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5 TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6 TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7 TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8 TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9 TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10 TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11 TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;
12 TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID%TYPE;
13 TYPE ORG_CONTACT_ROLE_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ROLE_ID%TYPE;
14 TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CREATED_BY_MODULE%TYPE;
15
16 TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
17 TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
18 TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
19 TYPE TYPE_COLUMN IS TABLE OF VARCHAR2(30);
20 TYPE IND_COLUMN IS TABLE OF VARCHAR2(30);
21 TYPE YEAR_COLUMN IS TABLE OF NUMBER(4);
22 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
23 TYPE FLAG_COLUMN IS TABLE OF VARCHAR2(1);
24 TYPE DATE_COLUMN IS TABLE OF DATE;
25
26 TYPE RefCurType IS REF CURSOR;
27
28
29 /* Validation error columns */
30 TYPE error_ids IS TABLE OF hz_imp_errors.error_id%TYPE;
31 TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
32 TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
33
34 /* Data load G_MISS values */
35 G_MISS_NUM CONSTANT NUMBER := -9999;
36 G_MISS_CHAR CONSTANT VARCHAR2(1) := '!';
37 G_MISS_DATE CONSTANT DATE := to_date('01/01/4000', 'DD/MM/YYYY');
38
39 PROCEDURE load_contactroles
40 (
41 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2 )
45 ;
46 END HZ_IMP_LOAD_CONTACT_ROLE_PKG;