Search Results update_std_article

Overview

OKC_STD_ARTICLE_PVT is a private (PVT) API package in the Oracle EBS Contracts (OKC) module, owned by APPS. It provides the internal processing layer for the setup and maintenance of standard articles, which are reusable clause or article definitions that can be attached to contract templates, contract terms, and contract documents. The package was introduced under the OKC Contracts Standard Article entity and exposes a structured set of procedures for creating, updating, validating, locking, and deleting standard articles and their associated versions and incomplete states.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema — a standard convention for private APIs that are intended to be invoked only through public wrapper APIs or internal concurrent processing, not directly by end users. It is a foundational private package; the ETRM metadata indicates it is referenced by one other package and relies on the public OKC_API package for shared global constants such as G_APP_NAME, G_COL_NAME_TOKEN, and message-handling tokens.

Key Procedures and Functions

Of the 75 documented procedures and functions, the most significant include:

• CREATE_STD_ARTICLE / UPDATE_STD_ARTICLE / DELETE_STD_ARTICLE — the core DML entry points for maintaining a standard article record, accepting typed record parameters (saev_rec_type, savv_tbl_type, saiv_tbl_type, samv_tbl_type) that map to the article, version, and set-membership structures.
• VALIDATE_STD_ARTICLE — the object of the user's search; it performs business-rule validation on a standard article prior to persistence or release, raising the G_EXCEPTION_HALT_VALIDATION exception when rules fail.
• LOCK_STD_ARTICLE — obtains a pessimistic lock on a standard article row to prevent concurrent modification.
• VALIDATE_NAME, VALIDATE_NO_K_ATTACHED, VALIDATE_SHORT_DESCRIPTION, VALIDATE_DATE_ACTIVE, VALIDATE_LATEST, VALIDATE_UPDATABLE, VALIDATE_SAV_RELEASE — granular validation helpers covering naming, attachment constraints, description length, effective dating, version currency, updatability, and release state.
• CREATE_STD_ART_VERSION, UPDATE_STD_ART_VERSION, DELETE_STD_ART_VERSION, LOCK_STD_ART_VERSION, VALIDATE_STD_ART_VERSION — the parallel lifecycle operations for standard article versions.
• CREATE_STD_ART_INCMPT, LOCK_STD_ART_INCMPT — management of incomplete standard article definitions, allowing partially authored articles to be staged before completion.
• ADD_LANGUAGE — installs translated language rows (typically invoked during NLS patching).

Tables Accessed

The package operates against the following base tables via APPS synonyms:

• OKC_K_ARTICLES_B — the contract articles base table, holding the master article definition.
• OKC_ARTICLE_VERSIONS — versioned article content, supporting multi-version article lifecycles.
• OKC_STD_ART_VERSIONS_B — standard article version base table, the primary target of version-level procedures.
• OKC_STD_ART_INCMPTS — stores incomplete standard articles during staged authoring.
• OKC_STD_ART_SET_MEMS — standard article set membership, supporting grouping of articles into sets.
• DBMS_LOB and PLITBLM — Oracle-supplied packages used for large object (CLOB/BLOB) handling of article text and for PL/SQL index-by table management, respectively.

Usage Notes

OKC_STD_ARTICLE_PVT is a private package and should not be invoked directly from custom code. In standard Oracle EBS usage it is called by the public OKC standard article APIs (typically in the OKC_STD_ARTICLE or OKC_API family) and by the Contracts Authoring forms that manage standard article setup. The presence of ADD_LANGUAGE and the validation token constants confirms it is also driven by Oracle's NLS installation and patch utilities.

Concurrent programs that load, migrate, or seed standard articles rely on this package indirectly through the public API layer. Custom integrators requiring programmatic creation of standard articles should call the corresponding public API, which in turn delegates to OKC_STD_ARTICLE_PVT. Because the package declares G_EXCEPTION_HALT_VALIDATION and uses OKC_API error tokens, callers can expect standardized FND message propagation through the OKC error stack.