DBA Data[Home] [Help]

APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on HZ_GEOGRAPHIES

Line 707: (ZONE_TYPE hz_geographies.geography_type%TYPE, --bug8251315

703: -- the structure below is used to cache geography types info
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:

Line 910: GEOGRAPHY_TYPE hz_geographies.geography_type%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,
914: GEOGRAPHY_USE hz_geographies.geography_use%type);

Line 911: GEOGRAPHY_ID hz_geographies.geography_id%type,

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,
914: GEOGRAPHY_USE hz_geographies.geography_use%type);
915:

Line 912: GEOGRAPHY_CODE hz_geographies.geography_code%type,

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,
914: GEOGRAPHY_USE hz_geographies.geography_use%type);
915:
916: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;

Line 913: GEOGRAPHY_NAME hz_geographies.geography_name%type,

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,
914: GEOGRAPHY_USE hz_geographies.geography_use%type);
915:
916: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
917: Loc_geography_info_tbl loc_geography_info_tbl_type;

Line 914: GEOGRAPHY_USE hz_geographies.geography_use%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,
914: GEOGRAPHY_USE hz_geographies.geography_use%type);
915:
916: type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
917: Loc_geography_info_tbl loc_geography_info_tbl_type;
918: