Search Results iem_rt_preproc_emails_pvt




Overview
Explore in AI Chat

Overview

The APPS.IEM_RT_PREPROC_EMAILS_PVT package body is a private helper package within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 Email Center (IEM) module. It participates in the inbound email pre-processing framework, which is responsible for handling, parsing, and routing incoming email messages before they are processed by the Email Center runtime. The package is classified with an API classification of PVT (private), indicating that it is intended for internal use by the Email Center application and is not part of the public integration API surface.

As a private package, it exposes functionality that supports the maintenance and lifecycle management of inbound email pre-processing records. The package works in close coordination with the base table IEM_RT_PREPROC_EMAILS and depends on standard Oracle EBS framework utilities such as FND_API (for the standard API return-status conventions), FND_MSG_PUB (for message handling and error propagation), and FND_PROFILE (for retrieving profile option values that govern runtime behaviour).

Key Procedures and Functions

The package body documents two procedures:

  • CREATE_ITEM — Creates a new pre-processing email item. This procedure inserts a record into the inbound email pre-processing store (the underlying IEM_RT_PREPROC_EMAILS table), capturing the details required for the Email Center to subsequently process the message. It is the entry point for registering an incoming email into the pre-processing workflow.
  • DELETE_ITEM — Removes a pre-processing email item. This procedure deletes the corresponding record from IEM_RT_PREPROC_EMAILS, typically after the message has been fully processed, routed, or otherwise no longer requires retention in the pre-processing queue.

Both procedures follow the standard FND_API conventions for error handling and status reporting. Parameter lists are not documented in the available metadata and should not be assumed; callers must inspect the package specification (which is not exposed here) to determine the exact argument signatures.

Tables Accessed

The package accesses a single documented table via its APPS synonym:

  • IEM_RT_PREPROC_EMAILS — The inbound email pre-processing table. The CREATE_ITEM procedure writes new rows to this table, while DELETE_ITEM removes rows. This table forms the persistent staging area for messages awaiting or undergoing Email Center pre-processing.

Usage Notes

Because IEM_RT_PREPROC_EMAILS_PVT is a private package, it is not intended to be called directly by external or custom code. It is invoked internally by other Email Center components — the ETRM metadata indicates that it is referenced by two other packages — as part of the inbound email handling pipeline. Typical invocation occurs when the Email Center processes a newly arrived message (triggering CREATE_ITEM) and when that message is cleared from the pre-processing stage (triggering DELETE_ITEM).

Integration developers should not depend on this package’s interface, as private packages are subject to change between patch levels and releases. The metadata confirms that the object is valid and has no downstream database dependencies referencing it, reinforcing its internal, encapsulated role within the IEM Email Center framework.