Search Results create_vendor

Overview

OKL_QUOTE_TO_CONTRACT_PVT is a private PL/SQL package body in the Oracle E-Business Suite Lease Management (OKL) module. Its principal business function is the conversion of an approved lease quote into a formal contract within the Oracle Contracts (OKC) schema. The package encapsulates the procedural logic required to transfer header, asset, and party information from the lease quotation and lease application entities into the corresponding contract structures, thereby enabling the downstream contracting, billing, and accounting processes that depend on an executed agreement.

The package is classified as a private (PVT) API, indicating it is intended for internal invocation by other ETRM packages rather than direct calls from external interfaces. The ETRM metadata records that it is referenced by four other packages, confirming its role as a shared internal utility within the lease-to-contract conversion flow. The source header reflects a maintenance level of 120.35.12010000.2, dated November 2008, and is consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The documented API surface consists of a single procedure:

• CREATE_CONTRACT — Orchestrates the creation of a contract from lease quotation data. Its internal logic drives the population of contract headers, contract lines, line styles, item associations, and party role records required to establish a valid contract record. It also performs tax-related setup derived from the quote, as evidenced by the inclusion of eBTax-related columns such as LINE_INTENDED_USE in the underlying lease application query.

The package also declares private cursors used by CREATE_CONTRACT, including c_get_leaseapp_hdr, which retrieves lease application header data joined to the primary lease quote for a given application, and c_get_leaseopp_hdr, which retrieves lease opportunity header data. The lease application cursor restricts selection to applications in a 'CR-APPROVED' status with a primary quote of 'Y', ensuring only fully approved quotations are eligible for contract creation.

Tables Accessed

The package reads and writes a documented set of tables through APPS synonyms:

• OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_ITEMS, OKC_LINE_STYLES_B — Core contract structures receiving the header, line, item, and line style data constructed from the lease quote.
• OKC_K_PARTY_ROLES_B — Stores the party roles (for example, lessee, lessor, guarantor) associated with the generated contract.
• OKC_QA_CHECK_LISTS_B — Quality assurance check lists applied to the contract.
• HZ_PARTIES, HZ_PARTY_SITES — Supplier of party and address identity information for the contract roles.
• AR_CMGT_CREDIT_REQUESTS, AR_CMGT_GUARANTOR_DATA — Credit management records consulted or referenced during conversion, including guarantor information.
• MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL — Item master and translated descriptions used to resolve the leased assets placed on the contract lines.
• FA_CATEGORY_BOOK_DEFAULTS, FA_METHODS — Fixed asset category and depreciation method defaults applied to asset-related contract data.
• FND_LOG_MESSAGES — Receives debug and logging output controlled by the package-level debug flags (L_DEBUG_ENABLED, IS_DEBUG_PROCEDURE_ON, IS_DEBUG_STATEMENT_ON).

Usage Notes

Because OKL_QUOTE_TO_CONTRACT_PVT is a private package, it is not exposed as a public integration API. It is invoked internally by the four referencing packages during the lease quotation approval and booking lifecycle, typically when a quote has reached the approved status and the business elects to generate the associated contract. Developers extending the lease-to-contract flow should call the public wrapper packages that reference this private body rather than invoking CREATE_CONTRACT directly.

The user search term "create_vendor" does not correspond to any documented procedure in this package; vendor creation is not a function of OKL_QUOTE_TO_CONTRACT_PVT. Any vendor-related logic in a lease-to-contract scenario originates elsewhere in the ETRM or Payables APIs. When diagnosing conversion issues, the FND_LOG_MESSAGES output gated by the package debug flags provides the primary trace mechanism.