Search Results validate_attr_code_rec

Overview

PV_ATTRIBUTE_CODE_PVT_W is a private API wrapper package in the Oracle EBS Product Lifecycle Management (PLM) / Product Visibility schema. It serves as the public-facing, AUTHID CURRENT_USER wrapper layer around the core implementation package PV_ATTRIBUTE_CODE_PVT, exposing the attribute code entity to callers that operate under the invoking user's privileges. Its primary business function is to manage "attribute codes" — the definable catalog of attribute identifiers used to classify and qualify items, structures, and other product data within the PLM attribute framework. The wrapper pattern separates the thin, exposed API signatures from the underlying private business logic, a common Oracle Applications architecture used to support Rosetta-style bulk table transport and standard PL/SQL API validation semantics.

Key Procedures and Functions

The package exposes seven documented procedures, reflecting a standard Oracle PLM API pattern:

• ROSETTA_TABLE_COPY_IN_P2 — Transfers columnar JTF typed arrays (JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_DATE_TABLE, and so on) into the private PL/SQL table type attribute_code_tbl_type. This supports high-volume, set-based data movement in and out of the API.
• ROSETTA_TABLE_COPY_OUT_P2 — The inverse operation, unpacking an attribute_code_tbl_type record set back into individual JTF typed arrays for consumption by callers such as forms or concurrent programs.
• CREATE_ATTRIBUTE_CODE — Creates a new attribute code record. It follows the standard PL/SQL API signature convention with API version, init message list, commit, and validation level parameters, plus standard return status, message count, message data, and an output attribute code identifier.
• UPDATE_ATTRIBUTE_CODE — Modifies an existing attribute code, sharing the same standard API parameter conventions.
• VALIDATE_ATTRIBUTE_CODE — Performs validation logic on an attribute code entity, typically returning status and error messaging for a single record.
• CHECK_ATTR_CODE_ITEMS — Verifies the item associations or child rows tied to an attribute code, used to enforce referential or business rules before create/update/delete operations.
• VALIDATE_ATTR_CODE_REC — Validates a single attribute code record, providing record-level validation invoked as a supporting step by the create and update logic or directly by callers.

Tables Accessed

The documented table reference is PLITBLM, accessed through APPS synonyms. PLITBLM is a PL/SQL index-organized or transient table used within the PLM attribute infrastructure to hold working sets of attribute code data during processing. The wrapper package relies on this table structure to stage records for validation and to persist or retrieve the attribute code definitions managed by the create and update procedures. The Rosetta copy routines do not persist directly; they shuttle data between typed arrays and the in-memory PL/SQL table type that ultimately maps to underlying attribute code storage.

Usage Notes

PV_ATTRIBUTE_CODE_PVT_W is a private wrapper (the "_PVT_W" suffix denotes "private wrapper") and is not intended for direct external invocation; Oracle EBS forms, concurrent programs, and other PLM APIs call it indirectly through the public API layer. Functions such as VALIDATE_ATTR_CODE_REC are typically triggered during form-level validation or as part of the create/update sequence to enforce data integrity. Custom extensions should call the corresponding public API rather than the wrapper itself. Because the package is AUTHID CURRENT_USER, all unqualified synonym references resolve to the invoking schema, reinforcing that direct access must respect the caller's privileges. The APPS owner and ETRM classification as OTHER indicate it is a supporting utility, referenced by no other documented packages in the 12.2.2 metadata, and it should be treated as an internal component of the attribute code framework.