888: rec_nrec_ccid_tbl rec_nrec_ccid_tbl_type;
889:
890: TYPE loc_info_rec_type is record
891: (
892: LOCATION_ID hz_locations.location_id%type,
893: LOCATION_TABLE_NAME VARCHAR2(30),
894: COUNTRY_CODE hz_locations.country%type);
895:
896: TYPE loc_info_tbl_type is table of loc_info_rec_type index by VARCHAR2(50);
890: TYPE loc_info_rec_type is record
891: (
892: LOCATION_ID hz_locations.location_id%type,
893: LOCATION_TABLE_NAME VARCHAR2(30),
894: COUNTRY_CODE hz_locations.country%type);
895:
896: TYPE loc_info_tbl_type is table of loc_info_rec_type index by VARCHAR2(50);
897: Loc_info_tbl loc_info_tbl_type;
898:
905: -- This structure is indexed by a hash value of to_char(location_id) + geography_type
906:
907: TYPE loc_geography_info_rec_type is record
908: (
909: LOCATION_ID hz_locations.location_id%type,
910: GEOGRAPHY_TYPE hz_geographies.geography_type%type,
911: GEOGRAPHY_ID hz_geographies.geography_id%type,
912: GEOGRAPHY_CODE hz_geographies.geography_code%type,
913: GEOGRAPHY_NAME hz_geographies.geography_name%type,