Results for “iem_emailaccount_pub”

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

Overview

IEM_EMAILACCOUNT_PUB is a public PL/SQL API package in the Oracle E-Business Suite Interaction E-mail (IEM) module. Its responsibility is to expose e-mail account definitions held in the IEM master tables to other EBS components, and to return the correspondence-related account context for a given resource, agent, or session. In practice, the package acts as the read layer for the e-mail account configuration used by iSupport, iStore, and the interaction/e-mail processing infrastructure, allowing calling code to resolve which outbound e-mail account, sender name, and database user should be used when generating or routing an e-mail message.

The package follows the standard EBS public API convention: it validates the caller's API version through FND_API.Compatible_API_Call, optionally initialises the message stack through FND_MSG_PUB, establishes a savepoint, and reports status via the standard x_return_status, x_msg_count, and x_msg_data OUT parameters. The source header (iempactb.pls 120.9) indicates the file was last revised in 2006, so the behaviour has been stable across 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_EMAILACCOUNT_LIST — Returns a collection of e-mail account records (EMACNT_tbl_type). When a resource identifier is supplied it joins IEM_MSTEMAIL_ACCOUNTS to JTF_RS_RESOURCE_VALUES to return only the accounts assigned to that resource; when no resource is supplied it returns all accounts. Each element carries the sender/account name, database user, and e-mail account identifier.
• GETEMAILHEADERS — Retrieves the e-mail header information associated with an account or message context, used to populate the "from", "to", and related routing fields.
• LISTAGENTACCOUNTS — Lists the e-mail accounts linked to a specified agent.
• LISTAGENTCPACCOUNTS — Lists the e-mail accounts available to an agent's contact-point configuration.
• LISTAGENTACCOUNTDETAILS — Returns the full attribute detail for the accounts associated with an agent.
• LISTACCOUNTDETAILS — Returns detailed attribute information for a specified e-mail account.

The parameter lists are not reproduced here; only the documented procedure names and their functional purpose are asserted.

Tables Accessed

• IEM_MSTEMAIL_ACCOUNTS — The master table of e-mail account definitions; the primary source of from_name, user_name, and email_account_id.
• JTF_RS_RESOURCE_VALUES — Maps resource identifiers to account ids, enabling the resource-specific account lookup.
• JTF_RS_RESOURCE_EXTNS — Resource extension attributes used to qualify the agent/resource context.
• IEM_AGENTS — Agent definitions that own or are associated with e-mail accounts.
• IEU_SH_SESSIONS — Session information used when resolving account context for an active interaction session.
• DBMS_SQL and PLITBLM — Dynamic SQL and PL/SQL table utilities used internally by the package.

Usage Notes

IEM_EMAILACCOUNT_PUB is a published API (API classification PUB) and is referenced by two other packages in the EBS data model, indicating that it is consumed by higher-level interaction or e-mail processing logic rather than being invoked directly by end users. Typical callers include the iSupport agent-facing forms that need to display or select the available e-mail accounts for a signed-on resource, and concurrent or background programs that must determine the correct outbound account when generating notifications. Custom code should call the procedures through the standard FND_API wrapper pattern, checking x_return_status before consuming the returned collection. Because resource_id may be passed as NULL, the same procedure can be used both to enumerate all accounts and to filter to a single resource, but callers must always validate the API version and initialise the message list where error detail is required.