Results for “ssp_ssp_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SSP_SSP_PKG is the core PL/SQL business process package for Statutory Sick Pay (SSP) within the Oracle E-Business Suite UK Payroll legislation. Declared with AUTHID CURRENT_USER, it encapsulates the calculation of entitlement and payment for SSP purposes in accordance with UK statutory requirements. The package header carries a version stamp of 120.2.12010000.1 originating in 2008, and its development history traces back to September 1995, reflecting a long-lived component of the Oracle Payroll (PAY) application family.

The package is classified under ETRM as API classification OTHER and is owned by the APPS schema. It operates as a supporting engine rather than a generic public API: it performs the actions mandated by UK legislation for SSP, applying the specific statutory rules documented in the Statutory Sick Pay Manual and the associated High Level Design documentation. It exposes seventeen documented procedures and functions and is referenced by fifteen other packages, indicating it sits at the centre of the SSP processing dependency graph.

Key Procedures and Functions

• SSP_IS_INSTALLED — Determines whether the SSP legislation component is installed, gating other processing.
• SSP_CONTROL — The principal controlling procedure orchestrating the SSP calculation flow.
• SSP1L_CONTROL — Controls the SSP1L statutory form processing logic associated with linked periods of incapacity for work.
• PERSON_CONTROL — Applies person-level eligibility checks for SSP entitlement.
• ABSENCE_CONTROL — Validates and processes absence records for SSP purposes.
• EARNINGS_CONTROL — Handles earnings tests and average weekly earnings calculations required by SSP rules.
• STOPPAGE_CONTROL — Manages the effect of other stoppages on SSP entitlement.
• MEDICAL_CONTROL — Added in version 115.9 (bug 3466672), manages medical evidence requirements.
• CHECK_SICKNESS_DATE_CHANGE — Added September 1995, detects and reacts to changes in sickness dates.
• ABSENCE_IS_A_PIW — Determines whether an absence qualifies as a Period of Incapacity for Work.
• LINKED_PIW_START_DATE and LINKED_PIW_END_DATE — Return the start and end dates of linked PIWs; pragma restrictions were removed at version 115.4 (bug 1027169).
• CHECK_FOR_BREAK_IN_LINKED_PIW — Tests for a break that severs the linkage between consecutive PIWs.
• LINKED_ABSENCE_ID and UPDATE_LINKED_ABSENCE_IDS — Manage and persist the identifiers that associate linked absence records.
• QUALIFYING_DAYS_IN_PERIOD — Calculates qualifying days for an SSP period; version 30.14 (bug 701750) added a parameter processing level controlling how much work is delegated to the calendars package.
• GET_SSP_ELEMENT — Retrieves the SSP element definition used in payroll processing.

Tables Accessed

The package reads and writes a broad set of HRMS and payroll tables through APPS synonyms. It consults PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F and PER_PERIODS_OF_SERVICE to establish the employee context, and PER_ABSENCE_ATTENDANCES for absence records. Payroll structures are sourced from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F and PAY_INPUT_VALUES_F. Legislative and installation checks use FND_APPLICATION and FND_PRODUCT_INSTALLATIONS. Calendar processing relies on HR_CALENDAR_USAGES, and organisation attributes on HR_ORGANIZATION_INFORMATION. SSP-specific state is persisted in SSP_EARNINGS_CALCULATIONS, SSP_MATERNITIES and SSP_MEDICALS.

Usage Notes

SSP_SSP_PKG is invoked indirectly by the payroll run and by other legislation packages rather than being called directly from end-user forms. Its fifteen referencing packages confirm that SSP entitlement, absence and earnings processing flow through this package during payroll calculation. Custom integrations should treat it as an internal engine, calling only the control procedures where documented, and never bypassing the standard SSP element setup. Because it is defined AUTHID CURRENT_USER, callers require appropriate grants on the underlying APPS synonyms.