Search Results pay_paywieeh_pkg




Overview
Explore in AI Chat

Overview

PAY_PAYWIEEH_PKG is the Element Entry History Form package within the Oracle E-Business Suite Payroll (PAY) module. Its documented purpose is to provide the information required by the PAYWIEEH form, the Element Entry History form used by payroll administrators and HR users to review the values, units of measure, and inherited properties associated with an employee's element entries across time. The package header carries the identifier paywieeh.pkb, and the source header records its creation on 25 October 1994 by N Simpson, with subsequent revisions in 1994, 1997, and 1999. The body is classified by ETRM as an OTHER API owned by APPS, meaning it is an internal, form-supporting package rather than a public, customer-facing API. Its principal responsibility is to resolve, at a given effective date, the input values that an element entry actually carries, together with the properties those values inherit from the element link definition.

Key Procedures and Functions

  • GET_ENTRY_VALUE_DETAILS — Returns the element entry values along with all their inherited properties for each element entry selected by a query in the form. It accepts an element entry identifier, an element link identifier, and an effective date, and returns a set of name and unit-of-measure output values (up to twelve input values are documented in the excerpt: p_name1 through p_name12 and p_uom1 through p_uom12, with p_name13, p_name14, and p_name15 declared for names and p_uom13, p_uom14, and p_uom15 used to hold unit-of-measure output). A revision note dated 26 June 1997 records that the cursor set_of_entry_values was changed to improve performance, and a further revision in February 1999 applied MLS changes. These output parameters are populated by the procedure and consumed directly by the PAYWIEEH form.
  • POPULATE_CONTEXT_ITEMS — Documented as the second procedure in the package. Its name indicates that it initializes form context items, typically the descriptive or key-flexfield context values the form requires before executing its queries. This is a standard pattern in Oracle Forms–backed PL/SQL packages, where context items must be established prior to the retrieval of entry value details.

Tables Accessed

ETRM documents four base tables read through APPS synonyms:

  • PAY_ELEMENT_ENTRY_VALUES_F — the primary source of the stored entry values returned by GET_ENTRY_VALUE_DETAILS.
  • PAY_INPUT_VALUES_F — the input value definitions that govern how each entry value is interpreted and named.
  • PAY_INPUT_VALUES_F_TL — the translated names and descriptions of input values, supporting the MLS changes noted in the 1999 revision.
  • PAY_LINK_INPUT_VALUES_F — the element link input value definitions from which the procedure derives the inherited properties of each entry value, using the passed element link identifier and effective date.

Usage Notes

The package is invoked exclusively in support of the PAYWIEEH form; ETRM records no other packages referencing it, confirming its role as a private form-support library rather than a shared service. GET_ENTRY_VALUE_DETAILS is called when the form query retrieves an element entry and must display the corresponding input value names, units of measure, and inherited link-level properties as of a selected effective date. The effective date parameter ensures date-tracked correctness for both the entry value rows and the link input value rows. Because the procedure relies on the element link identifier, callers must supply a valid link for the entry in question; where inheritance is not applicable, the inherited attributes are returned from the link definition rather than the entry itself. Custom code may call the package directly, but doing so is not recommended, as the interface is designed for form use and is not a supported public API.