Search Results get_element_link_id

Overview

APPS.PAY_DK_TC_DP_UPLOAD is a Danish localization payroll package within Oracle E-Business Suite, supporting the Danish tax reporting and data-collection requirements delivered for Oracle Payroll. In the Oracle EBS 12.1.1 and 12.2.2 releases it serves as the upload and processing utility for the Danish "TC" (Tax Card / skattekort) direct data collection interface, converting external flat-file tax card data into payroll element entries for a specified business group and effective date. The package is classified under the ETRM taxonomy as an OTHER API, meaning it is not a core public payroll API but a localization-specific uploader generally invoked through a concurrent program wrapper rather than from application forms.

Key Procedures and Functions

• UPLOAD — The primary entry point. It drives the flat-file import: it reads the input file identified by file name and effective date, resolves the target business group, and creates or updates payroll element entries for the affected assignments. It receives standard concurrent program OUT parameters (error buffer and return code), and accepts a batch name and optional reference to identify the upload run. It performs validation and writes processing results to the HR_PUMP staging tables before applying changes to payroll.
• READ_RECORD — A parsing helper that consumes a single delimited line of the input file and returns fifteen generic entry values and three return values as separate OUT parameters. It decouples file format parsing from business logic, allowing field positions within the Danish tax card record layout to be mapped to individual element input values.
• GET_ELEMENT_LINK_ID — A lookup function that returns the element link identifier for a given assignment, business group, effective date and element name. It resolves the correct element link by joining the element type definitions to the eligibility/link definitions valid at the supplied date, which is essential because element entries must be created against a valid link for the assignment. This function is the object most commonly searched for by developers, as it exposes the internal date-tracked link resolution logic for reuse or debugging.

Tables Accessed

• PAY_ELEMENT_TYPES_F / _TL, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F / _TL, PAY_ELEMENT_ENTRIES_F — the core payroll definitions and entry tables used to resolve element names, link eligibility, input values and to create or update the resulting entries.
• PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, HR_ORGANIZATION_INFORMATION — HR assignment, person and organization data used to determine eligible assignments and business group context.
• HR_PUMP_BATCH_HEADERS, HR_PUMP_BATCH_LINE_USER_KEYS — batch staging tables that record the upload batch and line-level keys for auditing and error reporting.
• FND_SESSIONS — provides session context, and UTL_FILE is used to read the input file from an accessible directory path.

Usage Notes

PAY_DK_TC_DP_UPLOAD is typically invoked through a Danish localization concurrent program that supplies the file name, effective date, business group and batch name. It is referenced by one other package within the ETRM inventory, indicating it forms part of a larger Danish payroll data-collection flow rather than being called directly from forms. Developers maintaining or extending Danish tax card processing may call GET_ELEMENT_LINK_ID or READ_RECORD independently when validating link resolution or prototyping record parsing, but the supported path for bulk data is the UPLOAD concurrent process, which must be run in the correct business group context and against a file located in a directory registered with UTL_FILE.