Search Results get_adjustment_details

Overview

APPS.PAY_NL_WW_ADJUSTMENTS is a Dutch statutory social-insurance (Sociale Verzekeringen) support package within the Oracle E-Business Suite Payroll application. Its business purpose is to determine, calculate, and persist the employer and employee social-insurance adjustments that arise when a payroll run is processed for a Dutch legal employer. The package resolves the applicable contribution rules from configuration stored against the Social Insurance Type (SIT) organization, evaluates the resulting adjustments for the assignment being processed, and materialises the detail rows that the payroll engine later consumes. The "WW" element of the name refers to the Dutch unemployment-insurance legislation (Werkloosheidswet), which is one of the statutory schemes administered through this code path alongside the broader SIT configuration model.

Configuration is held in HR_ORGANIZATION_INFORMATION under the NL_SIT information context, keyed by organization (the social-insurance provider), insurance type, and an effective date range. The user search term si_provider_id is directly relevant here: the package treats the social-insurance provider as an organization identifier (SI provider ID), which is passed as the join key against HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID when deriving basis calculation rules and gross/net treatment for employee contributions.

Key Procedures and Functions

• GET_BASIS_CALC_RULE — Returns the basis calculation rule applicable to a given social-insurance type, provider, and date earned, resolved from the NL_SIT organization information context.
• GET_EE_CONT_GROSS_NET — Determines whether the employee contribution is treated as gross or net for the supplied insurance type, provider, and date earned.
• GET_SI_PROV_COUNT — Returns a count of social-insurance providers, used to validate or qualify the provider being resolved for the assignment.
• GET_ADJUSTMENT_DETAILS — Derives the social-insurance adjustment detail for the payroll action being processed, combining assignment, payroll action, and time-period context.
• POPULATE_PL_SQL_TABLE — Populates the PL/SQL table (PLITBLM) with the adjustment rows produced, providing the transfer mechanism between this package and its caller.

All five documented units are exposed as public program units within the package body; the two GET_ functions for basis rules and gross/net treatment are implemented as cursor-driven lookups against the NL_SIT context.

Tables Accessed

• HR_ORGANIZATION_INFORMATION — The primary configuration source, read under the NL_SIT context to obtain basis calculation rule, gross/net indicator, and effective-dated provider attributes.
• PER_ALL_ASSIGNMENTS_F — Provides the assignment and effective-dated employment context for the person being processed.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — Define the payroll action and its assignment-level action rows, anchoring the adjustment to a specific payroll run.
• PAY_ACTION_CONTEXTS and FF_CONTEXTS — Supply the payroll action context values and fast-formula context definitions required for rule resolution.
• PER_TIME_PERIODS — Provides the payroll period boundaries used for effective-date determination.
• PLITBLM — The PL/SQL table populated by POPULATE_PL_SQL_TABLE as the output channel for calculated adjustment detail.

Usage Notes

The package is classified as OTHER in the ETRM registry and is referenced by zero other packages, indicating that it is invoked as a leaf-level utility rather than reused as a shared library. It is normally called from the Dutch payroll calculation path during payroll run processing, when the payroll engine requires the statutory social-insurance adjustment for an assignment. Because it relies on NL_SIT organization information, any changes to the social-insurance provider setup — including the SI provider ID assigned to the legal employer — directly affect its results. Custom code or concurrent programs that manipulate Dutch SIT configuration should therefore be tested against this package's rule resolution and gross/net logic.