Search Results rrs_sites_pkg




Overview
Explore in AI Chat

Overview

APPS.RRS_SITES_PKG is a PL/SQL package belonging to the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 application schema. Based on its object name and the tables it references, the package supports the Oracle Retail Reference (RRS) site and property location data model. Its primary business function is to create and maintain property location records that link RRS site entities to the standard Oracle location model (HZ_LOCATIONS), thereby enabling site-level address and location information to be shared with the broader EBS trading community architecture. The package is classified in the ETRM metadata with an API classification of OTHER, indicating it is not a formally published public interface but rather an internal utility used within the RRS module. It currently holds a VALID status in the APPS schema.

Key Procedures and Functions

Five documented program units are exposed by the package:

  • CREATE_PROPERTY_LOCATIONS — The core routine responsible for creating property location records, propagating site and property address data into the associated location tables.
  • CREATE_PROPERTY_LOCATIONS_WRP — A wrapper procedure that surrounds the core creation logic, providing a controlled invocation entry point (typically for error handling, logging, or default parameter mediation).
  • CREATE_PROPERTY_LOCATIONS_CONC — A concurrent-program entry point that allows property location creation to be submitted as a batch/concurrent request rather than interactively.
  • DELETE_TEMPLATE — Removes a template definition associated with RRS sites, supporting cleanup and configuration maintenance.
  • GET_COUNTRYCODE — A lookup function that returns the country code applicable to a given location or site context, used during location creation and validation.

The metadata documents procedure and function names only; parameter lists are not published and should not be assumed.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • RRS_SITES_B, RRS_SITES_TL — The base and translated tables holding RRS site definitions, serving as the source of property location data.
  • RRS_SITES_EXT_B, RRS_SITES_EXT_TL — Extension tables storing additional site attributes and their translations.
  • RRS_SITE_USES — Defines how each site is used, informing which locations require creation.
  • PN_LOCATIONS_ITF — The property/location interface table used for bulk loading and staging of location records.
  • HZ_LOCATIONS — The Trading Community Architecture location table into which final, standardized location records are written.

Together these tables support the mapping of RRS site definitions into the enterprise location model.

Usage Notes

RRS_SITES_PKG is typically invoked during property or site setup within the RRS module. The concurrent entry point (CREATE_PROPERTY_LOCATIONS_CONC) suggests it is commonly scheduled or submitted as a concurrent program to mass-generate property locations, while the wrapper (CREATE_PROPERTY_LOCATIONS_WRP) provides safe synchronous invocation from forms or custom PL/SQL. The ETRM metadata records no other APPS packages referencing RRS_SITES_PKG, indicating it is a self-contained utility with no upstream dependents. Customizations should call the wrapper or concurrent entry point rather than the underlying proc directly, and should treat the package as an internal rather than a published Oracle API.