Search Results pay_nl_nwr_xml_extract_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_NL_NWR_XML_EXTRACT_PKG is a Dutch (NL) localization package body responsible for generating the statutory NWR (Netherlands Wage Report / Nieuwe Werkgeversrapportage) XML extract from Oracle Payroll data. The package assembles the wage and employment details required by Dutch tax authorities and regulatory bodies into a structured XML document, applying the correct character encoding so that the output conforms to the publishable specification. The header revision (pynlwrep.pkb, version 120.26.12020000.6, dated 2013/01/11) confirms it ships as a seeded localization object in the APPS schema under EBS 12.1.1 and 12.2.2. In the context of the user search term "action_information," this package is notable because it directly reads the PAY_ACTION_INFORMATION table into a PL/SQL associative array, making it a consumer of the action information model used throughout Oracle Payroll.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions in this package body:

  • GET_TAG_NAME — Derives or resolves the XML element tag name used when emitting report data, mapping internal payroll values to the expected NWR XML structure.
  • YES_NO — Converts Oracle's internal yes/no indicator values into the literal tokens required by the XML schema.
  • GET_LE_NAME — Returns the legal employer name for the reporting entity, drawn from organization information for inclusion in the XML header.
  • LOAD_XML — Populates and assembles the XML payload, including the character-set conversion logic. Supporting functions visible in the source, such as get_IANA_charset, TO_UTF8, and WRITETOCLOB, confirm that XML is materialized in a CLOB using UTF-8 conversion based on NLS_DATABASE_PARAMETERS.
  • GENERATE — The main driver procedure that orchestrates the extract, wiring the preceding routines together to produce the finished NWR XML output.

Package-level state, including char_tab typed on PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE, holds collected action information values for the duration of a run.

Tables Accessed

The package reads data from the following documented tables via APPS synonyms:

Usage Notes

The package is a localization object, not a general-purpose API. ETRM records no inbound references from other packages, indicating it is invoked through a concurrent program or report driver rather than called programmatically by application code. It relies on FND_GLOBAL for localization conventions such as the end-of-line character (EOL) and USERENV('LANGUAGE'). Because it reads PAY_ACTION_INFORMATION, correct results depend on the relevant payroll actions being completed and posted, with action information values populated. Customizations should avoid modifying the seeded body directly; extensions belong in separate packages. The dynamic SQL and CLOB handling also mean the package requires adequate temporary space and an appropriately sized database character set to perform UTF-8 conversion reliably.