DBA Data[Home] [Help]

APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on HZ_LOCATIONS

Line 736: LOCATION_ID hz_locations.location_id%type,

732: rec_nrec_ccid_tbl rec_nrec_ccid_tbl_type;
733:
734: TYPE loc_info_rec_type is record
735: (
736: LOCATION_ID hz_locations.location_id%type,
737: LOCATION_TABLE_NAME VARCHAR2(30),
738: COUNTRY_CODE hz_locations.country%type);
739:
740: TYPE loc_info_tbl_type is table of loc_info_rec_type index by VARCHAR2(50);

Line 738: COUNTRY_CODE hz_locations.country%type);

734: TYPE loc_info_rec_type is record
735: (
736: LOCATION_ID hz_locations.location_id%type,
737: LOCATION_TABLE_NAME VARCHAR2(30),
738: COUNTRY_CODE hz_locations.country%type);
739:
740: TYPE loc_info_tbl_type is table of loc_info_rec_type index by VARCHAR2(50);
741: Loc_info_tbl loc_info_tbl_type;
742:

Line 753: LOCATION_ID hz_locations.location_id%type,

749: -- This structure is indexed by a hash value of to_char(location_id) + geography_type
750:
751: TYPE loc_geography_info_rec_type is record
752: (
753: LOCATION_ID hz_locations.location_id%type,
754: GEOGRAPHY_TYPE hz_geographies.geography_type%type,
755: GEOGRAPHY_ID hz_geographies.geography_id%type,
756: GEOGRAPHY_CODE hz_geographies.geography_code%type,
757: GEOGRAPHY_NAME hz_geographies.geography_name%type,