Search Results okc_terms_tmpl_approval_grp




Overview
Explore in AI Chat

Overview

The APPS.OKC_TERMS_TMPL_APPROVAL_GRP package is a member of the Oracle E-Business Suite Contracts (OKC) family of APIs, classified within ETRM as a GRP (group) API package. Its business purpose is to initiate the approval workflow associated with terms templates in Oracle Contracts. Terms templates (OKC_TERMS_TEMPLATES) define reusable clauses, articles, and boilerplate language that are applied to contract documents. Because changes to an approved template can affect many downstream contracts, Oracle Contracts provides an approval mechanism that governs when a template becomes active and available for use. This package encapsulates the logic that submits a terms template into that approval process.

The package follows the standard Oracle EBS API architecture. It is owned by the APPS schema, has a separate specification and body, and depends on the Oracle Application Object Library API, FND_API, which supplies the common API error-handling, message, and return-status conventions used across EBS. This dependency indicates the package conforms to the traditional FND_API-based API pattern (with standard return status, message data, and error tables) rather than a purely internal helper implementation.

Key Procedures and Functions

  • START_APPROVAL — The single documented entry point. This procedure is responsible for launching the approval process for a terms template. In practical terms, it prepares the template for workflow-based approval and hands control to the Oracle Workflow / approval engine so that designated approvers can review and act on the template. No signature, parameter list, or return values are documented in the ETRM metadata, so callers should consult the package specification (OKC_TERMS_TMPL_APPROVAL_GRP) directly to determine the exact argument set before invoking it.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

  • OKC_TERMS_TEMPLATES — The primary header table for terms templates. START_APPROVAL uses this table to identify the template being submitted, to read its current status, and to update approval-related columns such as the workflow or approval status as the process progresses.
  • OKC_K_ARTICLES_B — The base table storing the articles (structured clause content) associated with contract and template documents. Access to this table supports the need to reference the article content governed by, or carried into, the template being approved.

Both tables are central to the terms-template data model, and their inclusion confirms the package operates on the template definition layer rather than on authored contract instances.

Usage Notes

This package is typically invoked from the Oracle Contracts application when a user submits a terms template for approval through the relevant Oracle Forms UI, or programmatically from custom extensions that need to trigger the same approval behavior. Because ETRM documents it as a GRP-class API depending on FND_API, callers should expect the standard API calling convention and should capture and inspect the returned status to handle validation or workflow errors.

The dependency listing shows the package is referenced by no other packaged APIs, so its role is as a call target rather than as reusable internal infrastructure. In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID. When extending or troubleshooting template approvals, developers should read the package specification for the exact START_APPROVAL signature, since the ETRM metadata intentionally omits parameter details. Direct modification of the underlying tables is not advisable; the supported path is to call the API so that workflow notifications, status transitions, and audit information remain consistent.