Results for “top_base_line”

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

Overview

OKC_OC_INT_CONFIG_PVT is a private PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module that supports the integration of order capture and quoting data with contract configuration structures. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than its owner. Its core purpose is to build and manage configuration line hierarchies within a contract from external order and quote sources, and to maintain the relationships between contract lines and the quote lines from which they were derived. The name component "OC_INT" indicates the Order Capture integration role, while "CONFIG" reflects the package's focus on configured item lines such as models, bases, and options.

The package defines several constants that classify contract line configuration item types, including G_MODEL_LINE ('TOP_MODEL_LINE'), G_BASE_LINE ('TOP_BASE_LINE'), and G_NORMAL_LINE ('CONFIG'). It also declares collection types for holding line information, source information, and quote-to-contract line relationships, which are used to map external order and quote data onto the OKC contract line structure.

Key Procedures and Functions

• CREATE_K_CONFIG_LINES — Creates contract configuration lines from external order or quote source data. It is the primary routine for populating the OKC_K_LINES_B structure with configured model, base, and option lines derived from an order capture source. It leverages the line information and source information record types declared in the package to carry source references, quantities, units of measure, and line numbering into the newly created contract lines.
• QUOTE_LINE_RELATIONSHIP — Establishes and manages the relationship between contract lines and their originating quote lines. It uses the line relationship record and table types (which carry k_line_id, k_parent_line_id, quote line index, and item type code) to record how contract configuration lines map back to quote line entries, preserving the parent-child linkage across the integration.

Tables Accessed

• OKC_K_LINES_B — The base table for contract lines. The package reads and writes configuration item type, line style, and line identifiers here. This is the central table where the generated configuration lines are stored.
• OKC_LINE_STYLES_B — Stores line style definitions. The package references the line style code (lty_code) to correctly classify configuration lines during creation and validation.
• PLITBLM — The standard Oracle Applications PL/SQL index-by table used for bulk processing and temporary collection handling, referenced by the package for intermediate line processing.

Note that the package also draws data through APPS synonyms for the order and quote objects, including OKX_ORDER_HEADERS_V, OKX_ORDER_LINES_V, and OKX_QUOTE_LINES_V (originally referenced as ASO_QUOTE_LINES_ALL before a bug fix).

Usage Notes

OKC_OC_INT_CONFIG_PVT is a private (PVT) API and is not intended for direct invocation by external or customer code. It is referenced by four other packages within the Contracts integration stack, which call it internally during order-to-contract and quote-to-contract flows. Typical invocation occurs when a quote or order containing configured items is converted into a contract, triggering the creation of contract configuration lines and the establishment of quote-to-contract line relationships. Because it works with the OKX order and quote views, it depends on the presence of order capture data in the calling context. Administrators and developers troubleshooting contract configuration issues should expect this package to appear in the call stack of the higher-level integration APIs rather than being invoked independently, and any references to "emp getintopc" in a search context should be understood as unrelated to this object's documented function.