Search Results is_apar_batch

Overview

FUN_SYSTEM_OPTIONS_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It encapsulates access to the Oracle Receivables and Oracle Payables system options that are maintained by the Financials common infrastructure. These options control behavior shared across the two subledgers, including the default currency for transactions, the minimum transaction amount and its associated currency, batching behavior for AP/AR and General Ledger transfers, manual versus automatic document numbering, recipient rejection of payments, and the exchange rate type used for conversion.

The package belongs to the API classification OTHER, meaning it is not a formally published open interface but an internal utility relied upon by other EBS code. The package header carries the RCS identifier $Header: funsysutils.pls 120.6 2004/01/07 00:26:10 aslai noship $, indicating it is a shipped, non-customized file. In EBS 12.1.1 and 12.2.2 the package remains available in the APPS schema and is referenced by five other packages within the Financials family.

Because the package exposes system option values through PL/SQL rather than through direct table access, it centralizes and standardizes how dependent code resolves configuration flags. This reduces duplication and ensures consistent interpretation of the underlying FUN_SYSTEM_OPTIONS record.

Key Procedures and Functions

The documented interface contains seven functions:

• GET_MIN_TRX_AMT — Returns the minimum transaction amount together with its corresponding currency. A Boolean return value of FALSE indicates that no minimum amount has been defined in system options.
• IS_APAR_BATCH — Tests whether AP/AR transfer processing is configured for batching.
• IS_GL_BATCH — Tests whether General Ledger transfer processing is configured for batching.
• IS_MANUAL_NUMBERING — Tests whether the document numbering option is set to manual.
• GET_ALLOW_REJECT — Tests whether payment recipients are permitted to reject.
• GET_DEFAULT_CURRENCY — Retrieves the default currency and returns the currency code. This is the function most commonly sought by developers, as it provides the standard way to obtain the default currency without querying FUN_SYSTEM_OPTIONS directly.
• GET_EXCHG_RATE_TYPE — Returns the exchange rate type configured in system options.

Each function follows the package's convention of returning a Boolean or scalar result reflecting the system option state. No parameter lists are documented in the source excerpt, so callers should reference the live package specification before invoking these units.

Tables Accessed

The package reads from a single table, FUN_SYSTEM_OPTIONS, accessed through an APPS synonym. This table stores the shared Financials system option settings for an operating unit or installation. The functions in this package select the relevant columns to return the minimum transaction amount and currency, default currency, exchange rate type, and the various control flags for batching, numbering, and rejection. No inserts or updates are documented, consistent with the package's role as a read-only accessor of configuration data.

Usage Notes

FUN_SYSTEM_OPTIONS_PKG is typically invoked from Forms-based setup screens and from concurrent programs within Oracle Payables and Oracle Receivables that must honor system option settings at runtime. Custom PL/SQL and extensions may also call it when business logic depends on the default currency or other Financials options. Because it is classified OTHER rather than a published API, Oracle does not guarantee interface stability; developers should review the package specification after patches or upgrades. Callers requiring the default currency should use GET_DEFAULT_CURRENCY rather than issuing direct SQL against FUN_SYSTEM_OPTIONS.