Search Results pay_ter_del




Overview
Explore in AI Chat

Overview

The APPS.PAY_TER_DEL package is an Oracle E-Business Suite database object residing in the APPS schema that supports the Oracle Payroll and Human Resources "Termination" processing framework. Its name follows the standard ETRM naming convention, where the PAY prefix identifies it as a Payroll-family object and the TER segment denotes functionality related to termination (employee separations). The DEL suffix indicates that the package is responsible for delete operations performed against termination-related data structures.

In the 12.1.1 and 12.2.2 releases, the package is documented in the E-Business Suite Technical Reference Manual (ETRM) with a status of VALID and an API classification of OTHER, meaning it is not classified as a public, supported business API. It is best understood as an internal utility used by the termination processing subsystem to maintain referential consistency when termination records and their associated template exclusion rules are removed or re-processed. The package relies on the PAY_TER_SHD shadow (history) structure, which is characteristic of packages that log or archive changes to termination data before deletion.

Key Procedures and Functions

The ETRM documentation lists a single documented program unit within the package body:

  • DEL — The core deletion routine. Based on the naming and the single referenced table, DEL removes termination-related exclusion rule records from the underlying data structures. It is the only exposed entry point documented in the metadata.

No parameter lists are published in the ETRM metadata, and no other procedures or functions are documented. The package body also contains the package-level declarations and initialization section shown as [Package] and [Package Body] in the dependency listing, but these are structural rather than callable business logic.

Tables Accessed

The documented table reference for this package is:

  • PAY_TEMPLATE_EXCLUSION_RULES — accessed via an APPS synonym. This table stores the rules that determine which payroll/template elements are excluded from processing for a given population, assignment, or termination scenario. PAY_TER_DEL reads and deletes rows from this table as part of cleaning up termination-driven exclusions.
  • PAY_TER_SHD — referenced as a dependency. The shadow table operates as a history/audit counterpart, capturing the pre-deletion state of termination data to support auditing and potential recovery.

The SYS.STANDARD dependency confirms the package is compiled as a standard PL/SQL unit with no specialized Oracle-supplied package dependencies. No other application tables are documented.

Usage Notes

The ETRM records that APPS.PAY_TER_DEL is referenced by no other documented database packages and is itself referenced only within its own dependency tree. This indicates it is invoked directly rather than being called from a broader public API. In practice, packages of this type are typically executed from:

  • Oracle Forms events within the Termination or Template Exclusion Rules windows, where a user action triggers deletion of exclusion rule rows;
  • Concurrent programs that purge or reconcile termination data; and
  • Custom or upgrade/patched code performing controlled cleanup of the PAY_TEMPLATE_EXCLUSION_RULES table.

Because the API classification is OTHER rather than PUBLIC, customers and integrators should treat the DEL routine as an internal implementation detail. It should be invoked only through the supported form or concurrent interface, or by code that explicitly mirrors the package's own deletion and shadow-logging sequence. Direct calls run the risk of bypassing the shadow-table audit trail or violating the deletion order the package enforces. As with any APPS-schema object in 12.1.1 and 12.2.2, the package must be recompiled and validated after patching or upgrade to remain VALID.