Search Results pay_dk_bal_upload




Overview
Explore in AI Chat

Overview

APPS.PAY_DK_BAL_UPLOAD is a Danish (DK) country-specific localization package within the Oracle E-Business Suite Payroll (PAY) module. Its business purpose is to apply Denmark-specific statutory validation rules to balance upload batches before those batches are processed by the core Oracle Payroll balance upload engine. The package acts as a localized extension hook, allowing the standard PAY_BALANCE_UPLOAD framework to delegate regional compliance checks to a country-appropriate implementation. The header comment confirms this intent, stating that the package exists to apply DK specific validation to a batch, and that its procedures are invoked from within pay_balance_upload.validate_batch_lines. The header revision identifier (pydkbalupl.pkh 120.1, dated 13 March 2007) indicates the package has been in production since at least the early R12 timeframe and remains stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The documented API surface consists of four callable units, each reflecting a distinct localization concern:

  • EXPIRY_DATE (function) — Returns a date representing the expiry date applicable to a balance entry, based on the upload date, dimension name, assignment, and original entry supplied by the caller. It supports age- or period-sensitive handling of Danish balance data.
  • IS_SUPPORTED (function) — Returns a numeric indicator (typically 1 or 0) stating whether a given balance dimension name is supported by the Danish localization. This allows the generic upload engine to determine whether the DK rules apply to a particular dimension.
  • INCLUDE_ADJUSTMENT (function) — Returns a numeric indicator determining whether a specific balance adjustment should be included in the DK upload processing, evaluated against the balance type, dimension, original entry, upload date, and batch/line identifiers.
  • VALIDATE_BATCH_LINES (procedure) — The central entry point, accepting a batch identifier (p_batch_id) and applying Danish-specific validation to all lines in that batch. It is explicitly documented as being invoked by pay_balance_upload.validate_batch_lines.

Tables Accessed

The package references three objects through APPS synonyms:

  • PER_ALL_ASSIGNMENTS_F — The assignments date-tracked table, read to resolve assignment-level context such as effective dates and assignment validity when evaluating expiry and adjustment logic.
  • PER_TIME_PERIODS — The payroll time period definitions, consulted to map upload dates to the correct payroll period for Danish statutory reporting and validation.
  • DUAL — The standard Oracle dummy table, used for scalar evaluations and to satisfy PL/SQL query syntax where no physical table is required.

Usage Notes

This package is not intended for direct invocation by end users. It is called indirectly by the core PAY_BALANCE_UPLOAD package during the batch validation phase of the balance upload process. The ETRM metadata records that no other packages reference PAY_DK_BAL_UPLOAD directly, and it is classified as an OTHER API — meaning it is a localization hook rather than a public integration interface. In practice, it is exercised when a Danish payroll user loads balance adjustments via the standard balance upload mechanisms (such as the Balance Upload concurrent program or associated forms) and the batch contains elements requiring DK-specific validation. Custom code should not call these procedures directly, as the calling contract is owned by PAY_BALANCE_UPLOAD and may evolve between 12.1.1 and 12.2.2.