Search Results g_dsf_version_overlaps

Overview

OKL_SETUPFUNCTIONS_PVT is a private PL/SQL package in the Oracle Lease Management (OKL) module of Oracle E-Business Suite. It belongs to the ETRM (Enterprise Transaction Resource Management) family of APIs used to configure and maintain the setup data that underpins lease and contract processing. The package is declared with AUTHID CURRENT_USER, confirming that it executes with the privileges of the invoking schema rather than the definer — a standard convention for internal OKL private helpers.

Its business purpose is to manage "setup functions" — the configurable, function-based rules and parameters that drive data source evaluation during lease origination and contract setup. The package supports versioning of these setup records, which the global constants make explicit: G_INIT_VERSION (1.0), G_VERSION_MAJOR_INCREMENT (1.0), and G_VERSION_MINOR_INCREMENT (0.1). The constant G_VERSION_MAJOR_INCREMENT is the item most commonly searched in this object, and it governs how a version number advances when a major revision is created — typically when a new effective-dated version of a function is introduced.

Key Procedures and Functions

The package exposes three documented procedures:

• GET_REC — Retrieves a single setup-function record into a dsfv_rec_type record structure. It returns a status flag, a no-data-found indicator, and the populated record. This is the standard retrieval entry point used before an update or validation.
• INSERT_FUNCTIONS — Creates new setup-function definitions. It accepts the standard OKL API parameters (API version, initialization-message-list flag) and returns the customary x_return_status and message output. During insertion, the version-increment constants drive how version numbers are assigned to new records.
• UPDATE_FUNCTIONS — Modifies existing setup functions, including version advancement and effective dating. This is where the overlap and date-validation constants (G_DSF_VERSION_OVERLAPS, G_DATES_MISMATCH, G_PAST_RECORDS, G_START_DATE) are applied to reject conflicting or invalid versions.

The package defines private subtypes based on okl_data_src_fnctns_pub.dsfv_rec_type and okl_fnctn_prmtrs_pub.fprv_rec_type, linking it to the public data-source-function and function-parameter APIs.

Tables Accessed

Per the documented metadata, the package references OKL_OPERANDS_B via the APPS synonym. This base table stores the operand definitions that setup functions evaluate. The package reads it to validate operands referenced by a function and may write version-related attributes when functions are inserted or updated.

Usage Notes

As a PVT (private) package, OKL_SETUPFUNCTIONS_PVT is not a supported integration point. It is invoked internally by the Lease Management setup forms and by other OKL packages (metadata records two dependent packages) rather than called directly from custom code. Because it is private, the supported public alternative — typically OKL_DATA_SRC_FNCTNS_PUB or OKL_SETUPFUNCTIONS_PUB — should be used for custom extensions. The error tokens (G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN) indicate that exceptions are surfaced through the standard OKL message framework, so any diagnostic output appears as seeded OKL messages on the concurrent or forms log.