Search Results delete_task_template_group

Overview

APPS.JTF_TASK_TEMP_GROUP_PUB is a public PL/SQL package in the Oracle E-Business Suite CRM/Telephony (JTF) schema that manages task template groups. Task template groups are the reusable containers that organize task templates in the Task Manager and interaction/telephony modules, and the package exposes the standard public API surface (CREATE, UPDATE, DELETE, LOCK, and GET) used to maintain them through supported calls rather than direct DML. The package body header identifies it as version 115.28, last modified 2002/12/06, distributed as jtfptkgb.pls, and it relies on the JTF message dictionary and the FND API exception framework for error handling.

Key Procedures and Functions

• CREATE_TASK_TEMPLATE_GROUP — Validates input and inserts a new task template group. In practice it invokes the internal validation routines before committing the new record.
• UPDATE_TASK_TEMPLATE_GROUP — Modifies an existing task template group, applying the duplicate-name and existence validations before writing changes.
• DELETE_TASK_TEMPLATE_GROUP — Removes a task template group after confirming that it is valid and eligible for deletion.
• LOCK_TASK_TEMPLATE_GROUP — Places a lock on a task template group record, supporting concurrent-update protection during transactional processing.
• GET_TASK_TEMPLATE_GROUP — Retrieves task template group information for a given group identifier, typically returning attributes to the calling form or process.

Tables Accessed

The documented table access is via the APPS synonym JTF_TASKS_B, the base table underlying task definitions. The package body also queries the view JTF_TASK_TEMP_GROUPS_VL, which is the validated, translated view of task template groups. Validation cursors in the body query this view to confirm existence and uniqueness:

• val_task_temp_group_id — cursor val_temp_group_id selects from JTF_TASK_TEMP_GROUPS_VL by task_template_group_id; if not found it raises the JTF message JTF_TASK_MISSING_TEMP_GRP and fnd_api.g_exc_error.
• val_task_temp_group_name — cursor val_name checks for an existing template_group_name; if found it raises JTF_TK_DUP_TEMPL_GRP_NAME.
• val_upd_task_temp_group_name — cursor val_name_upd performs the same duplicate-name check while excluding the current record (task_template_group_id not equal to the input), preventing a false duplicate on update.
• val_source_object_type_code — additional validation on the source object type code.

Usage Notes

This package is a PUB-classified API, meaning it is intended for external callers. According to the ETRM metadata it is referenced by five other packages, and it is invoked from the Task Manager setup forms, concurrent/validation programs, and custom integrations that create or maintain task template groups. Callers should be aware that validation failures are signaled through the FND message stack with fnd_api.g_exc_error, so the calling code must handle the standard API exception. Because the validation cursors exist specifically to enforce the group ID and group name rules, developers writing custom code against this package should call its documented procedures rather than issuing direct DML against JTF_TASK_TEMP_GROUPS_VL or JTF_TASKS_B, ensuring consistent message handling and preserving the integrity of task template group definitions across Oracle EBS 12.1.1 and 12.2.2 environments.