Search Results icx_req_special_ord




Overview
Explore in AI Chat

Overview

ICX_REQ_SPECIAL_ORD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle iProcurement "Special Order" flow. Its role is to provide the server-side logic required when a requisitioner creates a non-catalog, free-form, or otherwise special requisition line and adds it to an iProcurement shopping cart. In this context, a "special order" is a requested item that is not held in a local inventory or published catalog, so the application must present a dedicated entry page, validate the request, and insert the resulting line into the requisition and cart structures. The package status is documented as VALID in both 12.1.1 and 12.2.2 metadata.

The package is classified under the ETRM API classification of OTHER rather than as a public or private API, indicating it is an internal implementation component of the iProcurement module (ICX). It exposes six documented program units and depends on the AK_QUERY_PKG framework package and the SYS.STANDARD package.

Key Procedures and Functions

The package contains six documented procedures, whose responsibilities are as follows:

  • SPECIAL_ORDER — The primary entry point that drives the special-order requisition flow, coordinating the request, validation, and cart insertion steps.
  • SPECIAL_ORDER_DISPLAY — Renders the user interface elements for the special-order page, producing the HTML required to capture item details from the requisitioner.
  • SPECIAL_ORDER_BUTTONS — Generates the control buttons (for example, add-to-cart and cancel style actions) presented on the special-order page.
  • ADD_ITEM_TO_CART — Adds a validated special-order item to the current iProcurement shopping cart, creating or updating the appropriate cart header and line records.
  • INSERT_ORDER_TO_CART_LINE — Performs the low-level insertion of the order data into the shopping cart line table, persisting the requested item attributes.
  • CHK_VENDOR_ON — Evaluates whether vendor-related processing is enabled or applicable for the requisition, based on system parameters.

Because the underlying metadata lists only program unit names, no parameter signatures are asserted here.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

Usage Notes

ICX_REQ_SPECIAL_ORD is invoked internally by the iProcurement application when a user selects the special-order or non-catalog requisition option. It is not designed for direct invocation by customer code, and the ETRM metadata records zero packages depending on it externally. The presence of the HTF, HTP, OWA_UTIL, and PLITBLM dependencies confirms that it is a web-rendering package executed within the Oracle Application Framework or the older iProcurement web toolkit stack rather than a batch concurrent program. Customization should be avoided; the recommended integration point for similar requisition functionality remains the supported iProcurement and Purchasing APIs.