Search Results submit_item

Overview

ICX_REQ_ORDER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the iProcurement (Internet Commerce Exchange) family of modules and is classified as an "OTHER" API rather than an officially supported public interface. Its principal responsibility is to support the self-service requisitioning workflow within iProcurement — specifically the online shopping cart and checkout experience that allows employees to build, review, modify, and submit purchase requisitions without direct access to the core Purchasing forms.

The package is heavily oriented toward presentation logic. Multiple procedures in the documented list reference HTF, HTP, OWA_UTIL, and PLITBLM, which are Oracle Web Toolkit and PL/SQL cartridge utilities used to generate and manipulate HTML dynamically. This confirms that ICX_REQ_ORDER functions as a server-side rendering and interaction engine for iProcurement web pages rather than as a pure data-manipulation API.

Key Procedures and Functions

The ETRM metadata documents thirteen procedures and functions. These include:

• MY_ORDER, MY_ORDER1, MY_ORDER2 — the primary entry points for rendering and processing the shopper's current requisition/cart. The numeric variants reflect successive code iterations retained across patch levels for backward compatibility.
• RESERVE_PO_NUM and GET_EMERGENCY_PO_NUM — handle purchase order number reservation and retrieval of emergency PO numbers for requisitions requiring immediate assignment.
• GET_CURRENCY — resolves currency information, drawing on FND_CURRENCIES, for cart line pricing and display.
• ADDURL, ADDATTACHMENTSCRIPT, GIVEWARNING — presentation-layer helpers that generate hyperlinks, inject attachment-handling JavaScript output, and produce user warning messages respectively.
• SUBMIT_ITEM, COPY_LINE, DELETE_LINE — cart manipulation routines that add an item to the requisition, duplicate an existing cart line, or remove a line.

The package body also contains internal SQL statements and references the SYS.STANDARD package. It is itself referenced by ICX_REQ_SUBMIT, indicating a layered design where submission logic delegates to this package.

Tables Accessed

Through APPS synonyms, ICX_REQ_ORDER reads and writes the following:

• ICX_SHOPPING_CARTS and ICX_SHOPPING_CART_LINES — the persistent shopping cart structures holding requisition header and line data prior to submission.
• ICX_CART_LINE_DISTRIBUTIONS and ICX_CART_LINE_DISTRIBUTIONS_S — charge-account and distribution information per cart line.
• ICX_REQ_CART_ERRORS — error staging for cart validation failures.
• PO_REQUISITION_LINES_S — the core Purchasing requisition line table written during submission/definition.
• PO_UNIQUE_IDENTIFIER_CONTROL — supports PO number reservation logic.
• FND_CURRENCIES and FINANCIALS_SYSTEM_PARAMETERS — currency and financials configuration lookups.
• AK_EXCLUDED_ITEMS — attribute/entity exclusions used by the framework.
• DUAL, HTF, HTP, OWA_UTIL, PLITBLM — utility and web toolkit objects for expression evaluation and HTML output.

Usage Notes

ICX_REQ_ORDER is an internal, unsupported package. Because it is classified as OTHER and exposes no formally documented public API, it is invoked almost exclusively by Oracle's own iProcurement Java/HTML pages and by neighboring packages such as ICX_REQ_SUBMIT. It should not be called directly from custom concurrent programs or forms, since signatures and behavior may change without notice during patching. Customers requiring integration should use supported requisition APIs (for example, PO_REQUISITION_* interfaces or the iProcurement public APIs) rather than this rendering-layer package.