Results for “get_category_code”

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

Overview

The APPS.HRI_OLTP_PMV_RANK_ABS package body is a supporting database object within the Oracle E-Business Suite Human Resources Intelligence (HRMSi) and HR Analytics infrastructure. It functions as a ranking and categorization utility for absence-related data surfaced through the Oracle Daily Business Intelligence (DBI) and HR Management Dashboard components. Its principal role is to resolve and rank absence categories so that analytical dashboards can present absence metrics grouped by meaningful, ordered category descriptors rather than raw identifiers. The package is classified under the ETRM metadata as an "OTHER" API classification and is documented as VALID in both the 12.1.1 and 12.2.2 environments.

The object operates in the context of the HR Operational Transactional Processing (OLTP) materialized view layer, particularly around the absence category materialized view, pairing those structures with the absence category values view to produce ranked output for dashboard presentation.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions within this package body:

• SET_TOP_CATEGORIES — Establishes or populates the set of ranked "top" absence categories used for dashboard display. This routine drives the ranking logic that determines which absence categories are promoted to the highest visibility tier in the analytics presentation layer.
• GET_CATEGORY_NAME — Returns the descriptive display name associated with a given absence category identifier, enabling the dashboard to render human-readable category labels.
• GET_CATEGORY_CODE — Returns the underlying category code corresponding to an absence category, supporting lookups, joins, and filtering operations in the reporting layer.

These three routines collectively provide the ranking, naming, and code-resolution services required to present absence category analytics consistently. No parameter lists are documented in the ETRM metadata, so the exact call signatures should be confirmed by inspecting the package specification in the target environment.

Tables Accessed

The package body references two principal absence-related data structures, both accessed through APPS-owned synonyms:

• HRI_MDP_SUP_ABSNC_CAT_MV — A supply (SUP) materialized view providing the aggregated absence category data underlying the ranking logic. This materialized view is characteristic of the HRMSi multi-dimensional model, offering pre-aggregated absence metrics for dashboard consumption.
• HRI_CL_ABSNC_CAT_V — The absence category category-level view supplying the category descriptors (name and code) that complement the aggregated metrics.

The package also depends on HRI_OLTP_VIEW_MESSAGE, a shared message/logging utility used across HRMSi OLTP view packages, indicating that error and status messaging is handled through that common framework. Dependencies on the SYS STANDARD package reflect normal PL/SQL runtime usage.

Usage Notes

HRI_OLTP_PMV_RANK_ABS is not referenced by any other database object per the documented dependency metadata, meaning it is a terminal, leaf-level package rather than a shared library. It is, however, part of the broader HRMSi dashboard package family, and the ETRM notes that related HRMSi packages are referenced by other packages in turn.

Typical invocation occurs when the HR Management Dashboard or absence analytics pages render top-category rankings. The package is called from within the dashboard's PL/SQL rendering code or supporting concurrent processes that refresh and present the absence category materialized view. Because the data is sourced from a materialized view, output should be treated as of the last refresh. Consultants extending absence dashboards should reuse GET_CATEGORY_NAME and GET_CATEGORY_CODE for consistent labeling, and should not modify the package directly; changes should instead flow through the supported HRMSi layer or via custom wrapper code that calls these documented routines.