Search Results rrs_site_header_rec

Overview

APPS.RRS_SITE_INFO is a PL/SQL package body belonging to the Oracle E-Business Suite Release Management and site information framework, associated with the Oracle Real Estate / Trade Management (RRS) module family. The package provides the central data-access layer for retrieving comprehensive site information used throughout Oracle's site and location management flows, including trade area analysis, site hierarchies, and site-related attributes. The package is classified as OTHER in the ETRM registry, indicating it is neither a public callable API nor a pure internal utility, but rather a supporting extraction package consumed by higher-level application logic.

The package's primary responsibility is to assemble a complete, denormalized view of a site — header, address, uses, properties, clusters, hierarchies, trade area groups, relationships, contacts, assets, and flexfield attribute data — starting from a single site identifier or site name. Notably, the metadata records that the package is referenced by zero other packages, meaning it is typically invoked directly through Oracle Forms, OA Framework pages, or custom extensions rather than being wrapped by another PL/SQL layer.

Key Procedures and Functions

The documented package exposes eleven procedures and functions:

• CALL — The generic dispatcher or entry point, typically routing requests to the appropriate internal handler based on the operation requested.
• GET_COMPLETE_SITE_DETAILS — The master aggregation routine. As visible in the source excerpt, it orchestrates calls to Get_site_details and Get_site_attributes and returns strongly-typed PL/SQL collection tables covering site header, address, uses, property, cluster, hierarchy, trade area group, relationship, phone, email, URL, person, attachment, asset, and user-attribute row/data tables (EGO_USER_ATTR_ROW_TABLE and EGO_USER_ATTR_DATA_TABLE).
• GET_SITE_DETAILS — Retrieves the core descriptive records: header, address, and site uses.
• GET_SITE_COMPLETE_ATTRIBUTES — Returns the full set of descriptive flexfield attributes for a site, consolidating multiple attribute contexts.
• GET_SITE_ATTRIBUTES — Retrieves site-level flexfield attribute rows and data, accepting an optional page name to scope which attribute context or page grouping is returned.
• GET_LOCATION_ATTRIBUTES — Returns location-scoped flexfield attributes for the site.
• GET_TRADE_AREA_ATTRIBUTES — Returns trade-area-scoped flexfield attributes associated with the site.
• GET_SITE_ASSOCIATIONS — Retrieves relationships and trade area group associations linking the site to other entities.
• GET_SITE_ATTACHMENTS — Returns attachments and related document metadata linked to the site.
• GET_SITE_CONTACTS — Returns site contact records including phone, email, URL, and person details.
• GET_SITE_ASSETS — Returns asset and item instance information associated with the site.

Tables Accessed

The package reads from several APPS synonyms spanning multiple EBS schemas. Flexfield metadata is drawn from EGO_FND_DSC_FLX_CTX_EXT, EGO_OBJ_AG_ASSOCS_B, and the EGO user-attribute structures referenced by the OUT parameters, enabling site, location, and trade-area descriptive flexfields to be surfaced alongside base records. Attachment handling relies on FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_DOCUMENT_CATEGORIES_TL, FND_DOCUMENT_DATATYPES, and FND_DOCUMENT_ENTITIES, providing category and datatype descriptions for each attachment. Asset and instance data comes from CSI_ITEM_INSTANCES and CSI_INSTANCE_STATUSES. Organizational hierarchy and calendar context is supplied by BOM_CALENDARS, FND_DM_NODES, and FND_OBJECTS. Reference lookups and messages use FND_LOOKUP_VALUES and FND_NEW_MESSAGES. The package is read-oriented; no explicit inserts or updates appear in the excerpt.

Usage Notes

RRS_SITE_INFO is typically invoked from Oracle Forms-based site maintenance screens, OA Framework pages, or custom PL/SQL extensions that require a consolidated snapshot of a site. Because GET_COMPLETE_SITE_DETAILS returns many OUT NOCOPY collection parameters, callers must pre-declare matching PL/SQL table types (rrs_site_header_tab, rrs_site_address_tab, rrs_site_uses_tab, rrs_property_tab, and so forth) and pass them by reference. The NOCOPY hint improves performance for large result sets but means callers should not assume the collections remain unmodified on exception. The package works in both 12.1.1 and 12.2.2, and the header revision (120.0.12010000.10) confirms compatibility across the 12.1.x and 12.2.x code lines. Customizations should treat these routines as informational retrieval APIs and avoid direct DML against the underlying tables.