Search Results validate_term

Overview

OKE_TERMS_PUB is a public PL/SQL API package owned by the APPS schema within Oracle E-Business Suite. It belongs to the Oracle Knowledge Base / Enterprise Transaction and Relationship Management (ETRM) module, which governs the authoring, negotiation, and management of contracts and related terms. The package exposes a supported, externally callable interface for the creation, maintenance, validation, and lifecycle management of contract terms — the discrete clauses, conditions, and structured attributes that together define the obligations and entitlements of a contract. As a "_PUB" package, it is intended to be invoked by other application modules and by customer extensions, shielding callers from the underlying private implementation logic contained in OKETRM_PVT and related internal units. The package is documented as VALID in the APPS schema and forms part of the standard contract terms API layer shipped with EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes five principal operations, which together provide full programmatic control over contract terms:

• CREATE_TERM — Establishes a new term record against a contract or terms template, applying the supplied term attributes and defaulting rules.
• VALIDATE_TERM — Performs validation against the term definition and its associated value set, confirming that the proposed term data satisfies the configured business rules before commit.
• COPY_TERM — Duplicates an existing term, typically to replicate terms from a template or source contract onto a target contract, adjusting ownership as required.
• LOCK_TERM — Places a term into a locked state to prevent further modification, supporting the contract approval and freeze workflow.
• DELETE_TERM — Removes a term record, respecting referential and workflow constraints defined by the terms model.

The metadata records ten procedures or functions in total; the remaining entries are internal helpers and overloads supporting the five operations listed above. Parameter lists are not published here and should not be assumed.

Tables Accessed

OKE_TERMS_PUB operates primarily against OKE_K_TERMS, the core Knowledge Base terms table that stores term definitions, values, and their association to contract documents. This is the principal target of the CREATE, COPY, DELETE, and LOCK operations, and the source of data validated by VALIDATE_TERM. The package also references PLITBLM, a standard EBS PL/SQL API table used for storing and retrieving descriptive flexfield and multi-row attribute structures. Access is performed through APPS synonyms, consistent with the standard schema-access pattern in EBS.

Usage Notes

The package is invoked by higher-level application code rather than directly by end users. Documented dependencies show that OKE_CONTRACT_PUB and OKE_KCOPY_PKG reference OKE_TERMS_PUB, indicating it is called during contract authoring and during contract copy operations respectively. It is also self-referential, reflecting internal reuse. In practice, the API is called from the Contracts and Terms/Knowledge Base forms, from concurrent programs that create or propagate terms, and from custom extensions and inbound interfaces that need to programmatically manipulate contract terms. Developers should call the public procedures rather than the private OKETRM_PVT units, and should expect the standard EBS API conventions: an initialization/context step, validation before commit, and explicit error handling through the returned status and message variables. Custom code should not update OKE_K_TERMS directly, as this bypasses locking and validation logic enforced by the public API.