Search Results writetoclob_rtf

Overview

APPS.PER_NL_FDR_ARCHIVE is a Dutch (NL) localization package within Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the archiving of HRMS person and payroll records for statutory reporting purposes. The suffix FDR denotes the Dutch term for the legal record-keeping obligation imposed on employers, and the package encapsulates the server-side logic required to extract, format, and persist the data elements associated with that archive. Its header carries the RCS identifier "penlfdra.pkh 120.0.12000000.1," confirming it is a seeded, Oracle-supplied object rather than a customer extension, and it resides in the APPS schema alongside the rest of the HRMS localization layer.

The package combines two distinct responsibilities. The first is parameter resolution for the concurrent archive process: callers pass a concatenated parameter string and the package tokenizes it into individual values. The second is XML and CLOB generation, where structured tag/value pairs are serialized into a Rich Text Format document stored as a CLOB. The metadata classifies the package as API classification "OTHER," meaning it is not published as a supported public interface, and it is referenced by zero other packages, indicating it is invoked directly by concurrent programs or report drivers rather than through a package dependency chain.

Key Procedures and Functions

• GET_PARAMETER — Function that extracts a single parameter value from the archive process parameter string by token and optional segment number. This is the low-level parser used to unpack the concurrent program's parameter list.
• GET_ALL_PARAMETERS — Procedure that returns the complete set of archive process parameters in a single call, exposing report date, organization structure identifier, person identifier, organization identifier, and business group identifier as output parameters.
• WRITETOCLOB_RTF — Procedure that writes the contents of the XML file as a CLOB, accepting a collection of XML tag/value records and producing RTF output. This is the specific routine associated with the search term "writetoclob_rtf" and is the core document-generation primitive of the package.
• CHECK_TAX_DETAILS — Function that returns 1 when the organization has tax details attached, allowing the archive process to determine whether tax-relevant data must be included for a given organization unit.
• GET_REF_DATE, ORG_CHECK, EMP_CHECK, RANGE_CODE — Supporting validation and date-derivation routines used to qualify organization and employee records and to establish the reference date range for the archive.
• ASSIGNMENT_ACTION_CODE, ARCHIVE_CODE, ARCHIVE_DEINIT_CODE — Lifecycle routines that drive the archive action itself and perform post-processing cleanup once extraction completes.

Tables Accessed

The package reads from a broad set of HRMS and payroll tables via APPS synonyms. Person and assignment data comes from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_PEOPLE_EXTRA_INFO, and PER_ASSIGNMENT_STATUS_TYPES. Organization context is drawn from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS. Payroll run and action context is supplied by PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, and PAY_ACTION_INFORMATION, where the payroll action identifier passed into GET_ALL_PARAMETERS anchors the query. FND_LOOKUP_VALUES provides reference lookup codes, and DBMS_LOB is used for CLOB manipulation behind WRITETOCLOB_RTF. Most access is read-only, with the archive action routines responsible for any state changes.

Usage Notes

PER_NL_FDR_ARCHIVE is invoked in the context of the Dutch statutory archive concurrent program. The typical flow begins with GET_ALL_PARAMETERS resolving the request parameters from PAY_PAYROLL_ACTIONS, followed by ORG_CHECK, EMP_CHECK, and RANGE_CODE filtering qualifying records, CHECK_TAX_DETAILS determining tax inclusion, and WRITETOCLOB_RTF assembling the RTF document as a CLOB for storage or delivery. ARCHIVE_CODE and ARCHIVE_DEINIT_CODE bracket the run. Because the package is classified as OTHER with no dependent packages, customizations should call the documented signatures rather than modify the seeded source, and any direct use of WRITETOCLOB_RTF should supply a properly initialized tXMLTable collection of tag/value records.