Results for “get_k_art_var”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_MRV_UTIL is a utility PL/SQL package in the APPS schema that supports the Management of Multiple Related Versions (MRV) functionality within Oracle E-Business Suite Contracts (OKC). The package provides helper routines used throughout the contract terms and variables infrastructure, particularly for handling article-version variable data, descriptive flexfield-based UDA (User Defined Attribute) attributes, and the pre-processing required when a contract document contains multiple related versions. It is classified as a UTIL package, indicating that it supplies reusable programmatic building blocks rather than exposing an end-user business API. In ETRM 12.1.1 and 12.2.2, the package is documented as VALID and contains ten procedures and functions that bridge the OKC contract article tables with the Oracle EGO (Enterprise Object/attribute group) flexfield metadata model and with XML document generation.

Key Procedures and Functions

The documented routines fall into three functional groupings.

• Article variable maintenance: UPDATE_K_ART_VAR and GET_K_ART_VAR provide the write and read accessors for contract article variable values stored against OKC_K_ART_VARIABLES. These are the core getter/setter routines used by other contract packages to manipulate variable data for a given article version.
• UDA attribute XML handling: GET_UDA_ATTR_XML and UPDATE_UDA_ATTR_XML convert between the physical UDA attribute storage and an XML representation. These are used when contract terms containing user-defined attributes must be serialized or reconstructed, and they interact with XMLTYPE and XQSEQUENCE.
• MRV processing and metadata lookup: MRV_PRE_PROCESS orchestrates the preparatory steps required before multiple related versions are generated. CHECKDOCHASMRV returns whether a document contains MRV content. GETATTRIBUTEGROUPDISPNAME and GETTEMPLATENAME resolve the display names for attribute groups and templates used by the MRV UI. COPY_VARIABLE_UDA_DATA copies variable and UDA data between versions.

As a UTIL classification package, these procedures are intended to be called from other OKC packages and from user interface layer components rather than directly by end users.

Tables Accessed

The package reads and writes several core Contracts and EGO tables through APPS synonyms. OKC_K_ARTICLES_B, OKC_ARTICLE_VERSIONS, and OKC_K_ART_VARIABLES hold the article definition, version, and variable value data manipulated by the article-variable routines. OKC_BUS_VARIABLES_B defines the business variable metadata, while OKC_MRV_T stores MRV template information referenced during pre-processing. The EGO flexfield tables—EGO_DATA_LEVEL_B, EGO_FND_DF_COL_USGS_EXT, EGO_FND_DSC_FLX_CTX_EXT, FND_DESCR_FLEX_COLUMN_USAGES, and FND_OBJECTS—supply the descriptive flexfield and object metadata needed to resolve UDA attribute definitions and their display names. FND_APPLICATION provides application context, and DBMS_LOB, XMLTYPE, and XQSEQUENCE are used for large-object and XML manipulation of UDA attribute data.

Usage Notes

OKC_MRV_UTIL is an internal utility that is referenced by several higher-level Contracts objects, including OKC_BUS_VARIABLES_SEARCH_V, OKC_K_ENTITY_LOCKS_GRP, OKC_TERMS_COPY_PVT, and OKC_MRV_UTIL itself in recursive form. It is typically invoked indirectly through Contracts forms and through the terms-copy and MRV generation flows rather than being called by custom code directly. Because it is classified as a UTIL package and its procedures operate on core contract article and variable tables, any custom extension that copies or modifies contract versions should call the public OKC APIs (for example OKC_TERMS_COPY_PVT) rather than invoking OKC_MRV_UTIL routines directly, to preserve transactional and locking integrity. When custom development must reference it, the package should be treated as version-sensitive between 12.1.1 and 12.2.2, and all dependencies on EGO flexfield tables should be validated against the target instance.