Search Results is_valid_attribute_value_id

Overview

APPS.CSI_EXTEND_ATTRIB_VLD_PVT is a private (PVT) PL/SQL validation package within the Oracle EBS Install Base (CSI) module. It encapsulates the server-side validation logic that governs extended attribute values associated with item instances. Extended attributes in Oracle Install Base allow organizations to capture customer-defined, flexfield-style descriptive data against an installed item—such as serial-specific configuration details, warranty codes, or equipment characteristics that fall outside the standard instance columns. This package provides the reusable validity checks that other CSI APIs and internal routines rely upon before committing extended attribute rows to the database.

The package is declared with AUTHID CURRENT_USER, meaning its database objects resolve under the privileges of the calling schema rather than the package owner. It is classified as a private API, so it is not part of the published, supported integration surface; Oracle may change its signature between releases. The parameter convention p_stack_err_msg IN BOOLEAN DEFAULT TRUE appearing across its functions indicates that callers can suppress error stack propagation when embedding these checks in larger validation flows.

Key Procedures and Functions

The package exposes sixteen documented functions that collectively validate identifiers, dates, levels, and object versions for extended attribute records:

• IS_VALID_INSTANCE_ID — confirms that a supplied instance identifier is a valid item instance and returns the associated inventory item and master organization identifiers.
• VAL_INST_ID_FOR_UPDATE — determines whether an instance identifier may be updated, comparing new and old values.
• VAL_AND_GET_EXT_ATT_ID — retrieves extended attribute values for a given attribute value identifier and populates the standard extended attribute record structure.
• IS_EXPIRE_OP — evaluates whether the current operation against an extended attribute record constitutes an expiry (end-dating) action.
• IS_UPDATABLE and ALTERNATE_PK_EXISTS — check record updatability and uniqueness of the alternate primary key, respectively.
• IS_VALID_ATTRIBUTE_ID, IS_VALID_ATTRIBUTE_VALUE_ID, and GET_ATTRIBUTE_VALUE_ID — validate attribute definitions and value identifiers and resolve the correct value identifier.
• IS_STARTDATE_VALID and IS_ENDDATE_VALID — enforce date-range integrity for effective-dated extended attribute rows.
• IS_VALID_ATTRIB_LEVEL_CONTENT — verifies that the attribute level and content combination is permissible.
• GET_ATTRIBUTE_VALUE_H_ID, IS_VALID_OBJ_VER_NUM, and GET_OBJECT_VERSION_NUMBER — support history-table lookups and optimistic locking through object version numbers.
• GET_FULL_DUMP_FREQUENCY — returns diagnostic full-dump frequency settings.

The user's search term is_valid_attribute_value_id corresponds directly to IS_VALID_ATTRIBUTE_VALUE_ID, the routine that screens a candidate extended attribute value identifier before it is accepted by the Install Base DML layer.

Tables Accessed

The package reads and writes through APPS synonyms. The extended attribute value tables—CSI_IEA_VALUES and its _H (history), _S (security), and _H_S variants—store the effective-dated attribute values being validated. CSI_ITEM_INSTANCES and CSI_I_EXTENDED_ATTRIBS supply the parent instance and attribute definition contexts. CSI_TRANSACTIONS provides transactional history support, MTL_ITEM_CATEGORIES supports item classification checks, and DUAL is used for scalar evaluations.

Usage Notes

Because this is a private package, it is not intended for direct customer invocation. It is typically called from Oracle Install Base forms and concurrent programs, from the public CSI APIs, and from the single package noted as referencing it. Custom code that calls CSI_EXTEND_ATTRIB_VLD_PVT directly does so at its own risk, since the interface is unsupported and subject to change.