Search Results icx_catg




Overview
Explore in AI Chat

Overview

ICX_CATG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite. In the ETRM 12.2.2 metadata, the package is classified under the API classification "OTHER," indicating that it is not one of the transactional or business-object APIs that EBS exposes for standard integration use. The package header carries a source control identifier of "ICXSTDCS.pls," a naming convention that associates it with the ICX (Oracle iProcurement / Internet Computing Architecture) product family. Given that the single exposed routine renders database content as HTML through the Oracle Web Toolkit, ICX_CATG functions as an internal utility for generating browser-rendered output rather than as a business-process engine. It is therefore best understood as a presentation-support routine embedded in the APPS schema, typically invoked indirectly by iProcurement or self-service pages rather than called from application workflows.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure for this package:

  • XLS — The sole documented entry point. Its name and the package's inclusion of the HTP and OWA_UTIL dependencies indicate that XLS produces an HTML presentation of query results, most likely by iterating over a result set and emitting markup tags to the browser. The procedure accepts a single p_where parameter, a VARCHAR2 filter clause that constrains the rows included in the generated output. This signature is consistent with a generic, ad hoc reporting helper that allows a caller to pass a dynamic predicate and receive formatted HTML in return. No other parameters, return values, or overloads are documented.

Tables Accessed

No base application tables are documented against ICX_CATG. The metadata lists the package's direct dependencies as HTP, OWA_UTIL, and PLITBLM. HTP and OWA_UTIL are the Oracle Web Toolkit PL/SQL packages used to emit HTML tags, escape special characters, and format HTTP output. PLITBLM is the PL/SQL implementation of the DBMS_LOB subset, providing large-object handling primitives such as reading and writing CLOB data. This dependency profile indicates that XLS retrieves data through dynamic SQL constructed from the p_where argument and renders it as HTML, potentially assembling large output buffers via PLITBLM. Because table references are absent from the documented dependency list, the procedure is almost certainly table-agnostic and relies on the caller to supply a fully qualified query or predicate.

Usage Notes

The package is referenced by zero other packages in the ETRM metadata, confirming that it sits outside the standard dependency chain of EBS application code. It is not exposed as a concurrent program nor bound to a form in the documented metadata. Practical use is therefore limited to diagnostics and troubleshooting: a developer or DBA with APPS credentials can invoke ICX_CATG.XLS from SQL*Plus or another PL/SQL client, passing an appropriate WHERE clause, and capture the HTML output for inspection. Because the procedure accepts a dynamic filter, callers must ensure the predicate is a trusted, internally constructed string; an externally sourced p_where value could introduce SQL injection risk. This consideration reinforces the view that ICX_CATG is an internal, non-publicized utility rather than a supported integration interface. The package is present in both 12.1.1 and 12.2.2, and the ETRM documentation is identical for both releases.