Search Results pv_entity_attrs_pkg




Overview
Explore in AI Chat

Overview

PV_ENTITY_ATTRS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that manages the metadata definitions stored in the PV_ENTITY_ATTRS table. This table forms part of the Oracle Product Information Management / Advanced Product Catalog data model, where entity attributes describe the configurable and descriptive characteristics attached to product entities. The package body provides the standard EBS "table handler" API pattern: a set of row-level DML operations (insert, update, lock, delete) together with seed data maintenance routines used during patching and data migration. As a VALID package body in release 12.1.1 and 12.2.2, it is registered in the ETRM repository with an API classification of OTHER, indicating it is an internal implementation utility rather than a formally published public interface. The package depends on APP_EXCEPTION, FND_API, and FND_MESSAGE, confirming that it follows Oracle Application Object Library error-handling conventions and raises messages through the standard FND message dictionary rather than raw SQL errors.

Key Procedures and Functions

The ETRM documentation records seven procedures or functions in this package body:

  • INSERT_ROW — Creates a new entity attribute definition row in PV_ENTITY_ATTRS, populating the columns required to describe an attribute and its association with a product entity.
  • LOCK_ROW — Acquires a row-level lock on an existing entity attribute record so that concurrent updates cannot corrupt the definition.
  • UPDATE_ROW — Modifies an existing entity attribute record, supporting the standard WHO columns and allowing selective column updates.
  • DELETE_ROW — Removes an entity attribute definition from PV_ENTITY_ATTRS.
  • UPDATE_SEED_ROW — Updates a seed (Oracle-delivered) row, applying changes supplied by a patch or seed data script while preserving the row's seed identity.
  • SEED_UPDATE_ROW — Performs the seed data refresh logic that reconciles an existing seeded record with the definition shipped in the current patch level.
  • LOAD_ROW — Inserts or updates a row as part of a bulk seed load, typically invoked from a concurrent program or installation script that populates PV_ENTITY_ATTRS from a data file.

Tables Accessed

The package operates against the APPS synonym PV_ENTITY_ATTRS, which resolves to the underlying entity attribute definition table in the product catalog schema. All seven procedures read or write this single table. INSERT_ROW, UPDATE_ROW, and DELETE_ROW perform the runtime maintenance of attribute definitions. LOCK_ROW issues the SELECT FOR UPDATE needed to serialise concurrent modifications. UPDATE_SEED_ROW, SEED_UPDATE_ROW, and LOAD_ROW are used when Oracle-supplied seed metadata must be applied or refreshed, and they compare the seeded values against the stored row before writing changes. Because the package references only this table, its scope is limited to entity attribute metadata and does not extend to the actual attribute values held against product entities.

Usage Notes

PV_ENTITY_ATTRS_PKG is not referenced by any other database object in the ETRM dependency listing, and the package itself is documented as being referenced by one other package. This indicates that it is invoked as a supporting utility rather than as a widely shared library. In practice it is called from Oracle Forms and OAF-based product catalog maintenance pages when users create or modify entity attribute definitions, and from concurrent programs or patch drivers that load seeded attribute metadata during upgrades and installations. Because the routines follow the FND_API and FND_MESSAGE conventions, errors surface through the standard message stack, and callers should therefore check the returned API status and inspect FND_MESSAGE output when a procedure reports failure. Customisations that need to manipulate entity attribute definitions directly should reuse these procedures instead of issuing direct DML against PV_ENTITY_ATTRS, since the package encapsulates the locking, WHO column maintenance, and seed-data reconciliation logic expected by the surrounding EBS components. Environments upgrading between 12.1.1 and 12.2.2 should treat the seed-related routines as patch-managed and avoid modifying them, as their behaviour is driven by Oracle-delivered seed data.