Search Results lock_txl_quote_lines




Overview
Explore in AI Chat

Overview

OKL_TXL_QUOTE_LINES_PUB is the public application programming interface for managing tax lines associated with quote lines in the Oracle Lease and Finance Management (OKL) module. It is a PL/SQL package owned by the APPS schema and classified as a PUB (public) API, meaning it is intended for invocation by external callers—Oracle Forms, concurrent programs, workflow, and custom extensions—rather than being restricted to internal package use. The package operates with AUTHID CURRENT_USER, so it executes with the privileges of the calling user and resolves objects through the caller's schema context.

In the leasing business flow, quote lines represent the individual line items of a lease or loan quotation. The tax engine (TXL) computes applicable tax amounts for those lines, and this package provides the sanctioned entry points for inserting, updating, deleting, and validating those tax quote line records. The naming convention follows Oracle's standard API pattern: a public wrapper (OKL_TXL_QUOTE_LINES_PUB) delegates to a private implementation (OKL_TQL_PVT), whose record and table types are re-declared here as subtypes (tqlv_rec_type and tqlv_tbl_type) for use by callers. All entry points follow the standard Oracle API contract with p_api_version, p_init_msg_list, and the x_return_status, x_msg_count, and x_msg_data output parameters, and support both single-record and bulk-table (PL/SQL table) invocation forms.

Key Procedures and Functions

The package exposes the following documented procedures:

  • INSERT_TXL_QUOTE_LINES — Creates new tax quote line records. Two overloaded forms exist: one accepts a PL/SQL table of records (p_tqlv_tbl) and returns a corresponding output table (x_tqlv_tbl), and one accepts a single record (p_tqlv_rec) and returns an output record (x_tqlv_rec). The bulk form supports efficient creation of multiple tax lines in a single call.
  • UPDATE_TXL_QUOTE_LINES — Modifies existing tax quote line records. This is the procedure most commonly searched for, as it is the standard mechanism for programmatic maintenance of tax amounts, tax rate references, and related attributes on quote lines after initial creation or recalculation.
  • DELETE_TXL_QUOTE_LINES — Removes tax quote line records, typically when quote lines are removed or a quotation is revised and its tax implications change.
  • LOCK_TXL_QUOTE_LINES — Obtains a lock on the specified quote line records to guarantee exclusive access during a concurrent transaction. It supports the same bulk table signature as the insert and update procedures and is used to prevent lost updates in multi-user environments.
  • VALIDATE_TXL_QUOTE_LINES — Performs validation on tax quote line data without committing changes. It applies business rules so that callers can confirm data integrity before invoking insert, update, or delete operations.

The package also declares global constants for error handling (G_PKG_NAME, G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN) and a global exception G_EXCEPTION_HALT_VALIDATION, which signals that validation should stop.

Tables Accessed

Per the documented ETRM metadata, this package accesses the table exposed through the APPS synonym PLITBLM. This is the standard Oracle Applications multi-language temporary storage table used by the FND message dictionary; it is referenced indirectly when the API retrieves translated messages to populate x_msg_data and the message stack. The API's substantive tax quote line data is handled through the private package and the OKL tax quote line base table, with the PUB layer functioning primarily as a controlled gateway rather than performing direct DML on the base table.

Usage Notes

OKL_TXL_QUOTE_LINES_PUB is normally invoked from the Oracle Lease Management quote entry forms, from concurrent programs that generate or recalculate quotation tax lines, and from custom PL/SQL code extending the leasing solution. The metadata records that the package is referenced by 11 other packages, confirming it as a shared dependency within the OKL tax integration layer.

Callers should observe the standard API conventions: supply a valid p_api_version, honor p_init_msg_list to control whether the message stack is cleared, always inspect x_return_status for FND_API.G_RET_STS_SUCCESS, and drain the message stack using FND_MSG_PUB when errors occur. Because AUTHID CURRENT_USER is in effect, the package must be granted directly to calling schemas and synonyms created as required. For bulk operations, the table-based overloads are preferred for performance; the single-record overloads suit form-level, one-line-at-a-time processing. The lock procedure should be called before updates in concurrent scenarios to avoid lost updates, and validation should precede insert or update to fail fast on invalid data.