1 PACKAGE HZ_IMP_LOAD_POST_PROCESS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLPPLS.pls 120.7 2005/09/29 01:07:36 achung noship $ */
3
4 TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
5 TYPE PARTY_TYPE IS TABLE OF HZ_PARTIES.PARTY_TYPE%TYPE;
6 TYPE INSERT_UPDATE_FLAG IS TABLE OF VARCHAR2(1);
7
8 TYPE PARTY_SITE_ID IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
9
10 TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACTS.ORG_CONTACT_ID%TYPE;
11
12 TYPE PERSON_TITLE IS TABLE OF HZ_PARTIES.PERSON_TITLE%TYPE;
13 TYPE PERSON_FIRST_NAME IS TABLE OF HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
14 TYPE PERSON_MIDDLE_NAME IS TABLE OF HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
15 TYPE PERSON_LAST_NAME IS TABLE OF HZ_PARTIES.PERSON_LAST_NAME%TYPE;
16 TYPE PERSON_NAME_SUFFIX IS TABLE OF HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
17 TYPE KNOWN_AS IS TABLE OF HZ_PARTIES.KNOWN_AS%TYPE;
18 TYPE PERSON_FIRST_NAME_PHONETIC IS TABLE OF HZ_PARTIES.PERSON_FIRST_NAME_PHONETIC%TYPE;
19 TYPE MIDDLE_NAME_PHONETIC IS TABLE OF HZ_PERSON_PROFILES.MIDDLE_NAME_PHONETIC%TYPE;
20 TYPE PERSON_LAST_NAME_PHONETIC IS TABLE OF HZ_PARTIES.PERSON_LAST_NAME_PHONETIC%TYPE;
21
22 TYPE PARTY_NAME IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;
23
24 TYPE LOCATION_ID IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
25 TYPE ADDRESS1 IS TABLE OF HZ_LOCATIONS.ADDRESS1%TYPE;
26 TYPE ADDRESS2 IS TABLE OF HZ_LOCATIONS.ADDRESS2%TYPE;
27 TYPE ADDRESS3 IS TABLE OF HZ_LOCATIONS.ADDRESS3%TYPE;
28 TYPE ADDRESS4 IS TABLE OF HZ_LOCATIONS.ADDRESS4%TYPE;
29 TYPE POSTAL_CODE IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
30 TYPE COUNTRY IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
31 TYPE CITY IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
32 TYPE STATE IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
33 TYPE CREATED_BY_MODULE IS TABLE OF HZ_LOCATIONS.CREATED_BY_MODULE%TYPE;
34 TYPE PARTY_NUMBER IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
35
36 TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37 TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38 TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39 TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40 TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41 TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42 TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43 TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44 TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45 TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46 TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47 TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48 TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
49
50 TYPE TITLE IS TABLE OF HZ_ORG_CONTACTS.TITLE%TYPE;
51
52 TYPE RELATIONSHIP_ID IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
53 TYPE RELATIONSHIP_CODE IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_CODE%TYPE;
54 TYPE SUBJECT_ID IS TABLE OF HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
55 TYPE OBJECT_ID IS TABLE OF HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
56 TYPE COMP_FLAG IS TABLE OF VARCHAR2(1);
57 TYPE REF_FLAG IS TABLE OF VARCHAR2(1);
58 TYPE PAR_FLAG IS TABLE OF VARCHAR2(1);
59 TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
60
61 -- Data Type for DQM Sync
62 TYPE EntityList IS TABLE OF VARCHAR2(30);
63
64 PROCEDURE WORKER_PROCESS (
65 Errbuf OUT NOCOPY VARCHAR2,
66 Retcode OUT NOCOPY VARCHAR2,
67 P_BATCH_ID IN NUMBER,
68 P_ACTUAL_CONTENT_SRC IN VARCHAR2,
69 P_BATCH_MODE_FLAG IN VARCHAR2,
70 P_REQUEST_ID IN NUMBER,
71 p_generate_fuzzy_key IN VARCHAR2 := 'Y'
72 );
73
74 END HZ_IMP_LOAD_POST_PROCESS_PKG;
[Home] [Help]