Results for “p_chart_of_accounts_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XLA_FLEX_PKG (internally named xla_flex_pkg) is a public PL/SQL package in the APPS schema that centralizes access to Oracle E-Business Suite flexfield and value set metadata on behalf of the Subledger Accounting (XLA) application. The package header is documented under the version identifier xlacmflx.pkh, with an original creation date of 01-May-2001 attributed to Dimple Shah, and is shipping unchanged in the 12.1.1 and 12.2.2 releases. Its business purpose is to resolve the descriptive information that surrounds accounting flexfields—value set names, chart of accounts names, segment names, segment qualifiers, and validation table select statements—so that subledger accounting programs and forms do not have to query the underlying FND flexfield tables directly. The package is classified as type OTHER in the ETRM metadata and exposes sixteen documented subprograms. It is referenced by twenty other packages, which confirms its role as a shared, foundational utility layer rather than an application-specific component.

Key Procedures and Functions

The documented subprograms fall into four broad groups. The first resolves identifiers into display names: GET_VALUE_SET_NAME returns the value set name for a supplied value set identifier, GET_CHART_OF_ACCOUNTS_NAME returns the chart of accounts name for a given application, flex code, and chart of accounts identifier, and GET_FLEXFIELD_SEGMENT_NAME returns the segment name associated with a segment code. The second group extracts segment and qualifier detail: GET_FLEXFIELD_SEGMENT_INFO, GET_FLEX_VALUE_MEANING, GET_QUALIFIER_SEGMENT, GET_SEGMENT_QUALIFIER, GET_QUALIFIER_NAME, and GET_SEGMENT_VALUESET describe segment and qualifier relationships and their attached value sets. The third group inspects qualifier and column attributes through boolean-style tests: SEGMENT_QUALIFIER_IS_ENABLED, ID_COLUMN_IS_NULL, MEANING_COLUMN_IS_NULL, and CHK_ADDITIONAL_WHERE_CLAUSE. The fourth group handles key flexfield structure resolution and generates the dynamic SQL used against validation tables, exposed through GET_FLEXFIELD_STRUCTURE and the pair GET_TABLE_VSET_SELECT and GET_TABLE_VSET_RETURN_COL, which together supply the SELECT clause and the return column for table-validated value sets.

Tables Accessed

The package reads from five FND tables through APPS synonyms. FND_FLEX_VALUE_SETS provides value set definitions and their validation types. FND_FLEX_VALIDATION_TABLES supplies the table-based validation definitions that GET_TABLE_VSET_SELECT and GET_TABLE_VSET_RETURN_COL translate into query text. FND_ID_FLEX_SEGMENTS holds segment definitions for key flexfields and supports segment name and qualifier lookups. FND_SEGMENT_ATTRIBUTE_TYPES and FND_SEGMENT_ATTRIBUTE_VALUES store the attribute type catalog and the per-segment attribute assignments, supporting the enabled-qualifier and column nullability checks. No documented write operations are performed; the package is a read-only metadata accessor.

Usage Notes

XLA_FLEX_PKG is normally invoked indirectly. Subledger accounting forms, concurrent programs, and the twenty dependent packages call its functions rather than issuing direct FND queries. Custom code may call it safely because the subprograms are declared in the public package specification. The table value set functions require particular care: callers should validate the generated SELECT fragment and return column against the target validation table before executing dynamic SQL, and must account for the additional WHERE clause behavior governed by CHK_ADDITIONAL_WHERE_CLAUSE. Because the package only reads metadata, it introduces no transactional side effects and requires no commit or rollback handling by the caller.