Search Results po_attribute_values_s




Overview
Explore in AI Chat

Overview

APPS.PO_ATTRIBUTE_VALUES_PVT is a private PL/SQL package body within the Oracle E-Business Suite Purchasing (PO) module. It manages the storage, retrieval, translation, and transfer of descriptive flexfield attribute values associated with purchasing documents such as purchase orders, lines, requisitions, and auctions. Attribute values captured in the Purchasing forms are persisted through this package into the base attribute values table and its translated counterpart, ensuring multi-language support and consistency across document types.

The package acts as a private implementation layer: it is not referenced by any other database object, and its procedures are invoked internally by public Purchasing packages and interfaces. It reconciles attribute data originating from user entry, supplier interfaces, auction interfaces, and requisition sources, thereby providing a single point of control for attribute persistence across the procurement lifecycle.

Key Procedures and Functions

Tables Accessed

The package reads and writes PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP, its primary storage objects. It joins to PO_LINES, PO_LINES_ALL, PO_REQEXPRESS_LINES_ALL, and PO_REQUISITION_LINES_ALL to associate attributes with their parent documents. Interface processing depends on PON_ATTRIBUTES_INTERFACE, PON_AUC_ITEMS_INTERFACE, PO_ATTR_VALUES_INTERFACE, and PO_ATTR_VALUES_TLP_INTERFACE, together with PON_AUCTION_ITEM_PRICES_ALL. Item context is derived from MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL, MTL_PARAMETERS, and related views. Language and profile behavior are governed by FND_LANGUAGES, FND_PROFILE_OPTION_VALUES, FINANCIALS_SYSTEM_PARAMETERS, and FINANCIALS_SYSTEM_PARAMS_ALL.

Usage Notes

This package is invoked indirectly through Purchasing forms, the Purchasing Documents Open Interface, auction and requisition import programs, and internal public APIs such as the PO attribute values public package. It is not intended for direct invocation by customer extensions; the presence of the _PVT suffix confirms private API classification. Custom code requiring attribute persistence should call supported public APIs. Because the package references FND_GLOBAL and PO_LOG, it respects session context and supports diagnostic logging during concurrent processing and multi-language operations.