Search Results get_term_default

Overview

ARP_TRX_DEFAULTS_3 is a PL/SQL package in the APPS schema that centralizes the derivation of default values used during Oracle Receivables transaction entry and processing. Its primary responsibility is to resolve defaults for remit-to addresses, payment methods, bank accounts, payment instruments, and payment terms based on the customer, customer site, transaction type, currency, and system parameters in effect at the time a transaction or receipt is created.

The package is classified as OTHER in the ETRM 12.2.2 metadata, indicating that it is not a published public API but rather an internal utility package. It is one component of the ARP_TRX_DEFAULTS family, alongside the parent package APPS.ARP_TRX_DEFAULTS, which invokes routines in this unit. The package is validated and valid in the APPS schema and is present in both Oracle EBS 12.1.1 and 12.2.2.

By consolidating this logic, ARP_TRX_DEFAULTS_3 ensures that defaulting rules — such as the remit-to address or the payment method — are applied consistently across the Receivables forms, AutoInvoice, and the various internal processing engines that create or validate transactions and receipts. The package exposes fifteen documented procedures and functions in total.

Key Procedures and Functions

The documented entry points address the principal defaulting decisions in Receivables:

• INIT — Initializes package state, typically establishing session-level context such as the current operating unit or system parameters before other routines are invoked.
• GET_DEFAULT_REMIT_TO — Returns the default remit-to address for a transaction, drawing on customer account and site information.
• GET_REMIT_TO_ADDRESS — Resolves and formats the remit-to address associated with the selected remit-to identifier.
• GET_REMIT_TO_DEFAULT — Determines the default remit-to value where a specific remit-to has not been supplied.
• GET_PAYMENT_METHOD_DEFAULT — Derives the default payment method for a transaction or receipt based on customer and receipt class configuration.
• CHECK_PAYMENT_METHOD — Validates that a given payment method is permissible for the transaction and customer context.
• GET_BANK_DEFAULTS — Retrieves default bank account information for receipt processing.
• GET_PAY_METHOD_AND_BANK_DEFLTS — Returns the combined default payment method and bank account, since these two defaults are frequently required together.
• GET_TERM_DEFAULT — Derives the default payment term for a transaction, considering the customer profile and transaction type.
• GET_ADDITIONAL_CUSTOMER_INFO — Retrieves supplementary customer attributes used in defaulting and validation logic.
• GET_PAYMENT_CHANNEL_NAME — Returns the payment channel name associated with a payment instrument or method.
• GET_PARTY_ID — Resolves the trading community party identifier for the customer account in context.
• GET_PAYMENT_INSTRUMENT — Derives the default payment instrument for the transaction or receipt.
• GET_BR_BANK_DEFAULTS — Returns bank defaults for bill-receivable or bank-related processing flows.
• GET_INSTR_DEFAULTS — Returns default values for payment instruments used in receipt and funds capture processing.

Tables Accessed

The package reads configuration and master data through APPS synonyms. Customer and site data is sourced from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, HZ_LOCATIONS, and HZ_CUSTOMER_PROFILES. Receipt configuration is drawn from AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, and AR_RECEIPT_METHOD_ACCOUNTS, with AR_SYSTEM_PARAMETERS supplying system-level defaulting controls. Bank and funds capture data is obtained from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_BANK_BRANCHES_V, IBY_FNDCPT_PAYER_ASSGN_INSTR_V, and IBY_TRXN_EXTENSIONS_V. Transaction setup and reference data comes from RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES, RA_TERMS, FND_CURRENCIES, FND_TERRITORIES_VL, and FND_APPLICATION.

Usage Notes

ARP_TRX_DEFAULTS_3 is an internal package and is not intended for direct invocation by customer extensions. It is referenced by fourteen other packages, including ARP_TRX_DEFAULTS, ARP_BF_BILL, ARP_PROCESS_HEADER, ARP_PROCESS_RCTS, ARP_PROCESS_CREDIT_UTIL, ARP_TRX_VAL, ARP_TRX_VALIDATE, ARP_CACHE_UTIL, ARP_PROGRAM_GENERATE_BR, AR_BILLS_CREATION_PUB, AR_DEPOSIT_LIB_PVT, AR_INVOICE_API_PUB, and AR_INVOICE_UTILS. These callers include the Receivables transaction and receipt forms, AutoInvoice, the Bills Receivable generation program, and the public invoice APIs. Custom code should call the documented public APIs — such as AR_INVOICE_API_PUB — rather than this package. Because the defaulting logic is shared by many concurrent programs and forms, changes to this package should be treated as high-impact and regression-tested across the corresponding business flows.