Search Results update_dsfparameters




Overview
Explore in AI Chat

Overview

OKL_SETUPDSFPARAMETERS_PUB is the public (PUB) PL/SQL package body within the Oracle E-Business Suite Oracle Lease Management (OKL) module. It serves as the externally callable API layer for the setup and maintenance of "DSF Parameters" — the parameter records that govern lease-related calculation and formula behavior stored as setup data. The package was authored under server-side header OKLPSFRB.pls (version 120.2, dated 2005/06/03), reflecting an early-generation EBS 11i/12.x code line that has been carried forward into 12.1.1 and 12.2.2.

Like other Oracle public APIs, this package implements a thin wrapper pattern: each public procedure delegates the substantive work to a corresponding private implementation in OKL_SETUPDSFPARAMETERS_PVT. The public layer is responsible for standard API contract handling — initializing the message list, propagating return status, translating unexpected errors into FND_API exception messages, and shielding callers from the private package's internals. This design allows Oracle to change the private implementation without breaking downstream integrations that call the public entry points.

Key Procedures and Functions

Four documented procedures constitute the public surface of this package, forming a complete CRUD set for DSF parameter setup data:

  • GET_REC — Retrieves a single DSF parameter record. It accepts an input record of type FPRV_REC_TYPE, invokes the private GET_REC, and returns the populated record along with X_RETURN_STATUS, X_MSG_DATA, and an X_NO_DATA_FOUND boolean indicator. When the private call returns FND_API.G_RET_STS_UNEXP_ERROR, it raises G_EXC_UNEXPECTED_ERROR; the OTHERS handler sets the status to unexpected error and populates the message via FND_MESSAGE.
  • INSERT_DSFPARAMETERS — The public wrapper for the insert_dsfparameters process API (this is the entry point matched by a search for "insert_dsfparameters"). It is the procedure responsible for creating new DSF parameter setup records. It operates on the DSFV_REC_TYPE and FPRV_REC_TYPE record structures and is a standard EBS API procedure whose exact parameter list is defined in the package specification rather than the published metadata excerpt.
  • UPDATE_DSFPARAMETERS — The public wrapper for the update process API, used to modify existing DSF parameter setup records.
  • DELETE_DSFPARAMETERS — The public wrapper for the delete process API, used to remove DSF parameter setup records.

Because this is a PUB-classified body, callers should invoke these procedures directly rather than the PVT counterparts.

Tables Accessed

The ETRM metadata for this object does not enumerate specific base tables referenced through APPS synonyms. At a functional level, the package writes to and reads from the underlying DSF parameter setup tables that store the formula-operand (FPRV) and DSF-value (DSFV) configuration data, consistent with the GET_REC procedure's association with the OKL_FMLA_OPRNDS_V view and the DSFV_REC_TYPE / FPRV_REC_TYPE record structures. Setup records persisted here drive downstream lease calculation and formula evaluation logic.

Usage Notes

This package is typically invoked from Oracle Lease Management setup forms, from concurrent programs that load or migrate lease setup data, and from custom PL/SQL integration code that needs to programmatically create, read, update, or delete DSF parameters. The metadata records that the package is referenced by one other package, indicating a dependent internal consumer within the OKL setup layer. Callers must supply the API version and follow the standard EBS API conventions: check X_RETURN_STATUS for FND_API.G_RET_STS_SUCCESS, inspect X_MSG_COUNT and X_MSG_DATA (or FND_MSG_PUB) for diagnostics, and supply an initialized message list only when intended.