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:

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.