Search Results iem_arch_requests_s1

Overview

APPS.IEM_ARCH_PVT is a private (PVT) PL/SQL package body in the Oracle E-Business Suite APPS schema that implements the archiving engine for the ETRM (Email Transaction Runtime Management / Interaction History) module. Its business purpose is to manage the lifecycle of email and interaction archiving requests: submitting a job, processing the request against its targeted folders and messages, cancelling an in-flight request, and reporting progress and errors back to the caller. The package is classified as PVT, meaning it is an internal implementation package and is not intended as a public API; instead, it is typically wrapped and driven by the public package APPS.IEM_ARCH_REQUESTS_PVT and its related detail package APPS.IEM_ARCH_DTLS_PVT.

The package is VALID in ETRM 12.1.1 and 12.2.2 and depends on standard EBS infrastructure, including FND_API, FND_MSG_PUB, FND_MESSAGE, FND_LOOKUPS, FND_PROFILE, and JTF_IH_PUB, indicating that it uses the standard EBS error-handling and messaging framework alongside interaction-history utilities.

Key Procedures and Functions

• SUBMIT_REQUEST — Creates and registers an archiving request, validating the caller's input and initializing the request record in IEM_ARCH_REQUESTS before processing begins.
• PROCESS_REQUEST — Executes the core archiving logic for a submitted request, iterating over the folders and messages to be archived and routing work to the archive-details package.
• CANCEL_REQUEST — Terminates an outstanding or in-progress archiving request, updating request status and releasing associated resources.
• GET_FOLDER_DTL — Retrieves folder-level detail for an archive request, used to resolve folder membership and contents prior to archiving.
• PROC_REQUESTS — Batch driver that processes multiple pending archiving requests, typically invoked by a concurrent program or scheduler loop.
• CREATE_MLCS — Creates the multi-language (MLS) context records required for archived data, ensuring language-specific values are available for the archived folders or messages.

No parameter signatures are documented; callers should reference the packaged specification for exact argument lists.

Tables Accessed

• IEM_ARCH_REQUESTS — master record of each archiving request (status, ownership, progress).
• IEM_ARCH_REQUESTS_S1 — the sequence used to generate unique archiving request identifiers.
• IEM_ARCHIVED_FOLDERS and IEM_ARCHIVED_DTLS — store the archived folder structure and the archived message/detail rows.
• IEM_ARCH_MSGS and IEM_ARCH_MSGDTLS — hold staged or archived email message headers and detail lines.
• IEM_EMAIL_ACCOUNTS — provides the email account context used when scoping and archiving messages.
• DUAL and PLITBLM — used for single-row evaluations and PL/SQL index-by-table support within internal logic.

Usage Notes

IEM_ARCH_PVT is a private implementation package and is not referenced by any other database object, so it is not a published extension point. In typical ETRM operation, it is invoked either directly by the ETRM Archiving/Email Administration forms through the public wrapper packages (IEM_ARCH_REQUESTS_PVT, IEM_ARCH_DTLS_PVT) or by a scheduled concurrent program that drives PROC_REQUESTS to process queued archiving requests. Because it relies on FND_MSG_PUB for error propagation, callers should check the standard FND message stack after invocation. Customizations should use the documented public archiving APIs rather than calling IEM_ARCH_PVT directly, as its interface is internal and subject to change.