Results for “quarter_end”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_DK_EMP_TRAINEE_REIMBURSE is a Danish localization package body in the Oracle E-Business Suite Payroll (PAY) module. Its responsibility is to support the reimbursement of employee trainees under Danish statutory payroll rules. The package assembles payroll-related data for employee trainees and generates the structured output (XML) required for reporting reimbursement amounts. The header comment pydkaerrpt.pkb indicates the source file is associated with a Danish (DK) payroll report, and the package belongs to the APPS schema, classifying it as an OTHER API (not a public, seeded business API such as those under PAY_*_API conventions). In 12.1.1 and 12.2.2 the package logic is essentially unchanged, operating against the same underlying PAY and PER tables in both releases.
Key Procedures and Functions
The ETRM metadata documents one public procedure: POPULATE_DETAILS. This procedure is the entry point that gathers the relevant trainee reimbursement details and populates the internal structures used to build the report output. Internally, the package body also contains supporting functions and procedures visible in the source excerpt, including get_IANA_charset, which resolves the correct XML character set by querying FND_LOOKUP_VALUES for the FND_ISO_CHARACTER_SET_MAP lookup type based on the session's NLS language setting, and write_to_clob, which iterates the package's global XML element table (g_xml_element_table) and writes each tag/value pair into a CLOB to produce well-formed XML. These helpers support the output generation performed on behalf of POPULATE_DETAILS. Parameter lists are not documented in ETRM and are therefore not asserted here.
Tables Accessed
The package reads and, where applicable, references the following documented tables through APPS synonyms:
- FF_GLOBALS_F — FastFormula globals, used for localization formula configuration and global values.
- FND_LOOKUP_VALUES — resolves the IANA character set for XML encoding in get_IANA_charset.
- PAY_ASSIGNMENT_ACTIONS — assignment-level payroll actions relevant to the trainee.
- PAY_BALANCE_DIMENSIONS, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES — balance definition, dimension, and value metadata used to retrieve reimbursement balances.
- PAY_ELEMENT_TYPES_F — element type definitions for the reimbursement elements.
- PAY_PAYROLL_ACTIONS — payroll run actions that scope the reporting period.
- PAY_RUN_RESULTS — the actual payroll run result values that constitute the reimbursement amounts.
- PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — assignment and person records for the trainee.
- DBMS_LOB and PLITBLM — Oracle-supplied packages used for CLOB manipulation and PL/SQL table handling during XML assembly.
Usage Notes
This package is invoked as part of the Danish payroll localization reporting flow. It is not referenced by any other documented package (referenced by 0 packages), indicating it functions as a top-level provider rather than a shared utility. In practice it is called from a concurrent program or from reporting logic that extracts trainee reimbursement data and produces XML output, which is then consumed by downstream reporting or submission processes. The XML generation pattern — building tag/value pairs in a PL/SQL table and writing them to a CLOB — is typical of Oracle EBS localization report generators. Because only POPULATE_DETAILS is exposed and documented, customizations should call that procedure rather than the internal XML helpers. The character set logic depends on the session NLS_LANG setting, so callers should ensure the correct language environment when scheduling concurrent requests.