Results for “fnd_value_sets”

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

Overview

The APPS.ADI_SECURITY_API package is a PL/SQL API belonging to the Application Desktop Integrator (ADI) subsystem of Oracle E-Business Suite, which provides the desktop integration framework used by Oracle General Ledger, Oracle Assets, and related financial applications. As defined in the ETRM metadata for release 12.1.1 and 12.2.2, the package is owned by the APPS schema and classified as an API. It is declared with AUTHID CURRENT_USER, meaning that privileges are evaluated against the invoking schema rather than the defining schema, a convention typical of EBS public APIs that are invoked from a variety of calling contexts.

The header comment retrieved from the source describes the original functional intent: to retrieve a list of expansion values from FND_VALUE_SETS, the Oracle Application Object Library table that stores value set definitions used throughout EBS. The package was therefore conceived as a supporting utility for value set expansion within ADI functionality, rather than as a full business transaction API.

Key Procedures and Functions

The ETRM metadata for this object records zero documented procedures and functions as of release 12.2.2. This is consistent with the package body being reduced over time to an empty specification.

The package header commentary preserves the historical evolution of the interface. A procedure named Package_Revision was added in February 2000 to capture the revision number of the package at runtime (Task 3858). The package was subsequently reworked in May 2000, when the $Header comment was moved and the creation syntax changed from CREATE OR REPLACE PACKAGE IS to ... AS. In November 2002, the procedures not used by the RM8 release were stubbed out, effectively removing the remaining callable surface.

Because the specification closes immediately after the header block, the package exposes no named procedures or functions in the documented 12.2.2 metadata. Any earlier versions that did expose procedures were superseded.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms for this package. The header comment names FND_VALUE_SETS as the intended source of expansion values, which is an Application Object Library table describing value set configuration. Given the empty documented interface, no active read or write access to this table occurs in the current definition.

With no documented table references, the package carries no meaningful data access footprint, no DML, and no locking behavior.

Usage Notes

The ETRM metadata records that this package is referenced by zero other packages, indicating it is not called by any dependent PL/SQL object in the documented inventory. Combined with the empty specification, this confirms that ADI_SECURITY_API functions as a stub or deprecated artifact in 12.1.1 and 12.2.2.

Typical invocation points associated with ADI security functionality include ADI forms, report definitions, and concurrent programs that validate user access to ADI-enabled value sets or account structures. Custom code should not depend on this package, because it exposes no supported public interface. Developers searching for API security functionality (for example, the query "API Security Inc") should treat ADI_SECURITY_API as a shell remnant rather than a callable integration point, and should reference the appropriate ADI or Application Object Library APIs for functional security requirements.