Search Results pay_now_amounts

Overview

APPS.AR_VIEW_TERM_GRP is a group-type (GRP) PL/SQL package in the Oracle E-Business Suite Receivables (AR) schema. Its business purpose is to expose payment-term and installment information held in the Receivables terms tables (RA_TERMS, RA_TERMS_LINES) in a form suitable for downstream consumption by other application modules. In practice, the package acts as a shared query/business-logic layer that converts stored payment-term definitions — including installment lines, due-date offsets, and currency attributes — into usable amount and scheduling data for calling programs.

The "GRP" classification indicates the package is a grouping container for related program units rather than a public API with a formal error-handling or message contract. It is not registered as a published interface such as an FND_API-based PL/SQL API; instead it is an internal package intended to be invoked by other EBS packages that need to interpret payment terms. The package is VALID in the documented environment, confirming it is compiled and available.

Key Procedures and Functions

The documented metadata identifies a single program unit within the package:

• PAY_NOW_AMOUNTS — Derives the "pay now" amount components associated with a payment term. This is used where a term requires an immediate or near-immediate payment (for example, a deposit or prepayment term), and the caller must determine the amount due at the outset rather than at a later installment date. The procedure/function resolves the term definition into the relevant monetary figure so that order, quote, or payment-verification logic can apply it.

The package contains package specification and package body sections along with internal SQL statements; the ETRM extract documents only PAY_NOW_AMOUNTS as a named, exposed unit. Parameter lists are not reproduced in the source metadata and are therefore not specified here.

Tables Accessed

The package reads and references the following objects (through APPS synonyms):

• RA_TERMS — Header-level payment term definitions, including term name, base amount, and type. This is the primary source of term identity and classification.
• RA_TERMS_LINES — The installment lines belonging to each term, providing the scheduling detail (number of installments, percentages, and due-date rules) that the package interprets when computing amounts.
• FND_CURRENCIES — Currency attributes, consulted to resolve precision, minimum accountable unit, and currency-specific handling when amounts are derived.
• PLITBLM — A generic index-by table (PL/SQL table) structure used as an in-memory collection type; it appears in the reference list as a supporting type rather than as a database table.

Additionally, the package references FND_API (the standard EBS API utility package) and STANDARD, consistent with EBS coding conventions for API support and standard utilities.

Usage Notes

AR_VIEW_TERM_GRP is an internal dependency rather than a user-facing entry point. It is not invoked directly from a Receivables form or concurrent program; instead it is called by other packages that need payment-term interpretation. The documented referencers are:

• OE_PREPAYMENT_PVT — Order Management prepayment processing, which must determine amounts payable up front against a term. This is the object the user searched for and is the primary consumer of the package's PAY_NOW_AMOUNTS logic.
• OE_TOTALS_GRP — Order totals computation, which needs term-derived amounts to calculate order values.
• OE_VERIFY_PAYMENT_PUB — Payment verification, which validates that payment received matches the term obligation.
• ASO_QUOTE_HEADERS_PVT — Quoting, which applies payment terms to quote headers and must resolve the payable amount.

Custom code should not call AR_VIEW_TERM_GRP directly, since it belongs to the AR schema and follows no documented public contract. Extensions requiring payment-term logic should instead use supported AR APIs or replicate the term interpretation through RA_TERMS and RA_TERMS_LINES queries within their own schema. When troubleshooting Order Management prepayment or payment-verification issues in 12.1.1 or 12.2.2, this package is a relevant dependency in the call stack and should be reviewed for compilation validity after any patching of the AR or ONT modules.