Search Results etrm_search




Overview
Explore in AI Chat

Overview

APPS.ETRM_SEARCH is a PL/SQL package belonging to the Oracle E-Business Suite eTRM (Oracle Applications repository browser and dependency report) utility set. The header comment in the package specification identifies it as part of an internal repository browser and dependency reporting tool authored by Peter Goldthorp in October 2001, with copyright spanning 2001 to 2014. Its purpose is to provide a searchable, browser-based interface over the Oracle EBS application object repository, allowing technical users to locate file definitions, object metadata, and related dependency information directly from within an EBS session.

The package is classified under API classification OTHER, meaning it is not a public, supported business API but rather an internal utility. It is not referenced by any other packages, which confirms its role as a top-level, user-facing search facility rather than a shared service consumed by other code.

Key Procedures and Functions

The documented package specification exposes three procedures:

  • SHOW_FILE — Accepts a file identifier and renders the content of the corresponding file. It is used to display the source or body of a repository object stored as a large object.
  • SEARCH — Accepts an optional search string and performs the repository lookup. This is the primary entry point for locating objects by name or keyword. The optional argument allows a default or unfiltered listing when no search term is supplied.
  • HELP — Displays usage or reference information for the package, guiding the user on available search behavior.

A commented-out function declaration (find_table) also appears in the specification, indicating a table lookup capability that was considered but not exposed in the current package interface.

Tables Accessed

The package operates against a set of EBS repository and framework tables, reached through APPS synonyms. FND_LOBS supplies the stored file bodies rendered by SHOW_FILE, while FND_TABLES, FND_VIEWS, and FND_COLUMNS provide the core repository metadata used to resolve and describe database objects. FND_HELP_DOCUMENTS and FND_PRODUCT_GROUPS supply documentation and application context, and FND_ETRM_SEARCH_TMP serves as a temporary staging structure for search results. DBA_OBJECTS is queried to validate and resolve database objects, and CATSEARCH supports the text-based search mechanism. Supporting packages and utilities referenced include DBMS_LOB for large-object handling, UTL_HTTP and OWA_COOKIE for the browser interaction layer, OWA_UTIL and HTP for HTML generation, and PLITBLM for list iteration.

Usage Notes

ETRM_SEARCH is invoked interactively rather than from concurrent programs or standard EBS forms. It is typically called from a browser-based session where the user submits a search term and the package returns matching repository objects, with SHOW_FILE used to drill into a specific object's definition. Because the package is classified as OTHER and is not referenced by other packages, it should be treated as an internal diagnostic and browsing aid. Custom code should not depend on its procedures, as they are not part of a supported public API. Its reliance on DBA_OBJECTS and Oracle Text (CATSEARCH) also implies that appropriate database privileges and text indexes must be available for full functionality.