Results for “delete_item”

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

Overview

IEM_TEMP_STORES_PVT is a private PL/SQL package in the APPS schema belonging to Oracle's E-Business Suite Email Center / Interaction Management (IEM) product family. Its principal role is to support the staging of inbound email messages into a temporary stores table, IEM_TEMP_STORES, before they are processed, categorized, and routed by the Email Center message-handling engine. The package name and its CREATE_ITEM procedure signature — carrying attributes such as p_rfc822, p_from_str, p_to, p_cc, p_bcc, p_subject, p_message_size, p_mig_status, and a BLOB content field (p_message_content) — confirm that the object exists to persist a raw email record into that staging area. The header revision (iemvmigb.pls 120.1, dated 2005) shows it is a migration-era artifact, originally used to migrate or load mail items into the temporary store during Email Center implementations and upgrades.

Key Procedures and Functions

The ETRM metadata documents two procedures in the package:

• CREATE_ITEM — Inserts a single email message record into the temporary stores table. The documented source shows the procedure accepts the standard FND_API conformance parameters (p_api_version_number, p_init_msg_list, p_commit) together with the message-level attributes listed above, and returns the standard x_return_status, x_msg_count, and x_msg_data out parameters. It begins with the standard FND_API.Compatible_API_Call version check, initializes x_return_status to G_RET_STS_SUCCESS, and conditionally commits when p_commit = 'T'. The INSERT statement itself is commented out in the shipped source, indicating the procedure was disabled or superseded in later builds.
• DELETE_ITEM — Removes a previously staged email record from the temporary stores table, allowing consumers of the staging area to clean up processed or invalid rows. Its exact parameter list is not reproduced in the available excerpt.

Both procedures follow the standard EBS private-API conversion conventions (G_PKG_NAME constant, local l_api_name and l_api_version_number variables, and FND_MSG_PUB-style error signalling).

Tables Accessed

The documented table reference is IEM_TEMP_STORES, accessed through its APPS synonym. This table is the temporary landing area for inbound email. CREATE_ITEM writes rows into it, populating the message identity (MESSAGE_ID), the owning email account (EMAIL_ACCOUNT_ID), folder name, addressing fields, sent date, subject, size, migration status and error text, the message text, and the BLOB message content. DELETE_ITEM deletes rows from the same table. No additional tables are documented as referenced by this package.

Usage Notes

Because IEM_TEMP_STORES_PVT is classified as a Private (PVT) API and is referenced by zero other packages, it is not part of the public integration surface of the Email Center. It is not intended for direct invocation from customer forms, concurrent programs, or custom code; Oracle's documented guidance is that private APIs may change without notice. The one sanctioned consumer is Oracle's own message-loading or migration logic, which invokes the package to stage mail items prior to the standard Email Center processing cycle. The presence of the p_mig_status and p_mig_error_text parameters reinforces the migration/loading purpose. The user query "i-therm process private limited" does not correspond to any object, table, or synonym in this metadata; it appears to be an unrelated search term and has no bearing on this package's function. In releases 12.1.1 and 12.2.2 the package remains for internal use only, and the commented-out INSERT in the shipped source suggests that in current environments the actual staging work is performed elsewhere, with this object retained largely for backward compatibility.