Results for “database_item”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_P45_PKG2 is a United Kingdom payroll legislative package whose primary responsibility is to supply the data required by the PAYRPP45 concurrent report, the Oracle EBS P45 report used when an employee leaves employment and must be issued a P45 tax form. The package encapsulates the logic that retrieves "database items" (DBIs) and balance items from the payroll run result tables and assembles them into the structure the report expects. Its header comment states explicitly that it "is used by PAYRPP45 report to retrieve the database items and the balance items," making it a report-support package rather than a general-purpose API. Although the file header dates from 1995, the body carries a high version number (115.x) reflecting nearly a decade of continuous legislative maintenance, including changes for aggregate PAYE, positive offsets, NDF (non-deductible) balance handling, and dimension changes such as the replacement of PER_TD_YTD with PER_TD_CPE_YTD. In 12.1.1 and 12.2.2 the package remains owned by APPS and is classified as OTHER, meaning it is not a public API but an internal component invoked by the standard payroll report.

Key Procedures and Functions

• GET_DATABASE_ITEMS — Retrieves the database item values needed for the P45 output. The maintenance log records that it was changed to return a tax basis return code rather than a description, to obtain statutory details from run result values in preference to DBIs, to rename the Previous Pay and Tax DBIs, and to handle NDFs and nocopy hints. Constants defined at the top of the body, such as G_TAX_REFNO_ITEM ('SCL_PAY_GB_TAX_REFERENCE') and G_TAX_CODE_ITEM ('PAYE_DETAILS_TAX_CODE_GB_...'), identify the individual UK DBIs consumed here. The procedure also references context and tax detail DBIs.
• GET_BALANCE_ITEMS — Retrieves the balance values required by the report. The version log shows it was modified alongside GET_DATABASE_ITEMS to cope with NDFs and to apply nocopy hints; related work introduced a legislation code specifier into the balance_type_id lookup in the defined_balance_id function, ensuring only balances for the relevant legislation are selected.
• GET_UK_TERM_DATES — Added in 2002 and called by HREMEA, this function defaults the last standard process and final process dates during termination processing. A subsequent change restricted it to return a value only for final close, where the end date has been pushed out nocopy for the end date of the period in which the regular payment date resides, and it was also adjusted for Positive Offsets.

Tables Accessed

The package reads the core UK payroll result model through APPS synonyms. PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES supply the run result values from which statutory details are now preferentially sourced; PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS provide the assignment and payroll action context; PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F provide element and entry data; PAY_INPUT_VALUES_F supplies input values; PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS resolve the balance definitions and dimensions used by the balance item logic. HR_SOFT_CODING_KEYFLEX and PAY_ACTION_INTERLOCKS support costing and action interlock validation. One historical fix removed a reference to the redundant index PAY_ASSIGNMENT_ACTIONS_N1 from a hint on PAY_ASSIGNMENT_ACTIONS.

Usage Notes

PAY_P45_PKG2 is invoked by the PAYRPP45 concurrent program, and its GET_UK_TERM_DATES function is additionally invoked by HREMEA during termination date defaulting. It is referenced by one other package, confirming it sits beneath the report layer rather than at the top. Because the object is documented only as an internal report-support package with no public API classification, custom code should not call it directly; developers needing P45 data should execute the standard PAYRPP45 report or use supported payroll APIs. Any modification risks the legislative correctness of the P45 output in UK payroll.