Search Results jtf_ih_pvt




Overview
Explore in AI Chat

Overview

JTF_IH_PVT is a private PL/SQL package body in the APPS schema belonging to the Oracle Interaction History (IH) sub-module of Oracle E-Business Suite, commonly delivered under the CRM/Telephony framework. The "PVT" suffix denotes a private API classification, meaning the package is intended for internal consumption by the Interaction History public APIs and supporting components rather than for direct invocation by external application code. Its business purpose is to encapsulate the low-level insert, validation, and persistence routines that record an interaction—such as an inbound or outbound call, e-mail, or other media-based customer contact—into the Interaction History data model. The package is documented as VALID in ETRM for both 12.1.1 and 12.2.2, and its dependency list confirms that it operates beneath the JTF_IH_PUB public layer.

Key Procedures and Functions

ETRM 12.2.2 documents a single procedure/function for this package body:

  • CREATE_INTERACTION_M — The core creation routine. As implied by the "_M" (multi-media or "create") naming convention used throughout the JTF Interaction History private APIs, this procedure is responsible for materializing a new interaction record and its associated media items within the Interaction History schema. It is the internal engine that the public API layer calls when a new customer interaction must be persisted. Parameter lists are not documented in the ETRM extract and should not be assumed; callers should treat this as a private entry point invoked exclusively through JTF_IH_PUB.

No additional procedures or functions are documented for this package body, indicating it is a narrowly scoped, single-purpose private API rather than a broad utility library.

Tables Accessed

The documented direct table references are limited:

  • DUAL — Used for standard single-row evaluation, typically for sequence value derivation or constant expression selection within the creation logic.
  • PLITBLM — A PL/SQL index-by table type used for in-memory array handling within the package, supporting bulk or set-based processing.

The dependency list additionally shows references to APPS.JTF_IH_INTERACTIONS_S1 and APPS.JTF_IH_MEDIA_ITEMS_S1. These are the primary base tables (or their synonyms/indexes) of the Interaction History model: JTF_IH_INTERACTIONS_S1 stores the parent interaction header rows, and JTF_IH_MEDIA_ITEMS_S1 stores the individual media items (call, e-mail, note, and similar) that belong to an interaction. READ access to these underlies the package's role in creating and validating the parent-child interaction structure.

Usage Notes

JTF_IH_PVT is not referenced by any other database object according to ETRM, and it is not intended for direct external use. It is invoked indirectly through the public package APPS.JTF_IH_PUB, which the dependency list shows it depends on alongside FND_API and FND_MSG_PUB. Typical invocation paths include:

  • Oracle Telephony / Call Center forms and CTI integrations — where an interaction (frequently a logged call) is created as part of agent activity.
  • Public API consumers — custom or seeded code calling JTF_IH_PUB, which in turn delegates record creation to JTF_IH_PVT.CREATE_INTERACTION_M.
  • Concurrent or batch processes — that generate interaction records in bulk.

Because it uses FND_API and FND_MSG_PUB, the package participates in the standard EBS API error-handling and message-stack framework. Customizations should never call JTF_IH_PVT directly; they should invoke the public JTF_IH_PUB interface and rely on this private body only as the internal implementation of interaction creation.