Search Results get_emailaccount_list

Overview

IEM_EMAILACCOUNT_PUB is a public PL/SQL API packaged under the APPS schema that supports the Oracle EBS Interaction Center / Email Center (IEM) module. Its principal business function is to expose email account configuration and inbound email header metadata to other EBS components and to custom extensions. The package provides the programmatic layer through which callers retrieve the list of configured email accounts, resolve agent-to-account associations, and fetch message header information for inbound email processed by the Email Center. Because the package is classified as PUB, its declared procedures are intended for external invocation by forms, concurrent programs, and customer-written code.

The package declares an extensive set of PL/SQL record and table types that model email account configuration and message metadata. These include EMACNT_rec_type (account name, database user, account password, account ID), msg_header (message ID, SMTP message ID, sender, received date, from/to strings, priority, reply-to, subject, classification, score, folder path), account_info_record (email user, password, domain, database server ID, email account ID), ACNTDETAILS_rec_type (account name, email user, email address, reply-to address, from name, email account ID, SMTP server, port, template category), AGNTACNTDETAILS_rec_type (resource ID, resource name, user name, role, last login time), and AGENTACNT_rec_type (agent account ID, email account ID, account name, reply-to address). These types are exposed so that calling programs can consume structured result sets without defining their own record layouts.

Key Procedures and Functions

• GET_EMAILACCOUNT_LIST — Returns the collection of configured email accounts, allowing a caller to enumerate accounts available for outbound or inbound processing.
• GETEMAILHEADERS — Retrieves inbound email header information, populating the msg_header structure with SMTP message identifiers, sender/recipient strings, subject, priority, classification, and folder path.
• LISTAGENTACCOUNTS — Lists the email accounts associated with agents, supporting assignment and routing logic within the Interaction Center.
• LISTAGENTCPACCOUNTS — Lists agent accounts scoped to a particular channel/campaign or comparable grouping, complementing LISTAGENTACCOUNTS.
• LISTAGENTACCOUNTDETAILS — Returns detailed agent-account records, including the resource, user name, role, and last login time.
• LISTACCOUNTDETAILS — Returns the detailed configuration for an email account, including the SMTP server, port, from name, reply-to address, and template category.

Tables Accessed

The package reads configuration and association data from several APPS synonyms. IEM_MSTEMAIL_ACCOUNTS holds the master email account definitions, including SMTP server, port, and template attributes surfaced by LISTACCOUNTDETAILS. IEM_AGENTS holds the agent records used to resolve agent-to-account associations. JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_VALUES supply resource attributes (resource name, user name, role) returned by LISTAGENTACCOUNTDETAILS. IEU_SH_SESSIONS provides session-related context. DBMS_SQL and PLITBLM are utility packages used for dynamic SQL and index-by table manipulation respectively.

Usage Notes

This package is typically invoked from Email Center setup and administration forms, agent-facing Interaction Center screens, and custom concurrent programs that need to enumerate email accounts or inspect inbound message headers. Because it is a PUB API, Oracle supports its use by external callers, but custom code should not reference the underlying record types' private internals. The presence of the SMTP_SERVER attribute in ACNTDETAILS_rec_type is the documented entry point for retrieving the configured SMTP server host for a given email account.