6163: l_geography_id NUMBER;
6164: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
6165: l_lines_count NUMBER;
6166:
6167: x_geography_id HZ_GEOGRAPHIES.geography_id%TYPE;
6168: x_geography_code HZ_GEOGRAPHIES.geography_code%TYPE;
6169: x_geography_name HZ_GEOGRAPHIES.geography_name%TYPE;
6170: l_geo_use_count NUMBER;
6171:
6164: l_zone_tbl HZ_GEO_GET_PUB.zone_tbl_type;
6165: l_lines_count NUMBER;
6166:
6167: x_geography_id HZ_GEOGRAPHIES.geography_id%TYPE;
6168: x_geography_code HZ_GEOGRAPHIES.geography_code%TYPE;
6169: x_geography_name HZ_GEOGRAPHIES.geography_name%TYPE;
6170: l_geo_use_count NUMBER;
6171:
6172: l_jursidiction_id_indx BINARY_INTEGER;
6165: l_lines_count NUMBER;
6166:
6167: x_geography_id HZ_GEOGRAPHIES.geography_id%TYPE;
6168: x_geography_code HZ_GEOGRAPHIES.geography_code%TYPE;
6169: x_geography_name HZ_GEOGRAPHIES.geography_name%TYPE;
6170: l_geo_use_count NUMBER;
6171:
6172: l_jursidiction_id_indx BINARY_INTEGER;
6173: