Search Results oks_kto_int_pub




Overview
Explore in AI Chat

Overview

OKS_KTO_INT_PUB is a public PL/SQL package body in the APPS schema that belongs to the Oracle E-Business Suite service contracts family of modules. Its purpose is to provide a supported public application programming interface for creating order records from service contract data. The name follows Oracle's established convention: the OKS prefix identifies the Service Contracts (Contracts Core) module, KTO indicates the knowledge-to-order transformation context, and the _PUB suffix marks the program unit as a public API intended for external invocation.

In the terminology of Oracle EBS integration architecture, OKS_KTO_INT_PUB functions as a thin public façade. It does not itself contain the bulk of the business logic; instead it delegates to the private package OKS_OC_INT_KTO_PVT, which holds the internal implementation. This separation mirrors Oracle's standard API layering, in which public packages expose a stable, documented surface while private packages remain subject to change without notice. The package is documented as part of the ETRM 12.1.1 and 12.2.2 code lines and carries a VALID status in the data dictionary.

Key Procedures and Functions

The documented public interface consists of a single procedure and one additional program unit, for a total of two.

  • CREATE_ORDER_FROM_K — Creates an order originating from a service contract. The procedure accepts a contract identifier, resolves the associated contract header information, and constructs the order structure through the OKC and OKS base APIs. This is the primary entry point for callers who need to instantiate order data from an existing service contract record.

The procedure relies on Oracle's standard API infrastructure, including FND_API for message handling and the global API return-status conventions. No parameter lists are reproduced here; callers should consult the package specification in the target instance for the exact signature applicable to their patch level.

Tables Accessed

The package body references OKC_K_HEADERS_B, the base table holding contract header records, through an APPS synonym. This table supplies the contract attributes required to build the corresponding order. The dependency listing also shows OKX_ORDER_HEADERS_V, a view over order header information used to validate or read order data, and OKC_K_HEADERS_B alongside the OKC_API and OKS_OC_INT_KTO_PVT packages. Direct SQL statements within the package are limited; most data manipulation is performed by the called APIs rather than by the package itself.

Usage Notes

Because OKS_KTO_INT_PUB is classified as a public API, it is the correct integration point for custom code, conversions, and external interfaces that must generate orders from service contracts. Typical invocation patterns include custom PL/SQL scripts during data migration, extension hooks within Oracle Service Contracts forms, and calls from third-party or middleware systems via database links. Callers should initialize the FND global variables and honor the API return status before committing, and should not call the private OKS_OC_INT_KTO_PVT package directly, since its interface may change between releases. The package is not referenced by any other database object, confirming that it is an entry point rather than an internal dependency. Compatibility should be verified against the target instance's patch level, as the underlying private package is updated administratively without public notice.