Search Results okl_try_pvt




Overview
Explore in AI Chat

Overview

OKL_TRY_PVT is the private implementation package body for the Oracle Lease and Finance Management (OKL) transaction type entity. Within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 architecture, the OKL schema supports lease and finance contract lifecycle processing under the Enterprise Transaction and Reference Model (ETRM) framework. The PKG classification of "PVT" indicates this package is a private implementation object, deliberately excluded from the public API surface; the executable DML and validation logic declared here is exposed to calling applications only through the corresponding public package, OKL_TRY_PUB.

The package encapsulates the complete persistence and retrieval layer for the OKL_TRX_TYPES entity — the reference data that defines the transaction types (for example, lease, loan, and combined structures) driving contract origination, booking, and accounting. By keeping row-level operations private, Oracle isolates multi-language seed data maintenance, concurrency control, and attribute validation from direct external invocation, preserving the integrity of the transaction type reference set used across the leasing module.

The documented metadata lists the package as VALID and confirms it is a dependent object referenced by eleven other packages, marking it as a foundational lower-layer component in the OKL dependency chain rather than a top-level entry point.

Key Procedures and Functions

  • QC — Quality-control routine used internally to perform consistency checks over the transaction type definition before committing data.
  • CHANGE_VERSION — Manages versioning of a transaction type record, supporting change tracking for the reference entity.
  • API_COPY — Copies an existing transaction type row, including its translated attributes, to create a new definition.
  • ADD_LANGUAGE — Inserts translated (TL) rows for additional languages installed in the instance.
  • INSERT_ROW — Creates a new OKL_TRX_TYPES row and its associated translation row.
  • LOCK_ROW — Obtains a row-level lock for concurrency control during update operations.
  • UPDATE_ROW — Modifies an existing transaction type record and its translatable columns.
  • DELETE_ROW — Removes a transaction type definition and dependent translation rows.
  • VALIDATE_ROW — Executes attribute-level and cross-entity validation prior to persistence.
  • LOAD_SEED_ROW — Loads Oracle-seeded transaction type definitions, typically invoked during installation, upgrade, or territory/language seed refresh.

Procedures rely on OKL_API, OKC_API, and FND_API to standardize error handling and return status consistent with the ETRM API convention.

Tables Accessed

  • OKL_TRX_TYPES_B — The base table holding language-independent columns; the primary read/write target for insert, update, delete, and lock operations.
  • OKL_TRX_TYPES_TL — The translation table storing language-specific name and description attributes; managed by ADD_LANGUAGE and the TL portions of INSERT_ROW and UPDATE_ROW.
  • FND_LANGUAGES — Read to identify installed languages during translation maintenance.
  • PLITBLM — The PL/SQL integer table type used for internal bulk collections.

The view OKL_TRX_TYPES_V is referenced for retrieval, and OKL_TRX_TYPES_TL supports the MLT (multi-lingual table) view pattern.

Usage Notes

Because OKL_TRY_PVT is a private package, it is never invoked directly by forms, concurrent programs, or custom code; all access flows through OKL_TRY_PUB. The package is called internally by the public wrapper during transaction type setup and maintenance, and by dependent OKL packages (eleven documented callers) that require consistent create, update, or validation behavior without duplicating DML logic. LOAD_SEED_ROW participates in seed data loading at installation and patch application. On upgrades between 12.1.1 and 12.2.2, the private body should be recompiled after any dependent object changes to retain its VALID status.