Results for “okl_setupdsfparameters_pvt_w”

28 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PL/SQL package APPS.OKL_SETUPDSFPARAMETERS_PVT_W is a private wrapper package within the Oracle Lease Management (OKL) module of Oracle E-Business Suite. It provides the low-level data access layer for the DSF Parameters (Deal Setup Fee Parameters) configuration entity used during lease and contract authoring. DSF parameters control pricing, fee computation, and setup defaults applied when an off-lease or lease agreement is created in OKL. The "_PVT_W" suffix indicates this is the private, wrapper-side implementation that the public PL/SQL API and the underlying TCA/OKL forms and business flows call. It is not intended for direct customer invocation and is classified as an "OTHER" API type in the ETRM metadata. The package was authored in 2005 (header comment OKLESFRS.pls 120.1 2005/07/12) and remains a foundational component across EBS 12.1.1 and 12.2.2, though it carries no ship designation beyond its original release.

Key Procedures and Functions

The ETRM metadata documents six callable units. The primary four are:

  • GET_REC — Retrieves a single DSF parameters record, returning each attribute through strongly-typed OUT parameters (numeric, VARCHAR2, and DATE fields) together with a return status and a no-data-found flag. It uses sentinel defaults for missing inputs, including fnd_api.g_miss_char and the date/number placeholder 0-1962.0724.
  • INSERT_DSFPARAMETERS — Creates a new DSF parameters row. It accepts API version and message-list initialization flags, exposes the standard FND return status, message count, and message data OUT parameters, and returns the newly generated attribute values.
  • UPDATE_DSFPARAMETERS — Modifies an existing DSF parameters record. This is the change path used when lease setup defaults are revised.
  • DELETE_DSFPARAMETERS — Removes a DSF parameters record.

Two additional documented units (bringing the total to six) serve as supporting internal logic. All procedures follow the Oracle Applications API coding standard: x_return_status, x_msg_count, and x_msg_data for error propagation, with p_api_version and p_init_msg_list governing API contract behavior.

Tables Accessed

The ETRM metadata does not enumerate the tables this package touches via APPS synonyms. Based on the OKL data model, the package operates on the DSF Parameters base table (typically OKL_DSF_PARAMETERS and its related _TL translation table where applicable). The GET_REC, INSERT_DSFPARAMETERS, UPDATE_DSFPARAMETERS, and DELETE_DSFPARAMETERS units perform the corresponding SELECT, INSERT, UPDATE, and DELETE operations against that entity. It also relies on the FND_API messaging infrastructure for return-status and message-stack management.

Usage Notes

This wrapper is invoked indirectly. Lease Management setup forms (such as the DSF Parameters setup window) and the public OKL setup API layer call OKL_SETUPDSFPARAMETERS_PVT_W rather than the base table. The ETRM metadata records that the package is referenced by zero other packages, confirming it is a leaf-level wrapper consumed only by forms or direct callers, not chained from other PL/SQL APIs. In EBS 12.1.1 and 12.2.2 the calling pattern is unchanged. Custom code should never call the wrapper directly; customers requiring programmatic manipulation of DSF parameters should use the supported public OKL setup API, which internally delegates to this private wrapper. The 2005 header indicates it is a stable, low-maintenance component reliant on the FND_API standard constants g_miss_char and g_miss_date.