Search Results execute_query

Overview

ICX_AK_JAVA_QUERY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. Its role is to support the Java-based rendering of Oracle Application Framework-style query regions within the iProcurement and Internet Computing Architecture (ICX) self-service stack. The package acts as the server-side bridge between a region definition and the Java query engine that displays, sorts, and paginates result sets on a web page. It was originally shipped as part of the ICX Applications Kit (AK) region infrastructure and, as indicated by its header comment (ICXAKJQS.pls, version 115.4), has been stable in the code line for well over two decades, carried forward into EBS 12.1.1 and 12.2.2 without functional redesign.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, and it is not referenced by any other documented package, which confirms its role as a leaf-level utility invoked directly by web-tier or form-tier logic.

Key Procedures and Functions

Four procedures are documented in the package specification:

• EXECUTE_QUERY — The central entry point. It accepts region identity, a WHERE clause, an ORDER BY clause, and a time/context token, then executes the assembled query on behalf of the Java region. This is the procedure corresponding to the user search term "execute_query."
• GET_ITEM — Retrieves descriptive metadata for a single item within a query region, returning attributes such as the attribute code, value identifier, label, display sequence, object/attribute flags, node display flag, and display length. It drives how individual columns are labelled and ordered on the rendered page.
• GET_RESULT_ROW — Returns the contents of a specified result row as a character table, enabling the Java layer to emit a page of query results without issuing a separate SQL round trip per column.
• UPDATE_OC_KIDS — Performs maintenance of grouped child records ("kids") associated with a given group identifier, supporting hierarchical or grouped display structures in the region.

Tables Accessed

The package references the APPS synonyms HTP and PLITBLM. HTP is the PL/SQL HTML toolkit used to generate markup fragments for the query region, indicating that the package contributes to the HTML output stream delivered to the browser. PLITBLM is a PL/SQL table type used to hold collections of strings, consistent with the icx_util.char240_table structure returned by GET_RESULT_ROW. Both are accessed through APPS synonyms, so the effective objects reside in the standard EBS technology stack rather than in application data tables; the package does not, per the documented metadata, persist business data of its own.

Usage Notes

ICX_AK_JAVA_QUERY is an internal infrastructure package rather than a published integration API. It is normally invoked indirectly: a Java query region rendered by the ICX/AK framework calls EXECUTE_QUERY to populate a session-scoped result set, then iterates GET_ITEM for column metadata and GET_RESULT_ROW for row data as the user pages through results. UPDATE_OC_KIDS supports grouping refresh. Because it is undocumented for customer use and is not referenced by other packages, direct invocation from custom code, concurrent programs, or forms personalizations is not recommended. Any custom call should be treated as unsupported, particularly given that the WHERE and ORDER BY clauses are passed as literal strings and must be validated by the caller. In 12.2.2 the package remains a supporting element of the OAF/iProcurement web stack rather than a data-access API.