Search Results hr_nz_element_entry_hook




Overview
Explore in AI Chat

Overview

HR_NZ_ELEMENT_ENTRY_HOOK is an APPS-owned PL/SQL package that forms part of the Oracle E-Business Suite localization layer for New Zealand payroll. Its role is to provide country-specific processing logic that executes during element entry processing within Oracle Payroll. The package is classified under the ETRM API classification of OTHER, indicating that it is not a public, supported application programming interface but rather an internal, hook-style routine invoked by the payroll engine when certain conditions are met.

In the Oracle HRMS architecture, "hook" packages are country extensions that allow localization teams to inject statutory or regulatory calculations into standard payroll flows without modifying the core application code. The New Zealand localization leverages this pattern so that absence-related descriptive flexfield information can be derived and populated during element entry, reflecting local legislative or reporting requirements. The package is documented as VALID and resides in the APPS schema alongside its subordinate package body and associated SQL statements.

Key Procedures and Functions

The documented API surface of this package consists of a single procedure: POPULATE_ABSENCE_DEV_DESC_FLEX.

  • POPULATE_ABSENCE_DEV_DESC_FLEX — This procedure is responsible for populating the descriptive flexfield (DFF) attributes associated with absence element entries. It supports the New Zealand localization requirement to record additional absence-related context on payroll element entries. The procedure reads absence attendance information and element entry structures, then writes the resulting descriptive flexfield values so that downstream payroll processing, reporting, and statutory submissions can reference them. Consistent with ETRM documentation conventions, the parameter list is not published here; the procedure should be treated as an internal routine whose signature is subject to change.

Tables Accessed

The package operates against a defined set of Oracle Payroll and Oracle HRMS tables, all accessed through APPS synonyms:

  • PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — these store the element entry header and its input values for an assignment, and constitute the primary targets that the hook examines and updates when populating absence descriptive flexfield information.
  • PAY_ELEMENT_LINKS_F and PAY_ELEMENT_TYPES_F — these define which elements are valid for a given payroll and the element definitions themselves; the package uses them to resolve the element being processed and to determine whether absence DFF population applies.
  • PAY_INPUT_VALUES_F — defines the input values belonging to each element type, providing the structural context for the entry values being processed.
  • PER_ABSENCE_ATTENDANCES and PER_ABSENCE_ATTENDANCE_TYPES — the absence records and their configured absence types; these supply the source data that the procedure derives the descriptive flexfield content from.

Usage Notes

HR_NZ_ELEMENT_ENTRY_HOOK is not intended for direct invocation by end users or customer-developed code. It is a localization hook that the Oracle Payroll element entry process calls automatically when processing absence-related element entries for New Zealand business groups. Because the ETRM metadata records zero referencing packages, no other APPS package depends on it statically; instead, the payroll engine invokes it dynamically as part of the standard element entry flow.

Typical invocation contexts include the Element Entry form and batch element entry processes, including concurrent programs that load or recalculate payroll element entries. Customizations should not call POPULATE_ABSENCE_DEV_DESC_FLEX directly, as its interface is not published and may change between releases. Administrators troubleshooting New Zealand absence DFF values should verify that the package is VALID in the APPS schema and that its dependent database objects compile cleanly. Any functional configuration affecting the behaviour, such as absence attendance type setups or descriptive flexfield definitions, should be reviewed in conjunction with this package when investigating unexpected DFF content.