Search Results pay_dk_general




Overview
Explore in AI Chat

Overview

APPS.PAY_DK_GENERAL is a Danish localization utility package in Oracle E-Business Suite Payroll (Oracle HRMS / Oracle Payroll). Its role is to centralize the retrieval of legislative and assignment-level attributes that Danish payroll processing and reporting require, so that payroll formulas, fast formulas, concurrent programs, and localization forms share a single, consistent source of truth. The package is a body-only implementation; its public contract is exposed through the declarative specifications of its constituent functions. The header comment (pydkgenr.pkb 120.2) indicates the object is shipped under the standard Oracle numeration and is treated as "noship" during development, which means it is not normally customized by customers.

Key Procedures and Functions

Thirteen documented functions make up the package. They cluster into distinct functional areas:

  • GET_TAX_CARD_DETAILS — the function documented in the source excerpt. It reads the assignment's Tax Card element entry and returns a set of tax-related outputs, including tax card type, tax percentage, tax free threshold, and monthly, bi-weekly, weekly, and daily tax deductions. Internally its private cursor get_details joins assignment, person, element link, element type, input value, element entry, and element entry value tables to resolve the effective Tax Card input value for the assignment as of a supplied effective date.
  • GET_TAX_DETAILS — returns Danish tax calculation detail for an assignment, complementing the tax card retrieval above.
  • GET_LE_EMPLOYMENT_DETAILS — returns legal employer employment attributes used by Danish statutory reporting and payroll processing.
  • GET_ATP_DETAILS and GET_ATP_OVERRIDE_HOURS — return ATP (Arbejdsmarkedets Tillægspension) pension contribution details and any overridden ATP hours for an assignment.
  • GET_SP_DETAILS — returns SP (Særlig Pensionsopsparing) contribution detail relevant to Danish payroll.
  • GET_HOLIDAY_DETAILS — returns holiday-related entitlement or accrual information used by Danish absence and pay processing.
  • GET_PBS_400_FLAG — returns a flag indicating whether PBS 400 reporting applies for the assignment or organization.
  • PENSION_TO_PROCESS_FLAG — returns a flag indicating whether pension contributions are to be processed.
  • GET_HOUR_SAL_FLAG — returns a flag indicating whether the assignment is hourly-salaried.
  • GET_ASG_START_DATE — returns the effective start date of an assignment for downstream date-based derivation.
  • GET_IANA_CHARSET and GET_UTF8TOANSI — character-set utility functions used to resolve IANA character set names and convert UTF-8 text to ANSI for Danish statutory file output.

Tables Accessed

The package reads from a well-defined set of EBS HRMS and Payroll tables, all accessed through APPS synonyms. Core payroll structures include PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F, which together supply the Tax Card element definition, its link to the business group, and the assignment's entered input values. PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F provide assignment and person context, including the primary assignment flag and business group alignment. FF_FORMULAS_F holds the formula name reference used at package level. PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_ROWS_F, and PAY_USER_COLUMN_INSTANCES_F support user-defined table lookups. FND_LOOKUP_VALUES supplies seeded lookup codes, HR_ORGANIZATION_INFORMATION supplies organization-level legislative attributes, and PAY_PAYROLL_ACTIONS is used for payroll action context. The documented access is predominantly read-only; the package is a retrieval utility rather than a data-maintenance API.

Usage Notes

PAY_DK_GENERAL is referenced by eleven other packages, which confirms it is an internal localization building block rather than an end-user-callable API. It is typically invoked from Danish payroll fast formulas, from Danish localization concurrent programs generating statutory reports such as PBS 400 and ATP/SP returns, and from Oracle Forms-based payroll pages that need to display or validate tax card and pension attributes. Because the functions require an assignment identifier and an effective date, callers must supply a valid HRMS date-tracking context; the cursor in GET_TAX_CARD_DETAILS resolves the Tax Card element by element name and legislation code 'DK' combined with a business-group match on the element link. All calls should pass the application's effective date rather than SYSDATE to preserve historical accuracy in retroactive payroll runs. The package is not intended for customer modification; any extension should be implemented in a separate custom package that calls these functions.