Search Results okl_option_rules_pub

Overview

The OKL_OPTION_RULES_PVT package is a private PL/SQL API within the Oracle E-Business Suite (EBS) Lease Management / Enterprise Taxation and Regime Management (ETRM) module, owned by the APPS schema. Its classification as a private package (PVT) indicates that it is not intended to be called directly by external or customer-developed code; instead, it functions as the internal implementation layer behind the public API exposed by OKL_OPTION_RULES_PUB. The package encapsulates the business logic that governs option rules and option validation rules within lease contracts, providing the procedural mechanics for creating, maintaining, validating, locking, and deleting these rule definitions.

In the ETRM context, option rules define the permissible terms, conditions, and validations applied to contract options (for example, purchase options, renewal options, and termination options) associated with leased assets. By centralizing this logic in a private package, Oracle ensures consistent enforcement of validation and referential integrity while shielding the underlying data model from direct manipulation.

Key Procedures and Functions

The package exposes twenty-three documented program units, which fall into two logical groupings: those operating on option rules and those operating on option validation rules. The principal procedures are:

CREATE_OPTION_RULES — Inserts a new option rule definition and establishes its associated attributes.
UPDATE_OPTION_RULES — Modifies the attributes of an existing option rule.
VALIDATE_OPTION_RULES — Performs business-rule and data-integrity validation against an option rule prior to persistence.
LOCK_OPTION_RULES — Acquires a lock on the option rule record to ensure concurrency control during DML operations.
DELETE_OPTION_RULES — Removes an option rule definition, subject to validation of downstream dependencies.
CREATE_OPTION_VAL_RULES — Creates a new option validation rule linked to an option rule.
LOCK_OPTION_VAL_RULES — Locks an option validation rule record for update.
UPDATE_OPTION_VAL_RULES — Updates the definition of an existing option validation rule.
DELETE_OPTION_VAL_RULES — Deletes an option validation rule record.
VALIDATE_OPTION_VAL_RULES — Validates the option validation rule set against established constraints.

The remaining units provide supporting internal logic and helper operations invoked by these primary procedures.

Tables Accessed

According to the documented metadata, the package references the table PLITBLM through APPS synonyms. This table is commonly used within the ETRM framework for storing structured or multi-part data elements referenced during rule processing. The package depends on several other APPS objects, notably OKC_API, OKL_ORL_PVT, and OKL_OVD_PVT, which supply contract and lease-related services consumed during rule creation and validation. The standard SYS.STANDARD package is also referenced as a foundational dependency.

Usage Notes

OKL_OPTION_RULES_PVT is referenced by OKL_OPTION_RULES_PUB and the database trigger package OKL_OPTION_RULES_PVT_W. It is invoked indirectly when users configure option rules through the Lease Management forms or when concurrent programs process option-rule-related data. Custom code should never call this private package directly; instead, developers must use the public wrapper OKL_OPTION_RULES_PUB to ensure that locking, validation, and auditing logic execute correctly. Direct invocation against the private layer risks bypassing validation and corrupting rule definitions.

APPS.OKL_OPTION_RULES_PUB SQL Statements 12.1.1
PACKAGE: APPS.OKL_OPTION_RULES_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_OPTION_RULES_PVT, status:VALID,
PACKAGE: APPS.OKL_OPTION_RULES_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_OPTION_RULES_PUB, status:VALID,
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OPTION_RULES_PUB, status:VALID,
PACKAGE: APPS.OKL_OPTION_RULES_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_OPTION_RULES_PVT, status:VALID,
APPS.OKL_OPTION_RULES_PUB SQL Statements 12.2.2
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OPTION_RULES_PUB, status:VALID,
PACKAGE: APPS.OKL_OPTION_RULES_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_OPTION_RULES_PUB, status:VALID,
PACKAGE: APPS.OKL_OVD_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_OVD_PVT, status:VALID,
PACKAGE: APPS.OKL_OVD_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_OVD_PVT, status:VALID,
PACKAGE: APPS.OKL_ORL_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_ORL_PVT, status:VALID,
PACKAGE: APPS.OKL_ORL_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_ORL_PVT, status:VALID,
PACKAGE: APPS.OKL_SETUPOVERULES_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOVERULES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB_W 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OPTION_RULES_PUB_W, status:VALID,
PACKAGE: APPS.OKL_SETUPOPTRULES_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOPTRULES_PVT, status:VALID,
PACKAGE: APPS.OKL_SETUPOVERULES_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOVERULES_PVT, status:VALID,
PACKAGE: APPS.OKL_SETUPOPTRULES_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOPTRULES_PVT, status:VALID,
PACKAGE: APPS.OKL_SETUPOVDTEMPLATES_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOVDTEMPLATES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_SETUPOVERULES_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_SETUPOVERULES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB_W 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_OPTION_RULES_PUB_W, status:VALID,
PACKAGE BODY: APPS.OKL_SETUPOVERULES_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_SETUPOVERULES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_SETUPOPTRULES_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_SETUPOPTRULES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_SETUPOPTRULES_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_SETUPOPTRULES_PVT, status:VALID,
PACKAGE: APPS.OKL_SETUPOVDTEMPLATES_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_SETUPOVDTEMPLATES_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB 12.2.2
PACKAGE BODY: APPS.OKL_OPTION_RULES_PUB 12.1.1
PACKAGE: APPS.OKL_OPTION_RULES_PUB 12.1.1
PACKAGE: APPS.OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_OPTION_RULES_PUB_W dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_OPTION_RULES_PUB_W dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_OPTION_RULES_PUB dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_OPTION_RULES_PUB dependencies on OKL_OPTION_RULES_PUB 12.2.2
APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.1.1
APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_OPTION_RULES_PUB 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.OKL_OPTION_RULES_PUB dependencies on FND_MSG_PUB 12.2.2
APPS.OKL_OPTION_RULES_PUB dependencies on FND_MSG_PUB 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.OKL_OPTION_RULES_PUB dependencies on OKC_API 12.1.1
APPS.OKL_OPTION_RULES_PUB dependencies on OKC_API 12.2.2