Search Results icx_po_rcv_qty




Overview
Explore in AI Chat

Overview

ICX_PO_RCV_QTY is a small utility package owned by the APPS schema in Oracle E-Business Suite. Its purpose is to resolve the net received quantity associated with a purchasing or receiving transaction, expressed in the primary unit of measure. The package is part of the iProcurement / Internet Computing Architecture (ICX) module family, which supplies the self-service purchasing and receiving functionality layered over the Oracle Purchasing and Oracle Receiving core applications. In release 12.1.1 and 12.2.2 the package is classified as OTHER in the ETRM repository, indicating that it is an internal helper package rather than a public, formally versioned API. It declares AUTHID CURRENT_USER, so it executes with the privileges of the calling session and relies on the caller having access to the underlying receiving data.

Key Procedures and Functions

  • GET_NET_QTY — The single documented program unit in the package. It returns the net quantity for a given receiving transaction. The function accepts a parent transaction identifier and a primary quantity, and returns a NUMBER. The pragma restrict_references(get_net_qty, WNDS, RNPS, WNPS) assertion declares the function as free of writes to database state (WNDS), reads of packaged state (RNPS), and writes to packaged state (WNPS). This makes it safe to call from SQL statements, including within views and select lists, where side-effect-free and deterministic behaviour is required. The presence of this pragma is consistent with the function being used as an inline calculation helper in queries returning purchasing or receiving quantity information.

Tables Accessed

The package references RCV_TRANSACTIONS through an APPS synonym. RCV_TRANSACTIONS is the central table in Oracle Receiving, holding one row per receiving, delivery, return, or correction transaction. The function is expected to read transaction rows, identify the parent transaction supplied by the caller, and derive the net received quantity — that is, the quantity remaining after corrections and returns are netted against original receipts. Because the package is invoked with the caller's privileges, the effective access path resolves through the APPS synonym to the RCV schema object.

Usage Notes

The package is referenced by four other packages in the EBS code base, indicating that it is a shared low-level helper consumed by higher-level ICX and receiving logic rather than being called directly by end users. Typical invocation points include iProcurement receiving and confirmation pages, where the net quantity of a receipt must be displayed or validated before an onward transaction is permitted, and concurrent or batch processes that reconcile received quantities. Because GET_NET_QTY is pragma-restricted and returns a scalar value, custom code and extensions may safely embed it in SQL select lists, for example in reports or views that present net received quantities alongside purchase order lines. When customising or extending functionality in 12.1.1 or 12.2.2, developers should treat ICX_PO_RCV_QTY as an internal implementation detail: its signature is stable in the documented releases, but it is not a published API and should not be relied upon as a supported integration point where a formal Receiving or Purchasing API is available.