Search Results pay_btl_del




Overview
Explore in AI Chat

Overview

PAY_BTL_DEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the OTHER API category within the ETRM repository for releases 12.1.1 and 12.2.2. Its name follows the Oracle Payroll naming convention in which the BTL segment denotes batch element entry (BEE) processing utilities, and the DEL suffix identifies the package as a deletion handler for batch lines. The package therefore serves a narrow but essential maintenance role: it removes batch line records associated with batch element entry processing, providing a controlled programmatic path for purging payroll batch data rather than relying on direct DML against the underlying base table.

The package is part of the batch element entry subsystem, which allows large volumes of element entries to be loaded, validated, and transferred into payroll runs through the Batch Element Entry window and related concurrent programs. When batch lines are rejected, superseded, or no longer required, they must be removed cleanly so that validation reports and transfer processes operate against a consistent set of data. PAY_BTL_DEL provides that deletion service.

Key Procedures and Functions

The documented package exposes a single program unit: the procedure DEL. Consistent with Oracle's practice of publishing only the entry points intended for external consumption, the package specification contains the declaration while the package body holds the implementation logic. The DEL procedure is responsible for deleting batch line records from the batch element entry tables in accordance with the parameters supplied by the caller.

  • DEL — Deletes batch line data. This is the sole documented procedure and forms the public interface of the package.

No additional functions or private helper routines are published in the ETRM metadata. Because the package body is not exposed in the documented content, the precise parameter list and internal control flow are not reproduced here; consumers should inspect the package specification in the database before invoking DEL directly.

Tables Accessed

The documented table reference for PAY_BTL_DEL is PAY_BATCH_LINES, accessed through an APPS synonym. PAY_BATCH_LINES stores the individual element entry lines belonging to a batch, including the assignment, element type, input values, and processing status for each row. The DEL procedure operates against this table to remove unwanted rows. A dependency listing also records that PAY_BTL_DEL references PAY_BTL_SHD, the corresponding shadow (audit/history) package used within the batch element entry infrastructure. No insert or update targets are documented, which is consistent with the package's purely deletion-oriented purpose.

Usage Notes

PAY_BTL_DEL is referenced by the package PAY_BATCH_ELEMENT_ENTRY_API, indicating that it is invoked internally by the batch element entry API layer when a caller requests deletion of batch lines. This is the primary supported invocation path: applications and custom code should call the higher-level batch element entry API rather than PAY_BTL_DEL directly, so that any necessary validation and auditing handled by that layer is preserved. The package also appears in its own dependency list, reflecting internal self-reference within the package body.

Typical consumers include the Batch Element Entry forms and any custom concurrent programs or PL/SQL routines that create and subsequently clean up batch lines. Because deletion is destructive and bypasses the standard validation sequence, it should be reserved for rows that have not been transferred to a payroll run. Direct invocation should be limited to controlled maintenance scripts executed by a privileged user, with appropriate testing and backup of the affected batch data beforehand.