Search Results abandon_revisions

Overview

OKL_TRANSACTION_PUB is a public PL/SQL package in the Oracle E-Business Suite (EBS) Oracle Lease and Finance Management (OKL) module, which is part of the Enterprise Contracts / ETRM (Enterprise Transaction and Revenue Management) family of applications. The package encapsulates business logic for creating and maintaining the transactional records that underpin lease and finance contracts, particularly the rebooking and restructuring activities that occur when a contract's financial terms must be re-derived. It is classified as a "PUB" (public) API, meaning it is intended to be called by external programs — including forms, concurrent programs, and custom extensions — rather than being an internal private package.

The header comment identifies the primary procedure, CREATE_TRANSACTION, as the first step toward REBOOKing a contract. The package is referenced by two other packages, confirming its role as a reusable API layer within the OKL module. The user's search term, update_trx_status, corresponds to one of the three documented procedures exposed by this package.

Key Procedures and Functions

• CREATE_TRANSACTION — Creates a transaction record as the initial step in the rebooking process. According to the header comment, it is the first operation in a multi-step workflow that eventually re-derives contract terms. It accepts API-standard parameters (API version, initialization of the message list) plus book/contract identifiers, a reason code, description, transaction date, and transaction type. The transaction type distinguishes between 'REBOOK' and 'SPLIT' operations. It returns a transaction record (tcnv_rec_type) and standard return status, message count, and message data outputs.
• UPDATE_TRX_STATUS — Updates the status of an existing transaction record. This procedure allows callers to advance a transaction through its lifecycle states without altering the underlying financial data. It is the procedure the user searched for, and it is typically invoked after a transaction has been created, validated, or processed.
• ABANDON_REVISIONS — Discards pending revisions associated with a transaction, providing a controlled rollback path when a rebooking or restructuring effort is cancelled before completion.

Tables Accessed

The provided ETRM metadata does not enumerate the specific tables referenced through APPS synonyms. Based on the package's documented purpose and the subtype declarations in the source excerpt — which include types drawn from OKL_STREAMS_PUB, OKL_CONTRACT_PUB, OKL_OKC_MIGRATION_PVT, OKL_RULE_PUB, and OKL_VERSION_PUB — the package operates across the OKL transaction, contract, stream, rule, and version entities. The OKC_K_HEADERS_V view, referenced in the CREATE_TRANSACTION signature for p_chr_id and p_new_chr_id, is the contract header view used to identify the source and target contracts in a rebooking. The transaction records themselves are persisted in OKL transaction tables, which UPDATE_TRX_STATUS modifies.

Usage Notes

OKL_TRANSACTION_PUB is invoked programmatically rather than through a direct user interface. Typical callers include the OKL rebooking and restructuring forms, concurrent programs that batch-process contract changes, and custom PL/SQL extensions that need to trigger a rebooking or split. Callers must follow the standard EBS API invocation pattern: pass the API version, initialize the message list, check x_return_status after each call, and drain x_msg_count/x_msg_data for error diagnostics. Because CREATE_TRANSACTION only creates the transaction shell, a complete rebooking requires the caller to subsequently invoke UPDATE_TRX_STATUS and the supporting OKL APIs that generate revised streams and versions. ABANDON_REVISIONS should be used to clean up when the workflow cannot complete. The package is available in both EBS 12.1.1 and 12.2.2.