Search Results update_ptl_qlty_values

Overview

The APPS.OKL_PTL_QUALITYS_PUB package body is a public API within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Taxation and Regulatory Management (ETRM) solution set. It exposes the PL/SQL interface through which external callers — forms, concurrent programs, and custom extensions — create, maintain, validate, and remove lease "quality" definitions and their associated quality values. In lease and asset terminology, quality records describe condition, grade, or classification attributes attached to leased assets and contract lines. The _PUB suffix confirms that this body is the published entry point, delegating business logic to the corresponding private package OKL_PTL_QUALITYS_PVT and to peer validation packages such as OKL_PTQ_PVT and OKL_PTV_PVT. The package is classified as a PUB API and is documented with a status of VALID in the APPS schema.

Key Procedures and Functions

ETRM metadata documents 23 procedures and functions. The principal ones are:

• CREATE_PTL_QUALITYS — Establishes a new lease quality header record, applying defaulting and validation rules before persistence.
• UPDATE_PTL_QUALITYS — Modifies attributes of an existing quality record, honouring optimistic locking conventions.
• VALIDATE_PTL_QUALITYS — Performs business-rule validation on a quality record without committing changes, allowing callers to pre-check data.
• LOCK_PTL_QUALITYS — Acquires a row-level lock on a quality record so that concurrent updates cannot collide.
• DELETE_PTL_QUALITYS — Removes a quality header, subject to referential and business constraints.
• CREATE_PTL_QLTY_VALUES — Inserts one or more quality value lines associated with a quality header.
• LOCK_PTL_QLTY_VALUES — Locks existing quality value rows for update.
• UPDATE_PTL_QLTY_VALUES — Amends quality value details such as code, description, or applicability.
• DELETE_PTL_QLTY_VALUES — Deletes quality value lines, typically as part of header maintenance.
• VALIDATE_PTL_QLTY_VALUES — Validates quality value data against quality-header and reference rules prior to commit.

The remaining documented procedures are utility and overload variants supporting the same CRUD and validation pattern for headers and values. The API follows the standard EBS multi-tier pattern: the public body translates caller input into a standard API parameter structure, delegates to OKL_PTL_QUALITYS_PVT, and uses FND_API and FND_MSG_PUB for the standard return-status and error-message stack. OKC_API is referenced for core contract utilities.

Tables Accessed

The only table directly documented as referenced through APPS synonyms is PLITBLM, the standard EBS multi-lingual translation table used to resolve translated descriptions for quality codes. Because write operations are performed against OKL quality entities, the underlying DML is executed in OKL_PTL_QUALITYS_PVT and its dependencies (OKL_PTQ_PVT, OKL_PTV_PVT), which operate on the OKL quality header and quality value base tables. Custom code should treat these as internal implementation tables and never write to them directly; all maintenance must pass through this API.

Usage Notes

The package is invoked from Lease Management setup and maintenance forms, from concurrent programs that load or migrate lease quality data, and from custom PL/SQL integrations that need to register quality definitions programmatically. Callers should follow the standard EBS API contract: initialise the FND_API global, call the relevant procedure, inspect the returned status, and use FND_MSG_PUB to retrieve messages. Always pair LOCK_* with UPDATE_* or DELETE_* within a single transaction to avoid lost updates. Because the body is not referenced by any other database object, it is a leaf-level public API that can be safely wrapped by customer extensions. It is available in both 12.1.1 and 12.2.2; the ETRM metadata confirms validity in the APPS schema.