Search Results c_where

Overview

ICX_ON_UTILITIES is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name and API surface indicate that it belongs to the Oracle iProcurement / Oracle Applications "One Navigator" (ICX) framework, which dynamically renders HTML pages for self-service flows. The package provides the runtime plumbing that translates Application Object Library (AK) region and page metadata into browser-renderable output, generates navigation forms, resolves and unpacks URL and WHERE-clause segments, and dispatches region content. It is a pure "OTHER" classified utility: it is not a business API that external integrations call directly, but rather an internal rendering engine consumed by the AK/ICX framework and by 26 other packaged callers within the EBS codebase.

Key Procedures and Functions

The documented API comprises eighteen procedures and functions. The central entry point is FINDPAGE, which accepts flow, page, and region identifiers, looks up the corresponding page or region title, sets a language-specific cookie, emits JavaScript and HTML headers, and then invokes FINDFORM to produce the driving form. FINDFORM completes the page skeleton. Collection routines GETREGIONS, PRINTREGIONS, and PRINTREGIONS2 enumerate and emit the regions associated with a flow or page. DISPLAYPAGE renders an assembled page, while FORMATTEXT and FORMATDATA format individual attributes and data values for display. On the query-parsing side, WHERESEGMENT extracts a WHERE fragment, UNPACK_WHERESEGMENT reverses that encoding, and UNPACK_PARAMETERS decodes parameter strings passed through the URL. BUILDORACLEONSTRING and BUILDORACLEONSTRING2 construct the Oracle "ON" query string used for dynamic drill-down navigation. CHECKDATE validates date inputs prior to query execution.

Tables Accessed

The package reads heavily from the AK metadata dictionary: AK_FLOW_PAGES_VL supplies page titles and primary region mappings, AK_REGIONS and AK_REGIONS_VL supply region names, AK_REGION_ITEMS and AK_OBJECT_ATTRIBUTES describe region columns, AK_FLOW_PAGE_REGIONS and AK_FLOW_REGION_RELATIONS define page/region structure and drill relationships, AK_ATTRIBUTES and AK_FOREIGN_KEYS drive attribute-level behavior and join generation, and AK_EXCLUDED_ITEMS filters out attributes that must not render. Runtime state is held in ICX_CONTEXT_RESULTS_TEMP_S (temporary query results) and ICX_PARAMETERS (framework configuration). It also leverages DBMS_SESSION and DBMS_SQL for dynamic cursor management, OWA_COOKIE for the cookie emitted in FINDPAGE, and HTF/HTP for HTML tag generation.

Usage Notes

ICX_ON_UTILITIES is invoked indirectly whenever a One Navigator or iProcurement page is rendered: the ICX/AK framework calls FINDPAGE and FINDFORM to construct the page, then relies on WHERESEGMENT and UNPACK_WHERESEGMENT to reconcile the query string carried on the URL (the "c_where" parameter familiar to developers debugging these pages). Because 26 other packages reference it, customizations should avoid modifying this body and should instead extend behavior through the documented AK metadata tables. Direct invocation from SQL*Plus or custom concurrent programs is possible but not supported, as the procedures depend on an active HTTP/OWA session for HTP output.