Results for “spawn_reports”

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

Overview

APPS.PAY_P45_PKG is a PL/SQL package within the Oracle E-Business Suite Applications schema that supports statutory year-end reporting for the United Kingdom payroll legislation. Its principal business purpose is the generation, archiving, and retrieval of P45 data — the certificate of pay and tax deducted that an employer must issue when an employee leaves employment, and the associated P45 (Part 1) return submitted to HM Revenue & Customs at the end of the tax year. The package coordinates the interaction between payroll assignment actions, end-of-year archival records held in PAY_GB_EOY_ARCHIVE, and the Oracle Fast Formula infrastructure used to derive legislative values.

The package is documented in ETRM 12.2.2 with an API classification of OTHER, indicating that it is a supporting internal component rather than a public, supported extension API. It exposes nineteen documented procedures and functions and depends on several core HRMS and payroll objects, including HR_GENERAL, HR_ORGANIZATION_INFORMATION, PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS.

Key Procedures and Functions

The documented procedures and functions address three functional areas: archival/action creation, P45 data retrieval, and P45 issued-flag maintenance.

• ARCHINIT, ARCH_ACT_CREATION, ARCHIVE_CODE, EDI_ACT_CREATION — initialise and populate archival structures, create the assignment actions required to record P45 activity, and manage the end-of-year archive code and electronic data interchange action creation.
• RANGE_CURSOR, GET_DATA, GET_FORM_QUERY_DATA — cursor and data-access routines used to select the assignment and archive records processed by the package and returned to the online form layer.
• GET_P45_FORMULA_ID, GET_STUDENT_LOAN_FLAG — retrieve the Fast Formula identifier governing P45 calculation and the student loan indicator applicable to the leaver.
• GET_P45_ASG_ACTION_ID, GET_P45_AGG_ASG_ACTION_ID — return the P45 assignment action identifier for an individual assignment and for the aggregated assignment action used in consolidated processing.
• GET_P45_EIT_MANUAL_ISSUE_DT — obtains the manually entered P45 issue date stored as an extra information type value.
• RETURN_P45_ISSUED_FLAG, PAYE_RETURN_P45_ISSUED_FLAG, PAYE_SYNC_P45_ISSUED_FLAG — read, set, and synchronise the flag that records whether a P45 has been issued, ensuring the PAYE return and the P45 record remain consistent.
• POP_TERM_PACT_FROM_ARCHIVE — populates termination and payroll action data from the end-of-year archive.
• SPAWN_REPORTS, GET_REPORT_REQUEST_ERROR — submit the associated P45 reports as concurrent requests and report errors raised during that submission.

Tables Accessed

The package reads and writes through APPS synonyms. Payroll and action data are held in PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_PAYROLL_ACTIONS, PAY_ALL_PAYROLLS_F, and PAY_ACTION_INTERLOCKS, which together represent the assignment-level actions that drive P45 creation and the interlock records that control action sequencing.

Archival data resides in the Fast Formula archive tables FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_USER_ENTITIES, FF_FORMULAS_F, and FF_FORMULA_TYPES, with PAY_GB_EOY_ARCHIVE storing the UK end-of-year archive itself. Organisational and legislative context is obtained from HR_ORGANIZATION_INFORMATION, HR_ALL_ORGANIZATION_UNITS, and HR_SOFT_CODING_KEYFLEX. Concurrent processing metadata is drawn from FND_CONCURRENT_REQUESTS and FND_SESSIONS.

Usage Notes

PAY_P45_PKG is referenced by PAY_GB_EOY_ARCHIVE, PAY_GB_REP, PAY_P45_PKG itself, and PER_GB_TERMINATION, and by six other packages in total. It is therefore invoked indirectly during UK end-of-year processing, P45 report submission, and employee termination handling rather than being called directly by end users. The procedures are typically driven from the UK payroll concurrent programs and from the termination and P45 forms, with SPAWN_REPORTS managing submission of the associated reports. Because the package is classified as OTHER rather than a public API, customisations should avoid direct calls and instead use supported concurrent program and form entry points.