704: -- This structure is referenced in jurisdictions API (get_zone)
705:
706: TYPE geography_type_info_rec_type is record
707: (ZONE_TYPE hz_geographies.geography_type%TYPE, --bug8251315
708: GEOGRAPHY_TYPE hz_geography_types_b.geography_type%TYPE,
709: GEOGRAPHY_USE hz_geography_types_b.GEOGRAPHY_USE%TYPE,
710: LIMITED_BY_GEOGRAPHY_ID hz_geography_types_b.LIMITED_BY_GEOGRAPHY_ID%TYPE);
711:
712: TYPE geography_type_info_tbl_type is table of geography_type_info_rec_type index by BINARY_INTEGER;
705:
706: TYPE geography_type_info_rec_type is record
707: (ZONE_TYPE hz_geographies.geography_type%TYPE, --bug8251315
708: GEOGRAPHY_TYPE hz_geography_types_b.geography_type%TYPE,
709: GEOGRAPHY_USE hz_geography_types_b.GEOGRAPHY_USE%TYPE,
710: LIMITED_BY_GEOGRAPHY_ID hz_geography_types_b.LIMITED_BY_GEOGRAPHY_ID%TYPE);
711:
712: TYPE geography_type_info_tbl_type is table of geography_type_info_rec_type index by BINARY_INTEGER;
713:
706: TYPE geography_type_info_rec_type is record
707: (ZONE_TYPE hz_geographies.geography_type%TYPE, --bug8251315
708: GEOGRAPHY_TYPE hz_geography_types_b.geography_type%TYPE,
709: GEOGRAPHY_USE hz_geography_types_b.GEOGRAPHY_USE%TYPE,
710: LIMITED_BY_GEOGRAPHY_ID hz_geography_types_b.LIMITED_BY_GEOGRAPHY_ID%TYPE);
711:
712: TYPE geography_type_info_tbl_type is table of geography_type_info_rec_type index by BINARY_INTEGER;
713:
714:
718: TYPE geography_use_info_rec_type is record
719: (
720: TAX_ID zx_taxes_b.tax_id%type,
721: GEOGRAPHY_TYPE_NUM number,
722: GEOGRAPHY_TYPE hz_geography_types_b.geography_type%type,
723: GEOGRAPHY_USE hz_geography_types_b.geography_use%TYPE);
724:
725: TYPE geography_use_info_tbl_type is table of geography_use_info_rec_type index by binary_integer;
726:
719: (
720: TAX_ID zx_taxes_b.tax_id%type,
721: GEOGRAPHY_TYPE_NUM number,
722: GEOGRAPHY_TYPE hz_geography_types_b.geography_type%type,
723: GEOGRAPHY_USE hz_geography_types_b.geography_use%TYPE);
724:
725: TYPE geography_use_info_tbl_type is table of geography_use_info_rec_type index by binary_integer;
726:
727: -- caching fix done for bug#8551677