APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_LOCATIONS

Line 10: TYPE APPLICATION_ID IS TABLE OF HZ_LOCATIONS.APPLICATION_ID%TYPE;

6: TYPE update_cursor_type IS REF CURSOR;
7: TYPE pri_flag_cursor_type IS REF CURSOR;
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;

Line 49: TYPE VALIDATION_STATUS_CODE IS TABLE OF HZ_LOCATIONS.VALIDATION_STATUS_CODE%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:
52:
53: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_ADDRESSES_SG.ACTION_FLAG%TYPE;

Line 54: TYPE LOCATION_ID IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;

50: TYPE PROFILE_SST_FLAG IS TABLE OF HZ_LOCATION_PROFILES.VALIDATION_SST_FLAG%TYPE;
51:
52:
53: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_ADDRESSES_SG.ACTION_FLAG%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;