Search Results get_days_excluded_date
Overview
APPS.PQP_GB_T1_PENSION_EXTRACTS is a PL/SQL package body belonging to the Oracle E-Business Suite Payroll (PQP) product family. It implements the logic required to produce United Kingdom statutory pension extract files — principally the T1 pension extract format associated with automatic enrolment and pension provider reporting. The package assembles assignment-level pension data, performs the payroll-derived calculations that the extract format demands, and writes the resulting records through the Benefits extract framework. The presence of trace-oriented helper procedures in the source header indicates that the package is designed for diagnostic execution within a concurrent processing environment, where debugging is controlled at the top level of the call stack.
The package is classified as OTHER rather than as a public API, meaning it is intended primarily for internal use by the pension extract concurrent program and its supporting framework rather than for direct invocation by customer extensions. Sensitive employee and payment information is processed, and much of the arithmetic concerns pensionable pay, qualifying earnings periods, and the exclusion of days for which pension contributions are not due.
Key Procedures and Functions
The package exposes sixty-six documented procedures and functions. The principal groups are as follows.
- Extract assembly and element processing: GET_ELEMENTS_FRM_UDT, GET_UDT_DATA, GET_UDT_VALUE and PROCESS_ELEMENT retrieve user-defined table (UDT) content and resolve payroll element definitions and values used to build extract records.
- Salary and rate calculations: RATES_HISTORY, CALC_ANNUAL_SAL_RATE, GET_ANNUAL_SAL_RATE_DATE, CALC_PART_TIME_SAL and GET_PART_TIME_SAL_DATE derive annualised and part-time salary rates and identify the effective dates on which those rates apply.
- Days worked and days excluded: CALC_DAYS_WORKED, GET_DAYS_ABSENT, GET_FT_DAYS_EXCLUDED, GET_PT_DAYS_EXCLUDED and GET_DAYS_EXCLUDED_DATE form the core of the calculation logic. GET_DAYS_EXCLUDED_DATE, the procedure most frequently sought by users, returns the date context against which excluded days are evaluated for full-time and part-time employees respectively.
- Balance and element lookups: GET_PAY_BAL_ID, GET_PAY_ELE_IDS_FROM_BAL and GET_EEV_INFO resolve payroll balance identifiers, element identifiers associated with those balances, and element entry values for the assignments under extract.
- Employee and employer information: GET_SAFEGUARDED_INFO, GET_EET_INFO and GET_EEV_INFO gather safeguarded information, employer (EET) details and related attributes required by the extract layout.
- Classification and control: GET_TRANSLATE_ASG_EMP_CAT_CODE maps assignment and employee category codes into the values expected by the extract, while the overloaded debug, debug_enter and related routines manage tracing through HR_UTILITY.
Tables Accessed
Access is through APPS synonyms. The Benefits extract framework tables — BEN_EXT_DFN, BEN_EXT_RCD, BEN_EXT_RCD_IN_FILE and BEN_EXT_RSLT_DTL — define the extract, its records and the result detail rows produced. FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS identify and monitor the concurrent request that drives the run. HR_ORGANIZATION_INFORMATION supplies organisation-level attributes, while PAY_ASSIGNMENT_ACTIONS provides assignment lifecycle data. The payroll calculation tables PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F and PAY_ELEMENT_LINKS_F provide element entries, their values and eligibility links; PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, PAY_BALANCE_FEEDS_F and PAY_BALANCE_DIMENSIONS resolve balance definitions, feeds and dimensional context used in the pensionable pay and exclusion calculations.
Usage Notes
PQP_GB_T1_PENSION_EXTRACTS is normally invoked by the UK pension extract concurrent program, with the business group established through FND_GLOBAL. Tracing is enabled only at the top level of the nested call stack, so diagnostic output is controlled by the extract attribute cursor rather than by individual callers. The package is referenced by four other packages, all of which depend on its calculation and lookup routines. Direct invocation from custom code is not recommended; developers requiring the exclusion or salary figures should call the extract program and consume the BEN_EXT_RSLT_DTL output, or replicate the logic with awareness of the underlying balance and element structures.