Search Results pay_gb_wnu_rules




Overview
Explore in AI Chat

Overview

PAY_GB_WNU_RULES is an Oracle E-Business Suite (EBS) PL/SQL package owned by the APPS schema that encapsulates the server-side business logic governing the United Kingdom Working Notification Update (WNU) process for payroll. The package supplies the core update routines invoked when an assignment or person record must reflect changes required by the UK Working Notification rules, including updates to assignment numbering, National Insurance number information, and the flag that determines whether an assignment is excluded from the Working Notification Update process. It is classified under the ETRM API classification "OTHER," indicating that it is an internal but callable business component rather than a public, fully supported developer API.

The package header is declared as AUTHID CURRENT_USER and includes the source revision marker pygbwnu1.pkh 115.8 dated 2003/12/18, reflecting the historical lineage of the UK payroll legislative rules it implements. Because the logic resides in the database tier, it centralises validation and persistence so that concurrent programs, forms, and any dependent code maintain consistent behaviour when WNU-related attributes change.

Key Procedures and Functions

The package exposes a single documented procedure name, WNU_UPDATE, which is overloaded to support two distinct calling contexts:

  • WNU_UPDATE (assignment-based overload) — Accepts assignment-level identifiers and effective dating information, together with optional assignment number values (current and previous), the "not included in WNU" indicator, an in/out object version number for optimistic locking, and an out parameter returning the assignment extra information identifier. It is the entry point used when the WNU update is driven from an assignment record.
  • WNU_UPDATE (person-based overload) — Introduced under Bug 3294480, this overload accepts person-level identifiers and effective dating information, an aggregated assignment indicator, a National Insurance number update value, the "not included in WNU" indicator, an in/out object version number, and an out assignment extra information identifier. It supports updates initiated against a person rather than a specific assignment.

Both overloads return an assignment extra information identifier, which allows the caller to retrieve the DFF row created or modified as a result of the WNU processing. No standalone functions are documented.

Tables Accessed

The package operates against the following tables, accessed through APPS synonyms:

  • PER_ASSIGNMENT_EXTRA_INFO — Stores the developer descriptive flexfield rows that hold WNU-specific assignment attributes; the primary persistence target and the source of the out parameter identifier.
  • PER_ALL_ASSIGNMENTS_F — The dated assignments entity; read and updated for assignment number and assignment-level WNU attributes.
  • PER_ALL_PEOPLE_F — The dated person entity; used when resolving person-level WNU updates.
  • PER_ASSIGNMENT_STATUS_TYPES — Reference data used to interpret assignment status during validation.
  • PAY_ALL_PAYROLLS_F — Payroll definition table consulted to confirm payroll context for the assignment.
  • HR_SOFT_CODING_KEYFLEX — Key flexfield structure used when validating or deriving soft coding associated with payroll processing.

Usage Notes

PAY_GB_WNU_RULES is not referenced by any other documented package (referenced-by count: zero), which confirms it is a top-level entry point rather than a shared utility. It is typically invoked when the UK Working Notification Update process must reconcile assignment data, National Insurance details, or the "not included in WNU" status. Because it is classified as "OTHER" rather than a supported public API, custom code calling WNU_UPDATE should apply the documented effective date and object version semantics carefully, and should expect the procedure to write to PER_ASSIGNMENT_EXTRA_INFO and return the resulting extra information identifier. The overloads permit selection between assignment-centric and person-centric invocation, with the person-based overload providing the aggregated assignment and NI number update behaviour added by Bug 3294480.