Search Results boolean_to_varchar2




Overview
Explore in AI Chat

Overview

ARP_TRX_UTIL is a utility package owned by the APPS schema in Oracle E-Business Suite Receivables (AR). It is classified in the ETRM metadata as a UTIL module, indicating that it supplies low-level helper logic rather than a business-facing API. Its role is to centralize common operations performed against transactions in the RA_CUSTOMER_TRX family of tables, together with the supporting validation and concurrency routines that the broader AutoInvoice, transaction processing, and tax integration code paths require.

The package depends directly on RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES at the schema level, confirming that its primary domain is the customer transaction header and its transaction type definition. At 12.2.2 it exposes eleven documented procedures and functions, and is referenced by twenty-two other APPS packages, which underlines its position as shared infrastructure for the Receivables transaction stack.

Key Procedures and Functions

The documented entry points in ARP_TRX_UTIL are:

  • DELETE_TRANSACTION — Removes a customer transaction, providing a controlled deletion path used by processing and correction logic.
  • LOCK_TRANSACTION — Acquires a lock on a transaction record before modification, supporting concurrency control in multi-user processing.
  • SET_TERM_IN_USE_FLAG — Maintains the in-use indicator associated with payment terms so that terms referenced by transactions are not removed or changed improperly.
  • SET_POSTED_FLAG — Sets the posted indicator on a transaction, reflecting accounting posting status.
  • BOOLEAN_TO_VARCHAR2 — Converts a PL/SQL BOOLEAN to its character representation, a common need when interfacing with SQL or external callers that cannot handle BOOLEAN.
  • DETECT_FREIGHT_ONLY_RULES_CASE — Identifies the freight-only rules scenario, supporting line and freight processing decisions.
  • TRANSACTION_BALANCES — Derives balance information for a transaction.
  • GET_SUMMARY_TRX_BALANCES — Returns summarized transaction balance figures for reporting and processing use.
  • IS_FV_ENABLED — Determines whether the relevant feature or validation option is enabled, allowing callers to branch conditionally.
  • IS_CCR_SUPPLIER — Determines whether a supplier qualifies under the CCR (Central Contractor Registration) criteria, supporting tax and supplier-related checks.
  • INIT — Initialization routine that prepares package-level state or cached values for subsequent calls.

Tables Accessed

The package reads and writes the customer transaction header (RA_CUSTOMER_TRX) and its type definition (RA_CUST_TRX_TYPES). Transaction lines, line distributions, and the header GL distributions are accessed through RA_CUSTOMER_TRX_LINES and RA_CUST_TRX_LINE_GL_DIST, supporting balance derivation and distribution-related processing. Payment terms are referenced via RA_TERMS_B, consistent with SET_TERM_IN_USE_FLAG. Supplier site information is reached through AP_SUPPLIER_SITES_ALL in support of the CCR supplier check, while FND_CURRENCIES supplies currency attributes used in balance calculations. DUAL is used for scalar evaluation.

Usage Notes

ARP_TRX_UTIL is not an end-user API; it is invoked from within the Receivables PL/SQL layer. Its consumers include ARP_PROCESS_HEADER, ARP_PROCESS_LINE, ARP_PROCESS_CREDIT, ARP_PROCESS_ADJUSTMENT, ARP_PROCESS_DIST, ARP_TRX_VALIDATE, ARP_TRX_COMPLETE_CHK, AR_INVOICE_TABLE_HANDLER, and the tax integration packages ARP_ETAX_SERVICES_PKG, ZX_CORE_REP_EXTRACT_PKG, and ZX_TAXWARE_TAX_SERVICE_PKG. It is also referenced by cache and date utilities such as ARP_CACHE_UTIL and ARP_DATES, and in 12.2.2 it supports credit-card-related processing through IS_CCR_SUPPLIER.

Because the package is internally referenced and not documented as a public API, customizations should avoid direct dependency on it. Standard invocation occurs indirectly through Receivables forms, AutoInvoice, and concurrent transaction processing, where the utility routines are called to lock, delete, flag, and derive balances for transactions as part of normal processing flow.