Search Results pay_nl_wts_report




Overview
Explore in AI Chat

Overview

PAY_NL_WTS_REPORT is an Oracle Application Object Library (APPS) PL/SQL package that belongs to the Oracle Payroll localization for the Netherlands. Its name indicates that it supports the Dutch Wage Tax Statement (WTS) reporting process — the statutory annual or periodic reporting of wage, tax, and social insurance data that Dutch employers must submit to the tax authorities. The package exposes the query and data-extraction logic used to assemble the wage tax statement from the payroll run results stored in the Oracle Payroll schema.

The object is classified in ETRM as an OTHER API (not a public batch or business API), meaning it is intended primarily for internal consumption by the localization's report generator rather than as a supported integration entry point. Its status is VALID in the 12.1.1 and 12.2.2 reference environments. The package body contains SQL statements and declared subprograms, and it is self-contained: ETRM records that it is referenced by zero other packages, so it functions as a leaf-level consumer of payroll data.

Key Procedures and Functions

The ETRM documentation lists ten subprograms, of which two are enumerated by name in the metadata excerpt (the remainder are generically reported as part of the package structure):

  • TO — A conversion or transformation routine, typically used to normalize or format payroll values (for example, date or numeric fields) into the representation required by the WTS output. The short identifier suggests an internal helper rather than a business-facing entry point.
  • RECORD_4712 — The designation 4712 is the standard Oracle EBS sentinel for an open-ended effective date. This routine is consistent with the selection of effective-dated payroll and assignment records that are valid as of the reporting cutoff, and with populating the statement's record set.

Because the ETRM listing does not publish full signatures for these units, parameter lists should not be assumed; the procedural contract is defined by the package specification inside the database.

Tables Accessed

The package reads from a broad set of Oracle Payroll and HR tables via APPS synonyms. Payroll run and result data is drawn from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_RUN_RESULTS; element and input value definitions come from PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F; balances are resolved through PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_DIMENSIONS. Assignment and organization context is supplied by PER_ALL_ASSIGNMENTS_F, HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS. FND_LOBS and PER_GB_XDO_TEMPLATES support the storage and layout of the generated report output. No write operations against core payroll tables are implied by this list; the package is a reporting reader.

Usage Notes

PAY_NL_WTS_REPORT is invoked as part of the Dutch wage tax statement generation flow, normally driven by a concurrent program or by the localization's report template rather than by direct end-user calls from a form. Because it is classified as OTHER and is referenced by no other package, customizations should treat it as an internal implementation unit: calling it from bespoke code risks incompatibility across patches. For supported integration, the underlying payroll data should be accessed through the documented Oracle Payroll APIs, and the package should be regarded as an implementation detail of the Netherlands statutory reporting feature.