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,
758: GEOGRAPHY_USE hz_geographies.geography_use%type);
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,
758: GEOGRAPHY_USE hz_geographies.geography_use%type);
759:
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,
758: GEOGRAPHY_USE hz_geographies.geography_use%type);
759:
760: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
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,
758: GEOGRAPHY_USE hz_geographies.geography_use%type);
759:
760: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
761: Loc_geography_info_tbl loc_geography_info_tbl_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,
758: GEOGRAPHY_USE hz_geographies.geography_use%type);
759:
760: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
761: Loc_geography_info_tbl loc_geography_info_tbl_type;
762: