Search Results icx_text_s

Overview

APPS.ICX_CALL is a foundational PL/SQL package body within the Oracle E-Business Suite Internet Computing Architecture (ICX) product family. It provides the low-level cryptographic, encoding, and session-support utilities that the ICX connectivity layer relies upon to secure and manage self-service session traffic. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is documented as VALID. Its responsibilities center on symmetric encryption and decryption of session data, generation of a cyclic-redundancy hash, and URL-safe encoding and decoding of parameters passed between the application tier and the browser.

The object is heavily depended upon rather than a top-level entry point: the ETRM dependency record shows APPS.ICX_CALL is referenced by 61 other packages while it itself is not referenced by any database object. This position confirms its role as an internal service package supporting the ICX framework, security routines, and transaction handling.

Key Procedures and Functions

The documented package exposes eleven procedures and functions, falling into three functional groups:

• ENCRYPT, ENCRYPT2, ENCRYPT3, ENCRYPT4 — a family of encryption routines offering variant cipher behaviour. These transform plaintext session values into protected, non-readable form before transmission or storage.
• DECRYPT, DECRYPT2, DECRYPT3, DECRYPT4 — the inverse operations corresponding to the four encryption variants, restoring encrypted payloads to their original plaintext for use by the ICX runtime.
• CRCHASH — computes a cyclic redundancy check hash, used to validate the integrity of session parameters and detect tampering or corruption.
• ENCODE_URL and DECODE_URL — convert special characters into and out of URL-encoded form so that session tokens and parameters survive transport through HTTP query strings and cookies.

The multiple encrypt/decrypt variants allow the package to support different key derivation or obfuscation schemes without altering its public interface.

Tables Accessed

ICX_CALL operates primarily on in-memory values, but its documented dependencies include several ICX tables and utilities:

• ICX_SESSIONS — the core session registry; encryption and hashing routines support secure session identifier handling.
• ICX_TEXT and ICX_TEXT_S — message and text lookup tables. ICX_TEXT_S, the search term supplied by the user, is accessed here in the context of ICX_CALL's dependency graph.
• ICX_TRANSACTIONS — transaction tracking used by the ICX layer for stateful request processing.

The package additionally depends on DBMS_OBFUSCATION_TOOLKIT and UTL_RAW for cryptographic primitives and raw byte manipulation, OWA_COOKIE for browser cookie handling, UTL_URL for URL syntax processing, and FND_PROFILE, FND_SESSION_UTILITIES, ICX_SEC and ICX_SESSIONS for profile, session and security context.

Usage Notes

ICX_CALL is invoked indirectly by ICX framework code rather than called directly from forms or concurrent programs. Because 61 packages depend on it, any modification carries broad regression risk and should be treated as a core security component. Customisations should never bypass ICX_CALL's encryption or hashing routines, since downstream ICX_SEC and session validation logic assume the formats produced here. During patching or cloning, a VALID status and an intact dependency chain must be preserved, as an invalidated body will cascade failures across the ICX self-service stack.