Results for “update_linked_absence_ids”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SSP_SSP_PKG is the Statutory Sick Pay (SSP) business process package within the Oracle E-Business Suite payroll application, owned by the APPS schema. Its stated purpose is to perform the calculation of entitlement and payment for SSP purposes, covering statutory sick pay obligations for employees whose absence meets the qualifying conditions defined by the relevant legislation. The package operates as an application programming interface (API) of classification OTHER, meaning it is called by other product code rather than being exposed as a standalone user-facing utility.
The package has a long lineage within the product. The header comment records its creation in September 1995 and traces successive modifications through the late 1990s, including the renaming of all SSP objects to carry the ssp_ prefix, the replacement of a local LEL constant with ssp_SMP_pkg.c_LEL, the addition of the check_sickness_date_change procedure, and error trapping added to the get_SSP... element procedures. One entry records that the value placed in the qualifying days element entry was changed from qualifying days in the calendar week to qualifying days in the absence period — the precise semantic issue underlying the search term qualifying_days_in_period.
Key Procedures and Functions
The package exposes seventeen documented procedures and functions. They fall into several functional groupings:
- QUALIFYING_DAYS_IN_PERIOD — Determines the number of qualifying days falling within a specified absence period. As the history records, the qualifying days entry value was deliberately changed from calendar-week qualifying days to absence-period qualifying days, making this function the authoritative source for that measure.
- Linked absence handling: UPDATE_LINKED_ABSENCE_IDS, LINKED_ABSENCE_ID, LINKED_PIW_START_DATE, LINKED_PIW_END_DATE, and CHECK_FOR_BREAK_IN_LINKED_PIW. These manage the chaining of linked periods of incapacity for work (PIWs), detecting breaks between linked absences and resolving the start and end dates of the combined period.
- Absence validation: CHECK_SICKNESS_DATE_CHANGE and ABSENCE_IS_A_PIW verify that a changed sickness date is valid and that an absence qualifies as a period of incapacity for work.
- Control procedures: SSP1L_CONTROL, PERSON_CONTROL, ABSENCE_CONTROL, EARNINGS_CONTROL, STOPPAGE_CONTROL, MEDICAL_CONTROL, and SSP_CONTROL provide the control and sequencing logic for the various SSP determination stages.
- Installation and calculation: SSP_IS_INSTALLED checks whether SSP is installed (historically via
pay_legislation_rules). GET_SSP_ELEMENT retrieves the SSP element used for payment entries.
Tables Accessed
The package reads and writes statutory and payroll data through APPS synonyms. Legislative and installation data comes from FND_APPLICATION, FND_PRODUCT_INSTALLATIONS, and HR_CALENDAR_USAGES. Employee and assignment context is drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, and PER_ABSENCE_ATTENDANCES. Payroll element configuration and entry values are accessed through PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F. SSP-specific calculation results are held in SSP_EARNINGS_CALCULATIONS, SSP_MATERNITIES, and SSP_MEDICALS, with HR_ORGANIZATION_INFORMATION supplying organizational detail.
Usage Notes
SSP_SSP_PKG is an internal business-process package rather than a form-level API. It is referenced by fifteen other packages, indicating that SSP determination and payment logic is invoked indirectly through statutory sick pay processing flows, typically from absence and payroll calculation routines. Custom code requiring qualifying-day counts or linked PIW boundaries should call the documented functions rather than reimplementing the logic, and should note the historical workaround embedded in SSP_IS_INSTALLED for pre-10.7 installations.
-
PACKAGE: APPS.SSP_SSP_PKG 12.1.1
-
PACKAGE: APPS.SSP_SSP_PKG 12.2.2
-
PACKAGE: APPS.SSP_SSP_PKG 12.2.2
-
PACKAGE: APPS.SSP_SSP_PKG 12.1.1