Search Results okl_setupoptrules_pvt




Overview
Explore in AI Chat

Overview

OKL_SETUPOPTRULES_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite Enterprise Contract and Lease Management (formerly Oracle Leasing and Oracle Contracts) module, commonly known as OKL. In the ETRM layered architecture, packages ending in the _PVT suffix hold the implementation logic that is exposed to the application through a corresponding public API wrapper. This package, therefore, contains the internal processing rules that support the setup and maintenance of option rules used during lease and contract origination.

Option rules define the conditions, eligibility, and defaulting behaviour applied to contractual options — such as purchase options, termination options, and renewal options — during lease and contract authoring. Because these rules drive downstream pricing and accounting calculations, their integrity is critical. The package operates as a private helper, isolating rule validation and persistence logic from the public interface, which is consistent with Oracle's standard separation between public (_PUB) and private (_PVT) API layers.

Key Procedures and Functions

The documented package exposes three procedures: GET_REC, INSERT_OPTRULES, and DELETE_OPTRULES. Their names indicate the core DML cycle for option rule records.

  • GET_REC — A retrieval routine used to fetch an existing option rules record, typically for validation, display, or use as a starting point when building a new record. It supplies record data to the calling public wrapper or form layer.
  • INSERT_OPTRULES — Handles creation of option rule rows. This is the principal write path used when a user defines a new option rule set, and it applies the internal validation and defaulting logic before persistence.
  • DELETE_OPTRULES — Removes option rule rows, supporting the removal of rules that are no longer applicable. It likely performs referential or status checks before deletion to preserve data integrity.

No parameter lists are reproduced here, as they are not part of the documented metadata.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This is a standard Oracle Application Object Library structure widely used across EBS modules for storing and iterating over list-type or collection data passed between the user interface and the database layer. Its presence indicates that OKL_SETUPOPTRULES_PVT participates in multi-row processing of option rule definitions, where sets of records are staged in PLITBLM before validation and commit. The package also depends on OKL_OPTION_RULES_PUB, OKL_OPTIONS_PUB, OKL_OPT_PVT, and OKL_ORL_PVT, meaning actual rule persistence is delegated to those option-rule tables and APIs rather than being performed directly here.

Usage Notes

OKL_SETUPOPTRULES_PVT is not intended for direct invocation by end users or custom code. It is referenced by its public counterpart, OKL_SETUPOPTRULES_PUB, by the wrapper package OKL_SETUPOPTRULES_PVT_W, and recursively by itself. Customizations and integrations should always call OKL_SETUPOPTRULES_PUB, which provides the supported, documented entry points and preserves upgrade safety. Typical invocation flows originate from lease and contract setup forms, or from concurrent programs that load and validate option rule data, with the public API delegating to this private package to perform the actual GET, INSERT, and DELETE operations. Understanding this package is primarily useful for support, troubleshooting, and impact analysis, since direct calls bypass supported interfaces and may be affected by changes between releases such as 12.1.1 and 12.2.2.