Search Results g_tmpl_doc_type




Overview
Explore in AI Chat

Overview

OKC_TERMS_QA_PVT is a private (PVT) PL/SQL package body in the Oracle E-Business Suite Contracts (OKC) module — specifically the Oracle Terms and Conditions / ETRM (Enterprise Contracts Terms Management) subsystem. Its business purpose is to perform quality assurance (QA) validation on contract terms, templates, and articles before they are adopted into a contract or published for use. The package carries the standard PVT classification, indicating that its procedures are intended for internal consumption by the OKC_TERMS_QA public API layer and other OKC packages rather than being called directly by external code.

The package declares a suite of global constants inherited from OKC_API, OKC_TERMS_UTIL_GRP, and OKC_TERMS_QA_GRP, establishing consistent values for message tokens (G_REQUIRED_VALUE, G_INVALID_VALUE), return status flags (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), QA status codes (G_QA_STS_SUCCESS, G_QA_STS_ERROR, G_QA_STS_WARNING), and the template document type constant referenced by the search term g_tmpl_doc_type. That constant is populated from OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE, confirming that g_tmpl_doc_type is the canonical identifier used throughout the package to distinguish template documents (as opposed to contract or other business document types) during QA processing.

Key Procedures and Functions

  • QA_DOC — The principal validation routine. It drives the quality-assurance check of a terms document, evaluating the document against the QA lists and variables defined for its business document type and recording findings.
  • LOG_QA_MESSAGES — Persists QA outcomes (success, error, or warning messages) generated during validation, writing them to the QA error repository so that users can review results after an action.
  • GET_QA_CODE_DETAIL — Retrieves descriptive detail for a QA code, returning the corresponding message or status information for a given validation outcome.
  • CHECK_LOCK_CONTRACT — Verifies whether the contract under review is currently locked, preventing QA or modification from proceeding against a record held by another user or process.
  • CHECK_CONTRACT_ADMIN — Determines whether the current user holds the contract administrator privilege required to perform the requested QA operation, supporting the package's authorization model.

Tables Accessed

The package operates across the ETRM article and QA schema. It reads and writes QA definitions and results in OKC_DOC_QA_LISTS and OKC_QA_ERRORS_T (and related QA lists), which supply the rules and store diagnostics. Article content is evaluated through OKC_K_ARTICLES_B, OKC_ARTICLES_ALL, OKC_ARTICLE_ADOPTIONS, OKC_ARTICLE_RELATNS_ALL, OKC_ARTICLE_VARIABLES, and OKC_ARTICLE_VERSIONS, together with OKC_K_ART_VARIABLES for adopted article variables. Business document types and variables are resolved via OKC_BUS_DOC_TYPES_B/TL, OKC_BUS_VARIABLES_B/TL, and allowed template usage via OKC_ALLOWED_TMPL_USAGES. FND_USER supports user/administrator checks. All access occurs through APPS synonyms, consistent with the 12.1.1 / 12.2.2 unified APPS schema.

Usage Notes

OKC_TERMS_QA_PVT is referenced by seven other packages and is normally invoked indirectly through the OKC_TERMS_QA public API rather than by custom code. In Oracle EBS 12.1.1 and 12.2.2 it executes when users adopt or submit contract terms, articles, or templates for validation from the Contracts authoring UI or during related concurrent processing. Custom integrations should call the corresponding public API (>_PUB) packages; direct calls to this private package are unsupported and may change between patch levels, as evidenced by its versioned header.