Results for “earliest_app_start_date”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.SSP_SAP_PKG is a PL/SQL package body within the Oracle E-Business Suite Statutory Sick Pay (SSP) and Statutory Maternity Pay (SMP) module, part of the Oracle Payroll legislative framework for the United Kingdom. The package encapsulates the business rules governing Statutory Adoption Pay (SAP), the statutory payment entitlement extended to employees who adopt a child. It provides the calculation and validation logic required to determine whether an adoption absence qualifies for SAP, to establish the correct week of adoption for a matching child, and to derive the dates on which payment entitlement begins and ends.
The user query "bodsgp1 in sap" relates to the SAP segment of the SSP/SMP/SAP acronym family and reflects the naming conventions used across Oracle Payroll UK legislative packages. SSP_SAP_PKG holds a VALID status in the APPS schema and operates as a foundational utility rather than a directly invoked user-facing API, functioning as a supporting layer consumed by other statutory payment packages.
Key Procedures and Functions
The ETRM metadata documents six procedures and functions within this package. Their purposes are as follows:
- MATERNITY_RECORD_EXISTS — Determines whether a maternity or adoption-related record already exists for a given assignment, preventing duplicate statutory payment entries.
- MATCHING_WEEK_OF_ADOPTION — Derives the matching week of adoption, the reference point from which SAP entitlement periods are calculated under UK adoption pay legislation.
- EARLIEST_APP_START_DATE — Returns the earliest permissible SAP start date, ensuring that payment does not commence before the statutory threshold allows.
- CONTINUOUS_EMPLOYMENT_DATE — Establishes the continuous employment reference date used to test qualifying service conditions for SAP eligibility.
- SAP_CONTROL — Serves as the central control routine, coordinating the validation and calculation flow that governs SAP processing.
- GET_MAX_SAP_DATE — Returns the maximum allowable SAP date, bounding the entitlement window and supporting end-of-payment determinations.
These routines collectively form the eligibility and date-derivation engine for adoption pay, and are invoked by broader statutory payment processing logic rather than exposed as standalone concurrent APIs.
Tables Accessed
The package reads and writes the following tables through APPS synonyms:
- SSP_MATERNITIES, SSP_EARNINGS_CALCULATIONS, SSP_STOPPAGES, and SSP_WITHHOLDING_REASONS — the core SSP/SAP transactional tables holding absence records, average earnings calculations, payment stoppages, and withholding reasons that determine net statutory payment amounts.
- PER_ABSENCE_ATTENDANCES — stores the absence record driving the adoption leave event.
- PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and PER_PERIODS_OF_SERVICE — supply assignment, person, and continuous service data used for eligibility testing.
- PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_LINKS_F — the payroll element definitions and entries into which SAP results are written for payroll processing.
- DUAL — used for single-row date and look-up computations.
Usage Notes
SSP_SAP_PKG is referenced by nine other database objects, confirming its role as a dependency for higher-level statutory payment processing. It is typically invoked during absence processing when an adoption leave absence is recorded, and during statutory payment calculation runs. The package depends on SSP_SMP_PKG, SSP_SMP_SUPPORT_PKG, SSP_ERN_INS, SSP_STP_DEL, and SSP_STP_INS, indicating close integration with the maternity and sickness payment subsystems and the insert/delete routines that maintain the SSP transactional tables.
Custom code or forms that extend SAP processing should invoke the documented functions rather than replicating their date and eligibility logic, ensuring compliance with maintained legislative rules. No database objects reference this package as a caller, so it should be treated as a consuming, downstream utility within the statutory payment stack.
-
PACKAGE: APPS.SSP_SAP_PKG 12.1.1
-
PACKAGE: APPS.SSP_SAP_PKG 12.2.2
-
PACKAGE: APPS.SSP_SAP_PKG 12.2.2
-
PACKAGE: APPS.SSP_SAP_PKG 12.1.1