Results for “hr_nl_academic_title”

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

Overview

APPS.PER_NL_QH_TAX is a Netherlands-specific localization package body within the Oracle E-Business Suite HRMS (Human Resources) module. Its internal name — "QH," standing for the Dutch Questionario/Header style tax data capture, or "Quick HR" — reflects its role in supporting Dutch statutory reporting requirements for employer tax and payroll authorities. In Oracle EBS 12.1.1 and 12.2.2, national localizations are delivered as seeded packages that extend the global PER schema with country-specific logic. PER_NL_QH_TAX is one such extension, bridging the common HR tax query framework (per_qh_tax_query) to the Netherlands-specific fields stored on the person record.

The package exists primarily to read from and write to the Dutch tax attribute columns held on PER_ALL_PEOPLE_F. These columns (per_information1 through per_information12) are overlaid for NL legislation to carry fiscal identifiers, tax codes, and name components required by Dutch tax filings. The package is marked as an API-classification "OTHER" object, indicating it is not a formally published business API but an internal localization routine.

Key Procedures and Functions

• UPDATE_NL_TAX_DATA — Writes the Dutch tax record back to the database. When the supplied legislation code equals 'NL', it updates PER_ALL_PEOPLE_F mapping the incoming per_qh_tax_query.taxrec fields (tax_field1, tax_field20 through tax_field31, tax_field7, tax_field22, etc.) onto the per_information1–12 columns plus first_name and middle_names. It also conditionally nulls country_of_birth when tax_field21 is empty. The update is date-effective, restricted to the row where the effective date falls between effective_start_date and effective_end_date.
• NL_TAX_QUERY — The read-side counterpart. It accepts the same tax record and person/assignment context, plus a legislation code and effective date, and populates the per_qh_tax_query.taxrec structure with the current Netherlands tax attributes for the given person, enabling downstream forms or reports to display the fiscal data.

Both procedures are declared with in out nocopy record parameters, consistent with performance-sensitive HR localization code, and both apply hr_utility.set_location tracing for diagnostics.

Tables Accessed

• PER_ALL_PEOPLE_F — The primary table. It is both read (during query) and written (during update) to persist the Dutch tax fields, name components, and country of birth on the date-effective person record.
• PER_ALL_ASSIGNMENTS_F — Referenced for the assignment identifier used to resolve the correct employee assignment context for the tax operation.

Both are accessed through APPS synonyms, standard for localization packages operating within the APPS schema.

Usage Notes

PER_NL_QH_TAX is not intended for direct customer invocation. It is referenced by two other packages in the ETRM registry, which are the typical entry points — most likely Dutch HR forms or the generic QH tax query orchestrator that dispatches to legislation-specific implementations. In practice the package fires when a user maintains Netherlands tax details through the Dutch HR/payroll self-service or professional forms, or when a concurrent process generates Dutch statutory tax output requiring person-level fiscal attributes. Because the update targets PER_ALL_PEOPLE_F directly, customizations calling it must supply a valid effective date and ensure date-track integrity, as the update respects the person record's effective-dating window. The 'NL' legislation guard means the routine is a no-op for any other country, making it safe when invoked from shared localization dispatchers.