Search Results move_deferred_tax




Overview
Explore in AI Chat

Overview

ARP_PROCESS_BR_HEADER is an Oracle Receivables (AR) internal PL/SQL package owned by the APPS schema. It encapsulates the low-level database maintenance logic for customer transaction header records stored in RA_CUSTOMER_TRX. The package wraps the insert, update, delete, and locking operations that surround the transaction header, and it also provides a targeted routine for relocating deferred tax amounts associated with an existing transaction. Because it is declared AUTHID CURRENT_USER, it executes with the privileges of the calling schema—typically APPS—rather than the definer, which is consistent with Oracle E-Business Suite conventions for internal APIs that are invoked from within the application stack rather than directly by end users.

The package is classified in ETRM as OTHER, meaning Oracle does not publicly document it as a supported public API. It is a supporting module used by higher-level Receivables transaction processing flows, including AutoInvoice and the Receivables transaction workbench, where a transaction header must be persisted and then reconciled against its lines and accounting distributions.

Key Procedures and Functions

The package exposes five documented procedures, all of which are internal to the transaction header lifecycle:

  • insert_header — Creates a new customer transaction header record, deriving the transaction number and customer transaction identifier for the newly created row.
  • update_header — Applies changes to an existing transaction header identified by its customer transaction identifier.
  • delete_header — Removes a transaction header row based on the supplied customer transaction identifier.
  • lock_transaction — Acquires a lock on the specified transaction to serialize concurrent modification and prevent lost updates during multi-step processing.
  • move_deferred_tax — Evaluates a given transaction and determines whether deferred tax amounts require relocation; it returns a boolean flag indicating whether the move is required.

Because move_deferred_tax returns an OUT boolean rather than performing an unconditional action, it functions as a decision or eligibility check within a larger tax-adjustment process, rather than a standalone side-effecting operation.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • RA_CUSTOMER_TRX — The primary transaction header table; target of the insert, update, delete, lock, and deferred-tax logic.
  • RA_CUSTOMER_TRX_LINES — Transaction lines that must remain consistent with header-level changes, particularly during deletion and tax relocation.
  • RA_CUST_TRX_LINE_GL_DIST — The accounting distributions generated for transaction lines, which are affected when deferred tax amounts are moved.
  • AR_TRANSACTION_HISTORY — Audit trail capturing changes to the transaction for history and reporting purposes.
  • DUAL — Used for singleton queries and simple validation checks.

Usage Notes

ARP_PROCESS_BR_HEADER is not intended for direct invocation by end users or external integrations. It is called by Receivables forms, by concurrent programs such as AutoInvoice, and by other internal packages—ETRM records six dependent packages that reference it. Custom code should avoid calling it directly because Oracle does not guarantee its signature across releases; the same behavior is available through supported Receivables APIs. When it is invoked, it should be treated as a low-level primitive that assumes the caller has already validated the transaction and is running within the appropriate transaction-processing context.