Search Results delete_tmpl_usage




Overview
Explore in AI Chat

Overview

The APPS.OKC_IMP_TERMS_TEMPLATES_PUB package is the public API layer of the Oracle E-Business Suite Contracts (OKC) module responsible for importing, creating, and maintaining terms templates and their constituent structures. Terms templates serve as reusable frameworks that define the standard clauses, sections, articles, and deliverable obligations that appear on contract documents. This package forms part of the import infrastructure that allows template content to be loaded into the ETRM repository programmatically rather than through manual form entry.

The package was last modified under the version tag OKCPITTS.pls 120.1.12020000.2 (dated 2012/07/16), indicating a build level applicable to both the 12.1.1 and 12.2.2 release codelines. It carries an API classification of PUB and is owned by the APPS schema. The internal implementation delegates to the private package OKC_IMP_TERMS_TEMPLATES_PVT, and its datatypes are defined against collection types declared in that private package. Because the metadata records that the package is referenced by zero other packages, it is intended to be invoked directly by external callers rather than as a dependency of other delivered PL/SQL units.

Key Procedures and Functions

The package exposes twelve documented procedures. For creation and maintenance of the core template hierarchy:

For deletion of template components:

For managing template usage assignments:

  • CREATE_TMPL_USAGE — establishes a usage association for a template.
  • UPDATE_TMPL_USAGE — modifies an existing usage association.
  • DELETE_TMPL_USAGE — removes a template usage association. This is the procedure matched by the search term delete_tmpl_usage and is the public entry point for terminating a template's usage record.

All procedures follow the ETRM API convention of accepting a p_commit parameter (defaulting to fnd_api.g_false), and deletion and revision procedures return standard x_return_status, x_msg_data, and x_msg_count out parameters.

Tables Accessed

The supplied metadata does not enumerate the underlying tables reached through APPS synonyms. Based on the functional scope of the procedures, the package operates on the OKC terms template schema — the template header table (OKC_TERMS_TEMPLATES), the section, article, and deliverable detail tables, the template revision structures, and the template usage table that records where a template applies. No dependent table list is available in the provided documentation, and callers should treat the underlying objects as implementation detail accessed exclusively through this public API.

Usage Notes

This package is typically invoked from concurrent programs and custom integration code that load or maintain terms template definitions during implementations and data migrations, and it may be called by forms that administer template content. Because it is a PUB API, it is the supported interface for custom development; direct DML against the underlying template tables is not recommended. Callers should pass a meaningful p_commit value to control transaction boundaries, and should inspect x_return_status and x_msg_data after each call. Because no delivered package references this API, each caller is responsible for its own error handling and for sequencing creation and deletion calls in the correct dependency order (for example, removing articles before deleting the sections or templates that contain them).