Search Results ego_extfwk_s




Overview
Explore in AI Chat

Overview

APPS.RRS_SITES_EXT_PKG is the PL/SQL package body that implements the server-side extension logic for the Oracle E-Business Suite "Sites" (locations) entity within the Enterprise Resource, Receiving, and Shipping (RRS) framework. In EBS 12.1.1 and 12.2.2 it acts as the transactional API for maintaining site records held in the RRS_SITES_EXT_B and RRS_SITES_EXT_TL tables. The package encapsulates the DML operations required to insert, lock, update, and delete site extension rows, and to propagate translated (language) descriptions, ensuring that all site maintenance occurs through a single controlled interface rather than through ad hoc SQL. It also participates in the Extensibility Framework by referencing EGO_EXTFWK_S, allowing site information to be surfaced and reused in configurator-style extension contexts. The body holds STATUS = VALID in the APPS schema and is not referenced by any other database object, confirming it is a top-level implementation unit.

Key Procedures and Functions

The package body documents five procedures:

  • INSERT_ROW — Creates a new site extension record, populating the base table (RRS_SITES_EXT_B) and the corresponding translation row (RRS_SITES_EXT_TL).
  • LOCK_ROW — Obtains a row-level lock on an existing site record prior to modification or deletion, providing the standard EBS concurrency-friendly pattern used by generated forms APIs.
  • UPDATE_ROW — Applies changes to an existing site record, updating both the base and translation tables as required.
  • DELETE_ROW — Removes a site record, typically cascading the deletion across the base and translation tables.
  • ADD_LANGUAGE — Inserts or refreshes the translated description rows for additional installed languages in RRS_SITES_EXT_TL, using FND_LANGUAGES to determine the active language set.

These procedures correspond to the standard EBS table-handler API pattern generated for _B/_TL table pairs. No parameter lists are documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

  • RRS_SITES_EXT_B — The base language-independent site table; read and written by INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • RRS_SITES_EXT_TL — The translation table holding language-specific text; written by INSERT_ROW, UPDATE_ROW, and ADD_LANGUAGE.
  • EGO_EXTFWK_S — The Extensibility Framework source table, referenced to integrate site extension data with the EGO extensibility model.
  • FND_LANGUAGES — Consulted by ADD_LANGUAGE to enumerate installed languages for translation propagation.
  • DUAL — Used as the standard single-row source for scalar/sequence lookups and validation queries.

Usage Notes

RRS_SITES_EXT_PKG is normally invoked indirectly by the Oracle Forms UI or by concurrent programs that maintain RRS site data, following the conventional insert-lock-update/delete sequence. The package also raises errors through FND_MESSAGE and APP_EXCEPTION, and depends on the RRS_SITES_EXT_B and RRS_SITES_EXT_TL table definitions. Because the body is not referenced by any other database object, custom code that needs to manipulate site extensions should call these procedures directly rather than issuing SQL against the underlying tables. The user search term "ego_extfwk_s" reflects the EGO_EXTFWK_S dependency recorded in the metadata, which links this RRS sites API to the EBS Extensibility Framework.