Search Results create_std_article

Overview

OKC_STD_ARTICLE_PVT is a private PL/SQL API package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema and classified as a Private (PVT) API. It provides the internal business logic responsible for creating, maintaining, and versioning standard articles — reusable clause and article definitions used across contract templates and contract documents in Oracle Contracts. Standard articles serve as the master repository from which contract authors draw pre-approved legal and commercial text, and this package governs their lifecycle: definition, validation, locking, versioning, and deletion. The package is declared AUTHID CURRENT_USER and is not intended for direct external invocation; it is called by the public OKC article APIs and by related private packages. Its header carries a 2005-era revision ($Header: OKCCSAES.pls 120.0), placing it within the core Contracts article infrastructure that remains consistent across EBS 12.1.1 and 12.2.2. The package defines strongly typed subtypes (saev_rec_type, savv_rec_type, saiv_rec_type, samv_rec_type, sacv_rec_type) that map to the corresponding entity, version, information, media, and association structures used by the OKC_S*_PVT packages, giving callers a consistent record/table-based interface.

Key Procedures and Functions

The package exposes 75 documented procedures and functions. The principal entry points include:

• CREATE_STD_ARTICLE — Creates a new standard article header together with its associated version, information, and media rows, based on the incoming entity record and child table collections.
• UPDATE_STD_ARTICLE — Modifies an existing standard article and its dependent child records.
• VALIDATE_STD_ARTICLE — Performs business-rule validation on a standard article before it is committed.
• LOCK_STD_ARTICLE — Acquires a lock on the article record, preventing concurrent modification during a transaction.
• DELETE_STD_ARTICLE — Removes a standard article, subject to master/child deletion restrictions.
• VALIDATE_NAME and VALIDATE_SHORT_DESCRIPTION — Enforce uniqueness and formatting rules on identifying attributes.
• VALIDATE_NO_K_ATTACHED — Prevents deletion or modification where the article is already attached to a contract (K) record.
• CREATE_STD_ART_VERSION, UPDATE_STD_ART_VERSION, DELETE_STD_ART_VERSION, VALIDATE_STD_ART_VERSION, LOCK_STD_ART_VERSION — Manage the versioning lifecycle of standard article versions.
• VALIDATE_SAV_RELEASE, VALIDATE_DATE_ACTIVE, VALIDATE_LATEST, VALIDATE_UPDATABLE — Check release status, effective dating, latest-version status, and updatability constraints.
• CREATE_STD_ART_INCMPT, LOCK_STD_ART_INCMPT — Handle standard article incompatibilities.
• ADD_LANGUAGE — Installs translated (MLS) rows for the article setup data.

Tables Accessed

The package reads and writes several core OKC tables through APPS synonyms:

• OKC_STD_ART_VERSIONS_B — Stores the base-table rows for each version of a standard article; the primary target of the version create/update/delete routines.
• OKC_K_ARTICLES_B — Links clause/article definitions to contract records; referenced by VALIDATE_NO_K_ATTACHED to detect existing attachments.
• OKC_ARTICLE_VERSIONS — Holds versioned article content; used during article and version maintenance.
• OKC_STD_ART_INCMPTS — Records incompatibilities between standard articles; maintained by CREATE_STD_ART_INCMPT and related routines.
• OKC_STD_ART_SET_MEMS — Stores membership of standard articles within article sets.
• DBMS_LOB and PLITBLM — Oracle-supplied packages used for large object manipulation (article text) and PL/SQL table handling during bulk row processing.

Usage Notes

OKC_STD_ARTICLE_PVT is a private implementation package and should not be called directly by customer extensions; Oracle supports access only through the corresponding public OKC APIs, which wrap this package with message-list and return-status handling. It is invoked primarily from the Standard Articles setup and maintenance windows in the Contracts application, and from internal concurrent or batch processes that import or migrate article definitions. Its subprograms are also referenced by at least one other OKC private package, making it a shared dependency within the article subsystem. Because it relies on typed records from OKC_SAE_PVT, OKC_SAV_PVT, OKC_SAI_PVT, OKC_SAM_PVT, and OKC_SAC_PVT, any custom code attempting to use it must construct matching record and table types. The package operates on the APPS schema, is AUTHID CURRENT_USER, and relies on FND message tokens (G_SQLERRM_TOKEN, G_SQLCODE_TOKEN, G_COL_NAME_TOKEN) for error reporting through OKC_API. Behavior and signatures are documented as consistent between EBS 12.1.1 and 12.2.2.