Search Results arp_tbat_pkg




Overview
Explore in AI Chat

Overview

ARP_TBAT_PKG is an internal Oracle Receivables package body owned by the APPS schema and documented with an API classification of OTHER within ETRM. Its naming and dependency graph identify it as a table-handler (TBAT) package responsible for managing the batch records that underpin Receivables automatic receipt processing and transactional batch entry. The package encapsulates the standard CRUD, locking, and display operations required to maintain rows in the RA_BATCHES table and their associated batch source definitions in RA_BATCH_SOURCES. Because it maintains the surrogate key sequence RA_BATCHES_S in coordination with DML on RA_BATCHES, ARP_TBAT_PKG effectively shields callers from the mechanics of batch identity generation and concurrency control. In Oracle EBS 12.1.1 and 12.2.2, this package operates as a supporting infrastructure component rather than a public extension API; it is invoked internally by Receivables forms and by other APPS code, and the ETRM record confirms that it is not referenced by any external database object, while it itself references three other packages.

Key Procedures and Functions

The documented interface comprises thirteen procedures and functions. INSERT_P performs insertion of new batch rows, including sequence-based key derivation. FETCH_P, UPDATE_P, and DELETE_P provide the conventional fetch, modify, and remove operations against an identified batch. The paired UPDATE_F_BS_ID and DELETE_F_BS_ID variants operate specifically against rows associated with a batch source identifier, supporting maintenance of batches tied to a particular source definition. LOCK_P obtains a row-level lock on a specified batch, while LOCK_FETCH_P combines locking with retrieval. LOCK_COMPARE_P and LOCK_COMPARE_COVER provide lock-and-verify semantics that compare retrieved values against expected values, with the COVER variant extending the comparison to additional columns. SET_TO_DUMMY initializes a record or field set to placeholder values, a common initialization idiom in EBS table handlers. DISPLAY_BATCH and DISPLAY_BATCH_REC render batch data, with the REC variant operating on an in-memory record structure.

Tables Accessed

Per the documented dependency list, the package reads and writes RA_BATCHES, the core batch table, and RA_BATCHES_S, the sequence supplying batch primary keys. RA_BATCH_SOURCES is consulted for the source definition used by the _F_BS_ID procedures. AR_SYSTEM_PARAMETERS supplies Receivables system-level configuration that governs batch behavior, and RA_CUSTOMER_TRX provides transaction context. DBMS_SQL indicates dynamic SQL execution, and DUAL supports scalar expression evaluation. Supporting packages referenced include ARP_GLOBAL, ARP_STANDARD, ARP_UTIL, FND_GLOBAL, FND_MESSAGE, APP_EXCEPTION, and GL_CA_UTILITY_PKG, which provide the multi-org context, error propagation, message retrieval, and standardization conventions applied throughout the handler.

Usage Notes

ARP_TBAT_PKG is typically invoked from the Receivables user interface and from internal APPS routines rather than from customer-extensible entry points. Because it is not referenced by any database object, direct dependency on it is limited to the EBS codebase itself and to custom extensions that mimic that internal usage. A developer searching on the term "ra_batches_s" most likely encountered this package while investigating how batch identifiers are generated. That sequence is consumed by INSERT_P and its related operations, so any custom code inserting batches directly must also advance RA_BATCHES_S to avoid collisions. When extending or troubleshooting batch behavior, the documented _F_BS_ID, LOCK_COMPARE, and DISPLAY procedures are the correct reference points; because parameter signatures are not exposed in the metadata, calling syntax must be verified against the package specification in the target environment.