Search Results varchar_table

Overview

APPS.ICX_ITEM_DIAG_GRP is a diagnostic group package belonging to the Internet Computing Architecture (ICX) product family within Oracle E-Business Suite. Its primary business function is to perform item-related diagnostic and validation operations, most notably the mapping of items to purchasing categories. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package supports the diagnostics framework used by the EBS Diagnostic Tools (for example, the "Item Diagnostics" or "Purchasing Diagnostics" test suites), which administrators and support personnel run to verify configuration integrity and data consistency across the purchasing and item master modules.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. This design is consistent with diagnostic utilities that must respect the caller's security context and access restrictions. The package is classified as a GRP (group) API and references several low-level constructs, including DBMS_SQL, PO_SESSION_GT, DUAL, and PLITBLM, indicating that it both queries setup data and manages session-level diagnostic state.

Key Procedures and Functions

The documented interface exposes a single public procedure:

• START_THIS — The main entry point for the diagnostic group. It accepts standard diagnostic parameters (an error buffer and return code), an org_id identifying the operating unit or inventory organization, an action_code that determines which diagnostic action is performed, an optional source_ids parameter, and an optional auto_map_category parameter. Its purpose is to orchestrate the diagnostic process, invoking the underlying item and category checks and returning status through the error buffer and return code. Because the metadata does not publish a parameter list beyond the declaration excerpt, only purpose and parameter categories are described here.

In addition to the public procedure, the package declares a user-defined collection type named VARCHAR_TABLE, defined as a table of DBMS_SQL.VARCHAR2_TABLE indexed by binary_integer. This type supports bulk handling of string values during diagnostic processing and is the reason the search term "varchar_table" surfaces this object.

Tables Accessed

The documented references for this package are DBMS_SQL, PO_SESSION_GT, DUAL, and PLITBLM. DBMS_SQL and DUAL are used for dynamic SQL execution and simple singleton queries, respectively. PO_SESSION_GT is a purchasing session global temporary table that stores transient diagnostic session data, such as the set of organizations or items under test. PLITBLM is a PL/SQL table management utility used for manipulating PL/SQL tables, which aligns with the VARCHAR_TABLE collection type declared in the package. Because APPS synonyms are used, the package reads and writes purchasing and diagnostic setup data through the standard APPS schema rather than direct object owners.

Usage Notes

ICX_ITEM_DIAG_GRP is typically invoked from the Oracle EBS Diagnostics user interface or from concurrent programs that execute diagnostic test suites. It may also be called from custom diagnostic wrappers or from the standard "Record and Play" / "Diagnostics" framework that passes the org_id, action_code, and related parameters. Because it is an APPS-owned GRP package, direct customization is not recommended; administrators should invoke it through the supported diagnostic interface. Its registration as referenced by one other package indicates it participates in a larger diagnostic dependency chain, so changes to its behavior can affect dependent diagnostic routines. In both 12.1.1 and 12.2.2, the package is distributed as part of the standard ICX code level and its header indicates a maintenance date of 2013, consistent with its status as a stable diagnostic utility.