Search Results update_deal

Overview

OKL_MLA_CREATE_UPDATE_PUB is a public (PUB) API package in the APPS schema that supports the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its core purpose is to create and update lease and finance deal structures programmatically, including the header, party roles, and related financial attributes. The MLA designation refers to the Multi-Level Aggregation / Master Lease Agreement family of functionality in ETRM, where complex financing instruments are consolidated and managed under a governing contract. In releases 12.1.1 and 12.2.2, the package exposes a controlled, supported entry point for creating a deal record and its associated party assignments without requiring direct DML against the underlying OKC and OKL tables. By centralizing validation, date-effectivity handling, and role assignment logic, the package protects data integrity across the contract and lease schema and ensures that downstream processes—such as pricing, accounting generation, and workflow branching—receive consistently formed records.

Key Procedures and Functions

The documented metadata identifies three public entry points:

• CREATE_DEAL — Creates a new lease or finance deal, including its header record and associated structural attributes. It is the primary entry point for constructing an MLA or master agreement deal from external or internal callers.
• UPDATE_DEAL — Modifies an existing deal, allowing attributes such as governing terms and header-level fields to be revised while preserving validations enforced by the API layer. It is intended to be invoked only for deals that already exist and have valid identifiers.
• CREATE_PARTY — Creates the party role assignment on a deal, binding a party to a specific role such as lessee, lessor, or guarantor. It ensures the role is linked correctly to the contract header and its supporting role definitions.

Parameter lists are not documented in the available metadata and are deliberately omitted; consumers should inspect the package specification in the target environment for exact signatures.

Tables Accessed

The package operates against a defined set of contract and lease tables, typically through APPS synonyms. Documented references include:

• OKC_K_HEADERS_B — the base contract header table, holding core contract identity and type.
• OKC_K_PARTY_ROLES_B — the base party role table linking parties to contracts.
• OKL_K_PARTY_ROLES — the lease-specific extension of party roles.
• OKL_K_HEADERS — the lease header extension carrying lease-specific attributes.
• OKL_VP_ASSOCIATIONS — associations supporting lease-to-value or business-partner relationships.
• AK_REGIONS and AK_REGION_ITEMS — definitions used for attribute grouping and UI/API structure.
• OKC_ROLE_SOURCES — the role sources that determine which roles are valid for a given contract.

It also references the database types WF_PARAMETER_LIST_T and PLITBLM for parameter passing and PL/SQL table handling.

Usage Notes

OKL_MLA_CREATE_UPDATE_PUB is the public API layer for its functionality; the underlying body is wrapped by OKL_MLA_CREATE_UPDATE_PUB_W. It depends on OKC_API and OKL_API for contract and lease-level validation and on views such as OKC_CONTACTS_V, OKC_GOVERNANCES_V, OKC_K_PARTY_ROLES_V, OKC_RULES_V, and OKL_PRODUCTS_V for lookup and validation. It is referenced by one other documented package. Typical invocation is from Oracle Forms, custom concurrent programs, or integration code that must create or maintain lease deals and their parties. Callers should always route changes through this package rather than direct table DML, commit only after the API returns successfully, and never pass undocumented parameters without confirming the specification in their specific release.