Search Results actual_termination_emp

Overview

PER_PL_TERMINATION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API. It is a country-specific (localization) package supporting Polish HRMS payroll and statutory reporting requirements. Its business function is to record and reverse the termination of an employee's period of service, including the actual termination date and the associated leaving reason, while ensuring that downstream Polish statutory records — in particular PAYE and SII (insurance) details — remain consistent with the employment event. The package is defined with AUTHID CURRENT_USER, meaning that executing privileges are evaluated against the calling schema rather than the package owner, which is typical of APPS wrapper packages that operate on the caller's behalf.

Key Procedures and Functions

• ACTUAL_TERMINATION_EMP — The primary procedure for recording an actual termination event. It accepts a period of service identifier, an actual termination date, and a business group identifier, and applies them to the employee's period of service record. This is the procedure surfaced by the search term "actual_termination_emp". Its purpose is to stamp the termination on the assignment's period of service and trigger any localization-specific side effects required for Polish payroll.
• REVERSE — The compensating procedure. It accepts a period of service identifier, an actual termination date, and a leaving reason, and reverses a previously recorded termination so that the employee's period of service is restored to its pre-termination state. The inclusion of the leaving reason allows the correction to retain or reset the categorisation of the exit.

Both procedures are declared in the package specification (peplterp.pkh). No additional public functions or procedures are documented in the supplied metadata; the package contains exactly two callable units.

Tables Accessed

Based on the documented reference list, the package interacts with the following tables (accessed through APPS synonyms):

• PER_PERIODS_OF_SERVICE — the core record for the employee's period of service; both procedures read and write the actual termination date and leaving reason here.
• PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES — used to reflect the change in the employee's assignment and assignment status arising from the termination or its reversal.
• PAY_PL_PAYE_DETAILS_F and PAY_PL_SII_DETAILS_F — Polish payroll and social insurance detail tables that must be kept aligned when an employment event changes.
• HR_SOFT_CODING_KEYFLEX — the key flexfield structure used to derive or validate flexfield combinations associated with the affected records.

Usage Notes

PER_PL_TERMINATION is a server-side localization API rather than a general-purpose HRMS entry point. It is normally invoked indirectly — from the Oracle HRMS termination forms or from Polish payroll and statutory-reporting concurrent programs — and can also be called directly from custom PL/SQL where a business process must terminate an employee programmatically. Typical consumers are the Polish payroll flows that generate PAYE and SII submissions, whose reference data depends on an accurate termination date. The metadata records the package as referenced by one other package, indicating that it is part of a small dependency cluster rather than a widely reused API. Because it is an "OTHER" classification API and carries AUTHID CURRENT_USER, callers should be mindful of grants and of the fact that it is not a public-supported API in the same sense as HRMS open interfaces. When the source header is consulted, note the ownership and version information embedded in the .pkh file.