Search Results validate_attribute_rec

Overview

APPS.PV_ATTRIBUTE_PVT_W is a private PL/SQL wrapper package within the Oracle EBS Product Information Management (PIM) / Advanced Product Catalog module. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, and its header revision ($Header: pvxwatss.pls 120.1) places its last significant change in the 11.5.10 era, carried forward into both 12.1.1 and 12.2.2. The package serves as the PL/SQL-to-Java (rosetta) bridge for the internal attribute business logic held in PV_ATTRIBUTE_PVT. Oracle's Forms-based and OAF-based attribute maintenance screens do not call the core *_PVT logic directly; instead they invoke generated wrapper packages such as this one, which marshal scalar and table-structured arguments into the JTF collection types expected by the middle tier. In practice the package underpins the creation, maintenance, and validation of attribute definitions and attribute items (the individual values belonging to an attribute group), which are the building blocks of item catalogs, item classes, and descriptive flexfield-style extensibility in EBS.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P3 — Converts the flattened set of JTF scalar tables (number, date, and varchar2 collections) supplied by the calling layer into a single pv_attribute_pvt.attribute_tbl_type PL/SQL record collection for inbound processing.
• ROSETTA_TABLE_COPY_OUT_P3 — Performs the inverse operation, exploding an outbound attribute_tbl_type collection back into the individual JTF tables returned to the client.
• CREATE_ATTRIBUTE — Logical entry point for inserting a new attribute definition, invoked by the attribute setup UI and by bulk-load/custom loaders.
• UPDATE_ATTRIBUTE — Applies changes to an existing attribute definition, subject to the validation rules encoded in the package.
• VALIDATE_ATTRIBUTE — Checks that the proposed attribute payload satisfies the module's business rules before persistence.
• CHECK_ATTRIBUTE_ITEMS — The procedure most relevant to the search term "check_attribute_items". It verifies the attribute item rows associated with an attribute — confirming that the items exist, are correctly keyed to the parent attribute, and do not violate dependency or duplicate constraints. It is typically the gatekeeper invoked before an attribute is saved, deleted, or promoted into a catalog.
• VALIDATE_ATTRIBUTE_REC — Single-record variant of attribute validation, used when processing one attribute row at a time rather than a set.

Tables Accessed

The only documented table reference is PLITBLM, accessed via an APPS synonym. This is the standard Oracle Applications "PL/SQL integer table" work table used to pass numeric ID lists (such as attribute or attribute-item IDs) between the Java middle tier and PL/SQL. No direct DML against the attribute base tables is documented in the wrapper, because the actual insert, update, and query logic resides in the underlying PV_ATTRIBUTE_PVT package that this wrapper delegates to; the wrapper's role is confined to argument conversion and to surfacing the validation outcome.

Usage Notes

PV_ATTRIBUTE_PVT_W is a private (suffix _PVT_W) package and is not intended as a public API. It is invoked indirectly from the EBS attribute and item catalog maintenance forms and OAF pages, and from concurrent programs that bulk-load or validate attribute data. It is referenced by zero other packages per the ETRM metadata, confirming its leaf position in the dependency chain. Custom code should not call CHECK_ATTRIBUTE_ITEMS directly unless the underlying PV_ATTRIBUTE_PVT logic is fully understood; the supported extension path is to reuse the public attribute APIs or the PIM/Advanced Product Catalog interfaces. Because it runs AUTHID CURRENT_USER, any direct invocation requires the caller to hold execute privileges on the package and appropriate DML privileges on the referenced attribute tables via APPS synonyms.