Search Results delete_item

Overview

IEM_INTENT_DOCS_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Email Center (IEM) module's management of account intent documents. In EBS 12.1.1 and 12.2.2, the Email Center uses intent documents to associate inbound or outbound email activity with a classification and an email account, thereby recording the customer's intent or query intent for a given interaction. This package provides the low-level data manipulation routines that create and remove records in the intent document repository.

The package is declared with AUTHID CURRENT_USER, meaning that its database operations execute under the privileges of the invoking user rather than the package owner, a design choice consistent with private APIs that are intended to be called from within the Email Center's own internal code base. As a PVT-class package, it is not part of the public, supported API surface; it is an internal implementation layer invoked by higher-level Email Center components.

Key Procedures and Functions

The documented package exposes two procedures:

• CREATE_ITEM — Inserts a record into the IEM_ACCOUNT_INTENT_DOCS table. It accepts a classification identifier, an email account identifier, and a query response value as inputs, and returns a generated document sequence number together with a return status. The procedure effectively registers an intent document that links a classification to a specific email account for the supplied query response.
• DELETE_ITEM — Removes a record from IEM_ACCOUNT_INTENT_DOCS. It takes an account intent document identifier as its single input and returns a status value indicating success or failure. This is the routine relevant to the user's search for "delete_item," and it represents the supported internal mechanism for purging an intent document row by its primary identifier.

Both procedures follow the standard Oracle EBS private API convention of returning an x_return_status OUT parameter to signal execution outcome. Neither procedure performs its own commit; callers are responsible for transaction control.

Tables Accessed

The package operates against the following objects, accessed through APPS synonyms:

• IEM_ACCOUNT_INTENT_DOCS — The primary transactional table storing account intent documents. CREATE_ITEM inserts into it and DELETE_ITEM deletes from it.
• IEM_ACCOUNT_INTENT_DOCS_S1 — A sequence used to generate the document sequence number returned by CREATE_ITEM, ensuring unique identifiers for each intent document.
• DUAL — The standard Oracle single-row utility table, typically referenced for sequence value retrieval or simple selects within the package body.

All access occurs under APPS synonyms, so the package is decoupled from the physical schema location of the underlying tables.

Usage Notes

Because IEM_INTENT_DOCS_PVT is a private package, it is not documented as a public integration point and should not be called directly from customer extensions without risk. In practice it is invoked by the Oracle Email Center runtime and by one other dependent package that references it (the ETRM metadata records a single referencing package). DELETE_ITEM is called when an intent document must be purged, for example when an email interaction is reclassified, reset, or removed by administrative cleanup logic.

Typical invocation occurs from Email Center server-side PL/SQL logic rather than from a concurrent program or a client form directly. Callers must supply the account intent document identifier obtained from a prior CREATE_ITEM call or from the IEM_ACCOUNT_INTENT_DOCS table, and they must inspect x_return_status to detect failure. All transaction commits should be issued by the calling layer, not by this package.