Search Results sdo_point_type

Overview

APPS.RRS_SITE_UTILS is a standalone PL/SQL utility package body in the Oracle E-Business Suite Applications schema, operating within the Oracle ETRM (Enterprise Trade and Transportation Management) product family. Its principal business function is the management, enrichment, and spatial representation of site and location data. The package bridges standard EBS location entities — such as HZ_LOCATIONS and PN_LOCATIONS_ALL — with trade area, grouping, and mapping structures specific to the RRS site model, and it integrates Oracle Spatial geometry types to support geographic visualization of sites on maps. A defining characteristic of the package, and the reason it surfaces in searches for "sdo_point_type," is its direct dependency on MDSYS spatial objects: SDO_GEOMETRY, SDO_ORDINATE_ARRAY, SDO_POINT_TYPE, and SDO_UTIL. The body is documented as VALID, classified as OTHER (not a public API), and exposes seventeen documented procedures and functions. It is not referenced by any database object, indicating it is invoked from external callers such as Forms, concurrent programs, or custom code rather than being called from other database packages. Per the dependency listing, two other packages reference RRS_SITE_UTILS, consistent with its role as a shared utility layer.

Key Procedures and Functions

The documented procedures and functions cluster around four concerns.

Address and naming utilities: GET_LOCATION_ADDRESS, GET_ADDRESS, GET_LOCATION_NAME, GET_SITE_DISPLAY_NAME, and GET_PROPERTY_NAME retrieve formatted address and display-name information for locations, sites, and properties.
User attribute and prompt handling: GET_USER_ATTR_VAL and GET_UOM_COLUMN_PROMPT resolve descriptive flexfield user attribute values and unit-of-measure column prompts.
Geometry and map support: GET_ORDINATE, GET_GEOMETRY_FOR_LOCATION, UPDATE_GEOMETRY_FOR_LOCATIONS, and SET_GEOMETRY_SRC_FOR_LOCATION construct, retrieve, and persist spatial geometry for locations, while INSERT_TEMP_FOR_MAP and CLEAR_TEMP_FOR_MAP populate and purge the temporary staging table used for map rendering. This cluster is where SDO_POINT_TYPE and related MDSYS types are employed.
Site numbering and favorites: DEFAULT_SITE_NUMBERS generates default site numbers, while ADD_FAVORITE_OBJECTS and GET_MULTIAG_COUNT manage user favorites and multi-agreement counts.
Association validation: ISAGANDCLSASSOCDELETABLE determines whether an agreement-and-class association may be deleted.

Tables Accessed

The package reads and writes both standard EBS and RRS-specific tables through APPS synonyms. HZ_LOCATIONS and PN_LOCATIONS_ALL supply location and address records, while PN_PROPERTIES_ALL provides property definitions. MTL_UNITS_OF_MEASURE and MTL_UOM_CONVERSIONS support unit-of-measure prompt and conversion logic. The RRS tables carry the site model: RRS_SITES_B, RRS_SITE_TMP, RRS_GROUP_TRADE_AREAS, RRS_LOC_TRADE_AREA_GRPS, RRS_TRADE_AREA_GROUPS_B, RRS_DEFAULT_SITE_NUMBER_S, RRS_FAVORITE_S, and RRS_USER_FAVORITES. EGO_FND_DSC_FLX_CTX_EXT and EGO_RESULTS_FMT_USAGES are referenced for flexfield context and results formatting. Spatial processing relies on the MDSYS schema and DUAL.

Usage Notes

RRS_SITE_UTILS is not a public API and is not referenced by any database object; it is therefore invoked by external callers — typically ETRM Forms, map-enabled UI regions, concurrent programs that default or synchronize site numbers, and custom extensions requiring location geometry or address formatting. Because it manipulates SDO_GEOMETRY and SDO_POINT_TYPE directly, any calling code must run in a session where Oracle Spatial is installed and the MDSYS types are accessible. The temporary map table (RRS_SITE_TMP) should be populated via INSERT_TEMP_FOR_MAP and released via CLEAR_TEMP_FOR_MAP to avoid residual data between map sessions. In 12.1.1 and 12.2.2 the object resolves through standard APPS synonyms, so no additional grants beyond normal APPS-schema access are required.

PACKAGE BODY: APPS.RRS_SITE_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:RRS_SITE_UTILS, status:VALID,
SYNONYM: PUBLIC.SDO_POINT_TYPE 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:SDO_POINT_TYPE, status:VALID,
SYNONYM: PUBLIC.SDO_POINT_TYPE 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:SDO_POINT_TYPE, status:VALID,
PACKAGE BODY: APPS.RRS_SITE_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:RRS_SITE_UTILS, status:VALID,
TYPE: MDSYS.SDO_POINT_TYPE 12.1.1
owner:MDSYS, object_type:TYPE, object_name:SDO_POINT_TYPE, status:VALID,
TYPE: MDSYS.SDO_POINT_TYPE 12.2.2
owner:MDSYS, object_type:TYPE, object_name:SDO_POINT_TYPE, status:VALID,
PACKAGE BODY: MDSYS.SDO_GCDR 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GCDR, status:VALID,
TYPE BODY: MDSYS.ST_POINT 12.1.1
owner:MDSYS, object_type:TYPE BODY, object_name:ST_POINT, status:VALID,
PACKAGE BODY: APPS.IRC_ISC_INS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_ISC_INS, status:VALID,
PACKAGE BODY: MDSYS.MD_LRS 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:MD_LRS, status:VALID,
TYPE BODY: MDSYS.ST_POINT 12.2.2
owner:MDSYS, object_type:TYPE BODY, object_name:ST_POINT, status:VALID,
PACKAGE BODY: MDSYS.MD_NET 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:MD_NET, status:VALID,
PACKAGE BODY: APPS.PV_LOCATOR 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PV_LOCATOR, status:VALID,
PACKAGE BODY: APPS.CSFW_SPATIAL_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CSFW_SPATIAL_PUB, status:VALID,
PACKAGE BODY: APPS.CSFW_SPATIAL_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CSFW_SPATIAL_PUB, status:VALID,
PACKAGE BODY: APPS.HZ_GEOCODE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOCODE_PKG, status:VALID,
PACKAGE: APPS.CSF_GPS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:CSF_GPS_PUB, status:VALID,
PACKAGE BODY: MDSYS.SDO_AGGR 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_AGGR, status:VALID,
PACKAGE BODY: MDSYS.SDO_GCDR 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GCDR, status:VALID,
PACKAGE BODY: APPS.WSH_LOCATIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_LOCATIONS_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_LOCATIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_LOCATIONS_PKG, status:VALID,
PACKAGE BODY: APPS.CSF_LF_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_LF_PUB, status:VALID,
PACKAGE BODY: MDSYS.SDO_AGGR 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_AGGR, status:VALID,
PACKAGE BODY: APPS.CSF_LOCUS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_LOCUS_PUB, status:VALID,
PACKAGE BODY: APPS.CSF_LF_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_LF_PUB, status:VALID,
PACKAGE BODY: MDSYS.SDO_NET 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_NET, status:VALID,
PACKAGE BODY: MDSYS.SDO_LRS 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_LRS, status:VALID,
PACKAGE BODY: MDSYS.SDO_GEOR 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GEOR, status:VALID,
PACKAGE BODY: APPS.IRC_ISC_UPD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_ISC_UPD, status:VALID,
PACKAGE BODY: APPS.IRC_ISC_UPD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_ISC_UPD, status:VALID,
PACKAGE BODY: APPS.CSF_LOCUS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_LOCUS_PUB, status:VALID,
PACKAGE BODY: APPS.IRC_LOCATION_UTILITY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_LOCATION_UTILITY, status:VALID,
PACKAGE BODY: APPS.PV_LOCATOR 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PV_LOCATOR, status:VALID,
PACKAGE BODY: MDSYS.SDO_LRS 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_LRS, status:VALID,
PACKAGE BODY: MDSYS.MD_LRS 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:MD_LRS, status:VALID,
PACKAGE BODY: APPS.IRC_ISC_INS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_ISC_INS, status:VALID,
PACKAGE BODY: APPS.IRC_LOCATION_UTILITY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_LOCATION_UTILITY, status:VALID,
PACKAGE BODY: MDSYS.SDO_NET 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_NET, status:VALID,
PACKAGE BODY: MDSYS.MD_NET 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:MD_NET, status:VALID,
PACKAGE BODY: MDSYS.SDO_UTIL 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_UTIL, status:VALID,
PACKAGE BODY: MDSYS.SDO_GEOM 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GEOM, status:VALID,
PACKAGE BODY: APPS.HZ_GEOCODE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOCODE_PKG, status:VALID,
PACKAGE BODY: APPS.CSF_GPS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_GPS_PUB, status:VALID,
PACKAGE BODY: MDSYS.SDO_GEOM 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GEOM, status:VALID,
PACKAGE BODY: MDSYS.SDO_CS 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_CS, status:VALID,
PACKAGE BODY: MDSYS.SDO_GEOR 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GEOR, status:VALID,
PACKAGE BODY: MDSYS.SDO_CS 12.1.1
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_CS, status:VALID,
PACKAGE BODY: APPS.HZ_ELOCATION_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_ELOCATION_PKG, status:VALID,
PACKAGE BODY: APPS.IRC_SEEKER_VAC_MATCHING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IRC_SEEKER_VAC_MATCHING_PKG, status:VALID,
PACKAGE BODY: MDSYS.SDO_GEOR_INT 12.2.2
owner:MDSYS, object_type:PACKAGE BODY, object_name:SDO_GEOR_INT, status:VALID,