Search Results pqp_gb_tp_type2_functions




Overview
Explore in AI Chat

Overview

PQP_GB_TP_TYPE2_FUNCTIONS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated as VALID in both 12.1.1 and 12.2.2. It belongs to the Oracle Payroll (PQP) product family and specifically to the United Kingdom legislative payroll functionality. The package supports the calculation, validation, and reporting required for Teachers' Pensions Type 2 (TP2) processing, which is a statutory pension reporting obligation for Local Education Authority (LEA) employers in the United Kingdom. In this role it acts as a calculation and helper layer that interrogates assignment, element entry and balance data to derive the values required for Teachers' Pension returns and additional contribution processing.

The object is not an end-user-facing component; it is a library of server-side routines consumed by other payroll packages and by extract/report processes. Its primary documented consumer is PQP_GB_T1_PENSION_EXTRACTS, which indicates that the package supplies computed pension extract figures to the higher-level Teachers' Pension extract generator.

Key Procedures and Functions

The ETRM metadata documents twelve callable units within the package. Each is named below with its functional intent as implied by its identifier.

  • GET_PAY_BAL_ID — Resolves the payroll balance identifier for a given balance definition, allowing other routines to reference balances by name or context rather than by internal ID.
  • GET_PAY_ELE_IDS_FROM_BAL — Derives the associated payroll element identifiers from a balance, supporting reverse mapping between balance accumulation and the elements that feed it.
  • GET_EET_INFO — Retrieves Element Entry (EET) information, supplying the element entry records used in additional contribution and pension calculations.
  • GET_ASG_INFO — Returns assignment-level information for the employee, drawing on the core assignment and people tables.
  • GET_AAT_INFO — Returns assignment attribute information, typically sourced from PQP_ASSIGNMENT_ATTRIBUTES_F, to expose payroll-specific assignment attributes.
  • CHK_TEACHER_QUAL_FOR_TP2 — Validates whether an assignment qualifies for Type 2 Teachers' Pension treatment, providing the eligibility test that gates subsequent calculations.
  • GET_ADD_CONT_VALUE — Calculates or retrieves the value of an additional contribution.
  • GET_ADD_CONT_REFUND_IND — Determines the additional contribution refund indicator, distinguishing contributions that are refundable from those that are not.
  • GET_FINANCIAL_YEAR — Establishes the financial year context for the calculation, ensuring values are attributed to the correct UK tax/financial year.
  • GET_TOTAL_ADD_CONT — Returns the total additional contribution amount for the relevant period.
  • GET_TOTAL_ADD_CONT_SIGN — Returns the sign (positive or negative) applicable to the total additional contribution, which governs whether the amount is treated as a deduction or a refund.
  • CHK_LEA_RUN — Validates that the payroll run is an LEA (Local Education Authority) run, confirming the legislative context before Type 2 processing proceeds.

Tables Accessed

The package reads from and operates against a defined set of payroll, benefits and HR tables through APPS synonyms.

Usage Notes

PQP_GB_TP_TYPE2_FUNCTIONS is invoked indirectly rather than directly by end users. Its confirmed calling package is PQP_GB_T1_PENSION_EXTRACTS, which orchestrates the Teachers' Pension extract and delegates Type 2 eligibility, additional contribution and financial year logic to this package. The package is therefore executed within payroll runs and extract reporting jobs for UK Local Education Authority employers, and it may also be called from custom Fast Formula or bespoke reporting code that requires the same TP2 calculations. Implementers extending or troubleshooting TP2 processing should treat this package as the authoritative computation layer and should re-test dependent extracts whenever it is modified.