Search Results okl_ech_rec

Overview

OKL_ECH_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) Oracle Lease and Finance Management (OKL) module, owned by the APPS schema and classified as a private (PVT) API. Its role is to encapsulate the core record-level data manipulation logic for the OKL_FE_CRITERIA_SET entity, which stores "match criteria" or "eligibility criteria" sets used by the lease/contract authoring and financing engine to determine how contracts, quotes, or financing offers are matched to business rules. The package name and the underlying okl_ech_rec global record type relate to the criteria-set header structure (the "ECH" family of objects), and the source header (OKLSECHS.pls, version 120.1) confirms it is a lightweight private helper focused on insert, update, delete, and version management.

The package declares public global data structures — a record type okl_ech_rec and an associative array okl_ech_tbl — that mirror the columns of the OKL_FE_CRITERIA_SET table, including CRITERIA_SET_ID, OBJECT_VERSION_NUMBER, SOURCE_ID, SOURCE_OBJECT_CODE, MATCH_CRITERIA_CODE, VALIDATION_CODE, and standard WHO audit columns. These structures are reused by higher-level public APIs and forms to pass criteria-set rows between layers.

Key Procedures and Functions

The documented API surface comprises these procedures:

• CHANGE_VERSION — manages the OBJECT_VERSION_NUMBER for a criteria-set row, supporting optimistic concurrency/locking so that stale forms or concurrent sessions cannot overwrite changed records.
• API_COPY — duplicates an existing criteria-set record (and its associated structure) to support copy/clone operations performed by forms or parent APIs.
• INSERT_ROW — performs the physical insert of a new OKL_FE_CRITERIA_SET row, populating WHO audit columns and the identifying criteria information.
• UPDATE_ROW — applies changes to an existing criteria-set row while enforcing version checks.
• DELETE_ROW — removes (or logically deletes) a criteria-set row.

Note that the metadata lists 8 documented procedures/functions in total while naming these five; the remaining members support validation, message handling, and internal helpers. The package also declares global message constants (g_form_unable_to_reserve_rec, g_form_record_deleted, g_form_record_changed, g_record_logically_deleted, g_required_value, g_invalid_value, and token constants) that standardize error and warning messages returned to the calling form, including the "record changed" and "logically deleted" conditions typical of Forms-based optimistic locking.

Tables Accessed

The package operates against two documented tables touched via APPS synonyms:

• OKL_FE_CRITERIA_SET — the base table storing criteria-set definitions. All of the record fields in okl_ech_rec are typed directly from this table's columns, and INSERT_ROW/UPDATE_ROW/DELETE_ROW maintain its rows.
• PLITBLM — a standard Oracle Forms/EBS "PL/SQL table message" structure used to pass message tokens and text between server-side code and the client form. Its presence confirms this package is invoked from an Oracle Forms UI.

Usage Notes

OKL_ECH_PVT is a private API and should not be called directly from customer extensions; it is invoked internally by the public OKL criteria-set APIs and by the Oracle Forms that maintain match/eligibility criteria sets in Lease Management. Fifteen other OKL packages reference it, indicating it is a low-level building block consumed by higher-level business APIs (for example, criteria-set public APIs and validation routines). When okl_ech_rec is referenced in a search, the correct citation is the global record type declared in this private package, used to move criteria-set data between the form, the table handler (this package), and the underlying OKL_FE_CRITERIA_SET table.