Results for “create_quote_from_k”

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

Overview

OKC_OC_INT_KTQ_PVT is a private (PVT) PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the integration between Oracle Quoting (Oracle Order Capture / OKX) and Oracle Contracts (OKC) in the context of Oracle Teleservice / Service Contract functionality. The package name suffix "KTQ" refers to "Contract Terms for Quote", and the private designation indicates that the package is intended for internal use only — it is not a public API and should not be called directly by external or custom code. Its primary business function is to programmatically create and update contract records that originate from quoting activities, ensuring that contract headers, lines, items, parties, rules, and statuses are consistently populated when a quote is converted or associated with a contract.

The package defines numerous global constants that map relationship types, line styles, reference document types, and ASO operation codes to their internal representations. These constants include relationship type codes such as OKX_ORDERHEAD, OKX_ORDERLINE, OKX_QUOTEHEAD, and OKX_QUOTELINE, relationship codes such as CONTRACTISTERMSFORQUOTE, CONTRACTNEGOTIATESQUOTE, and QUOTERENEWSCONTRACT, as well as line style constants like COVER_PROD, SUPPORT, SERVICE, and EXT_WARRANTY. These constants serve as the vocabulary through which the quoting and contracting subsystems communicate.

Key Procedures and Functions

The package exposes two documented procedures:

• CREATE_QUOTE_FROM_K — Creates a quote-related contract record from an existing contract (the "K" notation references the OKC_K contract schema tables). This procedure orchestrates the insertion of contract header, line, item, party role, rule, and status data required to represent a quote within the contracts model.
• UPDATE_QUOTE_FROM_K — Updates an existing quote-derived contract record when the underlying contract data changes. It synchronizes the contract structures with the current state of the associated quote.

Parameter lists are not documented in the ETRM metadata for these procedures; only their names and inferred purpose are available. The package is referenced by two other packages, confirming its role as an internal utility rather than a standalone callable API.

Tables Accessed

The package reads from and writes to the following tables via APPS synonyms:

• OKC_K_HEADERS_B — Stores contract header information; the anchor record for a contract.
• OKC_K_LINES_B, OKC_K_ITEMS — Store contract lines and line items derived from quote structure.
• OKC_K_REL_OBJS — Relationships between contract objects and external objects (e.g., quotes).
• OKC_K_PARTY_ROLES_B, OKC_CONTACTS — Party roles and contact assignments on the contract.
• OKC_RULES_B, OKC_RULE_GROUPS_B, OKC_GOVERNANCES — Contract terms, rule groups, and governance rules.
• OKC_LINE_STYLES_B, OKC_LINE_STYLE_SOURCES, OKC_ROLE_SOURCES — Line style definitions and their source mappings.
• OKC_STATUSES_B — Contract status definitions.
• FND_LOOKUP_VALUES, JTF_OBJECTS_B — Lookup values and JTF object definitions used for validation and reference resolution.

Usage Notes

OKC_OC_INT_KTQ_PVT is invoked internally by other packages in the Oracle Contracts / Quoting integration stack rather than by forms or concurrent programs directly. Because it is classified as a PVT package, customers and partners should not invoke its procedures from custom code; any customization should use supported public APIs. The package was last modified in 2006 (header version 120.2), indicating it is a stable, legacy component that continues to function across Oracle EBS 12.1.1 and 12.2.2. Understanding its constants is useful when debugging quote-to-contract data flow, particularly when investigating how relationship types such as CONTRACTISTERMSFORQUOTE or CONTRACTNEGOTIATESQUOTE are assigned to contract records.