Search Results arp_delete_line_cover




Overview
Explore in AI Chat

Overview

ARP_DELETE_LINE_COVER is a PL/SQL package owned by the APPS schema that supports the removal of transaction line detail within Oracle Receivables. Its name reflects its role: it provides the "cover" logic invoked when a user deletes or reverses a line on a customer transaction — an invoice, debit memo, credit memo, chargeback, or on-account credit. In Oracle EBS 12.1.1 and 12.2.2, deleting a transaction line is not a simple DML operation. Each line may carry associated distribution records in the accounting flexfield, tax and freight components, and revenue or receivables account references. Before those records can be removed, they must be validated and unwound in the correct sequence so that the subledger accounting engine and the receivables balances remain consistent.

The package is registered as VALID in the data dictionary and is classified under the general "OTHER" API category rather than as an open public interface. It therefore functions as an internal helper package called by higher-level Receivables transaction maintenance logic, not as a standalone integration point for external applications.

Key Procedures and Functions

The documented package exposes a single program unit:

  • DELETE_LINE_COVER — The routine that encapsulates the deletion of a transaction line and its associated accounting distributions. It acts as the controlled entry point through which the calling transaction form or concurrent process removes line-level records. Its purpose is to ensure that the dependent distribution and transaction line rows are handled in the appropriate order, and that any validation required before deletion is performed. The package name itself — "delete line cover" — indicates that this procedure provides a protective wrapper around the underlying delete operations.

No additional procedures or functions are documented in the package specification, confirming its narrow, single-purpose design.

h4>Tables Accessed

The documented dependency list identifies the tables this package reads and writes, all referenced through APPS synonyms:

  • RA_CUSTOMER_TRX — The transaction header table. The package reads the parent transaction to identify the context of the line being deleted and to keep header-level totals consistent.
  • RA_CUSTOMER_TRX_LINES — The line-level table that stores each transaction line. This is the primary target of the delete operation.
  • RA_CUST_TRX_LINE_GL_DIST — The distribution table holding the accounting flexfield assignments for each line. Because distributions must be removed or adjusted in step with the line, this package processes these rows as part of the delete cover.
  • AR_SYSTEM_PARAMETERS — The Receivables system options table, read to determine setup-dependent behavior, such as accounting and currency handling rules.
  • FND_CURRENCIES — The Oracle Application Object Library currency definition table, consulted to interpret the currency of the transaction being modified.

Usage Notes

ARP_DELETE_LINE_COVER is invoked by Oracle Receivables' own transaction maintenance logic rather than called directly by customer code. The documented reference list shows no other packages depending on it, which indicates that the caller is a form or concurrent program in the Receivables module rather than a shared PL/SQL dependency. In typical use, a user deletes a line through the Transactions form; the form triggers the deletion routine, which delegates the line and distribution removal to DELETE_LINE_COVER. Because the package is not published as a public API, customizations should avoid calling it directly. Integrations that need to remove transaction lines should instead use the supported Receivables APIs, allowing this package to operate only within the sanctioned internal flow where transaction, line, and distribution data remain synchronized.