Search Results okl_setupoverules_pub_w




Overview
Explore in AI Chat

Overview

OKL_SETUPOVERULES_PUB_W is a public PL/SQL package in the APPS schema that forms part of the Oracle Lease and Finance Management (OKL) module within Oracle E-Business Suite 12.1.1 and 12.2.2. The package serves as the public wrapper interface for managing "overrule" setup data — the configuration records that govern how the lease and finance application overrides, or "overrules," standard processing behavior during contract, pricing, and accounting workflows. Setup overrules are typically associated with the OKL Setup subsystem and are used to define conditions under which default terms, calculations, or validations are superseded by specified alternatives.

The "_PUB_W" suffix indicates that this is a public wrapper package, consistent with the Oracle EBS API design convention in which a public package exposes a stable, externally callable interface while delegating the bulk of the implementation to an internal body or handler. The package status is VALID, confirming that it compiles cleanly against the current database release.

Key Procedures and Functions

The ETRM documentation identifies three documented procedures or functions within this package:

  • GET_REC — Retrieves an existing setup overrule record. This routine is used to fetch the current definition of an overrule so that calling code (such as a form or a validation program) can inspect or act on its values before deciding whether to modify, apply, or delete it.
  • INSERT_OVERULES — Creates new setup overrule records. This procedure supports the initial definition of overrule configuration, accepting the values supplied by the caller and persisting them to the underlying repository.
  • DELETE_OVERULES — Removes setup overrule records that are no longer required. It supports cleanup and maintenance of overrule definitions as business rules evolve.

The procedures form a standard create/read/delete set for overrule configuration, exposing the operations through the public wrapper. Parameter lists are not enumerated in the documented metadata and should be confirmed against the package specification in the target instance before use.

Tables Accessed

The ETRM metadata records no direct table references for OKL_SETUPOVERULES_PUB_W through APPS synonyms at the wrapper level, which is typical for a public wrapper that delegates to an internal implementation package. Based on the package name and the create/read/delete operations, the underlying implementation reads from and writes to the OKL setup overrule base table (the OKL_SETUP_OVERULES family), where overrule definitions are stored. The three operations map directly to that repository: GET_REC reads it, INSERT_OVERULES writes new rows to it, and DELETE_OVERULES removes rows from it. Callers should not assume direct table access is supported outside the API.

Usage Notes

OKL_SETUPOVERULES_PUB_W declares dependencies on several Oracle shared components: FND_API (the EBS standard API error-handling and messaging framework), and the JTF collection types JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_2000. The presence of these JTF table types indicates that the API supports bulk or multi-row operations by passing PL/SQL collections, while FND_API indicates standard return-status and error-message handling.

The package is typically invoked from Oracle Forms and concurrent programs within the Lease and Finance Management setup flows, and it may be called by custom extensions that need to programmatically maintain overrule configuration. Because no other packages reference it in the documented dependency list, it is best regarded as a top-level public entry point. Custom code invoking these procedures should follow the FND_API calling convention, checking the returned status and inspecting the error message table before committing or rolling back the transaction.