Search Results lock_task

Overview

The APPS.JTF_TASK_TEMPLATES_PUB package is the public application programming interface for creating and maintaining task templates within the Oracle E-Business Suite CRM task management framework. Task templates provide reusable definitions that drive the automatic generation of tasks across modules such as TeleSales, Service, and Marketing. In the EBS 12.1.1 and 12.2.2 releases, this package exposes the business logic required to instantiate, modify, lock, and remove template definitions stored in the JTF task schema. It follows the standard EBS two-tier API convention in which a _PUB package wraps a companion _PVT package that performs the actual DML, while the public layer standardizes validation, error handling, and anchoring through FND_API. Utility routines are sourced from JTF_TASK_UTL, which supplies shared task-management logic. The package carries a VALID status in the EBS Technical Reference Manual, confirming that it is compiled, deployed, and supported in the documented environment.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions across the public interface:

• CREATE_TASK — Inserts a new task template record and its corresponding translated (TL) row, establishing the template definition used to spawn runtime tasks.
• UPDATE_TASK — Modifies attributes of an existing task template, including the translated descriptive columns maintained in the TL table.
• LOCK_TASK — Obtains a lock on the template record prior to modification, preventing concurrent updates and preserving data integrity during transactional processing.
• DELETE_TASK — Removes a task template and its dependent rows, handling the referential cleanup expected by the task template schema.

The metadata records six documented procedures or functions in total; the remaining entries follow the same public API pattern and support template lifecycle operations. Detailed parameter signatures are not reproduced here.

Tables Accessed

The package reads and writes several base and translation tables via APPS synonyms:

• JTF_TASK_TEMPLATES_B and JTF_TASK_TEMPLATES_TL — the primary base and translated tables holding template definitions.
• JTF_TASKS_B and JTF_TASKS_TL — runtime task tables that templates are built to generate.
• JTF_TASK_DEPENDS — dependency definitions governing task sequencing.
• JTF_TASK_PRIORITIES_B/TL, JTF_TASK_TYPES_B/TL, and JTF_TASK_STATUSES_B/TL — reference and lookup tables supplying priority, type, and status values applied to templates.
• JTF_TASK_RECUR_RULES — recurrence rules for repeating tasks.
• DUAL and PLITBLM — standard PL/SQL and EBS utility access points.

Usage Notes

The package is invoked programmatically rather than directly by end users. It is referenced by the task template business logic layer, including JTF_TASK_TEMPLATES_PVT, the concurrent handler packages JTF_TASK_TEMPLATES_CUHK and JTF_TASK_TEMPLATES_IUHK, and the validation handler JTF_TASK_TEMPLATES_VUHK. It is also consumed by OZF_TASK_TEMPLATE_PVT, which supports trade management task templates. In the 12.2.2 reference, five additional packages reference this interface. Typical callers include the Task Templates setup form, concurrent programs that seed or maintain templates, and custom extensions that create tasks programmatically. Custom code should call the _PUB procedures rather than the private layer to ensure consistent validation and error propagation through FND_API.