Search Results update_trx_contracts

Overview

OKL_TRANS_CONTRACTS_PUB is the public application programming interface (API) package for Oracle Lease and Finance Management (OKL) transaction contract data in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the contract-creation, maintenance, and deletion operations of the OKL transaction contract entity to external callers, while delegating the actual processing to the private package OKL_TRANS_CONTRACTS_PVT. The package follows the standard Oracle EBS API architecture: a public wrapper that manages SAVEPOINTs, message stack handling, caller pre- and post-processing hooks (customer and vertical industry), and conversion of return statuses into the FND_API error/exception model.

The body inspected bears the header $Header: OKLPTCTB.pls 115.3 2002/12/18 12:42:41 kjinger noship $, confirming it is an original OKL seed-file API whose signature has remained stable across releases. Business users do not call the package directly; it is the integration point for lease/loan contract creation and amendment, including the associated contract lines that represent assets, terms, and pricing.

Key Procedures and Functions

The documented API surface comprises six procedures spanning two logical entities — the transaction contract header (_TRX_CONTRACTS) and its lines (_TRX_CNTRCT_LINES):

• CREATE_TRX_CONTRACTS — creates a transaction contract header record.
• CREATE_TRX_CNTRCT_LINES — creates one or more transaction contract line records.
• UPDATE_TRX_CONTRACTS — updates an existing transaction contract header.
• UPDATE_TRX_CNTRCT_LINES — updates existing contract line records.
• DELETE_TRX_CONTRACTS — the procedure the user searched for; deletes transaction contract data. Its public signature is not reproduced here, and callers should reference the packaged API specification rather than assume parameters.
• DELETE_TRX_CNTRCT_LINES — deletes contract line records.

The body excerpt shows CREATE_TRX_CONTRACTS accepting an API version, an initialization flag, standard x_return_status/x_msg_count/x_msg_data OUT parameters, and a tcnv_rec_type header record with a tclv_tbl_type line table. It opens a SAVEPOINT named for the procedure, invokes the corresponding private method, and rolls back to that SAVEPOINT on G_EXC_ERROR or G_EXC_UNEXPECTED_ERROR. The same control pattern applies to the delete and update procedures.

Tables Accessed

The only table documented as referenced through an APPS synonym is PLITBLM, the standard EBS message table used by FND_MSG_PUB to store and retrieve API error and warning messages. All business-table access for the contract header and line entities is performed inside OKL_TRANS_CONTRACTS_PVT and is therefore not visible at the public layer. This is consistent with the encapsulation principle: the public package reads and writes no OKL contract tables directly.

Usage Notes

The package is invoked by OKL forms, concurrent programs, and other PL/SQL APIs that need to create, amend, or remove lease and finance contracts programmatically. It is referenced by two other packages in the ETRM schema, indicating that it acts as a lower-level service for higher-level contract-processing flows. Custom callers should supply p_init_msg_list, inspect x_return_status against FND_API.G_RET_STS_SUCCESS, and drain the message stack with FND_MSG_PUB.Count_and_get on failure. Because each procedure raises and rolls back through its own SAVEPOINT, callers may wrap multiple API calls in a single transaction and retain control of commit or rollback.