Search Results insert_pqualitys

Overview

The APPS.OKL_SETUPPQUALITYS_PUB package body is a public (PUB-classified) API within the Oracle E-Business Suite Enterprise Territory Management / Lease Management (ETRM) module. It provides the external, consumer-facing interface for creating and maintaining "product quality" setup records associated with the Oracle Lease Management product data model. In the OKL schema, "quality" refers to quality or grading attributes attached to a product or product combination, stored and exposed through the okl_pdt_qualitys_v view. The package follows the standard EBS public/private (PUB/PVT) architecture: this PUBLIC package is a thin wrapper that performs API-level initialization, error trapping, and message handling, while delegating the substantive business logic to a corresponding private package, OKL_SETUPPQUALITYS_PVT. This separation allows Oracle to change internal processing without altering the published interface relied upon by forms, concurrent programs, and custom extensions.

Key Procedures and Functions

The package exposes three documented entry points:

• GET_REC — Retrieves a single product-quality record. It accepts an input record of type pqyv_rec_type (typically carrying a primary key or identifying information), calls the private API's get_rec, propagates the private package's x_return_status, and returns the fully populated record along with a no-data-found indicator. It validates the private call's return status and converts an unexpected error into the standard FND_API.G_EXC_UNEXPECTED_ERROR exception.
• INSERT_PQUALITYS — The public wrapper for the insert-process API, corresponding to the user's search term. It creates a new product-quality setup record. It accepts an API version and an initialization flag (p_init_msg_list, defaulting to OKL_API.G_FALSE), an input record and output record of type pqyv_rec_type, and the standard EBS API messaging parameters x_return_status, x_msg_count, and x_msg_data. It declares a local API name constant for error-source identification and delegates the insert to the private package.
• UPDATE_PQUALITYS — The public wrapper for updating an existing product-quality record, following the same parameter and messaging conventions as the insert procedure.

Tables Accessed

The package operates against the product-quality data exposed through the okl_pdt_qualitys_v view, which is the documented source for the get_rec interface. The underlying base tables are accessed indirectly through the private package, OKL_SETUPPQUALITYS_PVT, rather than directly by this public wrapper. This view/table pair stores the quality definitions that qualify products for lease and financing setup purposes; GET_REC reads from it, while INSERT_PQUALITYS and UPDATE_PQUALITYS write new or modified quality rows through the private layer. Because the public package performs no direct SQL of its own, all data manipulation, validation, and concurrency handling are centralized in the private API.

Usage Notes

This package is intended to be invoked as a formal EBS public API. Typical call sites include Oracle Lease Management setup forms (for example, product/quality maintenance windows), concurrent programs that mass-create or update product quality definitions, and custom or extension code developed by implementers. Callers must always inspect x_return_status for FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR, and should retrieve messages via FND_MSG_PUB when x_msg_count is greater than zero. Because INSERT_PQUALITYS and UPDATE_PQUALITYS participate in the caller's transaction, commit or rollback must be controlled by the invoking program. Following the standard pattern, custom callers should pass the current API version and may request message-list initialization. One other package references this API, and it is registered as a PUBLIC object owned by APPS, so it should be treated as a supported, versioned interface rather than modified directly.