Results for “delete_valueset”

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

Overview

APPS.FND_FLEX_VAL_API is the Oracle Application Object Library API responsible for creating, updating, and querying key flexfield and descriptive flexfield value sets in Oracle E-Business Suite 12.1.1 and 12.2.2. Value sets define the validation rules applied to flexfield segments and to any concurrent program parameter that uses a value set. This package provides a supported, programmatic interface for the operations that administrators normally perform through the Segment Values and Value Sets forms, allowing value sets to be defined, renamed, resized, and inspected without direct, unsupported inserts into the underlying FND tables.

The package centralizes the logic that determines whether a value set is validated by an independent list of values, by a parent value set (dependent), by a database table, or by a special validation routine. Its get_*_vset_select functions, including GET_DEPENDENT_VSET_SELECT, are among the most frequently referenced routines, because they return the SQL or LOV structure that a dependent value set uses to restrict its list of values based on a parent value.

Key Procedures and Functions

• DEBUG_ON, DEBUG_OFF, SET_SESSION_MODE, VERSION, MESSAGE — diagnostic and session control utilities used to enable or disable debugging output, set the API session mode, return the package version, and retrieve the last error message.
• CREATE_VALUESET_NONE, CREATE_VALUESET_INDEPENDENT, CREATE_VALUESET_DEPENDENT, CREATE_VALUESET_TABLE, CREATE_VALUESET_SPECIAL, CREATE_VALUESET_PAIR — create value sets of each supported validation type, from "none" (no validation) through independent, dependent, table-validated, special, and paired value sets.
• ADD_EVENT — registers a validation event associated with a value set.
• DELETE_VALUESET and DESTRUCTIVE_RENAME — remove a value set or rename it, with the rename operation flagged as destructive because dependent objects and segment assignments may be affected.
• VALUESET_EXISTS — checks whether a value set with a given name already exists, typically used defensively before creation.
• UPDATE_TABLE_SIZES and UPDATE_MAXSIZE — adjust the size attributes of table-validated value sets and the maximum size of a value set.
• GET_INDEPENDENT_VSET_SELECT, GET_DEPENDENT_VSET_SELECT, GET_TABLE_VSET_SELECT — return the select statement or LOV definition used for each validation type. GET_DEPENDENT_VSET_SELECT returns the dependent value set's list of values query, deriving it from the parent value set and the associated table and column information.

These functions return integer codes rather than raising exceptions, including values such as 0 (no error), 11 (no value set), 12 (validation type mismatch), 21 (not independent-validated), 31 (not dependent-validated), and 32 (no parent value).

Tables Accessed

The package reads and writes the core flexfield definition tables through APPS synonyms. FND_FLEX_VALUE_SETS and its related flex validation tables (FND_FLEX_VALIDATION_TABLES, FND_FLEX_VALIDATION_EVENTS, FND_FLEX_HIERARCHIES) hold the value set definitions and validation rules. FND_COLUMNS, FND_TABLES, and FND_ID_FLEX_SEGMENTS supply column, table, and key flexfield segment metadata used to build select statements. Descriptive flexfield structures are drawn from FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_COL_USAGE_TL, FND_DESCR_FLEX_CONTEXTS, and FND_DESCR_FLEX_CONTEXTS_TL, while FND_APPLICATION and FND_APPLICATION_TL resolve application-level references. Dependent value sets additionally consult hierarchy tables to construct parent-child LOV queries.

Usage Notes

FND_FLEX_VAL_API is invoked by Oracle EBS forms, concurrent programs, and system administration routines that manage flexfield value sets, and it is referenced by at least twenty-one other packages. Customers and integrators typically call it during setup migration, when loading value set definitions programmatically, or when building custom validation logic that must replicate the standard LOV behavior. The get_*_vset_select functions are commonly used to obtain the runtime select statement for a value set so that a custom form or report can present the same validated list of values. Callers should check the returned status code against the documented return constants, and should enable debug mode through DEBUG_ON when diagnosing unexpected validation results.