Search Results validate_no_k_attached

Overview

OKC_STD_ARTICLE_PUB is the public API package for managing standard articles within Oracle E-Business Suite Contracts (OKC). Standard articles represent reusable clause and template text that can be attached to contract documents, contract templates, and related contracting entities. The package follows the standard Oracle EBS API architecture: a thin public (PUB) layer that delegates to a private implementation package (OKC_STD_ARTICLE_PVT) while exposing stable signatures for external callers. The public package declares AUTHID CURRENT_USER and relies on subtype aliases (saev_rec_type, savv_rec_type, saiv_rec_type, samv_rec_type, sacv_rec_type) mapped directly to the private package types, so callers work with the same record and table structures used internally.

The package header is versioned at 120.0 with the source header OKCPSAES.pls 120.0 2005/05/25, indicating this API has been stable since the 11.5.x code line and continues unchanged into Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 it is documented with 83 procedures and functions, which reflects the substantial validation and lifecycle surface required for standard article maintenance, version control, and multilingual support.

Key Procedures and Functions

• ADD_LANGUAGE — Loads translated rows for standard articles into the language-specific tables, supporting MLS (Multi-Language Support) installations.
• CREATE_STD_ARTICLE — Creates a new standard article header along with its associated version, article-version, item, and attachment (message) records supplied through the IN/OUT tables.
• UPDATE_STD_ARTICLE — Updates an existing standard article and its dependent child records.
• VALIDATE_STD_ARTICLE — Performs pre-write validation on the article record, returning errors before any DML is committed.
• LOCK_STD_ARTICLE — Obtains a row-level lock on the specified article to prevent concurrent modification.
• DELETE_STD_ARTICLE — Removes a standard article and dependent detail rows.
• VALIDATE_NAME — Checks uniqueness and formatting rules for the article name.
• VALIDATE_NO_K_ATTACHED — Confirms that no contract (K) rows remain attached to the article, typically invoked before deletion. This is the procedure associated with the search term "validate_no_k_attached".
• CREATE_STD_ART_VERSION — Creates a new version of an existing standard article, copying or initializing version-level attributes.
• LOCK_STD_ART_VERSION — Locks a specific article version row for update.
• UPDATE_STD_ART_VERSION — Updates the attributes of an existing article version.
• DELETE_STD_ART_VERSION — Deletes a specific article version.
• VALIDATE_STD_ART_VERSION — Validates version-level data such as version number and status.
• VALIDATE_SAV_RELEASE — Checks whether the version may be released based on its current state.
• VALIDATE_DATE_ACTIVE — Validates the active date range for the article or version.
• VALIDATE_UPDATABLE — Determines whether the article is in a state that permits updates.
• VALIDATE_LATEST — Confirms that the version being acted upon is the latest version.
• VALIDATE_SHORT_DESCRIPTION — Validates the short description field against length and required-field rules.
• CREATE_STD_ART_INCMPT — Creates an incomplete standard article shell, allowing the article to be built incrementally.
• LOCK_STD_ART_INCMPT — Locks an incomplete article record during incremental maintenance.

These procedures follow the standard API conventions: p_api_version, p_init_msg_list, x_return_status, x_msg_count, and x_msg_data, plus a package-level g_exception_halt_processing exception and user-hook records (g_saev_rec, g_saiv_rec, g_sacv_rec, g_savv_rec, g_samv_rec) used for extensibility.

Tables Accessed

• OKC_K_ARTICLES_B — Base table storing contract-article attachments; read by VALIDATE_NO_K_ATTACHED and written/cleaned during article delete and create operations.
• OKC_ARTICLE_VERSIONS — Stores version-level information for standard articles; accessed by CREATE/UPDATE/DELETE_STD_ART_VERSION and their validation companions.
• PLITBLM — Stores translated (MLS) long text for articles; used by ADD_LANGUAGE to populate language-specific rows.

Usage Notes

OKC_STD_ARTICLE_PUB is invoked from the Oracle Contracts Authoring and Standard Article setup forms, from concurrent programs performing bulk article maintenance or translation loading, and from customer extensions that programmatically create or version standard articles. Callers should pass a valid p_api_version, check x_return_status against OKC_API.G_RET_STS_SUCCESS, and call OKC_MSG_API to retrieve messages when x_msg_count > 0. All IN/OUT records and tables are based on the corresponding private package subtypes, so custom code should obtain the article, version, item, message, and category tables via the standard OKC query/utility APIs rather than constructing them manually. The package references no other public packages directly, making it a safe, low-coupling integration point.