Search Results ego_item_text_ctx_pkg




Overview
Explore in AI Chat

Overview

EGO_ITEM_TEXT_CTX_PKG is a PL/SQL package belonging to the Oracle E-Business Suite item master data model, residing in the CTXSYS schema (Oracle Text) in the ETRM metadata for Release 12.1.1 and 12.2.2. It is also documented under the APPS schema with the API classification OTHER, reflecting the EBS convention of exposing an APPS synonym that wraps the underlying implementation. The package provides the retrieval interface for long-description and attribute text associated with item definitions. In EBS, item text is stored as large character data and is frequently indexed for Oracle Text (interMedia) searching. This package acts as the access layer that resolves an item's text content and returns it to the calling application in the appropriate PL/SQL data type, decoupling the caller from the physical storage mechanism and from Oracle Text infrastructure internals. It is therefore a foundational utility for item search, item inquiry, and any feature that must surface descriptive item content.

Key Procedures and Functions

The documented interface exposes two retrieval routines:

  • GET_ITEM_TEXT_CLOB — Returns the item text as a CLOB. It is used when the full, unbounded text of an item description or attribute is required, such as in item detail display or when processing large text for search indexing.
  • GET_ITEM_TEXT_VARCHAR2 — Returns the item text as a VARCHAR2. It is used when the text fits within the SQL VARCHAR2 limit and the caller needs a scalar string for concatenation, display in a form field, or lightweight comparison.

Tables Accessed

The ETRM metadata records no explicitly documented base tables referenced through APPS synonyms for this object. Functionally, the package operates over the EGO item text storage structures — the EGO_ITEM_TEXT and related item description entities — and relies on Oracle Text (CTXSYS) infrastructure to resolve and return the requested text. Because it is owned by CTXSYS and referenced through APPS, the actual table reads are performed through the Oracle Text index and the EGO item text tables rather than through EBS public views. Any dependency on the underlying storage is encapsulated so that callers need not reference those tables directly.

Usage Notes

In 12.1.1 and 12.2.2, this package is invoked indirectly by the EGO item text APIs and by Oracle Text–based item search functionality. Application developers typically call the APPS-level synonym (APPS.EGO_ITEM_TEXT_CTX_PKG) rather than the CTXSYS implementation, allowing the EBS patch and upgrade process to manage the underlying code. It is not a standalone user-facing API and should not be called directly from custom concurrent programs unless the caller requires raw item text retrieval; standard item inquiry and search forms use the EGO API layer that ultimately delegates to this package. When extending item search or building custom item-text reports, callers should select the CLOB variant for full-text fidelity and the VARCHAR2 variant only when the text length is known to be within scalar limits, to avoid truncation or runtime errors.