Search Results rrs_site_utils




Overview
Explore in AI Chat

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.

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.