Results for “set_shared_globals”
21 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PQP_GB_PSI_FUNCTIONS is a PL/SQL package body within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Advanced Benefits module, specifically supporting the United Kingdom Pensions (Pension Scheme Information / PSI) statutory reporting requirements. The package provides the core business logic for the PQP Penserver Extract, a concurrent program that extracts pension scheme data for UK payroll employees and transfers it to an external pension provider ("Penserver"). It assembles employee eligibility, pay, and contract data into a structured extract file, validating each record against the criteria defined by the pension scheme configuration.
The object is owned by the APPS schema and holds a VALID status in ETRM for 12.2.2. The package is heavily integrated with Oracle Advanced Benefits (BEN) entities for person, result, and record handling, with Oracle Payroll (PAY) for element and run result data, and with Oracle HRMS (PER/HR) for assignment and people information. According to the documented metadata, the package is referenced by 13 other database objects, confirming its role as a foundational dependency rather than a leaf-level component.
Key Procedures and Functions
The package exposes approximately 50 procedures and functions. Documented examples include:
- INIT_ST_END_DATE_GLOB — initialises global variables that hold the start and end dates for the extraction window.
- GET_START_END_DATE, GET_CONTRACT_TYPE, GET_NOTIONAL_PAY, GET_ACTUAL_PAY — retrieval functions that derive the reporting period, employment contract classification, and both notional and actual pensionable pay values for an employee.
- CHECK_DEBUG, DEBUG, DEBUG_ENTER, DEBUG_EXIT, DEBUG_OTHERS — diagnostic and logging utilities that write trace information to the FND_FILE log when debugging is enabled.
- CHECK_EMPLOYEE_ELIGIBILITY, CHK_PENSERVER_BASIC_CRITERIA — evaluate whether an employee satisfies the scheme's eligibility rules and basic Penserver submission criteria.
- GET_CONFIG_TYPE_VALUES — reads configuration values that drive extract behaviour.
- SET_SHARED_GLOBALS — populates package-level global variables used throughout the extract.
- STORE_EXTRACT_EXCEPTIONS, RAISE_EXTRACT_EXCEPTIONS — capture and surface errors encountered during extraction.
- ALTKEY, PAYPOINT, EMPLOYER_CODE — derive the alternative key, payroll pay point, and employer code identifiers required by the pension provider's file format.
- PQP_PENSERVER_EXTRACT — the main driver that orchestrates the full extraction run.
Tables Accessed
The package reads and writes a broad set of EBS tables via APPS synonyms. Benefit-related access includes BEN_BENEFIT_ACTIONS, BEN_EXT_DFN, and BEN_EXT_RSLT, which supply plan definitions and participant results. Payroll data is drawn from PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES — providing element classification, entry values, and processed run results used to compute pensionable pay. HRMS entities PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F supply assignment and person records. Concurrent program context is retrieved from FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS, and configuration is read from PQP_CONFIGURATION_VALUES, while PQP_GB_PSI_ALLOWANCE_HISTORY stores historical allowance data for the PSI calculation.
Usage Notes
PQP_GB_PSI_FUNCTIONS is normally invoked indirectly through the PQP Penserver Extract concurrent program, which is submitted from the UK Payroll responsibility during the pension scheme reporting cycle. It is not typically called from Oracle Forms; instead, concurrent program submission triggers the extract, which iterates qualifying employees, applies eligibility checks, computes pay and contract values, and writes formatted output to a file via FND_FILE. Because the package is referenced by 13 other objects, customisations that modify its specification risk cascading compile failures. Developers extending UK pension reporting should treat this package as a protected integration point and prefer configuration values over direct modification.