Results for “add_concurrent”

13 results




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

Overview

OKC_COPY_CONTRACT_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Contract Management (OKC) module, owned by the APPS schema. Its overarching business purpose is to implement the logic required to copy an existing contract—or selected components of one—into a new or target contract. It centralizes the deep-clone semantics needed when users duplicate a contract header, lines, parties, articles, rules, conditions, and events, or when the system copies a contract template into a live contract. The package is classified as PVT, meaning it is an internal implementation layer not intended for direct customer invocation; the public API surface exposed to external callers is OKC_COPY_CONTRACT_PUB, which delegates to this package.

The "$Header" line identifies the source file as OKCRCPYS.pls, last modified in the 12.1.1 code line (120.2.12010000.3, 2008), which remains functionally consistent in the 12.2.2 ETRM metadata. The package begins by declaring a large set of SUBTYPE aliases that map record and table types back to the public packages (OKC_CONTRACT_PUB, OKC_RULE_PUB, OKC_K_ARTICLE_PUB, OKC_CONDITIONS_PUB, OKC_CONTRACT_ITEM_PUB, OKC_CONTRACT_PARTY_PUB, and OKC_CONTRACT_GROUP_PUB). These aliases ensure that the copy routines operate on the same strongly typed structures used throughout the OKC API stack.

Key Procedures and Functions

The metadata documents seventeen procedures and functions. Copy-related entry points include COPY_CONTRACT, which orchestrates a full contract duplication; COPY_CONTRACT_HEADER, COPY_CONTRACT_LINES, and COPY_CONTRACT_LINE, which handle header-level and line-level cloning; and COPY_COMPONENTS, which drives the copying of subordinate entities. Component-level routines consist of COPY_PARTY_ROLES, COPY_ARTICLES, COPY_LATEST_ARTICLES, COPY_EVENTS, and COPY_RULES, each responsible for replicating a specific class of contract data.

Control and validation routines include IS_COPY_ALLOWED, which determines whether a given contract may be copied; IS_SUBCONTRACT_ALLOWED, which governs subcontract copy eligibility; and DERIVE_LINE_STYLE, which resolves the appropriate line style during duplication. Target and template maintenance is handled by UPDATE_TARGET_CONTRACT and UPDATE_TEMPLATE_CONTRACT. The pair ADD_CONCURRENT and COPY_CONCURRENT supports concurrent-processing behavior, allowing a copy to be queued and executed as a background concurrent request.

Tables Accessed

The package reads and writes the core contract tables via APPS synonyms. Header, article, and grouping data reside in OKC_K_HEADERS_B, OKC_K_ARTICLES_B, and OKC_K_GROUPS_B. Condition structures are held in OKC_CONDITION_HEADERS_B, OKC_CONDITION_HEADERS_BH, and OKC_CONDITION_LINES_B. Rules and governance are captured in OKC_GOVERNANCES, while access control is tracked in OKC_K_ACCESSES. Audit history is written to OKC_K_HISTORY_B. Concurrent copy mechanics rely on OKC_CONC_REQUESTS and OKC_CONC_REQUESTS_S, and change tracking uses OKC_CHANGE_REQUESTS_B. Setup metadata is drawn from OKC_CLASS_OPERATIONS and FND_LOOKUP_VALUES, and document attachments are handled through FND_ATTACHED_DOCUMENTS.

Usage Notes

This package is an internal implementation unit; customers should invoke copy operations through the public OKC_COPY_CONTRACT_PUB wrapper rather than calling OKC_COPY_CONTRACT_PVT directly. It is exercised by the Contract Management forms when a user selects a copy action, by concurrent programs that mass-copy or template-instantiate contracts (via COPY_CONCURRENT and ADD_CONCURRENT), and by custom code that requires programmatic duplication of contract structures. Because it performs bulk inserts across many child tables, it should be run within an appropriately scoped transaction, and concurrent invocations should be used for large contracts to avoid online-form timeouts. As a PVT package, its signature may change between patches, so custom integrations must bind only to the public API.