Search Results parse_n_replace_text

Overview

OKC_ARTICLES_GRP is a Group-type PL/SQL package in the APPS schema that provides the core article management infrastructure for Oracle E-Business Suite's Enterprise Contract Terms Management (ETRM) module. ETRM, part of the Oracle Contracts family, allows organizations to define reusable contract terms and conditions as articles that can be assembled into contract templates and individual contracts. This package encapsulates the treatment of articles as structured business objects: their creation, versioning, locking, validation, copying, and variable substitution.

The package operates on article records stored in the OKC_ARTICLES_ALL table and related child tables, applying folder, version, and business-variable semantics. Because articles frequently contain merge-style variable placeholders (for example, contract party names or monetary amounts), OKC_ARTICLES_GRP supplies both the substitution engine and the structural lifecycle operations that other, more public-facing APIs delegate to. The package references the common FND_API error-handling standard and the FND document sequencing framework, and it is itself referenced by eight sibling packages, confirming its role as a shared internal service layer rather than an end-user entry point.

Key Procedures and Functions

The documented API surface includes sixteen procedures and functions:

• PARSE_N_REPLACE_TEXT — Scans article text for embedded business-variable tokens, resolves them against OKC_ARTICLE_VARIABLES, and substitutes the resolved values into the output text.
• GET_ARTICLE_SEQ_NUMBER — Returns the next sequence number used when generating an article identifier, typically driven by FND document sequence assignments.
• CREATE_ARTICLE — Inserts a new article record into OKC_ARTICLES_ALL, assigning the sequence number and initializing folder and version linkage.
• LOCK_ARTICLE — Establishes a locked, editable state for an existing article, preventing concurrent or conflicting modifications.
• UPDATE_ARTICLE — Applies modifications to an article's header-level attributes.
• DELETE_ARTICLE — Logically or physically removes an article and its dependent structures.
• VALIDATE_ARTICLE — Verifies that an article satisfies required ETRM business rules before it is committed for use.
• CREATE_ARTICLE_VERSION — Creates a new version of an existing article, preserving the prior version for audit and historical reference in OKC_ARTICLE_VERSIONS.
• LOCK_ARTICLE_VERSION — Places a specific article version into a locked, editable state.
• UPDATE_ARTICLE_VERSION — Updates the attributes of a specific article version.
• VALIDATE_ARTICLE_VERSION — Validates a specific version against ETRM rules.
• COPY_ARTICLE — Duplicates an article, including its variables and textual content, to simplify authoring of similar terms.
• CREATE_ARTICLE_RELATIONSHIP — Establishes a relationship between two articles, written to OKC_ARTICLE_RELATNS_ALL.
• DELETE_ARTICLE_RELATIONSHIP — Removes a previously defined article-to-article relationship.
• UPDATE_ARTICLE_VARIABLES — Refreshes the variable assignments associated with an article.
• LATER_APPROVED_EXISTS — Boolean function determining whether a later version of the same article has already been approved, supporting version-control decisions.

Tables Accessed

The package reads and writes a cohesive set of ETRM and shared tables through APPS synonyms:

• OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS — Primary article headers and their version history; the central object store.
• OKC_ARTICLE_VARIABLES, OKC_BUS_VARIABLES_TL, OKC_BUS_VARIABLES_B, OKC_ART_VAR_SECTIONS — Variable definitions, translated descriptions, and article-to-variable section mapping used by PARSE_N_REPLACE_TEXT and UPDATE_ARTICLE_VARIABLES.
• OKC_ARTICLE_RELATNS_ALL — Article-to-article relationship records created and deleted by the relationship APIs.
• OKC_ARTICLE_ADOPTIONS — Tracks adoption of articles, relevant when validating usability of a version.
• OKC_FOLDERS_ALL_B and OKC_FOLDER_CONTENTS — The folder hierarchy that organizes articles within ETRM.
• FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS, FND_DOC_SEQUENCE_CATEGORIES — Oracle Application Object Library document sequencing, supplying article sequence numbers.
• HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION — Human Resources organization data used when resolving organization-based business variables.

Usage Notes

OKC_ARTICLES_GRP is an internal Group-layer package and is not normally called directly by end users. It is invoked indirectly through:

• ETRM forms — Article maintenance, version management, and variable setup windows call the public wrappers OKC_ARTICLES_ALL_PVT and OKC_K_ARTICLES_PVT, which in turn delegate to this package.
• Concurrent programs — Article import, migration, and copy utilities invoke OKC_ARTICLES_IMPORT_GRP, OKC_ARTICLES_MIGRATE_GRP, and OKC_TERMS_COPY_PVT, all of which depend on OKC_ARTICLES_GRP.
• Public APIs — OKC_K_ARTICLE_PUB and OKC_K_NON_STD_ART_GRP expose article operations to external integrations and are built on this group package; OKC_K_ENTITY_LOCKS_GRP uses its locking routines for concurrency control.
• Custom code — Because the package is VALID and documented in ETRM 12.2.2, developers extending Contracts may call its procedures directly, but should prefer the public _PVT and _PUB wrappers to remain within Oracle's supported API boundary.

Customizations should not modify OKC_ARTICLES_GRP; instead, extensions should wrap the documented public packages.