Search Results delete_link

Overview

IEM_DBLINK_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is part of the E-Business Suite Technology Suite and supports the database connection and database link administration functionality used within the EBS environment. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified object references resolve using the privileges of the invoking user, and that runtime privilege checks are performed as the caller rather than as the package owner. This is significant for a utility that manages Oracle database links, because the ability to create or drop a link depends on the session's own privileges and on the presence of the underlying credentials. The package is a reserved, private API rather than a published interface; it is intended for internal consumption by other EBS code and should not be treated as a supported extension point for customer development.

Key Procedures and Functions

IEM_DBLINK_PVT exposes two documented procedures, both classified as private.

• CREATE_LINK — This procedure creates a record in the IEM_DB_CONNECTIONS table, effectively registering a database connection definition for use by EBS. Its input parameters include the standard API calling-convention arguments (API version number, an initialization message list flag, and a commit flag), together with the connection-specific values: the database global name, the database username, the database password, the database server identifier, and an administrative indicator. Standard concurrent-processing extensibility output parameters are returned: a return status, a message count, and a message data field. The procedure requires no documented pre-requisites, and the first version is 1.0.
• DELETE_LINK — This procedure removes a record from the IEM_DB_CONNECTIONS table. It follows the same API calling convention as CREATE_LINK, using the API version number, initialization message list flag, and commit flag, and identifies the target connection through a database connection identifier, which defaults to the missing-value constant FND_API.G_MISS_NUM when not supplied. It likewise returns return status, message count, and message data.

Tables Accessed

The package references several objects through APPS synonyms. IEM_DB_CONNECTIONS is the primary table for both procedures: CREATE_LINK inserts into it and DELETE_LINK removes rows from it. IEM_DB_SERVERS provides the database server definitions referenced by the server identifier parameter. FND_ORACLE_USERID holds the Oracle user credential information associated with the connection. ALL_DB_LINKS is used to inspect existing database links, which is relevant when determining whether a link already exists. The package also uses DBMS_SQL, consistent with the dynamic SQL required to create or drop database links at runtime, and DUAL for simple scalar evaluations. These references confirm that the package is the persistence and link-management layer underlying the EBS database connection setup.

Usage Notes

Because IEM_DBLINK_PVT is a private API referenced by no other documented packages in the ETRM metadata, it is best understood as an internal implementation detail invoked by the EBS forms and administrative flows that maintain database connections and database links. In practice, connection definitions are created and removed through the corresponding EBS administrative user interface rather than by calling this package directly; the forms invoke the private API on the user's behalf. Customers and integrators should not call CREATE_LINK or DELETE_LINK directly in custom code, since private APIs are subject to change without notice and are not covered by Oracle's public API compatibility commitments. All invocations should be routed through the supported setup screens, and any diagnostic work should treat the package as read-only from an interface perspective.