Search Results update_target_contract

Overview

OKL_COPY_CONTRACT_PUB_W is a public wrapper package in the Oracle E-Business Suite (EBS) Contracts (OKL / ETRM — Enterprise Trading and Rent Management) module. It exposes the core contract-copying business logic used by Oracle Lease Management and related contract authoring flows. The package provides a stable, publicly consumable interface for validating whether a source contract may be copied, managing sub-contract copy rules, updating target contract attributes, and orchestrating the actual copy of contract components from a source to a target contract. In practice, the package sits behind the contract "Copy" and "Copy to Template" actions available in the Contracts forms and is authored with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. The package header (version 120.1, last modified 2005) is delivered as a "noship" build, indicating it is a supporting wrapper rather than a standalone shipped entity.

Key Procedures and Functions

• IS_COPY_ALLOWED — The procedure most directly relevant to the user's search term. Given a contract header identifier and a status code, it evaluates the contract's current state and returns a boolean indicator (via ddrosetta_retval_bool) stating whether the contract is eligible to be copied. This is the gating check invoked before any copy operation proceeds.
• IS_SUBCONTRACT_ALLOWED — Parallel to IS_COPY_ALLOWED but scoped to sub-contract creation. It accepts the same header/status inputs and returns a boolean indicating whether the contract may be used as a source for a sub-contract.
• UPDATE_TARGET_CONTRACT — Takes a target contract header identifier and returns a boolean result, performing the updates needed on the destination contract record as part of the copy lifecycle.
• COPY_COMPONENTS — The main copy driver. It accepts API version, initialization message list, and standard EBS out-parameters (x_return_status, x_msg_count, x_msg_data), plus source and target header IDs, contract number and modifier, template flag, copy reference, party-copy flag, SCS code, intent, prospect, and multiple JTF_NUMBER_TABLE / JTF_VARCHAR2_TABLE_100 parameter arrays. It returns the created contract header identifier in x_chr_id. These array parameters carry flexible attribute values through the copy.

Tables Accessed

The documented metadata for this package does not enumerate specific tables accessed via APPS synonyms, and it is referenced by zero other packages. Functionally, the procedures operate on the OKL contract header and component tables (such as the OKC/OKL contract and component base tables) to read source values, validate status, and write copied records into the target contract. Because table-level detail is absent from the provided metadata, exact table names should be confirmed by inspecting the package body (OKLUCOPS.pls).

Usage Notes

This package is typically invoked from the Contracts form's Copy action, from concurrent programs that mass-copy or template contracts, and from custom PL/SQL integrations requiring programmatic contract replication. Callers should first invoke IS_COPY_ALLOWED to enforce business validation, then call COPY_COMPONENTS, checking x_return_status and the message stack on completion. It is not documented as a customer-modifiable API, so extensions should call it read-only rather than alter its signature.