DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_LOCATION_PROFILES

Line 50: TYPE PROFILE_SST_FLAG IS TABLE OF HZ_LOCATION_PROFILES.VALIDATION_SST_FLAG%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;
54: TYPE LOCATION_ID IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;

Line 55: TYPE LOCATION_PROFILE_ID IS TABLE OF HZ_LOCATION_PROFILES.LOCATION_PROFILE_ID%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;
59: TYPE NUMBER_COLUMN IS TABLE OF NUMBER;