Results for “get_commitment_adjustments”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.ARP_PROCESS_CREDIT_UTIL is a utility API package within the Oracle Receivables (AR) module of Oracle E-Business Suite. Its header revision (ARTECMUS.pls 120.4, dated 2008/07/24) indicates it is an established 11i-era component carried forward into Release 12.1.1 and 12.2.2. The package encapsulates the business logic required to evaluate credit transactions — credit memos, commitments, and their relationship to originating transactions — and to validate the defaults and banking attributes applied when such transactions are processed. It is classified in the ETRM metadata as a UTIL (utility) API, meaning it is an internal helper package rather than a public, customer-facing API with a formally supported interface. In practice, it supplies computational and validation services to higher-level Receivables processes, notably credit memo application, commitment adjustment, and receipt-related validation during transaction entry.
Key Procedures and Functions
The package exposes nine documented procedures and functions. The credit-computation group centers on determining amounts associated with commitment and credit transactions:
GET_COMMITMENT_ADJUSTMENTS— a function returning a numeric result representing the adjustment applicable to a commitment transaction relative to its originating transaction.GET_COMMITMENT_ADJ_DETAIL— returns the component breakdown of a commitment adjustment, including the amount, line amount, tax amount, and freight amount.GET_CREDITED_TRX_DETAILS— returns the original and remaining balances of a credited transaction, broken out into line, tax, freight, and total amounts, together with line and installment counts and a flag indicating whether payment already exists.GET_CREDIT_MEMO_AMOUNTS— returns the line, tax, and freight amounts for a credit memo along with the associated line counts.
A second group provides header defaults and validation logic invoked during credit memo and receipt processing: GET_CM_HEADER_DEFAULTS derives default header attribute values; CHECK_PAYMENT_METHOD validates a payment method; CHECK_BANK_ACCOUNT validates a bank account; and CHECK_CM_TRXTYPE validates the credit memo transaction type — the specific routine matching the user's search term. Finally, INIT performs package-level initialization. No parameter lists are reproduced here; only documented purposes are stated.
Tables Accessed
The package reads from a defined set of Receivables and shared reference tables, accessed through APPS synonyms. Transaction data is sourced from RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES, RA_CUST_TRX_LINE_GL_DIST, RA_BATCHES, RA_BATCH_SOURCES, and AR_ADJUSTMENTS. Receipt and banking validation relies on AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, and CE_BANK_ACCOUNTS. Customer and currency context is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_SITE_USES, and FND_CURRENCIES, while system-level defaults and options come from AR_SYSTEM_PARAMETERS. The metadata classifies these as read-oriented lookups supporting the package's computational and validation routines.
Usage Notes
As a UTIL-classified package, ARP_PROCESS_CREDIT_UTIL is not intended for direct customer invocation. It is referenced by three other packages, which call its routines to obtain credit amounts, header defaults, and validation results during Receivables transaction processing. Typical invocation occurs behind the Credit Transactions and Transactions windows, and within concurrent programs that apply or adjust credit memos and commitments. In 12.1.1 and 12.2.2, the package follows the standard EBS server-side execution model, and because of its internal classification, its interface may change without prior notice. Custom code should avoid direct dependency on this package and instead use supported public Receivables APIs. The CHECK_CM_TRXTYPE routine is the relevant entry point for validating a credit memo transaction type within these flows.