Results for “get_iana_charset”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_NL_RETRO_SETUP_REPORT is an Oracle E-Business Suite PL/SQL package belonging to the Oracle Payroll (PAY) module, with naming that identifies it as a Netherlands localization component ("NL") supporting retroactive pay setup reporting. Its documented API classification is OTHER, indicating it is not a published open interface but an internal utility used to render reporting output rather than to perform transactional data changes. The package header carries the revision marker pynlersr.pkh 120.0.12000000.1, dated 2007, which is consistent with the long-lived code line reused across the 12.1.1 and 12.2.2 application releases.

The business purpose of the package is to produce a structured report that describes the configuration of retroactive pay processing — specifically the element classifications, retro components, retro component usages, element span usages, and time definitions/spans that define how retroactive adjustments are calculated and attributed. Producing this report as XML allows the output to be rendered through Oracle XML Publisher (BI Publisher) templates, which is the standard reporting mechanism in both EBS 12.1.1 and 12.2.2. The function is therefore a configuration audit and implementation-support tool, typically run by payroll administrators or implementation consultants when validating a Netherlands payroll setup.

Key Procedures and Functions

The package exposes exactly two documented program units:

• GET_IANA_CHARSET — A function returning VARCHAR2. It supplies the IANA character set identifier used when constructing the XML output, ensuring the generated report declares an appropriate encoding. This is the object most closely associated with the search term "get_iana_charset". Because it is a function, it is invoked within the package's own XML generation logic rather than as a standalone API, and it takes no documented parameters.
• GENERATE — A procedure that produces the XML data for the retro setup report. It accepts a business group identifier, an effective date, element records, and a template name, and returns the resulting XML as a CLOB through an OUT NOCOPY parameter. Its role is to assemble the query results from the retro setup tables into an XML document suitable for transformation by an XML Publisher template.

No additional procedures or functions are documented in the ETRM metadata, and the parameter lists above are reproduced only at the level of the documented signature — no further parameters should be assumed.

Tables Accessed

The documented table references reflect the retroactive pay and element configuration model:

• PAY_RETRO_COMPONENTS and PAY_RETRO_COMPONENT_USAGES — define retro components and where they are applied.
• PAY_ELEMENT_CLASSIFICATIONS and PAY_ELEMENT_CLASSIFICATIONS_TL — provide classification codes and their translated names.
• PAY_ELEMENT_TYPES_F and PAY_ELEMENT_SPAN_USAGES — supply element definitions and span usage rules.
• PAY_TIME_DEFINITIONS and PAY_TIME_SPANS — provide the time dimension definitions used by retro processing.
• FND_LOOKUP_VALUES — resolves lookup meanings used in the report.
• DBMS_LOB — the Oracle-supplied package used to manipulate the CLOB XML output; PLITBLM — the PL/SQL table/index-by-table utility package used for internal collections.

Usage Notes

PAY_NL_RETRO_SETUP_REPORT is not referenced by any other documented package (referenced by 0), so it is effectively a leaf-level reporting utility. In practice it is invoked either directly by a concurrent program registered against the GENERATE procedure or by custom code that calls GENERATE to obtain the XML CLOB and then applies an XML Publisher template. Because the output is XML returned as a CLOB, callers must handle the CLOB explicitly, writing it to a file or passing it to the XML Publisher runtime API. The GET_IANA_CHARSET function is used internally to set the document encoding and is not normally called directly by end users.

This package is specific to the Netherlands localization and should be exercised only in environments where Dutch payroll legislation applies. When troubleshooting encoding problems in the generated report, the IANA character set returned by GET_IANA_CHARSET is the appropriate starting point.