Results for “ssp_pad_pkg”

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

Overview

SSP_PAD_PKG is the Statutory Paternity Pay Adoption (PAD) business process package within the Oracle E-Business Suite Payroll and Statutory Payments module. Its stated purpose, taken from the package header, is to perform calculation of entitlement and payment for PAD purposes. The package body is registered under the APPS schema and is classified as OTHER in the ETRM repository for 12.2.2, with lineage traceable to 12.1.1.

The package was originally created on 30 October 2002 from SSP_SMP_PKG, reflecting the shared statutory payment framework used across maternity, paternity, adoption, and sick pay processing. Its header records a substantial maintenance history spanning 2002 through 2006, addressing average earnings calculation defects, stoppage date corrections for "some work done" scenarios, hard-coded SATURDAY/SUNDAY replacement, lump sum recalculation, date conversion fixes, and performance tuning. Later changes migrated references from per_people_f and per_assignments_f to the per_all_people_f and per_all_assignments_f dated views, and amended pad_control to invoke generate_payments in insert mode when absence is greater than zero.

Key Procedures and Functions

• MATERNITY_RECORD_EXISTS — Determines whether a corresponding statutory record already exists, supporting duplicate-prevention and eligibility checks during PAD processing.
• MATCHING_WEEK_OF_ADOPTION — Derives the matching week of adoption, the reference period that anchors the PAD entitlement and payment calculation window.
• EARLIEST_PPP_START_DATE — Returns the earliest permissible start date for Statutory Paternity Pay in the adoption context, typically tied to the placement or matching week.
• LATEST_PPP_START_DATE — Returns the latest permissible start date, bounding the valid period within which PAD may commence.
• CONTINUOUS_EMPLOYMENT_DATE — Calculates the continuous employment date used to test service qualification for statutory paternity pay adoption entitlement.
• PAD_CONTROL — The main controlling routine. It orchestrates the PAD calculation flow, evaluates absences, and invokes generate_payments with insert semantics when an absence is present, coordinating entitlement, stoppage, and payment creation.

Tables Accessed

• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F — Element definition, entry, and linkage data used to create and validate PAD element entries.
• PER_ABSENCE_ATTENDANCES — Absence records driving the PAD absence evaluation logic.
• PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PERIODS_OF_SERVICE — Assignment, person, and service history data supporting continuous employment and eligibility determinations.
• SSP_EARNINGS_CALCULATIONS — Average earnings results used in payment computation.
• SSP_MATERNITIES — Statutory record used for existence and linkage checks.
• SSP_STOPPAGES, SSP_WITHHOLDING_REASONS — Stoppage creation and withholding reason data applied when PAD payments are adjusted or ceased.

Usage Notes

SSP_PAD_PKG is referenced by eight other packages, indicating it is invoked as a shared business-process dependency rather than called directly from user interfaces. It is typically triggered during payroll or statutory payment runs, through Oracle Payroll Absence and Statutory Payment flows, or from custom code orchestrating PAD entitlement calculations. Because PAD_CONTROL writes element entries and stoppages, it should be invoked within the standard transactional and date-effective context, and any custom integration should respect the package's insert-mode behaviour for absence-driven payment generation.