Search Results validate_attribute

Overview

APPS.PV_ATTRIBUTE_PVT is a private API package body in the Oracle E-Business Suite Process Manufacturing (OPM) product family, belonging to the PV (Process Value/Attribute) module. It encapsulates the business logic that governs how process attribute definitions are created, validated, modified, locked, and removed within the ETRM (Enterprise Transaction and Regulatory Management) schema. The package follows the Oracle EBS PL/SQL API architecture, exposing a private (PVT) layer that sits beneath the public attribute APIs and coordinates validation, message handling, and multi-table DML across the attribute definition tables. Status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented metadata lists seven procedures/functions within this package body:

• CREATE_ATTRIBUTE — Creates a new process attribute definition, orchestrating inserts into the base table and its associated translation and usage tables.
• UPDATE_ATTRIBUTE — Modifies an existing attribute definition, applying the same validation and translation handling used at creation.
• DELETE_ATTRIBUTE — Removes an attribute definition and its dependent rows (usages, responsibility mappings, translations, and entity-level references).
• LOCK_ATTRIBUTE — Applies locking semantics to an attribute record to prevent concurrent modification during transactional processing.
• VALIDATE_ATTRIBUTE — Performs attribute-level validation, returning success or error status via the FND_MSG_PUB messaging stack.
• CHECK_ATTRIBUTE_ITEMS — Verifies attribute items (codes, usages, or related child records) for consistency and completeness.
• VALIDATE_ATTRIBUTE_REC — Validates a single attribute record, used as a supporting routine by the higher-level validation entry points.

Tables Accessed

The package references the following documented tables through APPS synonyms:

• PV_ATTRIBUTES_B / PV_ATTRIBUTES_B_S — The base and secondary (translation-independent) attribute definition tables. The user search term "pv_attributes_b_s" corresponds directly to this secondary base table.
• PV_ATTRIBUTES_TL / PV_ATTRIBUTES_VL — Translation and view layers supplying language-specific attribute text.
• PV_ATTRIBUTE_USAGES / PV_ATTRIB_RESP_MAPPINGS — Track where attributes are used and which responsibilities are mapped to them.
• PV_ENTITY_ATTRS / PV_ENTY_ATTR_VALUES / PV_ENTY_SELECT_CRITERIA — Link attributes to entities, entity attribute values, and selection criteria.
• DUAL — Used for simple scalar computations and validations.

Supporting reference is also made to PV_ATTRIBUTE_CODES_VL, PV_PROCESS_RULES_VL, PV_LOOKUPS, and PV_ATTRIBUTE_PKG.

Usage Notes

PV_ATTRIBUTE_PVT is a private package and is not referenced by any external database object; it is invoked internally by the public attribute API layer and by sibling private packages such as PV_ATTRIBUTE_USAGE_PVT, PV_ATTRIBUTE_CODE_PVT, and PV_ENTITY_ATTRIBUTE_PVT. It relies on FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and JTF_PLSQL_API for API error handling and message publication. Customizations should generally target the public attribute APIs rather than this private body, since direct calls bypass the intended encapsulation and are subject to change between point releases. In 12.2.2 the package remains VALID and is referenced by one other package.