Search Results okl_rule_pub




Overview
Explore in AI Chat

Overview

OKL_RULE_PUB is the public-interface PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that governs the definition, validation, and lifecycle management of rules for Oracle Lease Management (OKL), part of the Enterprise Contracts and ETRM (Enterprise Transaction and Revenue Management) product family. In Oracle EBS 12.1.1 and 12.2.2, rules represent the configurable terms, conditions, and constraints that drive contract behavior — for example, permitted party roles, cover-time periods, and grouped rule definitions. The package is classified as a PUB (public) API, meaning it is intended for supported external invocation by other application modules, forms, and custom extensions rather than as an internal private worker.

The package body acts as a thin business-logic layer over the shared Oracle Contracts kernel objects. It depends on OKC_RULE_PUB, OKC_RUL_PVT, OKC_API, OKC_CURRENCY_API, and OKC_UTIL for the underlying rule engine, while layering on lease-specific validation such as contract status checks through OKL_CONTRACT_STATUS_PUB, vendor-program context via OKL_VENDOR_PROGRAM_PVT, migration handling through OKL_OKC_MIGRATION_PVT, and a standard API error-handling stack from FND_API. The object is VALID in the data dictionary, and it is called by 71 other database objects, making it a central dependency for lease rule processing.

Key Procedures and Functions

The documented interface exposes 74 procedures and functions organized around five functional rule areas. Each area follows the standard EBS API verb pattern of CREATE, UPDATE, DELETE or LOCK, and VALIDATE.

The LOCK_* routines implement optimistic concurrency control, while the VALIDATE_* routines enforce business and referential integrity before a CREATE or UPDATE is committed. All routines use the FND_API return-status and message convention to report success, warning, or error to the caller.

Tables Accessed

Per the documented dependency information, the package reads and writes through APPS synonyms over these tables:

These accesses confirm that OKL_RULE_PUB operates directly on the shared Contracts rule schema while leveraging lease-specific validation context derived from OKL_* dependencies.

Usage Notes

OKL_RULE_PUB is normally invoked indirectly. Oracle Lease Management forms — particularly rule and rule-group setup and contract-authoring screens — call these PUB routines rather than performing direct DML on OKC_RULES_B, so that validation, locking, and error messaging remain consistent. Concurrent programs that mass-create or migrate lease rules also route through this package. Because OKL_RULE_PUB is referenced by 71 database objects, customizations should call it rather than the underlying OKC_RUL_PVT or OKC_RULE_PUB procedures where lease-specific validation is required. When extending the package, developers should honor the standard EBS API contract: pass a caller-supplied API version, inspect the FND_API return status, and rely on LOCK_* before UPDATE_* to avoid lost updates. Direct inserts into OKC_RULES_B should be avoided, as they bypass validation and concurrency handling enforced here.