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.

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 12: TYPE SITE_ORIG_SYSTEM IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;

8: TYPE de_norm_cursor_type IS REF CURSOR;
9:
10: TYPE APPLICATION_ID IS TABLE OF HZ_LOCATIONS.APPLICATION_ID%TYPE;
11: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
12: TYPE SITE_ORIG_SYSTEM IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
13: TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
14: TYPE SITE_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_SITE_ID%TYPE;
15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_ID%TYPE;
16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;

Line 13: TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;

9:
10: TYPE APPLICATION_ID IS TABLE OF HZ_LOCATIONS.APPLICATION_ID%TYPE;
11: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
12: TYPE SITE_ORIG_SYSTEM IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
13: TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
14: TYPE SITE_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_SITE_ID%TYPE;
15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_ID%TYPE;
16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;
17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;

Line 16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;

12: TYPE SITE_ORIG_SYSTEM IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
13: TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
14: TYPE SITE_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_SITE_ID%TYPE;
15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_ID%TYPE;
16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;
17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;

Line 17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;

13: TYPE SITE_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
14: TYPE SITE_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_SITE_ID%TYPE;
15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_ID%TYPE;
16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;
17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;

Line 19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;

15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_ID%TYPE;
16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;
17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;

Line 20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;

16: TYPE SITE_NAME IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NAME%TYPE;
17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;

Line 21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;

17: TYPE PARTY_SITE_NUMBER IS TABLE OF HZ_IMP_ADDRESSES_INT.PARTY_SITE_NUMBER%TYPE;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;

Line 22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;

18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;

Line 23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;

19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;
20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;

Line 24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;

20: TYPE ATTRIBUTE IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE1%TYPE;
21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;

Line 25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;

21: TYPE COUNTRY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTRY%TYPE;
22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;

Line 26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;

22: TYPE ADDRESS IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS1%TYPE;
23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:

Line 27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;

23: TYPE CITY IS TABLE OF HZ_IMP_ADDRESSES_INT.CITY%TYPE;
24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;

Line 28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;

24: TYPE POSTAL_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_CODE%TYPE;
25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;

Line 29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;

25: TYPE STATE IS TABLE OF HZ_IMP_ADDRESSES_INT.STATE%TYPE;
26: TYPE PROVINCE IS TABLE OF HZ_IMP_ADDRESSES_INT.PROVINCE%TYPE;
27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;

Line 31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;

27: TYPE COUNTY IS TABLE OF HZ_IMP_ADDRESSES_INT.COUNTY%TYPE;
28: TYPE ADDRESS_LINES_PHONETIC IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDRESS_LINES_PHONETIC%TYPE;
29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;

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

29: TYPE LAST_UPDATED_BY IS TABLE OF HZ_IMP_ADDRESSES_INT.LAST_UPDATED_BY%TYPE;
30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;

Line 34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;

30:
31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;

Line 35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;

31: TYPE POSTAL_PLUS4_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.POSTAL_PLUS4_CODE%TYPE;
32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;

Line 36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;

32: TYPE TIMEZONE IS TABLE OF fnd_timezones_b.UPGRADE_TZ_ID%TYPE;
33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;

Line 37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;

33: TYPE TIMEZONE_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.TIMEZONE_CODE%TYPE;
34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;

Line 38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;

34: TYPE LOCATION_DIRECTIONS IS TABLE OF HZ_IMP_ADDRESSES_INT.LOCATION_DIRECTIONS%TYPE;
35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;

Line 39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;

35: TYPE CLLI_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.CLLI_CODE%TYPE;
36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;

Line 40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;

36: TYPE LANGUAGE IS TABLE OF HZ_IMP_ADDRESSES_INT.LANGUAGE%TYPE;
37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;

Line 41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;

37: TYPE SHORT_DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.SHORT_DESCRIPTION%TYPE;
38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;

Line 42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;

38: TYPE DESCRIPTION IS TABLE OF HZ_IMP_ADDRESSES_INT.DESCRIPTION%TYPE;
39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;

Line 43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;

39: TYPE SALES_TAX_GEOCODE IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_GEOCODE%TYPE;
40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;
47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;

Line 44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;

40: TYPE SALES_TAX_LIMITS IS TABLE OF HZ_IMP_ADDRESSES_INT.SALES_TAX_INSIDE_CITY_LIMITS%TYPE;
41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;
47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;
48: TYPE IDENT_ADDR_FLAG IS TABLE OF HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;

Line 45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;

41: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_ADDRESSES_INT.CREATED_BY_MODULE%TYPE;
42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;
47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;
48: TYPE IDENT_ADDR_FLAG IS TABLE OF HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;
49: TYPE VALIDATION_STATUS_CODE IS TABLE OF HZ_LOCATIONS.VALIDATION_STATUS_CODE%TYPE;

Line 46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;

42: TYPE DELIVERY_POINT_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.DELIVERY_POINT_CODE%TYPE;
43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;
47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;
48: TYPE IDENT_ADDR_FLAG IS TABLE OF HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;
49: TYPE VALIDATION_STATUS_CODE IS TABLE OF HZ_LOCATIONS.VALIDATION_STATUS_CODE%TYPE;
50: TYPE PROFILE_SST_FLAG IS TABLE OF HZ_LOCATION_PROFILES.VALIDATION_SST_FLAG%TYPE;

Line 47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;

43: TYPE ACCEPT_STANDARDIZED_FLAG IS TABLE OF HZ_IMP_ADDRESSES_INT.ACCEPT_STANDARDIZED_FLAG%TYPE;
44: TYPE ADAPTER_CONTENT_SRC IS TABLE OF HZ_IMP_ADDRESSES_INT.Adapter_content_source%TYPE;
45: TYPE CORRECT_MOVE_INDICATOR IS TABLE OF HZ_IMP_ADDRESSES_INT.CORRECT_MOVE_INDICATOR%TYPE;
46: TYPE VALID_STATUS_CODE IS TABLE OF HZ_IMP_ADDRESSES_INT.ADDR_VALID_STATUS_CODE%TYPE;
47: TYPE DATE_VALIDATED IS TABLE OF HZ_IMP_ADDRESSES_INT.DATE_VALIDATED%TYPE;
48: TYPE IDENT_ADDR_FLAG IS TABLE OF HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG%TYPE;
49: TYPE VALIDATION_STATUS_CODE IS TABLE OF HZ_LOCATIONS.VALIDATION_STATUS_CODE%TYPE;
50: TYPE PROFILE_SST_FLAG IS TABLE OF HZ_LOCATION_PROFILES.VALIDATION_SST_FLAG%TYPE;
51:

Line 58: TYPE ERROR_ID IS TABLE OF HZ_IMP_ADDRESSES_INT.ERROR_ID%TYPE;

54: TYPE LOCATION_ID IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
55: TYPE LOCATION_PROFILE_ID IS TABLE OF HZ_LOCATION_PROFILES.LOCATION_PROFILE_ID%TYPE;
56: TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
57: TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
58: TYPE ERROR_ID IS TABLE OF HZ_IMP_ADDRESSES_INT.ERROR_ID%TYPE;
59: TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
60: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
61: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
62: TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;