Search Results cac_notes_pvt




Overview
Explore in AI Chat

Overview

CAC_NOTES_PVT is a private PL/SQL package in the APPS schema that provides the core create, update, and delete logic for the notes infrastructure used across Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2 it acts as the underlying implementation layer beneath the public notes API, encapsulating the direct manipulation of the JTF_NOTES_B, JTF_NOTES_TL, and JTF_NOTE_CONTEXTS tables. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking session rather than the definer, and its procedures are intended to be called by other packaged APIs rather than by end users or forms directly. Its header carries the standard EBS version marker (cacvnts.pls, version 115.2), confirming it is a long-standing component of the CRM/JTT notes framework. The package is referenced by one other package, reinforcing its role as an internal service layer.

Key Procedures and Functions

The documented interface exposes seven procedures and functions:

  • CREATE_NOTE — Inserts a new note record into JTF_NOTES_B and its translated counterpart JTF_NOTES_TL. It accepts the owning source object, note text and detail, status and type, fifteen descriptive attributes, optional parent note linkage, and standard who-column auditing values, returning the generated note identifier and the standard return status, message count, and message data out parameters.
  • UPDATE_NOTE — Modifies an existing note record in JTF_NOTES_B and JTF_NOTES_TL, preserving the identity of the note while refreshing its descriptive and contextual columns.
  • DELETE_NOTE — Removes a note record and its associated translated and contextual rows.
  • CREATE_NOTE_CONTEXT — Establishes a context association for a note, inserting into JTF_NOTE_CONTEXTS so that the note is bound to a specific usage or object context. This is the routine most directly relevant to the searched term "create_note_context."
  • UPDATE_NOTE_CONTEXT — Modifies an existing note context association.
  • DELETE_NOTE_CONTEXT — Removes a note context association.
  • GET_ENTERED_BY_NAME — Resolves and returns the display name of the user who entered a note, joining to the user and person tables.

Tables Accessed

The package reads and writes the following documented tables and views, all referenced through APPS synonyms:

  • JTF_NOTES_B, JTF_NOTES_TL, JTF_NOTES_S — the base, translated, and secondary note tables that hold note text, attributes, and translations.
  • JTF_NOTE_CONTEXTS — stores the contextual bindings created and maintained by the context procedures.
  • JTF_OBJECT_USAGES — defines the object usage context against which notes are scoped.
  • FND_USER, PER_ALL_PEOPLE_F, HZ_PARTIES — used to resolve the user, person, and party behind the entered-by value.
  • FND_LANGUAGES, FND_LOOKUP_VALUES — supply language and lookup validation for note status, type, and translations.
  • DUAL — used for singleton queries and default value derivation.

Usage Notes

Because CAC_NOTES_PVT is classified as a private (PVT) API, it is not published for direct customer invocation. It is typically called from the public notes API layer, from CRM and Service forms that present note regions, and from concurrent programs or custom PL/SQL that require controlled note creation with context. The CREATE_NOTE_CONTEXT routine is invoked whenever a note must be associated with a specific object usage, such as linking a service request note to a context. Developers extending EBS should call the supported public wrapper rather than this private package, and should supply the standard x_return_status, x_msg_count, and x_msg_data out parameters to participate in the EBS error-handling stack. Its AUTHID CURRENT_USER declaration means the calling session must hold the necessary object privileges on the JTF tables.