Search Results okl_deal_create_pub_w




Overview
Explore in AI Chat

Overview

OKL_DEAL_CREATE_PUB_W is a public wrapper package in the Oracle E-Business Suite (EBS) Applications (APPS) schema, belonging to the Oracle Lease and Finance Management (OKL) module within the ETRM (Enterprise Territory and Revenue Management) product family. As the "_W" suffix convention suggests, this package operates as a thin wrapper layer that exposes the core business logic implemented in OKL_DEAL_CREATE_PUB to external callers, including Oracle Forms, concurrent programs, and custom integrations. Its principal business function is the creation, loading, and maintenance of lease and finance deals, together with their associated parties, within the OKL data model. In EBS 12.1.1 and 12.2.2, such wrapper packages form part of the public API surface that shields callers from internal implementation details while enforcing the standard EBS API conventions defined in FND_API, notably the returned status and message handling through the standard API result variables.

Key Procedures and Functions

The package exposes nine documented procedures spanning deal lifecycle operations and Rosetta data conversion utilities:

  • CREATE_DEAL — Creates a new lease or finance deal record, applying the standard EBS API validation and defaults framework.
  • UPDATE_DEAL — Modifies an existing deal, updating its attributes while preserving established validation rules.
  • LOAD_DEAL — Populates and loads deal data through the package's public interface, typically used for bulk or integration-driven deal creation.
  • CREATE_PARTY — Creates a party associated with a deal, such as a lessee, lessor, or guarantor.
  • UPDATE_PARTY — Updates an existing party record linked to a deal.
  • ROSETTA_TABLE_COPY_IN_P7 / ROSETTA_TABLE_COPY_OUT_P7 — Paired conversion routines that copy data into and out of Rosetta table structures for processing stage 7.
  • ROSETTA_TABLE_COPY_IN_P9 / ROSETTA_TABLE_COPY_OUT_P9 — Equivalent paired conversion routines for processing stage 9.

The Rosetta procedures leverage the JTF_DATE_TABLE, JTF_NUMBER_TABLE, and JTF_VARCHAR2_TABLE_* collection types to pass multi-row, multi-datatype data sets between the PL/SQL layer and external callers.

Tables Accessed

The documented table dependency for this package is PLITBLM, referenced through an APPS synonym. This is the standard EBS multi-lingual / multi-row processing table used in combination with the JTF collection types, allowing the Rosetta routines and the deal creation logic to operate on sets of rows rather than scalar values. Deal and party records created through CREATE_DEAL, UPDATE_DEAL, CREATE_PARTY, and UPDATE_PARTY are ultimately persisted to the underlying OKL deal and party tables via the core OKL_DEAL_CREATE_PUB package and OKL_API utility routines, which this wrapper invokes.

Usage Notes

As a public wrapper package, OKL_DEAL_CREATE_PUB_W is typically invoked by Oracle Lease Management forms during interactive deal entry and by concurrent programs that perform bulk deal or party creation and loading. Custom code and third-party integrations should call this wrapper rather than the internal OKL_DEAL_CREATE_PUB package, since the "_W" layer preserves the supported public API contract. Callers are expected to follow the FND_API convention of checking the returned status flag and reading exception messages before committing work. Because the package depends on OKL_API, FND_API, and a set of JTF table types, any calling environment must have these standard APPS objects available. The package reports a status of VALID in the documented 12.2.2 installation and is not referenced by any other package within the schema.