Search Results flex_values_exist

Overview

XLA_CMP_SOURCE_PKG is a private Oracle Subledger Accounting (XLA) package owned by APPS and classified as OTHER in the ETRM repository. It provides the caching and compilation layer that translates the metadata defined in the Accounting Methods Builder (AMB) into the runtime structures consumed by the XLA accounting engine. Its central responsibility is to read source definitions, source parameters, account derivation rules, analytical criteria, and journal entry line definitions from the XLA dictionary tables, and to build in-memory caches that accelerate the bulk accounting program during journal creation.

The package is declared with AUTHID CURRENT_USER and carries a long change history reflecting its role across multiple releases: initial creation in 2002, restructuring for the bulk accounting approach in 2003, incorporation of lookup selection from extract objects in 2004, ADR enhancements in 2005, and Multi-Period Accounting (MPA) support in bug 4262811. Global constants encode the AMB object types handled by the package, including C_DESC (description), C_ADR (account derivation rule), C_ANC (analytical criteria), C_ALT (journal entry line), and C_EVT (event).

Key Procedures and Functions

• GENERATESOURCE — Produces or refreshes the cached representation of a source definition so that the accounting engine can reference it without repeated dictionary queries.
• GENERATEPARAMETERS — Builds the parameter structures associated with a source or extract object, supporting the parameterized source model used in AMB.
• GET_OBJ_PARM_FOR_TAB — Added in June 2004 by A. Quaglia; returns the object parameters applicable to a given table, supporting table-driven source and parameter resolution.
• CACHESOURCE — Populates the source cache from XLA_SOURCES_B, XLA_SOURCES_TL, and XLA_SOURCE_PARAMS, making source metadata available in memory.
• STACKSOURCE — Maintains the ordered or hierarchical relationship among sources, allowing composite or nested sources to be resolved in sequence.
• CACHEAADOBJECT — Caches an Application Accounting Definition object (description, ADR, analytical criteria, or journal line definition) for reuse by the accounting engine.
• GETAADOBJECTPOSITION — Returns the position of an AAD object within its cached structure, typically used to order processing correctly.
• GETSOURCESINAADOBJECT — Enumerates the sources associated with a given AAD object, enabling the engine to determine which values must be supplied.
• FLEX_VALUES_EXIST — Tests whether flexfield values exist for the value sets referenced by the source, which is the entry point users typically locate when searching for this package.
• GENERATEGETMEANINGAPI — Generates the API used to derive the meaning of a flexfield value, complementing FLEX_VALUES_EXIST.

Tables Accessed

The package reads XLA_SOURCES_B and XLA_SOURCES_TL for source definitions and their translated names, and XLA_SOURCE_PARAMS for the parameter definitions attached to sources. It consults FND_FLEX_VALUE_SETS and FND_FLEX_VALIDATION_TABLES to resolve flexfield value sets and their validation tables, which underpins FLEX_VALUES_EXIST and GENERATEGETMEANINGAPI. FND_APPLICATION is used to resolve application context, PLITBLM supports bulk parameter manipulation, and DBMS_SQL enables dynamic SQL construction for source extraction.

Usage Notes

XLA_CMP_SOURCE_PKG is invoked internally by the XLA accounting engine and is referenced by eleven other packages. It is not exposed through a standard concurrent program or form, but is indirectly exercised when users maintain Accounting Methods Builder definitions, submit Subledger Accounting Program reports, or run Create Accounting. Custom code should not call it directly; instead, developers should use the supported XLA public APIs and treat this package as an internal implementation detail subject to change between 12.1.1 and 12.2.2.