Search Results get_category_code

Overview

The APPS.HRI_OLTP_PMV_RANK_ABS package is a PL/SQL component within the Oracle E-Business Suite HR Intelligence (HRI) product family. It supports the Oracle Learning Management and HR operational reporting infrastructure by providing rank-based categorization utilities consumed by the Public Market Views (PMV) reporting layer. In Oracle EBS 12.1.1 and 12.2.2, this package operates as part of the analytics foundation that supplies dimension values and category labels to dashboards and analytic reports.

The package is classified as OTHER in the documented API classification, indicating that it is not a public, customer-facing API but rather an internal utility invoked by other HRI components. Its principal role is to manage a bounded set of top categories — described in the source metadata as an abs_category_tab collection of VARCHAR2(80) values indexed by BINARY_INTEGER — and to return human-readable names and drill-across dimension codes for those categories by rank position.

Key Procedures and Functions

The documented interface exposes three program units:

• SET_TOP_CATEGORIES — A procedure that populates an output collection of top categories for a given supervisor and effective date range. It accepts a supervisor identifier, effective-from and effective-to dates, and a requested number of categories, returning the populated category table through an OUT NOCOPY parameter. This procedure establishes the working set that subsequent name and code lookups reference.
• GET_CATEGORY_NAME — A function that accepts a rank position and returns the corresponding category name as a VARCHAR2. It provides the display label used in report columns.
• GET_CATEGORY_CODE — A function that accepts a rank position and returns a VARCHAR2 category code. Per the source comments, this function is used for the drill-across dimension identifier associated with report columns 1 through 4, enabling navigation from a summary report into the underlying detail for ranked categories.

No parameter lists are documented beyond the signatures shown, and none should be assumed.

Tables Accessed

The ETRM metadata for this object does not enumerate any base tables referenced by HRI_OLTP_PMV_RANK_ABS through APPS synonyms. Because the package operates on an in-memory abs_category_tab collection rather than persistent storage, its category data is supplied upstream by the calling process, and the package serves primarily as an accessor over that collection. Any underlying HR or Learning Management tables are read by the caller or invoker context, not directly through the documented interface of this package.

Usage Notes

Given that the package is referenced by two other packages and is not classified as a public API, it is typically invoked indirectly. The normal invocation sequence is for a consuming HRI report or analytics package to call SET_TOP_CATEGORIES to establish the ranked category collection for a supervisor and date range, then to call GET_CATEGORY_NAME and GET_CATEGORY_CODE repeatedly as report columns and drill-across targets are rendered. The rank values passed to the two functions correspond to positions established by SET_TOP_CATEGORIES; the code function is specifically documented as serving columns 1 through 4 of the drill-across dimension.

Custom development should treat these entry points as internal HRI interfaces. Direct invocation is possible from custom PL/SQL in the APPS schema, but the supported pattern is to drive them through the HRI reporting framework that owns the call sequence. The package is delivered under the standard Oracle proprietary and confidential terms, and modification is not supported.