Search Results jtf_task_references_s

Overview

APPS.JTF_TASK_REFERENCES_PVT is the private implementation package body for the Task References business API in Oracle E-Business Suite. It belongs to the JTF (Application Foundation / CRM Foundation) task management layer, which provides the shared infrastructure used by Oracle Telephony Manager, Oracle Service, Oracle Sales, Oracle Contracts, and other modules that attach references to tasks. A "task reference" is the association between a task in JTF_TASKS_B and a business object recorded in JTF_OBJECTS_B — for example, linking a task to a customer, a service request, an opportunity, or a contract. This private package encapsulates the low-level validation, message propagation, and table maintenance logic that the public wrapper JTF_TASK_REFERENCES_PUB delegates to.

The object carries a VALID status in ETRM for both 12.1.1 and 12.2.2 and is an internal (PVT) rather than a public (PUB) API, meaning it is not intended for direct customer invocation.

Key Procedures and Functions

Three documented procedures constitute the operational surface of this package:

• CREATE_REFERENCES — Inserts one or more task-to-object reference rows into the references base table after validating the supplied task and object identifiers. It uses the FND_API message stack to return success, warning, or error status to the caller.
• UPDATE_REFERENCES — Modifies existing reference records, for example to change the referenced object type, object identifier, or reference attributes. It re-validates the target task and object before committing changes.
• DELETE_REFERENCES — Removes reference associations for a task, typically used when a task is reclassified or when a dependent object is detached. It also manages the corresponding translation rows where applicable.

Because ETRM documents no parameter lists for these procedures, exact signatures are not reproduced here. All three follow the standard EBS API contract pattern of returning a status code and populating FND_MSG_PUB with messages.

Tables Accessed

The package works against the following tables and synonym objects:

• JTF_TASK_REFERENCES_B — the base table holding reference records (object type, object identifier, and task foreign key). This is the primary insert/update/delete target.
• JTF_TASKS_B — the task base table, queried to validate that the task exists and is eligible for a reference.
• JTF_OBJECTS_B — the registered business object definitions, used to validate the object type being referenced.
• JTF_TASK_REFERENCES_TL and JTF_TASK_REFERENCES_VL — the translation and view-layer objects maintained in synchronization with the base row for MLS support.
• JTF_TASK_REFERENCES_S — the sequence used to generate the primary key for new reference rows.
• DUAL — used for single-row PL/SQL evaluations and sequence selection.

Usage Notes

This package should not be called directly from custom code. Customers and integrators must use the public wrapper APPS.JTF_TASK_REFERENCES_PUB, which performs the required public-API security context checks and then invokes the private procedures here. The private body also depends on JTF_TASK_REFERENCES_PKG, JTF_TASK_UTL, JTF_TASK_UTL_EXT, FND_API, FND_MESSAGE, and FND_MSG_PUB, so all standard EBS message-stack handling is performed internally.

Typical invocation paths include the Task Manager and Service Request forms in the HTML/Java UI, concurrent programs that bulk-associate tasks with business objects, and workflow or business-event subscribers that create references automatically when a related object is created. ETRM records that the package is referenced by six other database objects and references none of its own siblings, confirming its position as a leaf-level implementation module within the JTF task API stack.