Search Results ar_cm_app_lib_pvt




Overview
Explore in AI Chat

Overview

AR_CM_APP_LIB_PVT is a private PL/SQL library package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its header identifies it as AUTHID CURRENT_USER, meaning execution privileges are resolved against the invoking schema rather than the package owner. The package name embeds the abbreviation "CM," denoting cash management, and "APP_LIB," denoting an application library, indicating that it supplies shared defaulting and derivation logic used by the Receivables cash application flow.

The package provides the internal plumbing that populates and validates the key identifiers and accounting attributes required when a receipt is applied against a transaction. Rather than exposing a single public business API, it centralizes low-level defaulting routines that higher-level cash application logic calls repeatedly. Its $Header comment (ARXCMALS.pls 120.1, dated July 2005) and the removal of GSCC NOCOPY warnings under Bug 4462243 confirm that this is a long-standing internal component rather than a customer-facing interface.

Key Procedures and Functions

Four documented procedures constitute the package interface, all of which are private and intended for internal consumption by dependent code.

  • DEFAULT_CUSTOMER_TRX_ID — Resolves and returns a customer transaction identifier. It accepts a transaction number as input and returns the corresponding transaction ID along with a return status, allowing callers to default the transaction key when only the human-readable number is known.
  • DEFAULT_ACTIVITY_INFO — Populates the core activity attributes for a cash application: payment schedule ID, cash management currency code, GL date, unapplied amount, receipt method, transaction date, amount applied, apply date, and apply GL date. These outputs supply defaults for the application record before it is written.
  • DERIVE_ACTIVITY_UNAPP_IDS — Derives the identifiers required to reconcile an activity with its unapplied receipt, taking a transaction number and returning the customer transaction ID, the receivable application ID, and the apply GL date.
  • DEFAULT_UNAPP_ACTIVITY_INFO — Defaults the attributes for applying an unapplied receipt to a transaction. Given the receivable application ID, apply GL date, and customer transaction ID, it returns the reversal GL date, cash management GL date, payment schedule ID, and unapplied amount.

Tables Accessed

The package reads and writes three Receivables tables through APPS synonyms:

  • AR_PAYMENT_SCHEDULES — Supplies installment and payment schedule information, including the payment schedule ID and unapplied amounts returned by the defaulting routines.
  • AR_RECEIVABLE_APPLICATIONS — The application records linking receipts to transactions; the package derives and returns receivable application IDs and the associated GL dates.
  • RA_CUSTOMER_TRX — The transaction header table used to resolve transaction numbers to customer transaction IDs and to obtain transaction dates.

Usage Notes

As a PVT-classified package, AR_CM_APP_LIB_PVT is not a documented public API and should not be invoked directly by customer extensions. It is called from the Receivables cash application forms and from other Receivables packages; ETRM records one dependent package. The presence of the user-specific path fragment "C:\Users\sreedhar\vca_app\lib" in the originating search reflects a local development or version-control working directory and is not relevant to runtime behavior. Customizations should target the supported public APIs of Receivables rather than this internal library, since its private interface is subject to change without notice.