Search Results theme_based




Overview
Explore in AI Chat

Overview

IBC_CONTENT_SEARCH_PVT is a private PL/SQL package owned by APPS in the Oracle E-Business Suite. It belongs to the Oracle iStore / iContent (IBC) product family, which provides the content management and keyword search infrastructure used by EBS self-service storefronts and content repositories. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner — a design choice consistent with an internal utility package intended to be called from within the APPS schema context.

The central business function of IBC_CONTENT_SEARCH_PVT is to translate user-supplied search input into query strings that the underlying Oracle Text (interMedia) search engine can consume. It encapsulates the parsing and normalization logic that converts raw end-user keyword input into a syntactically valid search expression, supporting several distinct search modes. This package is a private (PVT) companion to the corresponding public API, and its types and shared constants are defined in the associated PUB package.

Key Procedures and Functions

Two functions are documented in the ETRM metadata:

  • BUILD_SIMPLE_TEXT_QUERY — Accepts a query string and a search option indicator and returns a VARCHAR2 containing a simple text search expression. It is intended for straightforward text-matching scenarios where minimal keyword transformation is required.
  • BUILD_KEYWORD_QUERY — Accepts a string and a search option and returns a VARCHAR2. This is the function targeted by the "build_keyword_query" search. It constructs a keyword-based query expression, applying the transformation rules dictated by the supplied search option constant so that the result is compatible with Oracle Text operators.

The package defines search option constants that govern both functions, including MATCH_ALL (0), MATCH_ANY (1), FUZZY (2), INTERMEDIA_SYNTAX (3), THEME_BASED (4), MATCH_ACCUM (5), and MATCH_PHRASE (7). Value 6 is reserved for match-by-id at the Java layer. Return status constants ERROR_STATUS (-1) and OKAY_STATUS (0) are also declared.

Tables Accessed

The ETRM metadata documents a single table reference via APPS synonyms: PLITBLM. This is the Oracle Text / interMedia auxiliary table used for thesaurus and linguistic processing support. Its presence is consistent with the package's role of preparing keyword strings for Oracle Text consumption, where linguistic and thesaurus expansion may be required.

Usage Notes

As a PVT-classified package, IBC_CONTENT_SEARCH_PVT is not intended for direct invocation by external or customer code. It is called internally by the public iContent search API and, in turn, by the index and search engine plumbing that serves iStore storefront search and content retrieval. The ETRM metadata records zero other packages referencing it directly, reflecting its role as a low-level helper rather than a broadly shared utility.

Because the source header carries the tag noship and revision 120.0 dated 2005, the package has remained stable across the 12.1.1 and 12.2.2 releases. It should be treated as an internal implementation detail; customizations that require search query construction should use the supported public search APIs rather than calling BUILD_KEYWORD_QUERY directly, since signature or behavior changes are not governed by a public API contract.