Search Results okl_option_rules_pvt_w




Overview
Explore in AI Chat

Overview

The package body APPS.OKL_OPTION_RULES_PVT_W is a private PL/SQL implementation unit belonging to the Oracle E-Business Suite Enterprise Territory and Resource Management (ETRM) module, specifically within the Oracle Lease and Finance Management (OKL) application. It operates in the 12.1.1 and 12.2.2 release streams and is owned by the APPS schema with a status of VALID. The package encapsulates the business logic that governs option rules and option validation rules used in lease and finance contracts. Option rules define the permissible configuration, pricing, and behavioral characteristics of contract options, while option validation rules enforce the conditions under which those options may be selected or executed.

The _W suffix denotes that this is a wrapper package body, a naming convention Oracle applies to internal implementation bodies that expose the public PL/SQL API surface implemented by a corresponding private package or a complementary package. In this case, the body interacts with OKL_OPTION_RULES_PVT and the related option validation and overdue processing packages, wrapping their logic into a callable interface for the ETRM runtime. The package is classified as OTHER in the ETRM API registry and does not appear as a dependency of any other database object, confirming that it is consumed as a leaf-level implementation unit rather than as a shared utility.

Key Procedures and Functions

The documented metadata enumerates twenty-three procedures and functions, of which the following ten are formally catalogued. Each falls into one of two functional groups: option rules and option validation rules.

Parameter lists are not exposed in the documented metadata and must be derived from the package specification. The procedures follow the Oracle API convention of returning a success or failure status and, where applicable, populating a standard error message table.

Tables Accessed

The documented dependency information does not include table references through APPS synonyms. However, the package body references the PL/SQL types JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_2000, which are the standard JTF collection types used to pass multi-row data into and out of concurrent and bulk processing APIs. The body also depends on OKC_API for contract message and error handling, and on FND_API for the standard Oracle Applications API framework, including the global message and return-status constants. The substantive option rule logic is delegated to OKL_OPTION_RULES_PVT, OKL_ORL_PVT, OKL_ORL_PVT_W, OKL_OVD_PVT, and OKL_OVD_PVT_W, which perform the actual DML against the underlying OKL option rules and option validation rule tables.

Usage Notes

OKL_OPTION_RULES_PVT_W is an internal wrapper and is not intended for direct invocation by external or custom code. It is typically called indirectly through the Oracle Lease and Finance Management setup forms and concurrent programs that maintain option rules and option validation rules, and through the public API layer that invokes OKL_OPTION_RULES_PVT. Because it is referenced by zero other database objects, it occupies the bottom of the call stack for this functional area. Customizations should call the public API rather than this wrapper. Any modification to the package body requires standard Oracle Applications patching discipline, including compilation against the APPS schema and validation with the FND_API error-handling conventions.