Results for “get_label”

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

Overview

APPS.HRI_OLTP_PMV_LABEL is a helper package in the Oracle E-Business Suite HR Intelligence (HRMS Analytics / Daily Business Intelligence) schema. Its business purpose is to resolve human-readable labels for the members of dimensional levels used in the HR OLTP performance management views and OBIEE-style dashboards. In the HR Intelligence data model, dimension members are stored as primary keys (identifiers), and the presentation layer must translate those keys into descriptive names in the language and format expected by the user. This package centralizes that translation logic so that the various performance management views (PMV) do not each re-implement label lookups.

The package maintains a private associative array that maps dimension short names to the underlying dimension view names. For example, HRI_PERF_BAND is mapped to the combination of performance and performance rating views, HRI_LOW_BAND and HRI_LOP_BAND to employee and contingent-worker low-band dimensions, and ABS_DRTN to the absence duration dimension. A global message, g_not_used_msg, supplies the standard "not used" text returned when no label can be resolved.

Key Procedures and Functions

• GET_LABEL — The single documented function. It accepts a dimension level name, a dimension level primary key, and a name type, and returns the descriptive label as a VARCHAR2. Internally it first resolves the dimension's short name through the initialization table; if the lookup fails it falls back to the passed name. It then delegates to the base-layer function hri_bpl_dim_lvl.get_value_label to obtain the label. If that call returns no value, it substitutes the "not used" message. Any exception—typically caused by missing metadata—is caught and the original dimension level name is returned as a safe fallback.

No other procedures or functions are documented in the ETRM metadata for this package body.

Tables Accessed

The ETRM metadata records no directly referenced application tables for this package body; label resolution is performed indirectly. The translation work is delegated to the base layer package HRI_BPL_DIM_LVL, which reads the dimension metadata and label tables on behalf of this package. The absence duration profile value is obtained from HRI_BPL_UTILIZATION. Consequently, this package functions as a thin caching and normalization layer rather than a direct SQL consumer of HR tables.

Usage Notes

HRI_OLTP_PMV_LABEL is an internal PL/SQL utility rather than a user-facing API. It is invoked by HR Intelligence performance management views, reports, and dashboards when presenting dimension member values, ensuring consistent labels across analyses. It should be called from custom code only where a dimension level key must be rendered as a display label and the calling code already operates within the HR Intelligence reporting context. Because the package initializes its global mapping table at load time, applications that use it should allow the package to load normally and should not attempt to alter the private lookup table. The function is defensive by design: missing metadata produces the "not used" message or the original dimension name instead of an error, so callers should not rely on an exception being raised to detect unresolved labels.

Note that the user search term "ms pro labels pvt ltd mail id" does not correspond to any object, parameter, or table in this package; it appears to be an unrelated query and is not addressed by this package.