Search Results okc_k_article_pub

Overview

OKC_K_ARTICLE_PUB is the public (API-classified) PL/SQL package in the APPS schema that exposes the contract article lifecycle to external callers within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Articles represent the reusable text clauses and terms attached to contract templates, contract headers, and their versions in Oracle Contract Terms Management (part of the Enterprise Contract Management family). The package forms the supported public surface over the private implementation package OKC_K_ARTICLE_PVT, and its procedures model the complete article state machine: creation, locking, update, deletion, validation, and multilingual translation maintenance. Because it is a PUB package, it is the contract that other Oracle modules and customer extensions are expected to call rather than the underlying private package.

Key Procedures and Functions

The package documents 22 procedures and functions, including the following notable entries:

CREATE_K_ARTICLE — creates a new contract article record, establishing the base row and default attributes.
LOCK_K_ARTICLE — acquires a locking handle on an existing article so that subsequent modification is performed safely.
UPDATE_K_ARTICLE — applies changes to a locked article's attributes and content.
DELETE_K_ARTICLE — removes an article and its associated version data.
VALIDATE_K_ARTICLE — performs business-rule validation on an article prior to commit or use in a contract.
CREATE_ARTICLE_TRANSLATION / LOCK_ARTICLE_TRANSLATION / DELETE_ARTICLE_TRANSLATION / VALIDATE_ARTICLE_TRANSLATION — the parallel translation lifecycle, enabling multilingual article text.
ADD_LANGUAGE — installs a new language dimension for article translations.
STD_ART_NAME — derives or returns the standard article name used for identification.
GET_REC — retrieves an article record for read/query purposes.

Tables Accessed

The package reads and writes the article and contract-term base tables through APPS synonyms:

OKC_K_ARTICLES_B and OKC_ARTICLES_ALL — the article master and its translation/MLS view, central to create, update, delete, and translation logic.
OKC_ARTICLE_VERSIONS — versioned article text, supporting article versioning.
OKC_SECTIONS_B and OKC_K_HEADERS_B — the contract section and header structures to which articles are attached.
OKC_TERMS_TEMPLATES_ALL and OKC_TERMS_TEMPLATES_ALL_S — terms templates that reference articles.
OKC_ALLOWED_TMPL_USAGES and OKC_ALLOWED_TMPL_USAGES_S — template usage rules validated during article use.
OKC_BUS_DOC_TYPES_B — business document type lookups.
DBMS_LOB, DUAL, PLITBLM — large-object manipulation of article text, single-row queries, and PL/SQL index-by table handling.

Usage Notes

OKC_K_ARTICLE_PUB is invoked by the contract authoring forms and by other public packages rather than run directly as a concurrent program. The dependency metadata shows it is referenced by OKC_CONTRACT_PVT, OKC_COPY_CONTRACT_PVT, OKE_CONTRACT_PUB, OKL_ARTICLE_PUB, OKL_OKC_MIGRATION_A_PVT, OKS_CONTRACTS_PUB, and OKS_COPY_CONTRACT_PVT. Notably, the user's search term OKS_RENCPY_PVT appears as a referencing package, confirming that the Service Contracts renewal/copy utility calls OKC_K_ARTICLE_PUB to replicate articles during contract renewal and copy operations. Because it depends on OKC_API, OKC_ATN_PVT, OKC_CAT_PVT, and OKC_K_ARTICLE_PVT, custom code should call this PUB interface, pass a valid API context, and allow the package to drive article validation and locking rather than manipulating the underlying _B and _ALL tables directly.

PACKAGE: APPS.OKC_K_ARTICLE_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLE_PUB, status:VALID,
PACKAGE: APPS.OKC_CAT_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CAT_PVT, status:VALID,
PACKAGE: APPS.OKC_CAT_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CAT_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_K_ARTICLE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_K_ARTICLE_PUB, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLE_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLE_PUB, status:VALID,
PACKAGE BODY: APPS.OKC_K_ARTICLE_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_K_ARTICLE_PUB, status:VALID,
SYNONYM: APPS.OKC_ALLOWED_TMPL_USAGES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_ALLOWED_TMPL_USAGES_S, status:VALID,
SYNONYM: APPS.OKC_TERMS_TEMPLATES_ALL_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_TERMS_TEMPLATES_ALL_S, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLE_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLE_PVT, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLE_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLE_PVT, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLES_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_ARTICLE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_ARTICLE_PUB, status:VALID,
PACKAGE BODY: APPS.OKL_ARTICLE_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_ARTICLE_PUB, status:VALID,
PACKAGE: APPS.OKC_TEMPLATE_USAGES_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_TEMPLATE_USAGES_GRP, status:VALID,
PACKAGE: APPS.OKC_ATN_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_ATN_PVT, status:VALID,
PACKAGE: APPS.OKC_ATN_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_ATN_PVT, status:VALID,
PACKAGE: APPS.OKC_ARTICLES_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_ARTICLES_GRP, status:VALID,
SYNONYM: APPS.OKC_ALLOWED_TMPL_USAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_ALLOWED_TMPL_USAGES, status:VALID,
SYNONYM: APPS.OKC_TERMS_TEMPLATES_ALL_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_TERMS_TEMPLATES_ALL_S, status:VALID,
PACKAGE BODY: APPS.OKL_OKC_MIGRATION_A_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OKC_MIGRATION_A_PVT, status:VALID,
SYNONYM: APPS.OKC_ALLOWED_TMPL_USAGES_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_ALLOWED_TMPL_USAGES_S, status:VALID,
SYNONYM: APPS.OKC_ALLOWED_TMPL_USAGES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_ALLOWED_TMPL_USAGES, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLES_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLES_PVT, status:VALID,
PACKAGE: APPS.OKC_TEMPLATE_USAGES_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_TEMPLATE_USAGES_GRP, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLES_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLES_GRP, status:VALID,
PACKAGE: APPS.OKC_ARTICLES_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_ARTICLES_GRP, status:VALID,
PACKAGE: APPS.OKC_K_ARTICLES_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_K_ARTICLES_GRP, status:VALID,
PACKAGE BODY: APPS.OKL_OKC_MIGRATION_A_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OKC_MIGRATION_A_PVT, status:VALID,
PACKAGE: APPS.OKS_RENCPY_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_RENCPY_PVT, status:VALID,
SYNONYM: APPS.OKC_BUS_DOC_TYPES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_BUS_DOC_TYPES_B, status:VALID,
PACKAGE: APPS.OKC_TERMS_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_TERMS_UTIL_PVT, status:VALID,
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
PACKAGE: APPS.OKS_COPY_CONTRACT_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_COPY_CONTRACT_PVT, status:VALID,
SYNONYM: APPS.OKC_BUS_DOC_TYPES_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_BUS_DOC_TYPES_B, status:VALID,
PACKAGE: APPS.OKC_COPY_CONTRACT_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,
SYNONYM: APPS.OKC_TERMS_TEMPLATES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_TERMS_TEMPLATES_ALL, status:VALID,
PACKAGE: APPS.OKS_RENCPY_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKS_RENCPY_PVT, status:VALID,
PACKAGE: APPS.OKC_TERMS_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_TERMS_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.OKE_CONTRACT_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_CONTRACT_PUB, status:VALID,
SYNONYM: APPS.OKC_ARTICLES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_ARTICLES_ALL, status:VALID,
SYNONYM: APPS.OKC_SECTIONS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_SECTIONS_B, status:VALID,
SYNONYM: APPS.OKC_ARTICLE_VERSIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_ARTICLE_VERSIONS, status:VALID,
SYNONYM: APPS.OKC_SECTIONS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_SECTIONS_B, status:VALID,
SYNONYM: APPS.OKC_TERMS_TEMPLATES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_TERMS_TEMPLATES_ALL, status:VALID,
PACKAGE BODY: APPS.OKE_CONTRACT_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_CONTRACT_PUB, status:VALID,
PACKAGE: APPS.OKC_COPY_CONTRACT_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,
SYNONYM: APPS.OKC_ARTICLES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_ARTICLES_ALL, status:VALID,
SYNONYM: APPS.OKC_ARTICLE_VERSIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_ARTICLE_VERSIONS, status:VALID,
VIEW: APPS.OKC_TEMPLATE_USAGES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_TEMPLATE_USAGES_V, object_name:OKC_TEMPLATE_USAGES_V, status:VALID,
SYNONYM: APPS.OKC_K_ARTICLES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_K_ARTICLES_B, status:VALID,