Search Results okc_qcl_pvt




Overview
Explore in AI Chat

Overview

OKC_QCL_PVT is a private PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module. Its name derives from "QCL," referring to QA Check Lists, and the "_PVT" suffix identifies it as an internal implementation package rather than a public API. The package provides the low-level data access and maintenance logic behind the OKC_QA_CHECK_LISTS_B and OKC_QA_CHECK_LISTS_TL tables, which store the master definitions of quality assurance check lists used during contract authoring and negotiation.

In the Oracle Contracts architecture, check lists allow organizations to define structured sets of questions or verification steps that must be completed against a contract or a contract template. The OKC_QCL_PVT package encapsulates the record type qcl_rec_type, which mirrors the columns of OKC_QA_CHECK_LISTS_B, including the primary key id, effective dating columns (begin_date, end_date), standard WHO audit columns (created_by, creation_date, last_updated_by, last_update_date, last_update_login), the object_version_number used for optimistic locking, and the DFF attribute columns (attribute_category and attribute1 through attribute14). This record type is the contract between this private package and its callers.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, of which the following are catalogued in the ETRM metadata:

  • INSERT_ROW — Inserts a new check list definition row into the base table, applying defaults and standard WHO audit columns.
  • UPDATE_ROW — Updates an existing check list row, typically including check of the object version number.
  • DELETE_ROW — Removes a check list row from the base table.
  • LOCK_ROW — Acquires a row-level lock and validates the object version number for concurrency control prior to update.
  • VALIDATE_ROW — Performs business validation on the record prior to insert or update, such as effective date range checks and uniqueness verification.
  • CHANGE_VERSION — Increments or resets the object version number, supporting the optimistic locking model.
  • API_COPY — Copies an existing check list definition, used when duplicating a check list or cloning a template.
  • ADD_LANGUAGE — Inserts or maintains the translated row in OKC_QA_CHECK_LISTS_TL for a given language.
  • QC — The quality-check routine that validates the integrity of the record before DML is committed by the calling code.

The remaining documented procedures are companion helpers to these core operations.

Tables Accessed

The package operates against two principal tables via APPS synonyms. OKC_QA_CHECK_LISTS_B is the base table holding the check list header and its descriptive attributes; the record type is modeled directly on its columns. OKC_QA_CHECK_LISTS_TL is the translation table, populated through ADD_LANGUAGE. FND_APPLICATION and FND_LANGUAGES are referenced to resolve application identifiers and installed/active languages for the multilingual logic. PLITBLM is the standard Oracle Forms/PL/SQL internal table used for message or list processing within the package.

Usage Notes

As a private package, OKC_QCL_PVT is not intended for direct invocation by external code. It is called by the check list maintenance forms and by higher-level public APIs within Oracle Contracts, and the metadata records that two other packages reference it. Customizations should call the supported public API layer rather than this package, since its signature and behavior are subject to change between releases. It is available in both EBS 12.1.1 and 12.2.2, with the header indicating a stable lineage dating to 2005.