Search Results jtf_notes_pkg




Overview
Explore in AI Chat

Overview

JTF_NOTES_PKG is the core PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that implements the Notes/Attachments infrastructure shared across multiple EBS modules. Notes in EBS are polymorphic: any object registered in JTF_OBJECTS_B can own one or more notes, and the same note can be linked to many objects simultaneously. JTF_NOTES_PKG provides the low-level DML and utility services that allow forms, public APIs, and views to insert, update, lock, delete, and translate notes without directly manipulating the underlying tables. Because the note data model is multi-lingual and stores large text content as LOBs, the package encapsulates releases, language handling, and LOB write mechanics rather than exposing them to callers. Views such as JTF_NOTES_VL, JTF_IH_NOTES_VL, JTF_IH_ALL_NOTES_VL, JTF_NOTE_CONTEXTS_V, CS_INCIDENTS_DIARY_V, and CSC_SR_KB_NOTE_LINKS_V depend on it for their read/write access paths. Its API classification is OTHER, and in ETRM 12.1.1/12.2.2 it is a standard, VALID dictionary object. It is referenced by at least eleven other packages, confirming its role as the foundational note-primitives layer.

Key Procedures and Functions

  • INSERT_ROW — Creates a new note record, initializing the base and translation rows for the note.
  • LOCK_ROW — Obtains a concurrency lock on an existing note so that subsequent updates do not collide with other sessions.
  • UPDATE_ROW — Modifies attributes of an existing note, including its textual content.
  • DELETE_ROW — Removes a note record and its related rows.
  • ADD_LANGUAGE — Adds a new translated language row for an existing note, supporting the multilingual (TL) model.
  • WRITEDATATOLOB — Writes the note body content into the LOB column, handling the actual LOB write semantics.
  • GET_NOTE_CONTEXT_VALUE — Retrieves a context value associated with a note from JTF_NOTE_CONTEXTS.
  • LOAD_ROW — Loads a note row for processing, typically during migration or seeding.
  • TRANSLATE_ROW — Translates an existing note row into another language.

Tables Accessed

The package operates against the standard Notes tables: JTF_NOTES_B (base attributes), JTF_NOTES_TL (translated note text), JTF_NOTES_S (sequence/denormalized values), JTF_NOTE_CONTEXTS (contextual attributes per note), JTF_OBJECTS_B (registered EBS entities that can own notes), and JTF_OBJECT_USAGES (usage linkage between objects and notes). Utility objects DBMS_LOB and DBMS_SQL support LOB writing and dynamic operations, while FND_LANGUAGES provides the installed-language validation used in ADD_LANGUAGE and TRANSLATE_ROW.

Usage Notes

This package is not exposed to end users directly; it is invoked through Notes forms, the JTF_NOTES_PUB public API layer, and dependent packages such as JTF_TASKS_PUB, CS_KNOWLEDGE_AUDIT_PVT, and JTF_IH_PVT. Custom code should normally call JTF_NOTES_PUB rather than JTF_NOTES_PKG, since the PUB layer enforces business validation and is more stable across releases.