Search Results function_validation

Overview

APPS.FND_FORM_FUNCTIONS_PKG is a VALID PL/SQL package body in the APPS schema that encapsulates the maintenance logic for Oracle E-Business Suite form functions. Form functions define the individual executable navigable units of the EBS application menu hierarchy—typically a form, a subfunction, or a non-form target—and are stored in the FND_FORM_FUNCTIONS family of tables. This package provides the programmatic interface through which function definitions are inserted, updated, loaded, translated, validated, and deleted, making it the primary data-manipulation layer behind the Forms-based "Form Functions" setup form and behind bulk data loading utilities.

The package is classified as an OTHER API in the ETRM metadata rather than as a formally published public API, which indicates it is primarily intended for internal use by Oracle Application Object Library components. Its dependency list—FND_LOAD_UTIL, FND_FUNCTION_SECURITY_CACHE, FND_GLOBAL, FND_MESSAGE, and APP_EXCEPTION—confirms tight integration with the application object library's loading, security-caching, and error-handling infrastructure.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions. The core row-level DML routines are INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW, covering the standard create, modify, remove, and concurrency-locking operations against a single function definition. LOAD_ROW supports bulk or seeded data loading, typically invoked by the loader utilities that migrate function definitions between environments.

Translation support is provided by ADD_LANGUAGE, which registers an additional language row, and TRANSLATE_ROW, which populates the translatable (TL) columns for an existing row. Two behavioral routines are notable: SET_FUNCTION_MODE controls function mode attributes, and FUNCTION_VALIDATION performs validation of a function definition, likely checking against FND_APPLICATION, FND_FORM, and FND_OBJECTS to ensure referenced entities exist and are consistent.

Tables Accessed

The package reads and writes the base table FND_FORM_FUNCTIONS and its associated FND_FORM_FUNCTIONS_S (sequence/primary key source) and FND_FORM_FUNCTIONS_TL (translatable text) tables. Validation and lookup activity draws on FND_APPLICATION (owning application), FND_FORM (target form registration), FND_OBJECTS (non-form function targets), FND_LANGUAGES (installed language list), and FND_LOOKUP_VALUES (function type and mode lookups). DUAL is referenced for trivial scalar evaluation, and FND_FUNCTION_SECURITY_CACHE is touched so that function-security caching remains consistent after definition changes.

Usage Notes

FND_FORM_FUNCTIONS_PKG is invoked indirectly by the Application Object Library "Form Functions" maintenance form and by concurrent/loader processes that import function definitions, such as those driven by FND_LOAD_UTIL. Because five other packages reference it, customizations that manipulate form functions directly against the base tables risk bypassing the validation, locking, and security-cache maintenance performed here.

Custom code should generally treat this package as a restricted internal API and prefer supported loading mechanisms. Where it is called directly, the DML routines should be wrapped in explicit transaction control, and LOCK_ROW should be used to avoid concurrent-update conflicts. Any change to a function definition should be followed by the security-cache refresh path referenced in the dependencies to ensure navigation and security rules reflect the updated function.