Search Results oke_note_pvt




Overview
Explore in AI Chat

Overview

OKE_NOTE_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Contracts (OKE) module by managing the storage, retrieval, and maintenance of standard note records associated with contract deliverables. In EBS 12.1.1 and 12.2.2, contract standard notes are reusable boilerplate text blocks attached to contract header, line, and deliverable entities. The PVT classification indicates that the package is intended for internal use by the Contracts public APIs rather than direct invocation by external callers. OKEE_NOTE_PVT operates alongside the OKE_STANDARD_NOTES_PUB public package, exposing the underlying row-level operations on the OKE_K_STANDARD_NOTES entities while the public layer performs validation, security checks, and business-rule orchestration.

The package depends on OKE_API, OKE_K_STANDARD_NOTES_B, and OKE_K_STANDARD_NOTES_TL, and is itself referenced by OKE_CONTRACT_PUB, OKE_NOTE_PVT, and OKE_STANDARD_NOTES_PUB. This dependency chain confirms its role as a foundational DML utility layer within the Contracts note subsystem.

Key Procedures and Functions

The documented package exposes thirteen procedures and functions that cover the standard DML lifecycle for standard note records:

  • INSERT_ROW — Creates a new standard note or note-association record, populating the base and translated tables.
  • UPDATE_ROW — Modifies the descriptive and textual attributes of an existing note record.
  • DELETE_ROW — Removes a note record from the transactional tables.
  • VALIDATE_ROW — Performs data-integrity checks before insert or update, ensuring required columns and foreign key references are consistent.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent modifications to a note record.
  • ADD_LANGUAGE — Inserts translated content into the TL (translated) table for a specific language, supporting multi-language deployments.

The remaining documented procedures follow the same naming conventions and support the same lifecycle, including language-specific and history-table maintenance. Note that parameter lists are intentionally not documented here; callers should reference the OKE_STANDARD_NOTES_PUB wrapper rather than invoke these procedures directly.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

Usage Notes

OKE_NOTE_PVT is not designed for direct invocation by end users or custom code. It is called internally by OKE_STANDARD_NOTES_PUB and OKE_CONTRACT_PUB when notes are created or modified through the Contracts workbench forms or through public API calls. In 12.2.2, the same dependency structure persists. Developers extending the Contracts module should call the PUBLIC package; calling OKE_NOTE_PVT directly bypasses validation logic and may corrupt history and translation records.