Search Results jtf_ec_pvt




Overview
Explore in AI Chat

Overview

JTF_EC_PVT is the private implementation package for Oracle E-Business Suite's Escalation Management functionality, owned by the APPS schema and classified as a PVT (private) API object. The package header declares AUTHID CURRENT_USER, and its source header identifies it as the private interface to JTF Escalation Management, responsible for creating, updating, and deleting contacts associated with escalations. As a private package, it is not intended for direct invocation by external callers; instead it backs the public, supported escalation APIs and business logic within the JTF (CRM Foundation / Task Manager) product family. The package name JTF_EC_PVT is a private implementation package for Oracle E-Business Suite Escalation Management.

The package participates in the broader Task Manager and Escalation framework, where escalations are treated as a business entity (JTA_ESCALATION) and integrated with resource, territory, and audit tracking. Its documented lifecycle status is active and its compatibility rating is S (supported).

Key Procedures and Functions

ETRM documents four procedures or functions for this package, all part of the escalation maintenance workflow:

  • CREATE_ESCALATION — Creates a new escalation record. After successful creation, it triggers the Business Event System (BES) for the create event. The API supports standard FND_API parameters such as p_api_version, p_init_msg_list, and p_commit, along with escalation attributes including name, description, status name and ID, priority name and ID, open and close dates, owner type code, owner ID, and owner territory.
  • UPDATE_ESCALATION — Modifies an existing escalation, allowing changes to its descriptive and status-related attributes while preserving the integrity of the escalation record.
  • DELETE_ESCALATION — Removes an escalation record, handling the associated cleanup and — where applicable — raising the corresponding business event.
  • GET_ASSIGN_ESC_TERR_RESOURCES — Retrieves the resources assigned to the escalation based on territory assignment rules, supporting the routing and ownership logic of the escalation framework.

Tables Accessed

The package reads and writes a well-defined set of application tables through APPS synonyms:

Usage Notes

Because JTF_EC_PVT is a private package, it is not exposed as a public API and is referenced by two other packages that provide the supported entry points. It is typically invoked indirectly through Oracle EBS forms and the Task Manager / Escalation Management UI, through concurrent programs performing escalation maintenance, or through custom code that calls the public escalation API layer rather than this private implementation. The BES trigger on create ensures downstream workflow, notification, and integration processes are fired consistently once an escalation is successfully persisted. Developers should avoid calling JTF_EC_PVT directly; the documented public interface should be used to preserve upgrade safety across EBS 12.1.1 and 12.2.2.