Search Results pos_complex_work_pvt




Overview
Explore in AI Chat

Overview

POS_COMPLEX_WORK_PVT is a private PL/SQL package body in the APPS schema of Oracle E-Business Suite, classified under the PVT (private) API category. It forms part of the Purchasing (PO) module's internal infrastructure and is designed to support complex work calculations associated with purchasing activity. The package provides the backend logic required to derive monetary and quantity figures from purchase orders, their lines, shipments, and receiving records. Its name and dependency profile indicate that it is not intended as a public interface; rather, it is a supporting utility invoked by other Purchasing or Advanced Pricing modules that require aggregated PO amount information. Because the package is classified as PVT and is not referenced by any other database object according to the ETRM metadata, it functions as a subordinate component in the broader Purchasing security and amount-derivation framework. In EBS 12.1.1 and 12.2.2, such private packages frequently underpin the Complex Work (also referred to as complex purchase order) functionality, where goods and services are procured against multiple occurrences or delivery schedules and require consolidated amount computation.

Key Procedures and Functions

The package body exposes three documented program units, all oriented toward retrieving purchase order monetary data:

  • GET_PO_AMOUNTS — Retrieves the overall amount values associated with a purchase order header, consolidating information across the order's constituent lines and schedules. This is typically the top-level entry point for amount derivation.
  • GET_PO_LINE_AMOUNTS — Returns the amount information specific to individual purchase order lines, used when a calling program needs line-level rather than header-level aggregation.
  • GET_PO_SHIP_AMOUNTS — Extracts amount values at the shipment or schedule level, corresponding to the line location records that define delivery details for a purchase order line.

Each routine is designed to be called by higher-level Purchasing logic that needs accurate, consistent amount figures. No parameter lists are documented, and the procedures are intended for internal use rather than direct invocation.

Tables Accessed

The package reads from four documented tables via APPS synonyms:

  • PO_LINES_ARCHIVE_ALL — The archived counterpart of purchase order lines, consulted to include historical line data in amount calculations.
  • PO_LINE_LOCATIONS_ALL — The live table holding shipment and schedule information for PO lines, which supplies shipment-level quantities and prices.
  • PO_LINE_LOCATIONS_ARCHIVE_ALL — The archived version of line locations, used to factor historical shipment data into complex work computations.
  • RCV_SHIPMENT_LINES — Receiving shipment lines, providing information about goods actually received against purchase orders.

The combination of live and archive tables indicates that the package supports both current and historical procurement scenarios.

Usage Notes

As a PVT-classified package with no inbound dependencies, POS_COMPLEX_WORK_PVT is not exposed for direct customer invocation. It is invoked internally by Purchasing forms, concurrent programs, or dependent private packages that require PO amount aggregation for complex work scenarios. Developers performing diagnostics or extensions in the Purchasing module may encounter this package when tracing how PO amounts are computed. Because it is private and undocumented as a public API, it should not be referenced directly in custom code; any custom requirement for PO amounts should use supported public APIs instead.