Search Results okl_setupoverules_pub




Overview
Explore in AI Chat

Overview

OKL_SETUPOVERULES_PUB is a public PL/SQL package in the APPS schema that supports the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its name derives from "setup over-rules," and the package exposes the public API surface for retrieving, creating, and removing override rules applied to lease and finance contract setup. In ETRM, override rules allow a contract to deviate from standard setup defaults or validation behavior for specific business conditions, such as a given product, customer, or transaction type. The package acts as the public wrapper (the _PUB suffix) around the internal private implementation, OKL_SETUPOVERULES_PVT, and depends on additional OKL private packages (OKL_OPT_PVT, OKL_OVD_PVT, OKL_OVE_PVT) plus the Oracle Contracts API, OKC_API. This layered design keeps the internal validation and query logic private while exposing a controlled, upgrade-safe interface to callers. It is a standard supported ETRM API object and is installed as VALID in both 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package body documents three public program units:

  • GET_REC — a retrieval routine that fetches an existing setup override rule record, typically returning the identifying and attribute values of a rule so that a caller can inspect, edit, or validate the current configuration.
  • INSERT_OVERULES — the creation routine used to define a new setup override rule. It accepts the caller's rule definition, performs the required validations, and persists the new rule so that subsequent contract setup activities honor the override.
  • DELETE_OVERULES — the removal routine used to delete or deactivate a previously created override rule, returning contract setup behavior to the standard configuration.

No parameter lists, return types, or exact signatures are reproduced here; the documented unit names and their functional roles above are the authoritative reference points.

Tables Accessed

The documented implementation notes that these procedures operate through APPS synonyms against the underlying Oracle Lease Management override tables. The specific table list is not enumerated in the supplied metadata. Functionally, GET_REC reads from the setup override storage tables, while INSERT_OVERULES and DELETE_OVERULES write to them. The reliance on tables rather than purely in-memory structures means changes made through these routines are durable and visible to the ETRM contract setup engine and its concurrent programs. The package also references OKC_API and OKL private packages to enforce contract-related validation and rule processing during these operations.

Usage Notes

OKL_SETUPOVERULES_PUB is normally invoked from Oracle Lease Management application flows — contract and setup forms, and ETRM concurrent or setup programs — and may also be called from custom extensions that automate override rule maintenance. Because the package is classified as a public API, custom code should call OKL_SETUPOVERULES_PUB rather than the private OKL_SETUPOVERULES_PVT package. The object is referenced by OKL_SETUPOVERULES_PUB_W and by other code, confirming its role as the sanctioned entry point. As with all Oracle EBS public APIs, callers should expect commit handling to reside with the calling application where applicable and should not call these routines during concurrent online setup processing without considering validation and locking behavior. Verify behavior against the target release (12.1.1 or 12.2.2) before deployment.