Search Results check_entity_attr_items

Overview

PV_ENTITY_ATTRIBUTE_PVT_W is a private PL/SQL wrapper package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Product Information Management (PIM) / Product Lifecycle Management family of modules, supporting the entity-attribute framework used to define and maintain flexible attribute data for product entities. In EBS 12.1.1 and 12.2.2, this package acts as a programmatic interface between the internal package body (PV_ENTITY_ATTRIBUTE_PVT) and external callers, particularly Oracle Forms and PL/SQL-based integrations that need to create, update, or validate entity attribute records.

The "_W" suffix is a common EBS naming convention indicating a wrapper package. The package declares its procedures with AUTHID CURRENT_USER, meaning the routines execute with the privileges of the calling user, a characteristic that influences how security and schema access are handled at runtime. The header comments reflect a legacy file revision (pvxweats.pls, revision 120.2), confirming the object has been stable since the mid-2000s releases and remains available in current installations.

Key Procedures and Functions

The package exposes seven documented routines grouped into two categories: Rosetta table conversion utilities and business-logic entity attribute routines.

• ROSETTA_TABLE_COPY_IN_P2 — Converts tabular (array-based) input data supplied by Oracle Forms or Java/JTF callers into the internal PL/SQL record structure pv_entity_attr_tbl_type. This bridges the JTF_NUMBER_TABLE, JTF_DATE_TABLE, and JTF_VARCHAR2_TABLE collection types used at the interface layer with the package's native types.
• ROSETTA_TABLE_COPY_OUT_P2 — Performs the inverse operation, mapping the internal record table back into the JTF collection types so results can be returned to externally coded callers.
• CREATE_ENTITY_ATTR — Inserts a new entity attribute record. This is the primary entry point for defining an attribute against a product entity.
• UPDATE_ENTITY_ATTR — Modifies an existing entity attribute record.
• VALIDATE_ENTITY_ATTR — Applies business validation rules to a single entity attribute prior to persistence.
• CHECK_ENTITY_ATTR_ITEMS — Checks dependent attribute items or related list-of-values entries associated with the entity attribute.
• VALIDATE_ENTITY_ATTR_REC — Validates an entire entity attribute record, performing the comprehensive field-level and cross-field checks needed before a create or update operation is committed.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed through an APPS synonym). PLITBLM is the standard EBS table used by the PL/SQL interface layer to log errors, messages, and status information for forms-based transactions. It provides the mechanism by which validation failures from routines such as VALIDATE_ENTITY_ATTR_REC are surfaced to the user through the Forms message stack rather than raised as unhandled exceptions. The entity attribute data itself is persisted by the underlying private package into the attribute definition tables of the Product Information Management model.

Usage Notes

This wrapper is most commonly invoked from Oracle Forms in the product entity attribute maintenance screens, where the Forms client calls the Rosetta copy-in routines to marshal block data, executes CREATE_ENTITY_ATTR or UPDATE_ENTITY_ATTR, and relies on the validate routines to enforce business rules before commit. Custom PL/SQL integrations may call the package directly when programmatically loading or migrating entity attribute definitions, though the underlying PV_ENTITY_ATTRIBUTE_PVT package is typically the preferred target for custom development because the wrapper exists primarily to serve the Forms interface. The package is referenced by no other packaged objects according to the documented metadata, confirming its role as a terminal interface layer rather than a shared internal utility. Because the routines run under AUTHID CURRENT_USER, callers must have the appropriate direct grants and the correct session context when invoking them outside the standard Forms environment.