DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_IMP_ADDRESSES_SG

Line 14: TYPE SITE_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_SITE_ID%TYPE;

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;
18:

Line 15: TYPE PARTY_ID IS TABLE OF HZ_IMP_ADDRESSES_SG.PARTY_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;
18:
19: TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_ADDRESSES_INT.ATTRIBUTE_CATEGORY%TYPE;

Line 53: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_ADDRESSES_SG.ACTION_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;
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;