Search Results okl_ec_evaluate_pvt




Overview
Explore in AI Chat

Overview

OKL_EC_EVALUATE_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Lease Management (formerly Oracle Lease and Finance Management, OKL) module. Its name reflects its role as the internal engine for evaluation criteria (EC) processing. In lease and finance transactions, eligibility and qualification of a contract must be evaluated against a defined set of business criteria before the deal can be approved, priced, or funded. This package encapsulates the reusable evaluation logic that scores, validates, and compares source-to-target relationships against those criteria.

The package declares several strongly typed record and collection structures (for example, okl_ec_rec_type, okl_ac_rec_type, and associated okl_number_table_type, okl_varchar2_table_type, and okl_date_tabe_type collection types). These structures carry the evaluation context — source and target identifiers, deal size, territory, customer credit class, down payment, advance rent, trade-in value, currency, and item categories — plus a results table (okl_qa_result_tbl_type) that accumulates message/status pairs for each criterion evaluated. A package global, g_ec_rec, holds the current evaluation context.

Key Procedures and Functions

  • VALIDATE — Performs validation of the evaluation criteria against the supplied context. It drives the qualification/QA result collection, populating the results table with individual criterion messages and an overall consolidated status.
  • GET_ADJUSTMENT_FACTOR — Returns the adjustment factor that applies to the evaluation. This is the entry point most commonly associated with the search term "get_adjustment_factor." The adjustment factor is used to modify or weight a baseline value (such as a rate, term, or pricing component) based on the criteria that are satisfied during evaluation.
  • COMPARE_ELIGIBILITY_CRITERIA — Compares the eligibility criteria between the source and target structures, determining whether the deal or its components meet the defined eligibility rules. It supports the source/target and effectiveness-date fields found in the record types.

Tables Accessed

  • OKL_FE_CRITERIA — Stores the criteria definitions used during evaluation.
  • OKL_FE_CRITERIA_SET — Groups criteria into sets applied to a given evaluation context.
  • OKL_FE_CRITERION_VALUES — Holds the permitted or expected values against which actual deal data is matched.
  • FND_LOG_MESSAGES — Receives debug/diagnostic log entries written during evaluation.
  • PLITBLM — The standard EBS PL/SQL table used for temporary in-memory storage and messaging.

Usage Notes

Because OKL_EC_EVALUATE_PVT is classified as PVT, it is not intended for direct invocation by end users or external integrations. It is called internally by higher-level public packages — the metadata indicates it is referenced by five other packages — as part of the lease evaluation and qualification flow. Typical invocation occurs when a lease or finance contract is being validated, priced, or approved, either from an EBS form or from a concurrent program performing batch evaluation. Custom code should not call this package directly; instead, developers should use the public wrapper packages that expose the supported API surface. The presence of FND_LOG_MESSAGES writes confirms that debugging output can be enabled through standard FND logging when troubleshooting evaluation failures.