Search Results get_display_value

Overview

APPS.PER_RI_RT_UTIL_PKG is a utility package in the Oracle E-Business Suite Human Resources (per) schema that supports the Oracle HRMS Regulatory Information and Reporting infrastructure — internally associated with the "RI" (Regulatory Information) and "RT" (Reporting Template) processing model. Its header identifies it as version 120.0, last modified in June 2005, shipped under the "noship" designation, which indicates it is an internal supporting package rather than an end-user-facing product object. The package aggregates a small set of helper routines used to resolve descriptive flexfield display text, validate flexfield contexts, persist generated regulatory report rows, and produce XML output from HR regulatory data. In Oracle EBS 12.1.1 and 12.2.2 it remains part of the APPS-shared PL/SQL layer and is callable by concurrent programs and forms components that require flexfield-aware formatting or XML-based regulatory data generation. The user's search term, get_display_value, corresponds directly to one of the documented functions in this package and is commonly referenced when troubleshooting how flexfield values are rendered for reporting.

Key Procedures and Functions

• INSERT_PER_RI_RT_GEN — Inserts a row into the PER_RI_RT_GEN staging table, capturing the concurrent program job name, request identifier, and user identifier to associate generated regulatory output with the originating concurrent request.
• GET_DISPLAY_PROMPT — Returns the display prompt (label) for a given flexfield, context, and column, allowing callers to obtain the user-facing prompt text associated with a descriptive flexfield segment.
• GET_DISPLAY_VALUE — Returns the display value for a given flexfield, context, column, and stored value. This is the function most relevant to the user's search, and is used to translate an underlying flexfield value into its formatted, user-readable representation.
• CHK_CONTEXT — Validates whether a specified flexfield context is enabled or recognized, returning a numeric status used by callers to decide whether display resolution is applicable.
• GENERATE_XML — Produces a CLOB of XML data for a given entity code, sample size, and business group, leveraging DBMS_XMLQUERY to serialize HR regulatory data for downstream reporting or submission.
• APPS_INITIALISE — Standard APPS initialization entry point used to establish the session environment (typically via FND_SESSIONS) prior to invoking package routines.

Tables Accessed

Documented table references, resolved through APPS synonyms, include FND_CONCURRENT_REQUESTS, used to relate generated output to the executing concurrent request; FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALUE_SETS, and the descriptive flexfield metadata queried to resolve prompts and display values; FND_SESSIONS, for session initialization; PER_RI_RT_GEN, the staging table written by INSERT_PER_RI_RT_GEN; and DUAL for scalar selects. Dynamic SQL against DBMS_SQL and XML serialization through DBMS_XMLQUERY are also used at runtime.

Usage Notes

This package is typically invoked from HRMS regulatory reporting concurrent programs and supporting forms logic rather than called directly by end users. The GET_DISPLAY_VALUE function is the routine most frequently referenced by developers seeking to render descriptive flexfield values in a consistent, formatted manner. Because the package is classified as OTHER and has no documented downstream package references, it should be treated as an internal utility. Developers extending or troubleshooting regulatory reporting in 12.1.1 or 12.2.2 may call it in custom PL/SQL, but should invoke APPS_INITIALISE first and respect the standard APPS schema grants and concurrent request context.