Search Results rrs_hierarchy_info




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RRS_HIERARCHY_INFO is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified under the OTHER API category and forms part of the site hierarchy and hierarchy versioning infrastructure used by Oracle's site and object management modules. The package is declared with AUTHID CURRENT_USER, meaning its unqualified database object references are resolved against the privileges of the invoking user rather than the package owner; in practice this is paired with APPS synonyms on the underlying tables.

The package exposes a read-oriented API surface for retrieving hierarchy headers, hierarchy members, and hierarchy attributes. It supplies both single-retrieval routines and "complete detail" routines that assemble an entire hierarchy structure in one invocation, plus a parallel set of _TEST wrapper procedures intended for validation and diagnostic use. Return values follow the standard Oracle EBS concurrent/API convention, using the status constants G_RET_STS_SUCCESS ('S'), G_RET_STS_ERROR ('E'), G_RET_STS_UNEXP_ERROR ('U'), and G_RET_STS_WARNING ('W'), with the customary x_return_status, x_msg_count, and x_msg_data out-parameters. The package also declares two named exceptions, e_no_hierarchy_found and e_no_parent_member_found, which signal the two most common failure conditions encountered by callers.

Key Procedures and Functions

  • GET_HIERARCHY_HEADER — overloaded procedure that returns the header record for a hierarchy. The overloads permit lookup by hierarchy version identifier, by hierarchy identifier plus version number, or by hierarchy name, populating an rrs_hier_header_rec out-record.
  • GET_HIERARCHY_MEMBERS — overloaded procedure that returns the member set for a hierarchy version, optionally constrained by a parent member type and parent member identifier, into an rrs_hier_members_tab collection.
  • GET_HIERARCHY_ATTRIBUTES — returns attribute information associated with hierarchy members, supporting custom/descriptive attribute retrieval for hierarchy content.
  • GET_COMPLETE_HIERARCHY_DETAILS — assembles the full hierarchy payload (header plus members plus attributes) in a single call, suited to callers that need the entire structure without iterative navigation.
  • GET_HIERARCHY_HEADER_TEST, GET_HIERARCHY_MEMBERS_TEST, GET_HIERARCHY_ATTRIBUTES_TEST, GET_COMP_HIER_DETAILS_TEST — test/diagnostic counterparts to the four production routines above, used to verify behavior and output without embedding test logic in the main API.

Sixteen documented procedures and functions are associated with the package. Parameter lists are intentionally not reproduced here; callers should obtain signatures from the package specification. NOCOPY is used on the OUT parameters in the documented signatures, reflecting the large collection payloads these routines can return.

Tables Accessed

These accesses are read-oriented, consistent with a query API. No other packages are documented as referencing RRS_HIERARCHY_INFO.

Usage Notes

RRS_HIERARCHY_INFO is typically invoked from server-side PL/SQL rather than directly from forms or concurrent programs. Callers begin with the appropriate GET_HIERARCHY_HEADER overload to validate the hierarchy and capture version context, then call GET_HIERARCHY_MEMBERS (with parent filters for partial traversal) or GET_COMPLETE_HIERARCHY_DETAILS when the full structure is required. Attribute retrieval is performed through GET_HIERARCHY_ATTRIBUTES after member resolution. The _TEST procedures are used during implementation and patching to confirm behavior against known data. Because return status follows the EBS API convention, callers must inspect x_return_status, then drain x_msg_count/x_msg_data via FND_MSG_PUB or DBMS_UTILITY, and be prepared to handle e_no_hierarchy_found and e_no_parent_member_found.

Note that the user search term "ego_user_attr_row_table" does not correspond to an object documented for this package; the attribute-related table references here are EGO_FND_DSC_FLX_CTX_EXT, EGO_OBJ_AG_ASSOCS_B, and FND_OBJECTS.