Search Results create_article_version

Overview

OKC_ARTICLES_GRP is the articles group API within the Oracle Contracts (OKC) module of Oracle E-Business Suite. It provides the core business logic for creating, maintaining, versioning, and relating contract articles—the reusable clause and template text that forms the body of contracts, terms, and conditions authored in Oracle Contracts. The package is classified as a GRP (group) API and resides in the APPS schema, compiled against the OKC and FND public APIs.

The package body opens with standard EBS globalization and message-handling conventions. It initializes a debug flag from the AFLOG_ENABLED profile, resolves a global organization identifier from the OKC_GLOBAL_ORG_ID profile, and captures document-sequence configuration through the UNIQUE:SEQ_NUMBERS and OKC_ARTICLE_DOC_SEQ_CATEGORY profile options. Constants are inherited from FND_API (G_MISS_NUM, G_MISS_CHAR, G_MISS_DATE, G_RET_STS_SUCCESS, and related return-status values) and from OKC_API (G_APP_NAME, G_INVALID_VALUE), establishing the package as a fully conforming member of the EBS API framework.

Key Procedures and Functions

Sixteen documented procedures and functions define the package's public surface:

• PARSE_N_REPLACE_TEXT — tokenizes article text and substitutes variables with resolved values.
• GET_ARTICLE_SEQ_NUMBER — obtains the next article sequence number from the configured document sequence.
• CREATE_ARTICLE, LOCK_ARTICLE, UPDATE_ARTICLE, DELETE_ARTICLE, VALIDATE_ARTICLE — the standard lifecycle quartet, plus validation, for article records.
• CREATE_ARTICLE_VERSION, LOCK_ARTICLE_VERSION, UPDATE_ARTICLE_VERSION, VALIDATE_ARTICLE_VERSION — the parallel lifecycle for article versions.
• COPY_ARTICLE — duplicates an existing article, typically for reuse across contracts or templates.
• CREATE_ARTICLE_RELATIONSHIP, DELETE_ARTICLE_RELATIONSHIP — manage associations between articles.
• UPDATE_ARTICLE_VARIABLES — maintains variable bindings attached to an article.
• LATER_APPROVED_EXISTS — checks whether a later approved version already exists, guarding against regressive edits.

Tables Accessed

The package reads and writes the following tables through APPS synonyms: OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS, and OKC_ARTICLES_ADOPTIONS for the article and version lifecycle; OKC_ARTICLE_RELATNS_ALL for inter-article relationships; OKC_ARTICLE_VARIABLES and OKC_ART_VAR_SECTIONS for variable definitions and section placement; OKC_BUS_VARIABLES_B and OKC_BUS_VARIABLES_TL for business variable metadata; OKC_FOLDERS_ALL_B and OKC_FOLDER_CONTENTS for folder organization; HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION for organization context; and the FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS, and FND_DOC_SEQUENCE_CATEGORIES tables supporting sequence-number generation.

Usage Notes

OKC_ARTICLES_GRP is invoked through Oracle Contracts forms (article authoring and clause-library screens), through concurrent programs that generate or refresh article content, and by custom extensions that must observe OKC's validation and versioning rules. Eight other packages reference it, confirming its role as the shared article-maintenance layer. Because the API enforces FND_API return statuses and standard message tokens, callers should always inspect the return status and message stack rather than relying on exceptions. Direct DML against the underlying OKC article tables is discouraged; all manipulation should route through this package to preserve version integrity, sequence numbering, and variable substitution behavior.