Results for “highlight_table”

10 results




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

Overview

IEM_IM_WRAPPERS_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Interaction Center / Email Center (IEM) product family. Its declared purpose is to wrap the native Internet Messaging (IM) APIs so that higher-level IEM components can retrieve message content, themes, highlights, headers, and attachments from the underlying messaging store without calling the IM layer directly. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the defining user, which is consistent with a shared internal wrapper intended to be invoked from other APPS-owned packages and Oracle Forms-based Email Center screens.

The package exposes several PL/SQL collection types — theme_rec/theme_table, highlight_rec/highlight_table, header_record/header_table, att_record/att_table, and msg_record/msg_record_table — that model the structured output of message interrogation: themes with weights, highlight offset/length pairs, header name/value pairs, attachment metadata, and a full message record including sender, recipients, subject, priority, folder path, and SMTP message identifiers. The header comment records the shipped version as 115.3, dated 2002/12/03.

Key Procedures and Functions

  • GETTHEMES — Returns a table of themes (theme_table) associated with a given message and message part, accepting flag and link inputs and returning an error text out parameter.
  • GETHIGHLIGHT — Returns a table of highlight records (highlight_table) representing offset and length spans within a message part, matched against a supplied text query.
  • GETPARTLIST — Returns the list of message parts as an attachment table (att_table), providing part number, content type, binary flag, size, and attachment name.
  • GETEXTENDEDHDRS — Returns extended message headers as a header table (header_table) of name/value pairs.
  • OPENFOLDER — Opens a messaging folder by name so that subsequent message retrieval calls operate against that folder context.
  • OPENFOLDERNEW — A companion folder-opening routine, documented alongside OPENFOLDER, providing the same logical operation against the current IM API surface.

Tables Accessed

According to the ETRM metadata, the only documented table referenced by this package through APPS synonyms is DUAL. This is consistent with a pure wrapper package: it does not persist application data itself but delegates to the underlying Internet Messaging server APIs and PL/SQL layer. No application tables such as IEM_* or FND_* tables are documented as directly accessed by this package.

Usage Notes

Because the API classification is PVT (private), IEM_IM_WRAPPERS_PVT is not intended for direct customer invocation. It is referenced by two other packages in the APPS schema, which are the documented entry points for Email Center message processing. Custom code should call those public wrappers rather than this package. In Oracle EBS 12.1.1 and 12.2.2 the package remains resident in the APPS schema and is compiled as part of the IEM product installation.

Regarding the originating search phrase (“word install pannama epdi panna”), the answer in Oracle EBS terms is that this package is not installed manually. It is delivered and compiled automatically when the Oracle Email Center / Interaction Center product is applied through Rapid Install or patching (ADOP in 12.2.2, adpatch in 12.1.1). Installation verification consists of confirming that IEM_IM_WRAPPERS_PVT is VALID in ALL_OBJECTS and that its dependent public packages compile successfully; no separate setup step is required.