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