Search Results get_defined_balance_id

Overview

APPS.PAY_GB_RTI_P60 is a United Kingdom-specific Oracle Payroll package body that retrieves live payroll data and archives it for the Real Time Information (RTI) P60 end-of-year reporting process. The package forms part of Oracle E-Business Suite's GB statutory payroll compliance layer for HMRC RTI submissions. Its header comment, versioned at 120.0.12020000.2 (last modified 11-Feb-2013 by krreddy), confirms the package's purpose: "It fetches the live data and archives it for RTI P60 Process." The package was originally created on 29-Dec-2012 under bug 14759137, with subsequent revisions addressing No Data Found errors, removal of pence conversion on amount fields, corrections to name_and_initials, w1_m1_indicator and NI Employee YTD logic, archiving of date of birth, sex and tax year, and revised PAYE and NI aggregation logic. A function, get_column_value, was added specifically for use by the PYGBRTIP60OP.xml report.

The package declares a set of global variables that drive its archiving logic, including g_legislation_code (fixed to 'GB'), business group and payroll identifiers, tax year boundaries (g_start_year, g_end_year), effective dates, and the FPS-related variables g_fps_effective_date, g_fps_start_year and g_fps_end_year. This state is shared across the package's procedures during a P60 archiving run.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions for this package:

• RANGE_CURSOR — Encapsulates the cursor logic that defines the data range processed during the archiving run, aligning the selection of assignment actions and balances to the relevant tax year and effective dates.
• RTI_FPS_ACTION_CREATION — Creates the payroll action records required for the RTI Full Payment Submission (FPS) process, which underpins the P60 data set.
• ARCHINIT — Initialises the archiving process, setting up the global package variables and preparation steps before data extraction begins.
• ARCHIVE_CODE — Performs the core archival work, copying live payroll data into the RTI P60 archive structures.
• DEINITIALIZATION_CODE — Cleans up package state after archiving completes, resetting globals and releasing any resources.
• GET_COLUMN_VALUE — A function added on 29-Jan-2013 specifically to support the PYGBRTIP60OP.xml report, returning formatted column values for report output.

No parameter lists are documented in the available metadata; the descriptions above reflect the purpose evidenced by the package header and naming conventions.

Tables Accessed

The package reads and writes a substantial set of APPS-synonym tables. Key data tables include PAY_DEFINED_BALANCES and PAY_BALANCE_DIMENSIONS, which supply the balance definitions and dimensional context used when aggregating PAYE and NI year-to-date values. PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S provide the payroll processing records for the tax year, while PAY_ALL_PAYROLLS_F, PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS support action creation and status tracking. HR_ORGANIZATION_INFORMATION and HR_ORGANIZATION_UNITS supply business group and organisation context, and HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS scope the assignment population. HR_SOFT_CODING_KEYFLEX is read for costing context, FND_TERRITORIES_TL for territory/legislation lookups, FND_CONCURRENT_REQUESTS for concurrent process tracking, and the FF_ARCHIVE_ITEMS and FF_USER_ENTITIES tables for the archiving framework itself.

Usage Notes

PAY_GB_RTI_P60 is invoked as part of the GB RTI P60 end-of-year concurrent process rather than from a standard form. Its GET_COLUMN_VALUE function is called by the PYGBRTIP60OP.xml report definition to render output columns. The package is not referenced by any other documented package, confirming that it functions as a top-level archival utility. Customers and partners extending GB RTI reporting should invoke the package through the seeded concurrent program to preserve the expected initialisation and deinitialisation sequence provided by ARCHINIT and DEINITIALIZATION_CODE.