Search Results okc_copy_contract_pub
Overview
The APPS.OKC_COPY_CONTRACT_PUB package body is the public API layer within Oracle E-Business Suite's Contract Lifecycle Management (formerly ETRM — Enterprise Trading and Risk Management) module responsible for duplicating contract records. It allows a user or process to generate a complete new contract from an existing source contract, carrying forward structure, parties, articles, lines, rules, and components while applying copy-control logic that governs whether a given source contract is eligible to be duplicated. The package is classified as a PUB (public) API, meaning it is the supported entry point for external callers, delegating the substantive work to the private worker package OKC_COPY_CONTRACT_PVT.
Because it sits at the boundary between the public contract model and internal business logic, it depends on OKC_API and OKC_CVM_PVT for core contract and version-management operations, on FND_PROFILE for profile option evaluation, and on the standard FND_API framework for message handling and API conventions. It is documented across both EBS 12.1.1 and 12.2.2, and is itself referenced by five other packages, indicating that contract copy is reused as a building block by higher-level business flows rather than being an isolated utility.
Key Procedures and Functions
The package exposes fourteen documented procedures and functions. They fall into three broad categories.
- Eligibility and validation:
IS_COPY_ALLOWEDandIS_SUBCONTRACT_ALLOWEDdetermine whether a source contract or a subcontract line may be copied, typically returning a boolean or status indicator to the caller before any data is written. - Granular copy operations:
COPY_COMPONENTS,COPY_CONTRACT_LINES,COPY_RULES,COPY_PARTY_ROLES,COPY_ARTICLES, andCOPY_LATEST_ARTICLESeach duplicate a specific sub-entity of a contract. These allow a caller to copy selectively — for example, copying only the latest version of articles rather than the entire article history — which is essential for template-driven contract generation. - Orchestration:
COPY_CONTRACTis the primary entry point, driving a full contract duplication by invoking the granular copy routines in the correct sequence.COPY_CONCURRENTsupports execution from a concurrent program context,DERIVE_LINE_STYLEdetermines the line-style classification for the copied lines, andUPDATE_TARGET_CONTRACTandUPDATE_TEMPLATE_CONTRACTfinalize or adjust the newly created target and template contracts after the copy completes.
Tables Accessed
The ETRM metadata does not enumerate explicit base tables; access is performed through APPS synonyms. Operationally, the package reads the source contract header and its child entities (articles, party roles, rules, lines, and components) and writes corresponding new rows for the target contract. The copy is version-aware — the presence of COPY_LATEST_ARTICLES and the dependency on OKC_CVM_PVT confirm that contract version management (CVM) tables are consulted to resolve which article versions belong to the effective contract. Party role duplication writes to the contract party role tables, and rule duplication writes to the contract rule tables used by the rules engine. Because all DML is routed through OKC_COPY_CONTRACT_PVT, the public package itself is largely an interface wrapper.
Usage Notes
OKC_COPY_CONTRACT_PUB is typically invoked when a user selects a "Copy Contract" or "Create from Template" action in the Contracts workbench, and by concurrent programs that mass-copy contracts (hence COPY_CONCURRENT). Custom code should call COPY_CONTRACT rather than the PVT worker, preceding the call with IS_COPY_ALLOWED to honor copy restrictions such as contract type, status, or security. Because the package relies on FND_API conventions, callers must initialize the standard API message list and check the return status before committing. As a PUB API it is a supported extension point, but it is not referenced by any database object, so upgrades that alter internal PVT logic can change behavior without affecting the public signature.
-
PACKAGE BODY: APPS.OKC_COPY_CONTRACT_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_COPY_CONTRACT_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKC_COPY_CONTRACT_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_COPY_CONTRACT_PUB, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PUB, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PUB, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CAT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CAT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CAT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CAT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CAC_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CAC_PVT, status:VALID,
-
PACKAGE: APPS.OKC_RGP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_RGP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CGC_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CGC_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CGC_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CGC_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKE_KCOPY_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_KCOPY_PKG, status:VALID,
-
PACKAGE: APPS.OKC_CONTRACT_GROUP_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CONTRACT_GROUP_PUB, status:VALID,
-
PACKAGE: APPS.OKC_CNH_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CNH_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CAC_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CAC_PVT, status:VALID,
-
PACKAGE: APPS.OKC_RGP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_RGP_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CONTRACT_GROUP_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CONTRACT_GROUP_PUB, status:VALID,
-
PACKAGE: APPS.OKC_RUL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_RUL_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CNH_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CNH_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CIM_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CIM_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CNL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CNL_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CNL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CNL_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CPL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CPL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKC_RENEW_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_RENEW_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CVM_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CVM_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKE_KCOPY_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_KCOPY_PKG, status:VALID,
-
PACKAGE: APPS.OKC_CIM_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CIM_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CVM_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CVM_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CPL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CPL_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CPS_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CPS_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CPS_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CPS_PVT, status:VALID,
-
PACKAGE: APPS.OKC_RUL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_RUL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKC_RENEW_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_RENEW_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKS_BILL_UTIL_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_BILL_UTIL_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKS_BILL_UTIL_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKS_BILL_UTIL_PUB, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PUB
12.2.2
-
PACKAGE: APPS.OKC_CLE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CLE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_COPY_CONTRACT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_COPY_CONTRACT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CHR_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CHR_PVT, status:VALID,
-
PACKAGE: APPS.OKC_COPY_CONTRACT_PUB
12.1.1
-
PACKAGE: APPS.OKC_CHR_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_CHR_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_COPY_CONTRACT_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_COPY_CONTRACT_PVT, status:VALID,
-
PACKAGE: APPS.OKC_CLE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CLE_PVT, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
PACKAGE BODY: APPS.OKC_COPY_CONTRACT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKC_COPY_CONTRACT_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_COPY_CONTRACT_PVT, status:VALID,