eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HZ_IMP_LOAD_CPT_PKG dependencies on HZ_IMP_CONTACTPTS_INT

Line 4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;

1: PACKAGE HZ_IMP_LOAD_CPT_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARHLCPTS.pls 120.7 2005/10/30 04:20:19 appldev noship $ */
3:
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;
5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;

Line 5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;

1: PACKAGE HZ_IMP_LOAD_CPT_PKG AUTHID CURRENT_USER AS
2: /* $Header: ARHLCPTS.pls 120.7 2005/10/30 04:20:19 appldev noship $ */
3:
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;
5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;

Line 6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;

2: /* $Header: ARHLCPTS.pls 120.7 2005/10/30 04:20:19 appldev noship $ */
3:
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;
5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;

Line 7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;

3:
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;
5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;

Line 8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;

4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.BATCH_ID%TYPE;
5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;

Line 9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;

5: TYPE ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;

Line 10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;

6: TYPE ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;

Line 11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;

7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;

Line 12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;

8: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_TYPE%TYPE;
9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;

Line 13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;

9: TYPE CONTACT_POINT_PURPOSE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CONTACT_POINT_PURPOSE%TYPE;
10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;

Line 14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;

10: TYPE EDI_ECE_TP_LOCATION_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ECE_TP_LOCATION_CODE%TYPE;
11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;

Line 15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;

11: TYPE EDI_ID_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_ID_NUMBER%TYPE;
12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;

Line 16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;

12: TYPE EDI_PAYMENT_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_FORMAT%TYPE;
13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;

Line 17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;

13: TYPE EDI_PAYMENT_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_PAYMENT_METHOD%TYPE;
14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;

Line 18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;

14: TYPE EDI_REMITTANCE_INSTRUCTION IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE;
15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;

Line 19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;

15: TYPE EDI_REMITTANCE_METHOD IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_REMITTANCE_METHOD%TYPE;
16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;

Line 20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;

16: TYPE EDI_TP_HEADER_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TP_HEADER_ID%TYPE;
17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;

Line 21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;

17: TYPE EDI_TRANSACTION_HANDLING IS TABLE OF HZ_IMP_CONTACTPTS_INT.EDI_TRANSACTION_HANDLING%TYPE;
18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;

Line 22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;

18: TYPE EFT_PRINTING_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_PRINTING_PROGRAM_ID%TYPE;
19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;

Line 23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;

19: TYPE EFT_SWIFT_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_SWIFT_CODE%TYPE;
20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;

Line 24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;

20: TYPE EFT_TRANSMISSION_PROGRAM_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_TRANSMISSION_PROGRAM_ID%TYPE;
21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;

Line 25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;

21: TYPE EFT_USER_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.EFT_USER_NUMBER%TYPE;
22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;

Line 26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;

22: TYPE EMAIL_ADDRESS IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_ADDRESS%TYPE;
23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;

Line 27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;

23: TYPE EMAIL_FORMAT IS TABLE OF HZ_IMP_CONTACTPTS_INT.EMAIL_FORMAT%TYPE;
24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;

Line 28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;

24: TYPE PHONE_AREA_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_AREA_CODE%TYPE;
25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;

Line 29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;

25: TYPE PHONE_COUNTRY_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_COUNTRY_CODE%TYPE;
26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;

Line 30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;

26: TYPE PHONE_EXTENSION IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_EXTENSION%TYPE;
27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;

Line 31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;

27: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_LINE_TYPE%TYPE;
28: TYPE PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_NUMBER%TYPE;
29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;

Line 33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;

29: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.RAW_PHONE_NUMBER%TYPE;
30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;

Line 34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;

30: TYPE PHONE_CALLING_CALENDAR IS TABLE OF HZ_IMP_CONTACTPTS_INT.PHONE_CALLING_CALENDAR%TYPE;
31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;

Line 35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;

31: TYPE TELEX_NUMBER IS TABLE OF HZ_IMP_CONTACTPTS_INT.TELEX_NUMBER%TYPE;
32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;

Line 36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;

32: TYPE TIMEZONE_ID IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;

Line 37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;

33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_CONTACTPTS_INT.TIMEZONE_CODE%TYPE;
34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;
41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;

Line 38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;

34: TYPE URL IS TABLE OF HZ_IMP_CONTACTPTS_INT.URL%TYPE;
35: TYPE WEB_TYPE IS TABLE OF HZ_IMP_CONTACTPTS_INT.WEB_TYPE%TYPE;
36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;
41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;
42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;

Line 40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;

36: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE_CATEGORY%TYPE;
37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;
41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;
42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;
43: TYPE PARTY_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_ID%TYPE;
44: TYPE PARTY_SITE_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_SITE_ID%TYPE;

Line 41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;

37: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_CONTACTPTS_INT.ATTRIBUTE1%TYPE;
38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;
41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;
42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;
43: TYPE PARTY_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_ID%TYPE;
44: TYPE PARTY_SITE_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_SITE_ID%TYPE;
45: -- TYPE STAGE_CP_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.STAGE_CP_ID%TYPE;

Line 42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;

38: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTPTS_INT.INTERFACE_STATUS%TYPE;
39: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_SG.ACTION_FLAG%TYPE;
40: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.ERROR_ID%TYPE;
41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;
42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;
43: TYPE PARTY_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_ID%TYPE;
44: TYPE PARTY_SITE_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_SITE_ID%TYPE;
45: -- TYPE STAGE_CP_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.STAGE_CP_ID%TYPE;
46: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CREATED_BY_MODULE%TYPE;

Line 45: -- TYPE STAGE_CP_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.STAGE_CP_ID%TYPE;

41: TYPE DQM_ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DQM_ACTION_FLAG%TYPE;
42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;
43: TYPE PARTY_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_ID%TYPE;
44: TYPE PARTY_SITE_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_SITE_ID%TYPE;
45: -- TYPE STAGE_CP_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.STAGE_CP_ID%TYPE;
46: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CREATED_BY_MODULE%TYPE;
47: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
48: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
49: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

Line 46: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CREATED_BY_MODULE%TYPE;

42: TYPE DUP_WITHIN_INT_FLAG IS TABLE OF HZ_IMP_CONTACTPTS_INT.DUP_WITHIN_INT_FLAG%TYPE;
43: TYPE PARTY_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_ID%TYPE;
44: TYPE PARTY_SITE_ID IS TABLE OF HZ_IMP_CONTACTPTS_SG.PARTY_SITE_ID%TYPE;
45: -- TYPE STAGE_CP_ID IS TABLE OF HZ_IMP_CONTACTPTS_INT.STAGE_CP_ID%TYPE;
46: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTPTS_INT.CREATED_BY_MODULE%TYPE;
47: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
48: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
49: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
50: