Search Results is_sps_distribution

Overview

APPS.PO_SHARED_PROC_PVT is an Oracle E-Business Suite private (PVT) PL/SQL package that centralizes shared processing logic used across the Oracle Purchasing and iProcurement modules. Its name — "shared procedures" — reflects its role as a common utility layer that multiple purchasing modules call rather than duplicate. The package was declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling schema, and the header comment ($Header: POXVSPSS.pls 120.0) indicates it originates from the Purchasing module source tree.

Functionally, the package supports cross-organizational (cross-OU) purchasing decisions, transaction flow validation, ship-to organization validation, item validity checks, and the derivation of chart of accounts and operating unit identifiers from inventory organization identifiers. These capabilities are essential for correctly modeling multi-organization procurement, where a requisitioning organization, purchasing organization, ship-to organization, and inventory organization may all differ.

Because the package is classified as PVT (private), it is not part of the officially supported public API surface. Oracle does not guarantee its signatures across releases, and it should not be treated as a published integration point.

Key Procedures and Functions

• CHECK_TRANSACTION_FLOW — Validates a proposed transaction flow between a start operating unit and an end operating unit, returning a transaction flow header identifier. It sits at the core of internal requisition and transfer flow logic.
• GET_COA_FROM_INV_ORG — Returns the chart of accounts identifier associated with a given inventory organization.
• GET_OU_AND_COA_FROM_INV_ORG — Returns both the operating unit and chart of accounts for an inventory organization, along with a return status.
• IS_SPS_DISTRIBUTION — Determines whether a distribution qualifies as a Supplier-Partnered-Supplier (SPS) distribution, evaluating destination type, document type, purchasing OU, project, and transaction flow context.
• IS_PA_PROJECT_REFERENCED — Indicates whether a requisition line references an Oracle Projects project.
• VALIDATE_CROSS_OU_PURCHASING — Validates a single cross-OU purchasing scenario (requisition line, requesting org, purchasing org, item, source document, VMI and consigned flags), returning status and error message.
• VALIDATE_CROSS_OU_TBL — Bulk counterpart to the above, operating on PO_TBL_NUMBER and PO_TBL_VARCHAR1 collections for set-based validation.
• CHECK_ITEM_IN_INVENTORY_ORG — Confirms an item is defined in a specific inventory organization.
• VALIDATE_SHIP_TO_ORG — Validates the ship-to organization for a purchasing document.
• IS_TXN_FLOW_SUPPORTED — Reports whether a given transaction flow configuration is supported.
• GET_INV_QUALIFIER_CODE — Retrieves the inventory qualifier code used in transaction flow resolution.
• DO_ITEM_VALIDITY_CHECKS — Performs consolidated item validity checks for purchasing.
• GET_LOGICAL_INV_ORG_ID — Returns the logical inventory organization identifier, typically used to resolve the logical organization context associated with a physical inventory organization.
• GET_PO_SETUP_PARAMETERS — Retrieves purchasing setup parameters from PO_SYSTEM_PARAMETERS_ALL.
• CHECK_ITEM_IN_LINV_POU — Validates an item within a logical inventory organization and purchasing operating unit context.

Tables Accessed

The package reads and writes several core EBS tables via APPS synonyms. FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL provide operating unit and ledger configuration. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION supply organization definitions and classification data. MTL_PARAMETERS and MTL_SYSTEM_ITEMS_B support inventory organization and item resolution, while MTL_ITEM_REVISIONS_B and MTL_TRANSACTION_FLOW_HEADERS/MTL_TRANSACTION_FLOW_LINES drive transaction flow validation. PO_REQUISITION_LINES_ALL, PO_REQ_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, and PO_SYSTEM_PARAMETERS_ALL cover purchasing document and setup data. HZ_LOCATIONS and FND_NEW_MESSAGES supply address data and error message text.

Usage Notes

PO_SHARED_PROC_PVT is invoked primarily by Oracle Purchasing forms, iProcurement, and internal requisition/transfer processing, and is referenced by approximately twelve other packages in the EBS codebase. Custom code should be cautious: as a PVT-classified package, its interfaces may change between releases and it is not a supported public API. Developers needing equivalent functionality should prefer documented public APIs or standard open interfaces. It is typically called during document validation and transaction flow resolution rather than as a standalone integration entry point.