Search Results update_quote_line

Overview

OKL_AM_TERMNT_QUOTE_PVT is a private (PVT-classified) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It supports the termination quoting workflow that allows a lessee or lessor to obtain a payoff or termination quotation against an existing lease or loan contract. Within this workflow a termination quote is created against a contract, populated with one or more quote lines representing assets, quantities, and financial components, optionally routed for approval, and finally converted into an actual termination. The package encapsulates the business logic that drives the quote line lifecycle and is consumed primarily by the public termination quote APIs and the ETRM/OKL forms and concurrent programs that expose the termination quote feature to end users. The measured header records the source revision as 120.3 and the internal package name as OKL_AM_TERMNT_QUOTE_PVT, consistent with the Application Object Library naming convention for module-private implementation packages that are not intended for direct external invocation.

Key Procedures and Functions

• TERMINATE_QUOTE — Executes the termination of a quote, driving the conversion of a completed termination quotation into the termination transaction and enforcing validation that the contract may be terminated.
• SUBMIT_FOR_APPROVAL — Places a termination quote into the approval workflow, initiating the Oracle Approval Management (AME) or OKC approval routing.
• CHECK_ASSET_SNO — Validates asset serial numbers associated with the quote against the installed asset base.
• QUOTE_LINE_DTLS — Retrieves and assembles the detail attributes of a termination quote line, including quantity and instance information.
• CREATE_QUOTE_LINE — Inserts a new termination quote line and its associated detail records.
• UPDATE_QUOTE_LINE — Modifies the attributes of an existing termination quote line.
• DELETE_QUOTE_LINE — Removes a termination quote line from the quote, which is the procedure most commonly searched for under the term "delete_quote_line." It is the counterpart to CREATE_QUOTE_LINE and is invoked when a user removes a line from the termination quote before submission.
• GET_QUOTE_UNITS — Returns the number of units applicable to a quote line, supporting quantity calculations.
• CHECK_ASSET_VALIDITY_IN_FA — Confirms that an asset referenced in the quote is valid within Oracle Assets by inspecting the asset books, depreciation periods, and fiscal year configuration.

These procedures operate on the package-level record type qte_ln_dtl_rec and the associated qte_ln_dtl_tbl collection, which carry quote line identifiers, instance quantity, IB and financing line references, and contract identifiers between the private package and its public callers.

Tables Accessed

The package reads and writes the core quoting tables OKL_TRX_QUOTES_B and OKL_TXL_QUOTE_LINES_B, together with their detail tables OKL_TXD_QUOTE_LINE_DTLS, which store quote headers, quote lines, and per-line quantity detail. Contract linkage is maintained through OKC_K_LINES_B and the OKL view OKL_K_LINES. Asset validation relies on CSI_ITEM_INSTANCES and the Oracle Assets tables FA_BOOKS, FA_BOOK_CONTROLS, FA_DEPRN_PERIODS, FA_FISCAL_YEAR, and FA_TRANSACTION_HEADERS. Party and location information is resolved through HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES, while FND_CONCURRENT_REQUESTS is referenced for concurrent program monitoring.

Usage Notes

As a PVT package, OKL_AM_TERMNT_QUOTE_PVT should not be called directly by customer extensions. It is invoked by the public termination quote API layer and by the OKL termination quote forms and concurrent programs, and it is referenced by seven other packages within the OKL schema. Customizations requiring quote line manipulation, including deletion via DELETE_QUOTE_LINE, should be performed through the supported public API or the standard ETRM user interface rather than by direct invocation, because private packages may change between patch releases without notice. When troubleshooting issues such as failure to delete a quote line, verify the quote status, the contract's termination eligibility, and that the line is not referenced by a downstream approval or termination transaction before retrying the operation.