Search Results c_input_value

Overview

APPS.HR_NZ_ELEMENT_ENTRY_HOOK is a legislative hook package body delivered as part of the Oracle HRMS payroll localization for New Zealand. Its purpose is to enforce New Zealand statutory and legislative requirements at the point where element entries are created or modified against an employee assignment. The package is a hook, meaning it is not invoked directly by end users but is called by the standard Oracle Payroll element entry processing layer — specifically, by the PAY_ELEMENT_ENTRIES_F after-insert and after-update database triggers. The header comment identifies the package as the "NZ HRMS element entry legislative hook package," confirming its role as the extension point through which New Zealand-specific rules are applied to the generic element entry model.

The package carries a documented change history dating to September and January 2000, with fixes tracked against Bug#1412369 and Bug#1098494. These changes addressed the population of the ABS_INFORMATION_CATEGORY column and a correction to the join between element entries and absence records, replacing the use of SOURCE_ID with CREATOR_ID.

Key Procedures and Functions

The package exposes a single documented public procedure: POPULATE_ABSENCE_DEV_DESC_FLEX. As its name and the package comments indicate, this procedure populates descriptive flexfield information on absence-related element entries by deriving values from the underlying absence attendance record. The procedure is declared with parameters covering the effective date, the element entry identifier, the creator type, the element link identifier, and the creator identifier. It declares local variables for the absence batch identifier, the seasonal shutdown value, the number of complete weeks, the absence category, and the element name, and it uses an internal cursor over PER_ABSENCE_ATTENDANCES to retrieve the batch identifier associated with a given absence attendance record. The procedure is the sole documented entry point and represents the legislative logic applied for New Zealand element entries.

Tables Accessed

The package reads and writes data across the core element entry and absence schemas. PAY_ELEMENT_ENTRIES_F supplies the element entry being processed, while PAY_ELEMENT_ENTRY_VALUES_F holds the individual input values — including the screen entry values referenced by the local variables for seasonal shutdown and number of complete weeks — that the hook evaluates and may amend. PAY_ELEMENT_LINKS_F and PAY_ELEMENT_TYPES_F provide the link and element definition context, including the element name used in the logic. PAY_INPUT_VALUES_F defines the input values associated with the element, confirming that the c_input_value construct referenced by users relates to the input value definitions consulted during this processing. The absence side is served by PER_ABSENCE_ATTENDANCES, which supplies the batch identifier and absence category, and PER_ABSENCE_ATTENDANCE_TYPES, which anchors the absence category lookup. Writes focus on populating the descriptive flexfield and information category attributes of the element entry.

Usage Notes

This package is invoked implicitly by the PAY_ELEMENT_ENTRIES_F after-insert and after-update hooks during standard payroll element entry maintenance in Oracle EBS 12.1.1 and 12.2.2. It is not exposed through a form or concurrent program and is not referenced by any other packaged API, as the metadata records zero dependent packages. Consequently, it executes transparently whenever a New Zealand absence-related element entry is created or changed, including through the Element Entries form and through any batch or dataload process that inserts into PAY_ELEMENT_ENTRIES_F. Customizations should not call POPULATE_ABSENCE_DEV_DESC_F directly unless replicating the trigger invocation context; the correct integration point remains the element entry DML that triggers the hook. Because the logic depends on the creator identifier and creator type of the entry, any data load must populate those columns correctly for the absence linkage to resolve.