Search Results delete_transaction

Overview

ARP_PROCESS_BR_HEADER is a public PL/SQL package body in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema and classified under ETRM as an "OTHER" API. Its purpose is to serve as the entity handler for Bills Receivable header transactions, encapsulating the header-level database operations that surround the creation, maintenance, and removal of a bills receivable transaction record in the RA_CUSTOMER_TRX table. As indicated by the inline documentation, the package deliberately performs no validation or defaulting of its own; all business validation and attribute defaulting are delegated to the higher-level Bills Receivable API (the BR API). This layered design keeps the entity handler focused strictly on persistence mechanics — inserting, updating, and deleting header rows and their related accounting distributions — while the calling API layer governs transaction rules. The package is documented in both Oracle EBS 12.1.1 and 12.2.2, and its header comment references version 120.4 of the source file ARTEBRHB.pls.

Key Procedures and Functions

The documented public surface of the package consists of five procedures: INSERT_HEADER, UPDATE_HEADER, DELETE_HEADER, LOCK_TRANSACTION, and MOVE_DEFERRED_TAX. Two private helper declarations, delete_transaction and delete_transaction_dist, are also visible in the source excerpt. The most relevant to the user's search term, "delete_transaction," is a private procedure declared within the package body; it accepts a customer transaction identifier and is referenced in the package's debug logging. Its companion, delete_transaction_dist, handles removal of the associated distribution records. DELETE_HEADER is the documented public entry point for removing a Bills Receivable header transaction.

• INSERT_HEADER — Inserts a new Bills Receivable transaction header into RA_CUSTOMER_TRX. It accepts a RA_CUSTOMER_TRX row type, a GL date, and returns the generated transaction number and customer_trx_id.
• UPDATE_HEADER — Persists modifications to an existing Bills Receivable header record.
• DELETE_HEADER — Removes a Bills Receivable header transaction and its dependent rows.
• LOCK_TRANSACTION — Acquires a row-level lock on the transaction, providing concurrency control during processing.
• MOVE_DEFERRED_TAX — Relocates deferred tax amounts associated with the transaction, supporting tax accounting flows.

Tables Accessed

The package reads and writes five documented tables through APPS synonyms. RA_CUSTOMER_TRX is the primary target, holding the Bills Receivable header. AR_TRANSACTION_HISTORY records transaction lifecycle audit events; the INSERT_HEADER logic populates an AR_TRANSACTION_HISTORY row. RA_CUSTOMER_TRX_LINES and RA_CUST_TRX_LINE_GL_DIST store the transaction lines and their General Ledger distributions, which are maintained and removed in step with the header. DUAL is used for single-row SQL operations and lookups. The private delete_transaction and delete_transaction_dist procedures are the mechanisms through which header and distribution rows are purged.

Usage Notes

ARP_PROCESS_BR_HEADER is not intended for direct invocation by end users. It functions as a subordinate entity handler invoked by the Bills Receivable API during transaction processing and is referenced by six other packages within the APPS schema. Typical call paths originate from Bills Receivable forms, the Receivables transaction workbench, and concurrent programs that create, adjust, or cancel bills receivable. Custom extensions should call the public BR API rather than this package, since the BR API performs the validation and defaulting that this entity handler explicitly omits, and because direct calls bypass the business rules enforced one layer above.