Search Results proc_requests

Overview

IEM_ARCH_PVT is a private PL/SQL package in the APPS schema that implements the core archiving engine for Oracle E-Business Suite's Email Center (Interaction/Email Management) module. Its business function is to manage the lifecycle of email archiving requests: creating a request record, executing the archiving work that moves email messages and their folders into archive storage, and canceling requests that are no longer required. The package is classified as PVT (private), meaning it is not a published public API and is intended for internal consumption by other Email Center components rather than for direct customer extension. The header comment ($Header: iemarcps.pls 120.2 2005/10/11) indicates the package has been stable since the early 12.x code line and remains present in both 12.1.1 and 12.2.2.

Key Procedures and Functions

• SUBMIT_REQUEST — Creates a new archiving request. It accepts API framework parameters (p_api_version_number, p_init_msg_list, p_commit), a message identifier list, a folder, an email account ID, search criteria, and a request type, and returns the new request ID along with standard return status, message count, and message data outputs. The header documentation describes it as allowing submission of a request for archiving.
• PROCESS_REQUEST — Starts the actual archiving process. It takes the API framework parameters plus a request ID and request type, and returns the standard x_return_status, x_msg_count, and x_msg_data outputs. It is the worker procedure that performs the archive operation against the identified request.
• CANCEL_REQUEST — Cancels an existing archiving request. This is the procedure most relevant to the "cancel_request" search; it allows a pending or in-progress archive request to be terminated so that it is not processed further.
• GET_FOLDER_DTL — Retrieves details for an email folder, supporting the archive scope determination used by the submit and process procedures.
• PROC_REQUESTS — Processes pending archive requests, typically invoked as a batch step to walk outstanding requests and hand them to PROCESS_REQUEST.
• CREATE_MLCS — Creates multi-language/context support records associated with the archive data, ensuring the archived email content is stored with the correct language and message context.

Tables Accessed

• IEM_ARCH_REQUESTS and IEM_ARCH_REQUESTS_S1 — the primary request header table and its sequence; SUBMIT_REQUEST inserts here, CANCEL_REQUEST updates status, and PROCESS_REQUEST/PROC_REQUESTS read and update it.
• IEM_ARCH_MSGS, IEM_ARCH_MSGDTLS, and IEM_ARCH_MSGDTLS-related IEM_ARCH_MSGDTLS — capture the archived message headers and their detail rows.
• IEM_ARCHIVED_FOLDERS and IEM_ARCHIVED_DTLS — hold the archived folder definitions and the archived detail records produced when messages are moved to archive storage.
• IEM_EMAIL_ACCOUNTS — provides the email account context (p_email_account_id) used to scope which mailbox is archived.
• DUAL and PLITBLM — used for simple single-row selection and for the PL/SQL table/list handling of the message ID collection parameter (jtf_varchar2_Table_100).

Usage Notes

Because IEM_ARCH_PVT is a private package, it is not intended to be called directly from customer code or Oracle Forms. It is normally invoked by the Email Center archiving concurrent programs (which call PROC_REQUESTS/SUBMIT_REQUEST to queue work and PROCESS_REQUEST to execute it) and by the Email Center administrative UI when a user initiates or cancels an archive operation. The CANCEL_REQUEST procedure is reached when an administrator aborts a pending archive job. In 12.2.2 the package remains unchanged in behavior relative to 12.1.1, and since it is referenced by zero other documented packages, any dependency on it is through the Email Center application layer rather than through a published API surface.