Search Results get_basis_calc_rule

Overview

APPS.PAY_NL_WW_ADJUSTMENTS is a Dutch localizations (NL) payroll package within Oracle E-Business Suite. Its purpose is to support the calculation of social insurance (SI) contributions and the associated adjustments applied to Dutch statutory deductions during payroll processing. The package encapsulates the logic required to determine contribution percentages, basis calculation rules, and provider-level information needed by the adjustment formula executed through the Oracle Payroll Fast Formula engine.

The package header, sourced from pynlsicp.pkh, declares a global PL/SQL table structure (r_si_provider / t_si_provider) that stores SI provider information for a given assignment action, including the assignment action identifier, SI type, SI provider identifier, and a processed flag. This in-memory structure allows the adjustment formula to iterate across multiple SI providers within a single payroll run without repeated database round trips. The package is classified as API classification OTHER and is owned by APPS.

Key Procedures and Functions

The package exposes five documented program units:

• GET_ADJUSTMENT_DETAILS — Returns contribution percentages (employee and employer) and the SI type name for the next execution of the adjustment formula, based on the assignment action, date earned, source text values, and age. This is the primary entry point invoked by the formula logic.
• POPULATE_PL_SQL_TABLE — Populates the package's global PL/SQL table with SI provider information for a given assignment action, date earned, SI type, and SI provider. It seeds the in-memory collection used by subsequent calls.
• GET_BASIS_CALC_RULE — Returns a numeric value representing the basis calculation rule applicable to a given combination of source text, source text2, and date earned. This rule governs how the contribution basis is derived (for example, which wage components are included or excluded).
• GET_EE_CONT_GROSS_NET — Determines whether the employee contribution is treated as gross or net for the applicable context.
• GET_SI_PROV_COUNT — Returns the count of SI providers held in the populated PL/SQL table, allowing the caller to iterate the correct number of times.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS — provide the assignment action and payroll action context for the calculation.
• PER_ALL_ASSIGNMENTS_F — supplies assignment-level attributes such as assignment identifiers used to resolve the correct employee record.
• PER_TIME_PERIODS — validates and resolves the date earned against the payroll period.
• FF_CONTEXTS and PAY_ACTION_CONTEXTS — store Fast Formula context values used to select the appropriate calculation rule and parameters.
• HR_ORGANIZATION_INFORMATION — provides organization-level (SI provider / legal employer) attributes.
• PLITBLM — the Payroll PL/SQL table mapping table, used in conjunction with the package's global PL/SQL table.

Usage Notes

PAY_NL_WW_ADJUSTMENTS is not typically called directly by end users. It is invoked indirectly through the Oracle Payroll Fast Formula engine when Dutch statutory deduction and adjustment formulas execute during a payroll run. The formula calls GET_ADJUSTMENT_DETAILS after POPULATE_PL_SQL_TABLE has been invoked to seed provider data, using GET_SI_PROV_COUNT to bound the iteration and GET_BASIS_CALC_RULE and GET_EE_CONT_GROSS_NET to resolve calculation parameters.

The package is referenced by zero other packages, indicating it functions as a standalone utility underlying the localization formula layer rather than as a dependency of other PL/SQL APIs. Custom code should invoke it only in the same context as the standard Dutch payroll formulas, respecting the assignment action in question.