Search Results unpack_wheresegment

Overview

APPS.ICX_ON_UTILITIES is a utility package within the Oracle E-Business Suite Oracle iStore / Oracle Applications Framework foundation layer. It supplies the low-level plumbing used by the AK (Application Kit) region and flow-page engine to translate application metadata into rendered HTML pages and Oracle Forms calls. In EBS 12.1.1 and 12.2.2 the package remains classified as an OTHER API under the APPS schema, and its header ($Header: ICXONUS.pls 120.0) indicates it is a long-standing, stable internal utility rather than a public, versioned interface. It is heavily reused: the ETRM metadata records that ICX_ON_UTILITIES is referenced by 26 other packages, confirming its role as a shared helper for self-service and framework-based pages.

The package provides two broad capabilities. First, it resolves and displays framework pages and regions (findPage, findForm, getRegions, displayPage, printRegions, printRegions2, formatText, formatData). Second, it parses structured metadata strings — including WHERE-clause fragments and parameter lists — to support dynamic cursor construction and parameter propagation (whereSegment, unpack_whereSegment, unpack_parameters, checkDate, buildOracleOnString, buildOracleOnString2). Collectively these routines let callers build runtime SQL, render regions, and pass user context between flow pages without each calling product re-implementing the logic.

Key Procedures and Functions

• findPage — Locates a flow page/region definition using flow, page and region application identifiers and codes, and prepares navigation, help and "new" URLs plus paging attributes.
• findForm — Resolves a region to an Oracle Forms invocation, accepting LOV mode, default title, paging and hidden-field parameters and supplying the target for the form call.
• getRegions — Retrieves the region set associated with a flow, used to drive subsequent rendering.
• displayPage — Renders the resolved page, emitting the HTML output for the current context.
• formatText — Applies formatting rules to text values before display.
• formatData — Formats data values according to framework conventions.
• whereSegment — Builds a WHERE-clause fragment from region/attribute metadata.
• unpack_whereSegment — Parses a previously packed WHERE-segment string back into its constituent parts.
• unpack_parameters — Decomposes a serialized parameter string into individual name/value pairs so callers can bind or re-emit them; this is the routine most often sought when diagnosing parameter-passing behavior between framework pages and forms.
• checkDate — Validates a date value, typically before it is embedded in dynamic SQL.
• buildOracleOnString / buildOracleOnString2 — Construct the Oracle "ON" (join/condition) clause text used in dynamic queries; the two variants accommodate different input shapes.
• printRegions / printRegions2 — Emit region HTML, with the second variant providing an alternate rendering path.

Tables Accessed

The package reads framework metadata primarily from the AK tables: AK_REGIONS, AK_REGION_ITEMS, AK_ATTRIBUTES, AK_OBJECT_ATTRIBUTES, AK_FLOW_PAGE_REGIONS, AK_FLOW_REGION_RELATIONS, AK_FOREIGN_KEYS and AK_EXCLUDED_ITEMS via APPS synonyms. Runtime state is held in ICX_CONTEXT_RESULTS_TEMP_S and ICX_PARAMETERS. Session and output handling uses DBMS_SESSION, DBMS_SQL, OWA_COOKIE and the HTF/HTP HTML-generation packages.

Usage Notes

ICX_ON_UTILITIES is an internal framework utility, not an end-user API, and Oracle does not document it for direct customer calls. It is invoked implicitly whenever AK-based self-service pages render or navigate, and its helpers (notably unpack_parameters, unpack_whereSegment and buildOracleOnString) are called by the 26 dependent packages that build dynamic SQL from framework metadata. Customizations should avoid overriding the package and instead rely on supported extension points; diagnostic work involving "unpack_parameters" should treat the parameter string format as internal and subject to change between releases.