Search Results pv_attribute_pkg




Overview
Explore in AI Chat

Overview

PV_ATTRIBUTE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the low-level data access layer for the attribute definitions used by Oracle Process Manufacturing (OPM) Product Development and, more broadly, the Process Manufacturing attribute framework. In EBS 12.1.1 and 12.2.2, attributes are the configurable, user-defined characteristics that can be attached to items, batches, specifications, and quality results. The package encapsulates the insert, update, delete, and translation logic required to maintain these attribute definitions consistently across the underlying base and translation tables.

The package is classified as an OTHER API in the ETRM repository and is marked VALID. It exposes nine documented program units and is referenced by one other package, PV_ATTRIBUTE_PVT, which is the private implementation package that typically layers business rules and validation on top of the raw row operations. PV_ATTRIBUTE_PKG therefore functions as the persistence utility layer rather than the public business API.

Key Procedures and Functions

The nine documented program units cover the full lifecycle of attribute definition maintenance:

  • INSERT_ROW — creates a new attribute definition by inserting a row into the base attribute table.
  • UPDATE_ROW — modifies an existing, non-seeded attribute definition.
  • UPDATE_ROW_SEED — updates a seeded (Oracle-delivered) attribute definition, applying the rules applicable to seed data.
  • DELETE_ROW — removes an attribute definition from the base table.
  • LOCK_ROW — acquires a row-level lock on an attribute before update, supporting concurrency control in multi-user environments.
  • ADD_LANGUAGE — inserts the translatable (TL) rows required so that an attribute can be presented in an additional installed language.
  • TRANSLATE_ROW — updates the translated descriptive columns of an attribute for the current language.
  • LOAD_ROW — loads a customer-defined attribute definition, typically as part of a data migration or setup load.
  • LOAD_SEED_ROW — loads an Oracle-seeded attribute definition, preserving seed ownership and translation behavior.

No parameter lists are documented in the ETRM extract; parameter signatures should be obtained from the package specification in the database.

Tables Accessed

The package accesses three tables through APPS synonyms:

  • PV_ATTRIBUTES_B — the base table holding the language-independent attribute definition rows. This is the primary target of INSERT_ROW, UPDATE_ROW, UPDATE_ROW_SEED, DELETE_ROW, LOCK_ROW, LOAD_ROW, and LOAD_SEED_ROW.
  • PV_ATTRIBUTES_TL — the translation table holding language-specific attribute text. This is written by ADD_LANGUAGE and TRANSLATE_ROW.
  • FND_LANGUAGES — the Oracle Applications language repository, consulted to validate the language codes used when adding or translating attribute rows.

Usage Notes

PV_ATTRIBUTE_PKG is not intended for direct invocation by end users. It is normally called indirectly through PV_ATTRIBUTE_PVT, which supplies the business validation and defaulting logic, and from the OPM Product Development setup forms and concurrent programs that maintain attribute definitions. Direct calls are also made by installation, upgrade, and seed-data loading scripts, which use LOAD_SEED_ROW and UPDATE_ROW_SEED to install Oracle-delivered attributes and ADD_LANGUAGE or TRANSLATE_ROW to populate translations for newly installed languages.

The package depends on FND_API and the STANDARD PL/SQL package, consistent with Oracle's API conventions. Because it performs unguarded row operations, customizations should invoke it through PV_ATTRIBUTE_PVT rather than directly, and any direct use should be preceded by LOCK_ROW to avoid lost updates in concurrent sessions. Its presence in both 12.1.1 and 12.2.2 confirms that the attribute framework's data access layer remained stable across these releases.