Search Results ar_view_term_grp




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.AR_VIEW_TERM_GRP is a Receivables (AR) utility package that supports the viewing and interpretation of payment term definitions in Oracle E-Business Suite. Its name and the dependent objects it references indicate that it consolidates payment term header and line data (from RA_TERMS and RA_TERMS_LINES) together with functional currency information to present or derive terminal amount calculations for a given payment term. In Release 12.1.1 and 12.2.2 alike, the package is classified as a "GRP" (group) type API under the APPS schema, meaning it is an internal supporting layer rather than an externally published business API. It carries a VALID status in the ETRM metadata, confirming that it compiles cleanly against the standard AR data model and the Oracle Financials common components (FND_API, FND_MSG_PUB, FND_MESSAGE, FND_PROFILE, and FND_CURRENCIES) that it depends upon.

The package is not referenced by any database object according to the metadata, which means it is invoked directly from application code or online forms rather than being called indirectly through another stored program. It is, however, referenced by four other packages, indicating it forms part of a small internal reuse cluster within the Receivables module.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within this package body:

  • PAY_NOW_AMOUNTS — The substantive procedure exposed by the package. Consistent with its name and the package's dependency on ARPCURR, FND_CURRENCIES, and ARP_UTIL, this procedure derives "pay now" discount or immediate-payment amount information for a specified payment term. It resolves the term's line-level rules, applies the appropriate currency conversion or rounding conventions, and returns the resulting amount figures to the calling layer. Because the metadata classifies the package as GRP rather than a public API, its parameter interface is intended for internal Receivables use and is not documented as a supported integration point.

No additional public procedures or functions are enumerated for this package body in the supplied metadata. Any further internal helper routines are not part of the documented interface.

Tables Accessed

The package reads and processes data from the following tables, exposed to the APPS schema through synonyms where applicable:

  • RA_TERMS — The Receivables payment terms header table. The package accesses this to retrieve the term definition, including discount and due-date rules, that underlies the "pay now" calculation.
  • RA_TERMS_LINES — The payment terms line table. Each term can have multiple lines defining discount percentages, day ranges, and installment schedules; the package reads these lines to determine the effective discount window and amount.
  • FND_CURRENCIES — The Oracle Financials currency definition table. It supplies currency precision, minimum accountable unit, and related attributes used to correctly format and round the computed amounts.
  • PLITBLM — The Oracle standard PL/SQL table type used internally for in-memory collections and bulk processing within the package.

In addition, the package references the ARPCURR and ARP_UTIL utility units, which encapsulate currency conversion and general Receivables helper logic, ensuring consistent monetary handling across the module.

Usage Notes

AR_VIEW_TERM_GRP is an internal Receivables component and is not intended for direct customer-facing integration. In practice it is invoked from the Receivables transaction and payment term setup forms, and from other PL/SQL packages within the AR module that must resolve the immediate-payment discount for a term at runtime. The four packages that reference it confirm this role as a shared calculation helper.

Custom code should avoid calling PAY_NOW_AMOUNTS directly, since the GRP classification signals an unsupported, potentially version-sensitive interface that Oracle may change without notice. Where an external requirement exists to derive payment term amounts, the supported approach is to use the published Receivables APIs or to replicate the term interpretation logic in custom code. The package relies on FND_MSG_PUB and FND_MESSAGE for error and message handling, and on FND_PROFILE to retrieve the runtime operating context, so callers operating outside a standard EBS session must ensure these dependencies are properly initialized.