Results for “iem_text_pvt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IEM_TEXT_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a Private (PVT) API within the ETRM (Email Center / Interaction Management) module. Its purpose is to support the text-analysis and content-indexing capabilities of Oracle's interaction and email processing framework. The package acts as an internal engine for extracting, tokenizing, and storing textual content associated with messages, message parts, and intents. It integrates Oracle Text (CTXSYS) functionality — themes, tokens, and highlights — with the ETRM message store.
The package defines several SUBTYPEs and collection types that wrap Oracle Text document structures: THEME_TABLE (CTX_DOC.THEME_TAB), HIGHLIGHT_TABLE (CTX_DOC.HIGHLIGHT_TAB), TOKEN_TABLE (CTX_DOC.TOKEN_TAB), and a custom keyword_rec_type/keyword_rec_tbl for keyword-weight pairs. These types allow the package to return Oracle Text analysis results directly to calling ETRM routines. As a PVT package, it is not intended as a public integration point; it is called internally by other ETRM packages and concurrent processing logic.
Key Procedures and Functions
- GETTHEMES — Retrieves theme information for a given message and message part, returning results in a THEME_TABLE structure along with an error text.
- GETTOKENS — Extracts tokens for a specified message, part, and language, returning them in a TOKEN_TABLE.
- IEM_INSERT_TEXTS — Inserts text content (a CLOB) for a given language, returning a generated identifier and a status.
- GET_TOKENS — A variant token/theme extraction routine that operates on a passed-in text CLOB, keyed by type (theme or token) and language, returning a keyword_rec_tbl.
- IEM_GET_TOKENS — Extracts tokens from query and response text associated with an intent, returning separate token collections and a status.
- IEM_PROCESS_PARTS — Processes message parts for a message and message type in a given language, returning a status.
- RETRIEVE_DOC — Retrieves a document for a given intent, returning a status.
- RETRIEVE_TEXT — Retrieves the assembled text for a message, returning it as a varchar2 and a status.
Tables Accessed
The package reads and writes ETRM tables via APPS synonyms. IEM_MS_BASE_HEADERS, IEM_MS_MIMEMSGS, IEM_MS_MSGBODYS, and IEM_MS_MSGPARTS hold the message store — headers, MIME messages, bodies, and parts — which supply and receive the text being analyzed. IEM_IMT_TEXTS and IEM_IMT_KEYWORDS store extracted text and keyword/weight data produced by the token and theme routines. IEM_INTENT_DOCUMENTS and IEM_INTENT_DTLS hold intent-related documents and details used by RETRIEVE_DOC and IEM_GET_TOKENS. The package also references CTX_DOC (Oracle Text) and DBMS_LOB for LOB handling, DUAL for singleton queries, and PLITBLM as a PL/SQL table helper.
Usage Notes
Because IEM_TEXT_PVT is a private package, it is invoked indirectly through ETRM's public APIs and processing flows rather than called directly by customers or forms. It is typically exercised during email and interaction processing when message bodies and parts must be indexed or analyzed, when intents are matched against stored text, and when keywords and themes are persisted for search or classification. The presence of GET_TOKENS and GETTHEMES reflecting Oracle Text subtypes indicates the package depends on a valid Oracle Text (CTXSYS) installation. Custom development should avoid calling this package directly and instead rely on the public ETRM APIs that wrap it.
-
SYNONYM: APPS.IEM_IMT_TEXTS 12.2.2
-
SYNONYM: PUBLIC.CTX_DOC 12.2.2
-
PACKAGE: APPS.IEM_TEXT_PVT 12.1.1
-
SYNONYM: PUBLIC.CTX_DOC 12.1.1
-
SYNONYM: APPS.IEM_IMT_TEXTS 12.1.1
-
PACKAGE: APPS.IEM_TEXT_PVT 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.DBMS_LOB 12.1.1
-
SYNONYM: PUBLIC.DBMS_LOB 12.2.2