Search Results iem_configuration_pub




Overview
Explore in AI Chat

Overview

IEM_CONFIGURATION_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the iMarketing (iEM / eMail Center) application module. Its stated purpose, taken directly from the package header comments, is to expose a public interface for collecting eMail Center configuration settings. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified database object references are resolved against the privileges of the invoking session rather than the package owner. This is a deliberate design choice for a configuration-read utility, allowing callers to see only the configuration data their own credentials permit. The package is classified as PUB in the ETRM metadata, confirming it is an intended extension point rather than an internal helper. The header identifies the original author and dates the source at version 115.2 (2002/12/04), reflecting the long-standing stability of the eMail Center configuration layer across EBS releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents a single public program unit in this package.

  • GETCONFIGURATION — A public procedure whose documented function is to collect eMail Center configurations. It is the sole entry point exposed by the package. Standard EBS API conventions are evident in its signature: an API version number defaulted to 1, initialisation and commit flags following the FND_API.G_FALSE / FND_API.G_TRUE pattern, and a pair of IN/OUT strings conventionally named ERRBUF and ERRRET for returning status and error text. Callers should treat the procedure as a read-oriented configuration retriever and inspect ERRBUF and ERRRET for diagnostic output; no other documented parameters, return types, or overloads exist for this package.

Tables Accessed

The package's data access is defined through APPS synonyms over the following iEM tables, each corresponding to a discrete configuration domain:

Collectively these tables represent the full configuration surface of the eMail Center. GETCONFIGURATION reads across them to assemble a consolidated configuration picture rather than touching a single repository.

Usage Notes

Because GETCONFIGURATION is the only documented entry point, the package is normally invoked where a consolidated view of eMail Center configuration is required: from Oracle Forms or OAF pages that display or validate configuration, from concurrent programs that audit or initialise the iEM setup, and from custom PL/SQL that must confirm server, account, or theme settings before processing mail. The ETRM metadata records no other package as referencing IEM_CONFIGURATION_PUB, so it has no internal dependants within the shipped code and is effectively a leaf-level public utility. Its AUTHID CURRENT_USER declaration means callers must hold the necessary object privileges themselves, which matters when granting execute rights to custom schemas. The versioned API signature allows Oracle to evolve the interface without breaking existing callers, and the init/commit flags let callers control message-stack initialisation in the standard EBS manner. Application developers integrating with the eMail Center should prefer this package over direct reads of the underlying IEM tables, as it is the documented and supported access path.