Search Results arp_process_header_post_commit




Overview
Explore in AI Chat

Overview

ARP_PROCESS_HEADER_POST_COMMIT is an Oracle Receivables (AR) PL/SQL package owned by the APPS schema. It is classified in ETRM as an OTHER API and is defined with AUTHID CURRENT_USER, meaning that its unqualified database references resolve against the privileges of the invoking session rather than against the package owner. The package supplies the post-commit processing logic that executes after a customer transaction header has been committed in the Receivables transaction workbench. Its single substantive procedure, post_commit, is designed to reconcile transaction-level state — completion, open receivables status, creation sign, and overapplication or natural application behavior — once the database commit has made the transaction header persistent. The companion init procedure serves as a package initialization entry point.

Key Procedures and Functions

Two procedures are documented for this package:

  • post_commit — Performs post-commit processing for a customer transaction header. The signature is driven by the transaction context: it accepts the calling form name and form version, the customer transaction identifier (p_customer_trx_id), the previous customer transaction identifier for the prior transaction version, the complete flag, the open receivables flag for the current transaction type, the prior open receivables flag, the creation sign, the overapplication allowance flag, the natural application only flag, an optional cash receipt identifier (defaulting to NULL), and an error mode indicator. Because these inputs map directly to columns of RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES, the procedure resolves transaction type and customer state at runtime and applies the appropriate post-commit actions, including the treatment of overapplication and natural application rules when a receipt is associated.
  • init — Initializes package-level state. No parameters are documented.

Tables Accessed

All tables are referenced through APPS synonyms. The package reads and writes transaction and receipt data across the following objects:

  • RA_CUSTOMER_TRX — the committed transaction header and its complete flag and previous transaction linkage.
  • RA_CUST_TRX_TYPES — behavior flags including accounting affect, creation sign, overapplication, and natural application only.
  • AR_PAYMENT_SCHEDULES / AR_PAYMENT_SCHEDULES_ALL — installment and open receivables balances affected by the transaction.
  • AR_CASH_RECEIPTS — the cash receipt identified by p_cash_receipt_id when the transaction is applied to a receipt.
  • RA_CUST_TRX_LINE_GL_DIST — accounting distributions associated with the transaction.
  • AR_TRX_SUMMARY_HIST — transaction summary history for reporting and reconciliation.
  • AR_SYSTEM_PARAMETERS and FND_CURRENCIES — system-level defaults and currency validation.

Usage Notes

This package is invoked by four other packages in the ETRM repository, indicating it is a supporting component of the Receivables transaction entry flow rather than a top-level API. It is typically called after the transaction workbench form commits a customer transaction, using the form name and version to determine context and the transaction identifier to locate the affected rows. Its ETRM classification as OTHER means it is not a published public interface; custom code should not call it directly unless the calling convention and error mode are fully understood. Developers customizing AR transaction logic should treat post-commit work as a downstream concern and rely on documented public APIs for supported integrations.