Search Results ic_parent

Overview

ICX_REQ_NAVIGATION is an Oracle Application Object Library (APPS) PL/SQL package that supports the Oracle iProcurement requisitioning flow in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented API classification is OTHER, meaning it is not a formally published open interface but an internal utility package used by the iProcurement storefront and checkout pages. In practical terms, the package encapsulates the navigation, session-context, and cart-related logic that drives the Requisition Express and full requisition pages presented to shoppers. It supplies page-level behavior such as shopper information retrieval, welcome page rendering, vendor validation, frame and parent URL construction, currency resolution, warning messages, and the transfer of a requisition back into the shopping cart.

The package is marked VALID in the ETRM repository and depends on SYS.STANDARD. It is referenced by eight other APPS packages, indicating it acts as a shared service layer rather than a standalone process.

Key Procedures and Functions

The ETRM documentation identifies nine procedures and functions within ICX_REQ_NAVIGATION:

• SHOPPER_INFO — Retrieves and returns the profile and contextual information for the current iProcurement shopper, used to personalize requisition pages.
• REQS_WELCOME_PAGE — Controls rendering/behavior of the requisition welcome page presented to the shopper.
• CHK_VENDOR_ON — Checks whether the vendor (supplier) related feature or flag is enabled, gating vendor-dependent logic on the requisition page.
• TOP_FRAME — Manages the top frame content or navigation context for the requisition user interface.
• IC_PARENT — Resolves or returns the parent context used by the iProcurement navigation hierarchy.
• ADDURL — Constructs or appends a URL used to redirect the shopper to the appropriate page or function.
• GET_CURRENCY — Determines the applicable currency for the requisition/cart context.
• GIVEWARNING — Issues a warning message to the shopper (for example, validation or confirmation messages).
• COPY_REQ_TO_CART — Copies an existing requisition into the shopping cart, enabling re-use or re-ordering of a prior requisition.

Parameter lists are not published in the ETRM extract and should be confirmed from the package specification in the database.

Tables Accessed

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

• ICX_SHOPPING_CARTS, ICX_SHOPPING_CART_LINES — the iProcurement shopping cart header and lines, central to COPY_REQ_TO_CART.
• ICX_CART_DISTRIBUTIONS, ICX_CART_DISTRIBUTIONS_S, ICX_CART_LINE_DISTRIBUTIONS, ICX_CART_LINE_DISTRIBUTIONS_S — cart-level and line-level accounting distributions.
• PO_REQEXPRESS_HEADERS, PO_REQUISITION_HEADERS, PO_REQUISITION_HEADERS_S, PO_REQUISITION_LINES, PO_REQUISITION_LINES_S, PO_REQ_DISTRIBUTIONS — purchasing requisition header, line, and distribution data used when building or copying requisitions.
• MTL_SYSTEM_ITEMS_KFV — item key-flexfield view for item validation and description display.
• FND_CURRENCIES — currency definition, supporting GET_CURRENCY.
• FINANCIALS_SYSTEM_PARAMETERS — ledger/system parameter context for the operating unit.

Usage Notes

ICX_REQ_NAVIGATION is typically invoked indirectly by the iProcurement JSP/HTML pages and by other APPS packages rather than called directly from custom code. The ETRM dependency listing shows it is referenced by ICX_REQ_ACCT_DIST, ICX_REQ_CATEGORIES, ICX_REQ_COPY_REQ, ICX_REQ_NAVIGATION itself, ICX_REQ_ORDER, ICX_REQ_SEARCH, ICX_REQ_SPECIAL_ORD, ICX_REQ_SUBMIT, and ICX_REQ_TEMPLATES. Customizations should treat it as an internal, unsupported utility; Oracle recommends using documented iProcurement APIs instead. Any direct calls risk breakage across patches and releases.