Search Results okl_rule_extract_pvt




Overview
Explore in AI Chat

Overview

OKL_RULE_EXTRACT_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Lease and Finance Management (OKL) rule extraction infrastructure within Oracle E-Business Suite. The package operates as the internal implementation layer behind OKL_RULE_EXTRACT_PUB, the corresponding public API. Its central business purpose is to resolve and surface the rule definitions that govern contract and lease processing — specifically, identifying which rule groups apply to a given subclass, which rules belong to those groups, what the definitions of individual rules are, and what metadata describes them for downstream consumption.

In lease and financing agreements, rule groups and rules drive validation, pricing, accounting generation, and lifecycle transitions on contract headers and lines. The extraction routines in this package allow that rule configuration to be queried programmatically rather than hard-coded, which is essential for extensibility and for interfaces that must apply the same logic as the core application. As a PVT (private) package, it is not intended for direct invocation by external integrators; the public wrapper packages and views expose the sanctioned entry points.

Key Procedures and Functions

The documented API surface consists of four procedures or functions:

  • GET_SUBCLASS_RGS — Retrieves the rule groups associated with a given contract subclass. This establishes the applicable rule-group context before individual rules are evaluated.
  • GET_RG_RULES — Returns the rules belonging to a specified rule group, serving as the enumeration step that connects rule-group definitions to their constituent rule records.
  • GET_RULE_DEF — Resolves the definition of an individual rule, providing the substantive configuration that drives rule execution behavior.
  • GET_RULES_METADATA — Supplies descriptive metadata about rules, typically used to drive user interfaces, value sets, or dynamic validation logic at runtime.

The metadata does not document individual parameter lists for these routines, and none should be assumed. Their names clearly indicate a layered retrieval pattern: subclass to rule groups, rule groups to rules, rule to definition, and rule to metadata.

Tables Accessed

The package reads from a combination of OKL, OKC, and FND application tables, resolved through APPS synonyms:

Usage Notes

OKL_RULE_EXTRACT_PVT is referenced by OKL_RULE_EXTRACT_PUB,_PUB_W, _PVT_W, and by itself, confirming it is part of a coordinated public/private API and wrapper hierarchy. It is normally invoked indirectly: application forms, concurrent programs, or custom extensions call the public layer (OKL_RULE_EXTRACT_PUB) or the wrapper, which delegates to this private package. It also depends on OKC_API, OKL_API, and OKL_RULE_PUB for shared validation and rule logic. Direct calls should be avoided because the signature is not a supported integration interface and may change across 12.1.1 and 12.2.2.