Search Results pqp_gb_tp_extract_functions




Overview
Explore in AI Chat

Overview

PQP_GB_TP_EXTRACT_FUNCTIONS is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment, classified under the ETRM repository as an "OTHER" API type. Its name identifies it as a GB (United Kingdom) localisation component belonging to the Payroll/HR (PQP) product family, oriented toward "TP" (third-party or transfer/pension) extract processing. The package provides a reusable library of extraction utility routines that assemble, validate, and surface data during the generation of statutory or pension-related extracts. Rather than acting as a standalone concurrent program, it functions as a shared service layer invoked by other extract packages that require consistent handling of extract results, person-level context, and error or warning reporting. In Oracle EBS 12.1.1 and 12.2.2, such packages are commonly embedded in the GB payroll legislative architecture, supporting extracts that must reconcile assignment and person records before output files are produced.

Key Procedures and Functions

The ETRM metadata documents four callable units within this package. No parameter signatures are published, so the descriptions below reflect purpose only.

  • GET_CURRENT_EXTRACT_RESULT — Returns the result of the extract currently being processed, allowing calling packages to determine success, failure, or accumulated output state without maintaining their own tracking variables.
  • GET_CURRENT_EXTRACT_PERSON — Returns the person context for the extract in progress, providing the identity currently under processing so downstream routines can associate data with the correct individual.
  • RAISE_EXTRACT_WARNING — Raises a non-fatal warning condition during extraction, enabling callers to record issues that do not halt the extract run but require visibility.
  • RAISE_EXTRACT_ERROR — Raises a fatal error condition, typically used to abort or flag the extract when validation fails or required data is unavailable.

Tables Accessed

The documented dependency list identifies a single referenced table accessed via an APPS synonym: PER_ALL_ASSIGNMENTS_F. This is the core Oracle HRMS assignment table, holding the effective-dated assignment records that link a person to an organisation, position, payroll, and location. Access to this table indicates that the package resolves current assignment context as part of extraction — consistent with the person-oriented function GET_CURRENT_EXTRACT_PERSON and with the need to scope extract output to valid, active assignments. It reads assignment data rather than maintaining its own persistent extract tables, implying that storage of extract results is delegated to the calling packages.

Usage Notes

The ETRM metadata records that this package is referenced by three other packages: PQP_GB_CPX_EXTRACT_FUNCTIONS, PQP_GB_T1_PENSION_EXTRACTS, and PQP_GB_TP_PENSION_EXTRACTS, and that it also references itself (internal calls between its own procedures and functions). This dependency pattern shows its role as a subordinate utility invoked by higher-level extract drivers. In practice, such packages are called from concurrent program execution paths and from custom PL/SQL that generates GB pension or third-party extracts. Because it is not itself an entry-point API and exposes no documented parameters, it should be treated as an internal implementation package: customisations should not call it directly unless the surrounding extract context has been established. Administrators validating extract behaviour in 12.1.1 or 12.2.2 can confirm its status as VALID in the APPS schema and inspect the referenced-by list to trace which extract programs depend upon it.