Search Results create_price_parm




Overview
Explore in AI Chat

Overview

The APPS.OKL_SETUP_PRCPARAMS_PUB package body is the public API wrapper for the Oracle Lease and Finance Management (OLFM) setup entity known as "price parameters." It belongs to the ETRM (Enterprise Transaction and Reference Models) family of modules and is classified as a Public (PUB) API, meaning it is a supported integration surface for external callers. Its central purpose is to expose the business logic required to create and maintain pricing parameter records — the setup definitions that drive how lease pricing, rates, and related financial terms are derived during contract underwriting. The package does not itself contain the core validation and database manipulation logic; rather, it delegates to the private package OKL_SETUP_PRCPARAMS_PVT, acting as a thin, controlled entry point.

The wrapper follows the standard Oracle EBS PL/SQL API pattern. Each public procedure first calls OKL_API.START_ACTIVITY to initialize the API context, validate the API version, and set up the message list. It then maps the incoming record structures to the private API invocation and translates the returned status codes into the standardized EBS return values (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR). The presence of the g_exc_unexpected_error symbol in the searched content reflects the package's exception translation logic: when START_ACTIVITY or the private API returns G_RET_STS_UNEXP_ERROR, the wrapper raises G_EXC_UNEXPECTED_ERROR so that an unexpected database or runtime failure is propagated distinctly from a normal validation error (G_EXC_ERROR).

Key Procedures and Functions

  • CREATE_PRICE_PARM — Creates a new price parameter setup record. It accepts an API version, an initialization flag for the message list, and an input record of type sppv_rec_type. It returns the created record, the standard EBS return status, and message count/data outputs. Internally it initializes the activity, invokes the corresponding private procedure, and maps the outcome to the public exception scheme.
  • UPDATE_PRICE_PARM — Updates an existing price parameter setup record, following the same wrapper conventions as the create procedure: activity initialization, delegation to the private package, and status/exception translation.

The ETRM metadata documents four total procedures/functions, of which the two above are the named public routines. Parameter lists are intentionally not reproduced here beyond the documented signatures; callers should reference the package specification for exact argument definitions.

Tables Accessed

The documented table referenced via an APPS synonym is PLITBLM. In the OLFM data model, PLITBLM is a multilanguage (MLS) base table used to store translatable descriptive text, and the price parameter setup view OKL_SIF_PRICE_PARMS_V is built upon it. The wrapper itself does not query the table directly; the underlying private package performs the insert, update, and validation operations against the price parameter base structures that this table supports.

Usage Notes

This package is typically invoked programmatically rather than interactively. It is called by the OLFM setup forms when a user creates or modifies price parameters, by concurrent programs that load or migrate pricing setup data, and by custom integration code that needs to seed price parameters during implementation. Because it is a PUB API, custom code should always call OKL_SETUP_PRCPARAMS_PUB rather than OKL_SETUP_PRCPARAMS_PVT, ensuring that activity initialization, message handling, and exception semantics are applied consistently. The metadata notes that this package is referenced by one other package, confirming it sits within a small dependency chain in the OLFM setup stack. Standard EBS practice applies: set p_init_msg_list to G_TRUE at the top-level call to clear prior messages, inspect x_return_status after every invocation, and retrieve messages with OKL_API.GET_MESSAGE when an error is returned.