Search Results update_dp_config_data




Overview
Explore in AI Chat

Overview

APPS.IEM_EMTA_ADMIN_PVT is a private PL/SQL package in Oracle E-Business Suite that supports the administrative management of e-mail accounts in the ETRM (Email Center / eMail Tracking and Response Management) module. The package is defined with AUTHID CURRENT_USER and was originally created by Liang Xia on 10/05/2004, as reflected in the header of the source specification iemvemts.pls (version 120.2, dated 2005/07/13). Its primary business function is to coordinate updates to e-mail account configuration so that those changes are recognized and processed by the Download Processor, the component responsible for retrieving inbound e-mail. The package therefore acts as a bridge between the account administration layer and the background Download Processor processing layer.

The user search term "acct_info_tbl" corresponds directly to a package-level PL/SQL collection type declared within this package: TYPE acct_info_tbl is TABLE OF acct_info_rec INDEX BY BINARY_INTEGER;. It is an associative array (index-by table) whose element type, acct_info_rec, is a record carrying e-mail account attributes including account_id, action, update_flag, user_name, user_password, in_host, and in_port. For technical consultants, acct_info_tbl is significant because it is the internal data structure used to pass and stage sets of email account information through the administrative APIs.

Key Procedures and Functions

The documented package exposes six procedures/functions, all classified as Private (PVT):

  • IS_DLPS_RUNNING — Checks whether the Download Processor is currently running for a given e-mail account. It is used to guard against conflicting operations while the processor is active.
  • UPDATE_DP_CONFIG_DATA — Inserts data into IEM_EMTA_CONFIG_PARAMS so that an e-mail account update can be picked up (uptaken) by the Download Processor.
  • UPDATE_DP_CONFIG_DATA_WRAP — A wrapper around the configuration update logic, providing an alternate or higher-level entry point for the same processing flow.
  • GET_ACCOUNT_INFO — Retrieves e-mail account information that is to be updated, populating the internal account structures (including acct_info_tbl) used by downstream steps.
  • DELETE_ITEMS — Removes account-related items from the relevant staging or configuration tables.
  • IS_DATA_CHANGED — Determines whether the account data has changed since a prior state, allowing the package to avoid redundant processing when no updates have occurred.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • IEM_EMTA_CONFIG_PARAMS — The primary configuration table written to by UPDATE_DP_CONFIG_DATA; it signals the Download Processor that an account update is pending.
  • IEM_EMTA_CONFIG_PARAMS_S1 — A related sequence or supporting object used in generating/sequencing configuration parameter records.
  • IEM_MSTEMAIL_ACCOUNTS — The master e-mail account definition table that holds account credentials, host, port, and related attributes; read and manipulated to build account information records.
  • DUAL — Used for single-row evaluations such as status checks and flag determination.

Usage Notes

As a private (PVT) package, IEM_EMTA_ADMIN_PVT is not intended for direct customer invocation; it is called internally by the ETRM administrative layer, typically from Oracle Forms-based email account setup screens or from other ETRM packages (the metadata notes it is referenced by one other package). It may also be reached indirectly through concurrent program or workflow processing that administers e-mail accounts. Custom code should not call these private APIs directly, since their signatures and behavior are subject to change across releases. Because the package executes AUTHID CURRENT_USER and relies on APPS synonyms, any invocation must occur within an environment where the APPS schema and its grants are properly in place. The acct_info_tbl collection is meaningful only within the package's internal processing and is not a persistent or externally exposed structure.