Search Results okc_qlp_pvt




Overview
Explore in AI Chat

Overview

OKC_QLP_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Contract Terms and Conditions (QA check list / quality assurance list processing) functionality. It belongs to the OKC module (Contracts Core) and is classified as a PVT (private) API, meaning it is intended to be called internally by other packages rather than directly by end users or external integrations. The package name references "QLP," which corresponds to the OKC_QA_LIST_PROCESSES entity—the quality assurance list processes that govern how check lists are applied against contracts and their associated clauses.

Its principal role is to provide the underlying data manipulation and validation logic that higher-level public APIs, particularly OKC_QA_CHECK_LIST_PUB and OKC_QA_CHECK_LIST_PVT, depend upon. It centralizes the low-level operations—insert, update, delete, lock, and version management—for QA list process records, thereby insulating callers from the physical schema details and enforcing consistent business rules. In EBS 12.1.1 and 12.2.2, the package status is VALID and it is compiled against the standard FND_API utility layer.

Key Procedures and Functions

The ETRM metadata documents thirteen procedures/functions. The named ones include:

  • QC — A quality control / consistency check routine, typically used to verify the integrity of QA list process data prior to committing changes.
  • CHANGE_VERSION — Manages version stamping of records, ensuring the correct version number is applied when QA list process rows are created or modified.
  • API_COPY — Copies QA list process data from a source record to a new or target record, supporting duplication scenarios.
  • INSERT_ROW — Inserts a new row into the QA list process table.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent modifications.
  • UPDATE_ROW — Updates an existing QA list process row.
  • DELETE_ROW — Removes a QA list process row.
  • VALIDATE_ROW — Performs validation checks against business rules before a row is persisted.

Additional entries (five more of the thirteen) follow the same DML/validation pattern. No parameter lists are documented in the metadata, so exact signatures are not asserted here.

Tables Accessed

The package references several application tables through APPS synonyms:

  • OKC_QA_LIST_PROCESSES — The primary transactional table holding QA list process definitions and instances.
  • OKC_PROCESS_DEFS_B — Stores process definitions, providing the template/framework against which list processes are instantiated.
  • OKC_QA_CHECK_LISTS_B — The base table for QA check lists, linking check list content to the processes.
  • PLITBLM — A standard EBS PL/SQL index-by table used for bulk processing; not a persisted application table.

In addition, the package depends on OKC_QA_LIST_PROCESSES_V (a view) and on OKC_API, FND_API, and STANDARD.

Usage Notes

Because OKC_QLP_PVT is a private package, it is not invoked directly through Oracle Forms or concurrent programs. It is called from OKC_QA_CHECK_LIST_PUB and OKC_QA_CHECK_LIST_PVT, and is self-referenced. Customizations should prefer the public OKC_QA_CHECK_LIST_PUB interface. Any direct use of OKC_QLP_PVT should be treated as unsupported and subject to change during patching or upgrades.