Search Results html_pieces

Overview

OKC_XPRT_INT_GRP is a grouping (GRP) package body in the Oracle E-Business Suite Contracts (OKC) application, owned by APPS and associated with Application ID 510 (Oracle Contracts). The package provides internal group-level processing routines that support the export and manipulation of contract terms and template structures. Its scope centers on two related areas: retrieving contract terms from a given document context, and deleting empty sections from a document, with the latter also renumbering terms when sections are removed.

The package follows the standard EBS PL/SQL API conventions. It declares global constants for API status codes (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), a package name token, an application name derived from OKC_API, and logging controls referencing FND_LOG. These declarations indicate the procedures participate in the common message-handling and error-token framework used across Contract Core APIs. The header comment (120.18, dated 2006) and an embedded reference to Bug 4685428 confirm this is a long-standing, maintained component rather than a point release artifact.

Key Procedures and Functions

The documented package exposes two procedures:

• GET_CONTRACT_TERMS — Retrieves the terms associated with a contract document. In the context of term export and section processing, this procedure supplies the term set that downstream logic (such as renumbering) operates against. Parameter details are not enumerated in the catalogued metadata, so consumers should reference the distributed ETRM specification.
• DELETE_EMPTY_SECTIONS — Removes sections that contain no terms and subsequently renumbers the remaining terms so that numbering remains contiguous after deletion. The visible declaration accepts API version, initialization message list flag, document type, document identifier, template identifier, and document number as inputs, and returns status, message count, and message data as outputs. A local variable l_api_name supports error logging.

Both are procedural; no documented functions are listed.

Tables Accessed

The package reads and writes through APPS synonyms against the following documented tables:

• OKC_K_ARTICLES_B — the base table holding contract articles/terms; central to both term retrieval and renumbering.
• OKC_SECTIONS_B — stores section definitions; the target of empty-section deletion.
• OKC_TERMS_TEMPLATES_ALL — template term definitions used to resolve expected structure.
• OKC_TEMPLATE_USAGES — links templates to the documents that use them, supporting template-driven processing.
• ASO_QUOTE_HEADERS — quote header data, relevant when the source document originates from a quote.
• PLITBLM — an internal PL/SQL table of messages used for the message stack and error propagation.

The combination indicates the package joins document, template, and section metadata to determine which sections are empty and which terms require renumbering.

Usage Notes

As an internal (INT) group package, OKC_XPRT_INT_GRP is not a user-facing entry point. It is invoked from Oracle Contracts forms during term editing and export operations, from concurrent programs that process contract templates, and from other PL/SQL packages — the metadata records two dependent packages. Custom code should call the public procedures only within the standard API call sequence (set message level, call the procedure, interrogate x_return_status and the message stack), and should treat the package as subject to change across releases. Behavior is consistent between EBS 12.1.1 and 12.2.2, with no online-patching differences noted.