Search Results del_tl

Overview

AME_AYL_DEL is a PL/SQL package in the Oracle E-Business Suite Application Object Library schema (APPS) that belongs to the Approvals Management Engine (AME) product family. Its name follows the AME-generated table handler naming convention, where the _DEL suffix denotes a delete handler. The package provides the canonical deletion interface for the translated (language-dependent) table associated with AME action types. In Oracle EBS globalization architecture, business entities are split across a non-translated base table and a "_TL" translation table that stores the language-specific display text for each row. AME_AYL_DEL encapsulates the logic required to remove those translation rows cleanly while preserving the integrity contract expected by the AME data model.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the definer. This is consistent with an internal handler intended to be driven from a trusted AME or Oracle Forms context in which the caller already holds the necessary DML privileges on the underlying tables.

Key Procedures and Functions

The documented interface consists of a single procedure, DEL_TL, which is described in the package header as the main interface for deleting rows in the translated table.

• DEL_TL — Deletes all translation rows corresponding to a specified identifier value. The procedure removes the complete set of language translations belonging to one logical entity instance rather than a single language row, so a call cleans up every translated record that maps to the supplied ID. It operates on the assumption that the unique surrogate key already exists in the non-translated table and that the corresponding base row has been successfully locked by the caller. On success, all validation has passed and the translation rows are deleted from the _TL table, but no changes are committed; transaction control remains with the caller. On failure, a PL/SQL exception is raised. Per the header comments, the procedure is marked for internal development use only.

Tables Accessed

The only documented table reference is AME_ACTION_TYPES_TL, accessed through an APPS synonym. This is the translation table for AME action types, holding the language-specific name and description text displayed on AME setup forms and approval configuration pages. DEL_TL writes to this table by removing rows; it does not read the base AME_ACTION_TYPES table itself, relying instead on the caller's prior validation and locking of the non-translated parent row.

Usage Notes

AME_AYL_DEL is generated-code infrastructure rather than a public application programming interface. It is typically invoked indirectly, when an AME action type is deleted through the standard AME setup forms or through the corresponding AME maintenance logic, which in turn calls the translation delete handler for each affected record. Because the package performs no commit, any caller must manage the transaction boundary and decide whether to commit or roll back the deletion of the translation rows together with the base-table delete.

Custom code should not call DEL_TL directly unless it faithfully reproduces the documented pre-requisites: the parent row must exist, must be locked, and the transaction must be controlled by the caller. The "Internal Development Use Only" access status indicates that Oracle does not support its use as an extension point, and direct calls may be incompatible with future releases. The absence of documented external callers in the metadata reinforces that this package is a component of the AME table handler layer, invoked as part of Oracle's internal delete processing for translated AME entities.