Search Results okl_setupoptrules_pub




Overview
Explore in AI Chat

Overview

OKL_SETUPOPTRULES_PUB is a public API package in the APPS schema that belongs to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It exposes the setup option rules functionality of the application, allowing callers outside the OKL core to retrieve, create, and remove the configuration rules that govern how lease and finance contracts are processed. Setup option rules drive the defaulting, validation, and behavioral logic applied when contracts are authored and booked, so the package acts as the sanctioned entry point for programmatic maintenance of that configuration data. The package is classified as a PUB API, meaning its signature is considered stable and is the supported surface for external invocation, in contrast to the private implementation packages it delegates to.

Key Procedures and Functions

The documented public surface consists of three procedures:

  • GET_REC — Retrieves a setup option rule record, returning the values of an existing configuration entry to the calling program so it can be displayed, inspected, or used to drive downstream processing.
  • INSERT_OPTRULES — Creates a new setup option rule entry, writing the supplied configuration values into the underlying OKL tables through the private implementation layer.
  • DELETE_OPTRULES — Removes an existing setup option rule entry, reversing a prior configuration so that the associated behavior no longer applies.

No parameter lists are reproduced here because the documented metadata does not include signatures; callers should obtain the exact PL/SQL specification from the deployed package source in the target environment.

Tables Accessed

The ETRM metadata does not enumerate physical tables for this package; instead it records dependencies on the OKL private packages and the OKC API layer. Table activity is therefore indirect: INSERT_OPTRULES and DELETE_OPTRULES perform their DML through OKL_SETUPOPTRULES_PVT, which owns the actual insert and delete statements against the option rules tables. GET_REC likewise routes through the private layer to read the current configuration. In addition, the package depends on OKL_OPT_PVT and OKL_ORL_PVT, which supply option and rules-related business logic, and on OKC_API, the Contracts Core API, reflecting the shared contract infrastructure that OKL builds upon. Because the public package is a thin wrapper, the authoritative table list is held by OKL_SETUPOPTRULES_PVT.

Usage Notes

OKL_SETUPOPTRULES_PUB is typically invoked from the Oracle Lease and Finance Management setup and administration forms, from concurrent programs that seed or migrate lease configuration, and from custom PL/SQL that needs to maintain option rules without direct table access. Direct DML against the underlying tables is not recommended, since the private layer encapsulates validation, defaulting, and any auditing performed during rule maintenance.

The package is referenced by OKL_SETUPOPTRULES_PUB_W, a wrapper object that provides an additional invocation path, and by itself, indicating internal recursive or delegated calls. Published ETRM documentation lists one other referencing package. Because the package status is VALID in the documented release, it is fully compiled and supported in both Oracle EBS 12.1.1 and 12.2.2. When tuning or troubleshooting, developers should remember that errors surfacing from this package generally originate in the private implementation packages or in the OKC_API contract layer rather than in the public wrapper itself.