Search Results original_entry_name

Overview

APPS.HR_ENTRY_DISPLAY is a legacy Oracle EBS PL/SQL package whose stated purpose (per the package header) is "maintaining entry level display utilities." It was originally created in 1994 (version 40.0, J.S. Hobbs) to support Oracle Forms 2.3 screens that display element entries. The package exists to overcome a specific limitation of Forms 2.3: those forms cannot natively render element entries horizontally for rapid, spreadsheet-style data entry. HR_ENTRY_DISPLAY provides the special fetch routines that retrieve element entry rows, which the form then iterates over in a loop to paint the horizontal display. The header explicitly notes that the 4.0 (and later) forms do not require these routines because they can use native Forms functionality to display entries horizontally. The package therefore survives in 12.1.1 and 12.2.2 primarily to serve older, un-converted forms and any custom code still dependent on its utility functions.

Key Procedures and Functions

The ETRM documentation identifies three documented program units in this package:

• ORIGINAL_ENTRY_NAME — A function that returns the original entry name associated with a specified element entry identifier. It was added in version 115.2 (16-Sep-04, T. Habara). Its purpose is to resolve the display name of the original element entry, typically for display alongside a current or overridden entry in entry forms.
• COUNT_INPUT_VALUES — A procedure described in the source as "(obsolete)" and intended for entry form population. It counts how many input values are defined for an element (presumably in the context of the entry being displayed), allowing the form to size or lay out the horizontal entry grid. Because it is marked obsolete, new development should not call it, though it remains callable for backward compatibility.
• GET_INPUT_VALUE_DETAILS — The third documented unit, and the object the user searched for. Consistent with the package's display-utility purpose, it retrieves the detail attributes of input values (for example, value, name, and display characteristics) so that entry forms can populate the horizontal entry display. As with the other units, existence of this routine is the documented fact; no parameter signatures should be assumed beyond what the ETRM metadata provides.

Tables Accessed

The package reads from the core Oracle Payroll element-entry tables via APPS synonyms:

• PAY_ELEMENT_ENTRIES_F — the element entry header (the assignment/element entry being displayed), used to locate the entry and its original entry reference.
• PAY_ELEMENT_ENTRY_VALUES_F — the per-entry input value rows, the source data for the horizontal display.
• PAY_ELEMENT_LINKS_F and PAY_LINK_INPUT_VALUES_F — the element link and link-level input values that determine which input values are eligible for entry.
• PAY_ELEMENT_TYPES_F_TL — element type translated names, used to resolve element display names.
• PAY_INPUT_VALUES_F and PAY_INPUT_VALUES_F_TL — input value definitions and their translated display names, used to label each value column and to resolve the detail returned by GET_INPUT_VALUE_DETAILS.

All access is read-oriented; the package is a display utility and does not maintain transactional entry data itself.

Usage Notes

HR_ENTRY_DISPLAY is classified as "OTHER" API and is referenced by zero other packages, indicating no intra-database dependency chain. It is invoked from Oracle Forms (chiefly legacy 2.3-derived entry forms) and from custom code that replicates that form behavior. It is not a concurrent-program API and should not be used for new development; the obsolete marking on COUNT_INPUT_VALUES and the header note that post-2.3 forms no longer need these utilities both point to deprecation. Developers maintaining existing customizations should treat GET_INPUT_VALUE_DETAILS and ORIGINAL_ENTRY_NAME as read-only helpers for retrieving entry-display data, and should prefer native Forms/Payroll APIs for new entry screens.