Search Results pay_ptt_del




Overview
Explore in AI Chat

Overview

PAY_PTT_DEL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its name follows the Oracle HRMS/Payroll naming convention in which the PTT component denotes "Payroll Translation Table" and the DEL suffix denotes deletion. The package therefore forms part of the multilingual (translation) maintenance layer of Oracle Payroll, specifically the subsystem that manages the translated description columns of user-defined payroll tables. In EBS 12.1.1 and 12.2.2 the object is shipped in VALID status and is classified under the generic API category (OTHER) in the ETRM repository.

The package exists to remove translation rows that are no longer required, keeping the translation tables synchronised with their base (non-translated) definitions. Because Oracle Payroll enables customers to define their own user tables and associated columns, translation maintenance cannot be handled entirely by seeded code; a dedicated deletion routine such as PAY_PTT_DEL is required to purge orphaned or superseded translation records.

Key Procedures and Functions

The ETRM metadata documents a single entry point:

  • DEL_TL — The only recorded procedure or function in the package. Its name indicates a delete operation against translated (_TL) data. Its purpose is to remove translation rows for payroll user table definitions, taking the identifying key of the parent entity and deleting the corresponding language-specific records. Because the object is published as a package with a separate package body, the procedure is callable directly from PL/SQL, but it is intended for internal use by the translation-maintenance flow rather than as a public, supported API.

No additional procedures or functions are recorded, and the documented parameter list is intentionally omitted; callers should rely on the declaration in the shipped package specification rather than on assumed signatures.

Tables Accessed

The only table recorded in the metadata is PAY_USER_TABLES_TL, accessed through its APPS synonym. This is the translation table that stores the language-specific descriptive attributes of payroll user tables defined by the customer. DEL_TL operates against this table to delete the rows belonging to a given user table definition, ensuring that the translation table does not retain entries whose parent definition has been removed or redefined.

The dependency listing shows only SYS.STANDARD in addition to the table reference, confirming that the package has a narrow footprint and does not itself reach into other application data structures.

Usage Notes

PAY_PTT_DEL is not designed to be invoked directly by end users. Its callers are other components of the payroll user-table translation stack:

  • PAY_PUT_MNT_TL_ARD — the routine that maintains translated records, which calls the deletion procedure when translation data must be purged.
  • PAY_USER_TABLES_PKG and PAY_USER_TABLE_API — the packages that expose user-table definition and maintenance operations and that drive translation cleanup as part of their processing.

These three dependent packages constitute the standard invocation path. Custom code should not call DEL_TL in isolation, because deleting translation rows outside the enclosing maintenance transaction can leave the base definition and its translations inconsistent; the supported entry points are the user table API and package routines listed above. In a 12.1.1 or 12.2.2 environment the package is applied and patched with the standard multilingual (NLS) translation objects, and its validity should be verified after any patch that touches the payroll user table definitions. Diagnosing errors typically involves checking for locked or referenced translation rows in PAY_USER_TABLES_TL before the delete is attempted.