Search Results rrs_sites_ext_pkg




Overview
Explore in AI Chat

Overview

RRS_SITES_EXT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Site Hub / Enterprise Data Quality family of objects, indicated by the RRS_SITES prefix shared with the underlying site extension tables and by its references to the EGO_EXTFWK_S extensibility framework table. The package serves as the low-level database access layer for the "site extension" entity — the customer-defined, flexfield-style attributes that are attached to inventory organizations, sites, and related master data records. It provides the standard CRUD (create, read, update, delete) and row-locking primitives that higher-level business logic, Oracle Forms screens, and the extensibility framework call when persisting attribute values for a site.

The object is documented with a VALID status in ETRM for both 12.1.1 and 12.2.2. Its API classification is recorded as OTHER, reflecting that it is an internal supporting package rather than a published, supported public API.

Key Procedures and Functions

The ETRM metadata documents five procedures. Their purposes are as follows:

  • INSERT_ROW — Creates a new site extension record. It writes the base row into the base table and the corresponding translated descriptions into the translation table.
  • LOCK_ROW — Selects a site extension row for update, acquiring the row-level lock required before a modification. It is normally invoked by the update path to enforce concurrency control.
  • UPDATE_ROW — Applies changes to an existing site extension record, updating the base and translation tables in a consistent manner.
  • DELETE_ROW — Removes a site extension record and its dependent translation rows.
  • ADD_LANGUAGE — Inserts translation rows for a language that does not yet have a translated record for the site extension, supporting the multilingual (TL) table pattern used throughout EBS.

No parameter lists are published in the documentation, and none should be assumed. In practice these procedures follow the conventional EBS _ROW signature pattern, taking the primary key or a row-type record together with an x_return_status out parameter.

Tables Accessed

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

  • RRS_SITES_EXT_B — the base table holding the non-translatable site extension attributes and the primary key of each extension record. This is the principal target of INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW.
  • RRS_SITES_EXT_TL — the translation table holding language-specific text such as the extension name or description. Written by INSERT_ROW, UPDATE_ROW, and ADD_LANGUAGE.
  • EGO_EXTFWK_S — the extensibility framework sequence used to generate primary keys for new extension records during INSERT_ROW.
  • FND_LANGUAGES — the Oracle Applications language repository, consulted by ADD_LANGUAGE to determine the set of installed languages for which translation rows must be created.
  • DUAL — used for single-row scalar queries and sequence lookups.

Usage Notes

RRS_SITES_EXT_PKG is an internal package. ETRM records zero dependent packages, meaning no other PL/SQL API in the applications schema references it directly; its callers are therefore UI and framework components rather than public APIs. It is typically invoked from the Oracle Forms screens that maintain site extension data, and from the EGO extensibility framework when user-defined attributes are committed for a site record. Because the procedures handle their own row locking and translation maintenance, customizations that need to manipulate site extension data should call this package rather than issuing direct DML against RRS_SITES_EXT_B and RRS_SITES_EXT_TL, which would bypass the language synchronization and key generation logic. As an unclassified internal object, it is not covered by Oracle's public API compatibility guarantee, so custom code should be validated after any upgrade between 12.1.1 and 12.2.2.