Search Results get_atp_details

Overview

PAY_DK_GENERAL is a Danish localization utility package within the Oracle EBS Payroll (PAY) application. It belongs to the APPS schema and is classified as an OTHER API. The package consolidates a set of date-effective, assignment-level lookups that the Danish payroll engine and its supporting legislation processes require at runtime. Rather than duplicating business rules across fast formulas and concurrent programs, the package centralizes the derivation of tax card attributes, ATP (labour market supplementary pension) values, holiday allowance data, special pension information, and character set handling into a single callable API surface. The header revision ($Header: pydkgenr.pkh 120.2.12000000.2, dated 2007) indicates the package has been stable across the 12.1.1 and 12.2.2 releases and remains a shared dependency for other localization packages.

Key Procedures and Functions

• get_tax_card_details — Retrieves the tax card type and the associated percentage and exemption thresholds for an assignment, returning the resulting deductions normalized across monthly, bi-weekly, weekly, and daily frequencies.
• get_tax_details — Returns the effective start and end dates of the assignment's tax record, allowing callers to determine when a given tax configuration applies.
• get_le_employment_details — Supplies the legal employer's standard work hours and the frequency at which those hours are expressed, based on the organization identifier.
• get_atp_details — Returns the effective date range of an assignment's ATP record, used to validate whether ATP contributions apply for a payroll period.
• get_sp_details — Retrieves the CVR (central business register) number associated with a payroll action, supporting statutory reporting.
• get_atp_override_hours — Returns any manually overridden ATP hours defined for an assignment at a given effective date.
• get_holiday_details — Derives holiday allowance start and end dates plus any override days and hours for an absence period.
• get_IANA_charset — Returns the IANA character set name used for Danish output encoding.
• get_hour_sal_flag — Returns a flag indicating whether the assignment is paid on an hourly or salaried basis, which payroll formulas use to select the correct processing path.

Additional public members include GET_UTF8TOANSI, GET_ASG_START_DATE, PENSION_TO_PROCESS_FLAG, and GET_PBS_400_FLAG.

Tables Accessed

The package reads assignment and person context from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F, and legal employer attributes from HR_ORGANIZATION_INFORMATION. Payroll configuration is drawn from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F. Tax and reporting references come from FND_LOOKUP_VALUES and PAY_PAYROLL_ACTIONS, while formula integration and user-defined data are sourced from FF_FORMULAS_F and the PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F, PAY_USER_ROWS_F, and PAY_USER_TABLES family. All access is through APPS synonyms.

Usage Notes

PAY_DK_GENERAL is invoked primarily from Danish payroll fast formulas, which call get_hour_sal_flag, get_tax_card_details, and get_atp_details during payroll run processing to resolve assignment-level attributes at the effective date. Concurrent programs and the Danish statutory reporting extracts call get_sp_details and get_IANA_charset for output generation. The package is referenced by eleven other packages, so customizations should treat it as a stable interface: extend behavior by wrapping these functions rather than modifying the package body, and always pass a valid effective date, since every assignment-level function is date-effective.