Search Results okl_version_overlaps

Overview

OKL_SETUPFORMULAE_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the setup and maintenance of pricing formulae used within the Oracle Lease Management (OKL) module. In the 12.1.1 and 12.2.2 release streams, this package belongs to the internal service layer that underpins the public formulae APIs, most notably OKL_FORMULAE_PUB and OKL_FMLA_OPRNDS_PUB. Its primary business function is to validate, insert, and update formula header version records, ensuring that formula definitions remain consistent with effective-dating and versioning rules.

The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling invoker. A substantial block of global constants defines error and token names used for message substitution and exception handling. Among these, G_VERSION_OVERLAPS maps to the message token OKL_VERSION_OVERLAPS, which is the specific identifier surfaced when a user attempts to define a formula version whose effective date range collides with an existing version. Other notable constants govern date-mismatch conditions, past-record restrictions, and SQL error propagation.

Key Procedures and Functions

The ETRM metadata documents three procedures exposed by this package:

• GET_REC — Retrieves a single formula version record based on the supplied search criteria, returning it into a typed record structure along with return status and a no-data-found indicator. It underpins read access for formula setup screens and dependent validation logic.
• INSERT_FORMULAE — Creates a new formula version record, applying the package's versioning conventions (initial version 1.0, major increment 1.0, minor increment 0.1, format mask FM999.0999) and performing the overlap and date-consistency checks that raise conditions such as OKL_VERSION_OVERLAPS and OKL_DATES_MISMATCH.
• UPDATE_FORMULAE — Modifies an existing formula version, re-validating version ranges and protecting against past-record edits through the OKL_PAST_RECORDS condition.

The package also defines the exception G_EXCEPTION_HALT_PROCESSING and subtypes that mirror the public API record types fmav_rec_type, fmav_tbl_type, fodv_rec_type, and fodv_tbl_type, allowing seamless data passing between the public and private layers.

Tables Accessed

The documented table referenced by this package is OKL_OPERANDS_B, accessed through an APPS synonym. This base table stores operand definitions associated with formulae, and the package interacts with it to validate that referenced operands are consistent with the formula version being created or amended. The DML performed by INSERT_FORMULAE and UPDATE_FORMULAE ultimately affects the formula version store, while GET_REC reads the corresponding records.

Usage Notes

OKL_SETUPFORMULAE_PVT is not intended for direct invocation by end users or custom code. It is called by the public wrapper package OKL_FORMULAE_PUB and is referenced by two other dependent packages within the OKL setup layer. The package is typically invoked in the following contexts:

• Oracle Forms-based setup screens for lease pricing formulae, where user actions trigger insert or update calls through the public API.
• Concurrent or batch processes that create or version formulae during implementation and configuration.
• Internal validation paths in dependent OKL packages that call GET_REC to confirm formula version existence and effective dates.

Developers seeking the "g_version_overlaps" identifier should understand it as the error constant surfaced when version effective dates conflict. Because the package is private, customisations should route through OKL_FORMULAE_PUB rather than calling OKL_SETUPFORMULAE_PVT directly, preserving the supported upgrade path across 12.1.1 and 12.2.2.