Results for “create_valueset_dependent”

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

Overview

FND_FLEX_VAL_API is the core PL/SQL package body in the APPS schema responsible for creating, maintaining, and querying Oracle EBS Key and Descriptive Flexfield value sets and their validation definitions. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package underpins the Flexfields infrastructure that governs how segments are validated across the entire application suite. Its business function is to provide a programmatic, API-driven alternative to the Forms-based Flexfield Value Set definition screens, allowing administrators and developers to define value sets, register validation events, and configure validation tables without direct manipulation of the underlying FND tables. The package is classified as an API and exposes a substantial public interface of 33 documented procedures and functions, making it one of the more significant flexfield maintenance APIs within the FND schema.

Key Procedures and Functions

The package provides a broad set of entry points organized around value set lifecycle management, event configuration, and dynamic SQL generation. Documented procedures include:

• CREATE_VALUESET_NONE, CREATE_VALUESET_INDEPENDENT, CREATE_VALUESET_DEPENDENT, CREATE_VALUESET_TABLE, CREATE_VALUESET_SPECIAL, CREATE_VALUESET_PAIR — one creation routine per flexfield validation type, allowing the caller to define value sets of type None, Independent, Dependent, Table, Special, and Pair respectively.
• ADD_EVENT — registers a validation event against a value set, driving when and how validation is applied.
• DELETE_VALUESET, DESTRUCTIVE_RENAME, VALUESET_EXISTS — maintenance and introspection routines for removing, renaming, and verifying the existence of value sets.
• UPDATE_TABLE_SIZES, UPDATE_MAXSIZE — adjust the physical sizing attributes associated with table-validated value sets.
• GET_INDEPENDENT_VSET_SELECT, GET_DEPENDENT_VSET_SELECT, GET_TABLE_VSET_SELECT — return the SQL SELECT statement fragments used to validate values for each value set category, enabling runtime validation of flexfield entries.
• DEBUG_ON, DEBUG_OFF, SET_SESSION_MODE, VERSION, MESSAGE — diagnostic, versioning, and messaging utility routines consistent with standard FND API conventions.

Tables Accessed

The package reads and writes a broad set of FND tables via APPS synonyms. Value set definitions are stored in FND_FLEX_VALUE_SETS and its sequence, FND_FLEX_VALUE_SETS_S. Validation rules, events, qualifiers, and tables are managed through FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALIDATION_EVENTS, and FND_FLEX_VALIDATION_QUALIFIERS. Hierarchical structures are handled via FND_FLEX_HIERARCHIES, FND_FLEX_HIERARCHIES_TL, FND_FLEX_VALUE_HIERARCHIES, and FND_FLEX_VALUE_NORM_HIERARCHY. Rule definitions reside in FND_FLEX_VALUE_RULES, FND_FLEX_VALUE_RULES_TL, FND_FLEX_VALUE_RULE_LINES, and FND_FLEX_VALUE_RULE_USAGES. Flexfield structure metadata is drawn from FND_ID_FLEXS, FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_STRUCTURES_TL, FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_CONTEXTS, and related translation tables. General metadata and lookup information is sourced from FND_COLUMNS, FND_TABLES, FND_APPLICATION, FND_LOOKUPS, and FND_LOOKUP_VALUES.

Usage Notes

FND_FLEX_VAL_API is typically invoked from the Flexfield Value Set definition Forms, from concurrent programs that migrate or bulk-load value set configurations, and from custom PL/SQL code that programmatically provisions flexfield validation. The package is referenced by 21 other database objects, confirming its role as a foundational dependency for flexfield-related APIs such as FND_FLEX_VALUES_PKG, FND_FLEX_LOADER_APIS, and FND_FLEX_VAL_UTIL. Developers integrating with this API should observe standard FND API conventions, including the use of FND_API, FND_MESSAGE, and FND_GLOBAL for error handling and session context. Because the package manipulates core flexfield metadata, changes made through these routines directly affect segment validation behavior across the applications that reference the affected value sets.