Search Results okl_deal_create_pub




Overview
Explore in AI Chat

Overview

OKL_DEAL_CREATE_PUB is a public PL/SQL API package in the APPS schema that serves as the primary programmatic entry point for creating and maintaining lease and deal records within the Oracle E-Business Suite Lease Management (OKL) module. Lease Management is delivered as part of Oracle Enterprise Contracts and is tightly integrated with the OKC (Contracts Core) schema, which owns the underlying contract header, line, party-role, and rule structures. The package abstracts the complexity of these multi-table contract constructs so that callers can create a complete deal—header, parties, rules, and associated governance data—through a small number of well-defined entry points rather than writing directly against the OKC base tables.

The package is classified as PUB (public), indicating that Oracle supports its use as a documented extension and integration interface. It is validated in both EBS 12.1.1 and 12.2.2. Internally it depends on OKC_API and OKL_API, the core contract and lease APIs, and on several OKC views and base tables, so it encapsulates rather than duplicates the underlying business logic.

Key Procedures and Functions

Eleven documented procedures and functions are exposed. The most significant are:

  • CREATE_DEAL — Creates a new lease or deal contract, establishing the OKC contract header and the associated OKL lease attributes.
  • UPDATE_DEAL — Modifies an existing deal, applying changes to header-level attributes and related contract data.
  • LOAD_DEAL — Populates a deal from an existing source, typically supporting bulk or interface-driven creation.
  • COPY_RULES — Copies rule groups and rules from a source contract to the target deal, preserving rule configuration across similar agreements.
  • CONFIRM_CANCEL_CONTRACT — Confirms or cancels a contract, transitioning its lifecycle status.
  • CREATE_PARTY — Adds a party role (for example, lessee or lessor) to the deal, creating the associated OKC party-role and contact records.
  • UPDATE_PARTY — Modifies an existing party role association on the deal.

The remaining documented routines support ancillary setup and validation activities. Parameter lists are intentionally not reproduced here; callers should consult the package specification in the database for exact signatures.

Tables Accessed

The package reads and writes contract structures primarily through APPS synonyms, including OKC_K_HEADERS_B and OKC_K_HEADERS_ALL_B (contract headers), OKC_K_LINES_B and OKC_LINE_STYLES_B (contract lines), OKC_K_PARTY_ROLES_B (party role assignments), OKC_K_ARTICLES_B, OKC_CONTACTS, and OKC_GOVERNANCES (contract text, contacts, and governance data). Lease-specific data is accessed through OKL_K_PARTY_ROLES and the OKL_K_HEADERS_FULL_V view. Setup and validation lookups draw on FND_LOOKUP_VALUES, FND_FLEX_VALUE_SETS, FND_DESCR_FLEX_COLUMN_USAGES, AK_REGIONS, AK_REGION_ITEMS, and OKC_QA_CHECK_LISTS_B, which supply descriptive flexfield definitions, region metadata, and quality-assurance checklist configuration used during deal creation and validation.

Usage Notes

OKL_DEAL_CREATE_PUB is referenced by several other components, including OKL_CS_LC_CONTRACT_PVT, OKL_DEAL_CREATE_PUB_W (a wrapper package), and OKL_OPEN_INTERFACE_PVT, indicating that it is invoked both from the Lease Management forms layer and from open-interface processing. Custom integrations and concurrent programs that must deliver or migrate lease deals should call this package rather than the OKC base tables, since the API enforces the required validations and cross-table insert sequencing. Because it is a PUB-classified API, it is the supported surface for extension development, but callers must still respect the OKC/OKL transaction model and commit strategy expected by the standard Lease Management flows.