Search Results catalog_items_display




Overview
Explore in AI Chat

Overview

The APPS.ICX_REQ_CATEGORIES package is a PL/SQL server-side component within the Oracle E-Business Suite Internet Computing Architecture (ICX) product family. Its principal business function is to support the presentation, navigation, and management of purchasing item categories within the Oracle iProcurement self-service requisitioning module. The package enables users to browse catalog category hierarchies and to build requisition lines from catalog items presented through the iProcurement storefront. It is classified as an OTHER API, indicating that it is an internal, non-public interface intended for use by Oracle's own forms, JSP pages, and dependent packages rather than as a formally supported extension point. The object resides in the APPS schema, holds a VALID status, and is composed of both a package specification and a package body.

Key Procedures and Functions

The ETRM documentation records seven procedures or functions within ICX_REQ_CATEGORIES:

  • GETCATEGORYTOP — Retrieves the top-level category node(s) in the category hierarchy, providing the starting point for catalog navigation.
  • CATEGORIES — Renders or returns the category listing for a given level of the hierarchy, driving the category browse interface.
  • GETCATEGORYCHILDREN — Returns the child categories of a specified parent category, enabling drill-down navigation through the category tree.
  • SUBMIT_ITEMS — Submits selected catalog items into the shopping cart, converting user selections into cart entries.
  • CATALOG_ITEMS — Retrieves the catalog items associated with a category, populating the item display for user selection.
  • CATALOG_ITEMS_DISPLAY — Formats and returns the HTML presentation of the catalog items for the storefront.
  • CATALOG_ITEMS_BUTTONS — Generates the action buttons (such as add-to-cart controls) associated with catalog items in the display.

Parameter lists are not documented in the available metadata and are not reproduced here.

Tables Accessed

The package references several tables through APPS synonyms. ICX_SHOPPING_CARTS and ICX_SHOPPING_CART_LINES hold the shopping cart header and line data that SUBMIT_ITEMS writes to when items are added. PO_REQUISITION_LINES_S stores requisition line detail, linking catalog selections to the purchasing requisition. ICX_PARAMETERS supplies configuration and session parameters governing catalog behavior, while AK_EXCLUDED_ITEMS supports item exclusion logic. DUAL is used for singleton queries, and the Web Toolkit packages HTF, HTP, and OWA_UTIL generate HTML output and handle URL escaping. PLITBLM is the PL/SQL table utility package commonly used for array manipulation.

Usage Notes

ICX_REQ_CATEGORIES is invoked primarily by the iProcurement storefront UI and by the dependent package ICX_REQ_NAVIGATION, which is documented as referencing it. The package also references ICX_OWA_PARMS, reflecting its integration with the Oracle Web Agent parameter-passing model used by iProcurement's HTML pages. Because the API classification is OTHER, it is not a published extension interface; custom code should avoid calling it directly. Its behavior is delivered through the standard iProcurement forms and JSP-based pages rather than through concurrent programs. Any analysis of dependency impact, patching, or invalidations involving iProcurement catalog navigation should account for the linkage between this package, ICX_REQ_NAVIGATION, and the shopping cart and requisition base tables it touches.