Results for “okc_oc_int_kto_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.OKC_OC_INT_KTO_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite Contracts (OKC) and Order Capture (ASO/OKX) integration layer. Its name reflects its role: "OC" denotes Order Capture, "INT" denotes integration, and "KTO" denotes Contract-To-Order processing. The package serves a single, focused business function — supporting the creation of an order (or order-related relationship) from an existing contract, thereby enabling the "contract-to-order" data flow within the Order Capture and Service Contracts architecture.

The package header, with a header string dating to 2005, declares a set of relationship type and relationship code constants (for example, OKX_ORDERHEAD, OKX_QUOTEHEAD, CONTRACTFORORDER, CONTRACTISTERMSOFQUOTE, and CONTRACTNEGOTIATESQUOTE) along with item-classification constants (TOP_MODEL_LINE, TOP_BASE_LINE, CONFIG, SRV, and their ASO equivalents). These constants drive the relationship and configuration semantics processed by the package. Global variables (l_contract_number, l_contract_number_modifier, l_order_number) are also declared for use across the package body.

Key Procedures and Functions

• CREATE_ORDER_FROM_K — Creates an order from a contract by first populating quote input records from the contract as an initial stage. It establishes relationship rows from the ordering contract to the order, and may additionally create a subject-to relationship from the order to a master contract when the ordering contract is itself subject to a master contract. The procedure is documented as implementing process 2.1 in the high-level design data flow diagram and ultimately calls ASO_ORDER_INT.CREATE_ORDER to perform the actual order creation.
• CREATE_K_RELATIONSHIPS — Creates the contract-side relationship records that link the contract to the generated order (and, where applicable, to a master contract). This procedure encapsulates the relationship-type and relationship-code logic defined by the package constants such as ORDERSHIPSCONTRACT, CONTRACTFORORDER, and the quote-related negotiation codes.

Parameter lists are not reproduced here; the documented metadata identifies the procedures by name and purpose only.

Tables Accessed

• OKC_K_HEADERS_B — The contract headers base table. The package reads contract header information (contract number and modifier source columns are typed against it) to identify the source contract driving order creation and to supply relationship context.
• OKC_K_REL_OBJS — The contract relationship objects table. Relationship rows created by CREATE_K_RELATIONSHIPS and used by CREATE_ORDER_FROM_K are persisted here, associating the contract with the resulting order and any master contract.

Usage Notes

As a PVT-classified package, OKC_OC_INT_KTO_PVT is not a public, supported integration point. It is invoked internally by higher-level order-capture or contracts processing logic, including references from at least one other application package as documented in the ETRM metadata. Typical invocation scenarios include seeded Order Capture workflows that convert an ordering contract into an order, and internal EBS concurrent or form-driven processes that use Service Contracts data as the seed for order creation.

Custom code should not call this package directly. Because it is private and its header predates the 12.1.1 and 12.2.2 releases, Oracle may alter its signature or behavior without notice across upgrades, including the 12.1.1 to 12.2.2 transition. Integrations requiring contract-to-order behavior should rely on documented public APIs, notably ASO_ORDER_INT.CREATE_ORDER, which this package itself calls, and on the supported Contracts public APIs for relationship creation.