Search Results pv_entity_attrs_s

Overview

The APPS.PV_ENTITY_ATTRIBUTE_PVT package body is a private API within the Oracle E-Business Suite Partner Relationship Management (PRM) / Channel Revenue Management product family, operating under the PV module prefix. Its principal business function is to manage the definition and lifecycle of entity attributes — the configurable characteristics that describe channel entities such as partners, programs, and partner programs. These attributes drive eligibility rules, qualification criteria, and questionnaire-driven data capture used throughout partner and program management.

As a _PVT (private) package, it is not intended for direct invocation by external callers or customer extensions. Instead, it provides the internal implementation layer consumed by the public-facing PV_ENTITY_ATTRS_PKG and related APIs. The package encapsulates business logic for creating, updating, deleting, locking, and validating entity attribute records, ensuring that attribute definitions remain consistent with the underlying LOV, SQL, and questionnaire element definitions before persistence.

Key Procedures and Functions

• CREATE_ENTITY_ATTR — Inserts a new entity attribute definition, applying defaulting and derivation logic prior to writing to the attribute tables.
• UPDATE_ENTITY_ATTR — Modifies an existing entity attribute definition, revalidating dependent configuration on change.
• DELETE_ENTITY_ATTR — Removes an entity attribute, cascading relevant cleanup of associated values or dependencies.
• LOCK_ENTITY_ATTR — Acquires a logical lock on an attribute record to serialize concurrent maintenance operations.
• VALIDATE_ENTITY_ATTR — Performs whole-record validation of an entity attribute prior to create or update.
• CHECK_ENTITY_ATTR_ITEMS — Validates individual attribute items or child components associated with a definition.
• VALIDATE_ENTITY_ATTR_REC — Validates a single entity attribute record structure, typically invoked as a sub-validator.
• VALIDATE_SQL_TEXT — Confirms that a user-entered SQL expression (used for dynamic attribute derivation or value lists) is syntactically executable, leveraging DBMS_SQL parsing.
• VALIDATE_LOV_STRING — Confirms that a supplied LOV (List of Values) definition string or lookup reference is valid.

Tables Accessed

• PV_ENTITY_ATTRS — Base table for entity attribute definitions; the primary target of create, update, and delete logic.
• PV_ENTITY_ATTRS_S — The sequence or secondary/translation shadow used to generate or track attribute identifiers.
• PV_ENTY_ATTR_VALUES — Stores permitted values for enumerated or LOV-driven attributes, consulted during validation.
• PV_GE_QSNR_ELEMENTS_B — Questionnaire element definitions, enabling attributes to be tied to dynamic questionnaire content.
• PV_ATTRIBUTES_VL, PV_LOOKUPS, PV_PARTNER_PROGRAM_VL — Supporting views and lookup tables used to resolve attribute metadata and lookup codes.
• DBMS_SQL and DUAL — Utilized by VALIDATE_SQL_TEXT to parse and verify dynamic SQL expressions without executing them against business data.

Usage Notes

This package is invoked indirectly through the PRM attribute maintenance UI (Oracle Forms) and through PV_ENTITY_ATTRS_PKG, whose public procedures delegate to these private routines. It is also called by other internal packages — the ETRM metadata indicates it is referenced by two other packages — during attribute setup, program configuration, and partner onboarding validation. Because it is a private package, customizations should call the supported public API layer rather than referencing PV_ENTITY_ATTRIBUTE_PVT directly. All procedures rely on FND_API, FND_MSG_PUB, and FND_MESSAGE for the standard EBS error-handling and message-stack conventions, so callers should check the message stack after invocation in the manner typical of EBS PL/SQL APIs.