Results for “pay_p45_pkg”

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

Overview

PAY_P45_PKG is a UK-specific Oracle Payroll package that supports the P45 form (form name PAYWSR45), which is invoked from the PAYGBTAX form. Its principal business purpose is to gather, validate, archive, and expose the payroll and assignment data required to produce a P45 — the statutory UK end-of-employment tax document issued when an employee leaves an assignment. The package body is registered in Oracle E-Business Suite 12.1.1 and 12.2.2 under the APPS schema with an API classification of OTHER. It encapsulates report request error handling, archive-package integration, P45 formula resolution, student loan determination, and form query data retrieval. The header comment dates the package to 1994, and its revision history documents two decades of maintenance fixes covering year-2000 date handling, NLS date formatting, taxable-pay subquery correlation, and multi-period-of-service leaver scenarios — evidence of its long-standing role in UK payroll compliance.

Key Procedures and Functions

The package exposes 19 documented procedures and functions, which fall into several functional groups.

• Archive processing: ARCH_ACT_CREATION and EDI_ACT_CREATION interact with the archive framework to create archive and EDI actions; ARCHINIT initializes archive structures; ARCHIVE_CODE supplies archive classification; POP_TERM_PACT_FROM_ARCHIVE populates termination payroll action data from archived records.
• Data retrieval: GET_DATA and GET_FORM_QUERY_DATA return the core P45 datasets; GET_P45_FORMULA_ID resolves the formula used to derive P45 values; GET_P45_ASG_ACTION_ID, GET_P45_AGG_ASG_ACTION_ID, and GET_P45_EIT_MANUAL_ISSUE_DT resolve assignment action identifiers and manual-issue effective dates.
• Status and flags: GET_STUDENT_LOAN_FLAG determines student loan applicability; RETURN_P45_ISSUED_FLAG, PAYE_RETURN_P45_ISSUED_FLAG, and PAYE_SYNC_P45_ISSUED_FLAG report and synchronize whether a P45 has been issued.
• Infrastructure: RANGE_CURSOR defines a reusable cursor range; GET_REPORT_REQUEST_ERROR captures concurrent request errors; SPAWN_REPORTS submits report runs.

Tables Accessed

The package reads and writes a defined set of payroll and HR tables through APPS synonyms.

• Archive tables: FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_USER_ENTITIES, FF_FORMULAS_F, and FF_FORMULA_TYPES supply archived payroll balances, user entity definitions, and formula metadata used by the archiving and formula-resolution logic.
• Assignment and action tables: PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INTERLOCKS, and PAY_PAYROLL_ACTIONS provide assignment action history, interlocks, and payroll action records used to derive termination and P45 action identifiers.
• Payroll definition: PAY_ALL_PAYROLLS_F supplies payroll attributes, including the tax reference held on the payroll soft coding, used to identify the correct tax details for the assignment.
• HR organization data: HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX deliver employer address and soft coding information that appears on the P45.
• Concurrent processing: FND_CONCURRENT_REQUESTS and FND_SESSIONS support report submission and session-date handling historically tied to get_ff_data processing.

Usage Notes

PAY_P45_PKG is invoked primarily through the PAYGBTAX form when the user opens the P45 form (PAYWSR45), and secondarily from concurrent report submission paths via SPAWN_REPORTS. Six other packages reference it, confirming it is a shared dependency in the UK payroll processing chain rather than an isolated form handler. Customizations should avoid direct calls to internal archive routines and instead use the documented entry points such as GET_DATA and GET_FORM_QUERY_DATA. Because the package manipulates archived payroll balances and PAYE/taxable pay data, testing must account for NLS date formats and multiple periods of service for leavers, as documented in the package history.