Search Results okl_copy_contract_pub_w




Overview
Explore in AI Chat

Overview

OKL_COPY_CONTRACT_PUB_W is the public wrapper package body for the Oracle Lease and Finance Management (OKL) contract copy feature within Oracle E-Business Suite releases 12.1.1 and 12.2.2. The _W suffix identifies it as a thin, publicly callable layer that shields external callers from the internal implementation held in OKL_COPY_CONTRACT_PVT and OKL_COPY_CONTRACT_PVT_W. Its principal business purpose is to duplicate an existing lease or loan contract — together with its associated components, lines, and pricing structures — into a new or target contract record, while enforcing the eligibility rules that determine whether a copy operation is permitted at all.

The package resides in the APPS schema with a status of VALID and is classified as an OTHER API. It is not referenced by any other database object, which confirms its role as a top-level entry point rather than an internal utility.

Key Procedures and Functions

The ETRM documentation lists four documented program units in this package body:

  • IS_COPY_ALLOWED — A validation routine that determines whether a given source contract may be copied. Callers use the result to enable or suppress copy actions in the user interface and to short-circuit processing before any data manipulation begins.
  • IS_SUBCONTRACT_ALLOWED — A companion eligibility check that establishes whether subcontract-level information attached to the contract can participate in the copy. This separates contract-level copy eligibility from the additional conditions that govern subcontract structures.
  • UPDATE_TARGET_CONTRACT — Applies the copy results to the destination contract, updating the target record with the values derived from the source contract and the copy configuration supplied by the caller.
  • COPY_COMPONENTS — Performs the component-level duplication, propagating the constituent parts of the source contract into the target contract so that the copied agreement is functionally complete.

No parameter lists are documented for these units, and none should be assumed. The procedures are invoked collectively to validate, execute, and finalize a contract copy.

Tables Accessed

The documented metadata does not enumerate base tables accessed through APPS synonyms. The dependency list instead shows that OKL_COPY_CONTRACT_PUB_W relies on OKL_COPY_CONTRACT_PUB, OKL_COPY_CONTRACT_PVT, and OKL_COPY_CONTRACT_PVT_W for its underlying SQL activity. In practice, the actual INSERT, UPDATE, and SELECT statements against the OKL contract, contract line, and component tables are executed by these private packages and surfaced through this wrapper. Dependency entries for JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100 indicate that the private layer passes collections of identifiers and character values for bulk or set-based processing. FND_API and STANDARD provide the standard error-handling and PL/SQL runtime facilities.

Usage Notes

OKL_COPY_CONTRACT_PUB_W is the interface intended for external consumers. Oracle Forms-based contract entry and maintenance screens in the OKL module call it when a user initiates a copy of an existing lease or loan agreement. Concurrent programs that mass-duplicate contracts or migrate contract data may also invoke the wrapper. Custom extensions and integrations should call this public package rather than the _PVT implementation packages, since the private layer is subject to change without notice while the public wrapper preserves a stable contract. Because the package is not referenced by any other database object, it carries no downstream dependency risk within the schema, and it is safe to treat as a terminal API surface for contract copy operations.