Results for “jtf_task_templates_utl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TASK_TEMPLATES_UTL is an APPS-owned PL/SQL package body in the Oracle E-Business Suite Task Manager (JTF) module. It supports the task template and task template group infrastructure, providing the validation and creation utilities that underpin the definition of reusable task templates within the Oracle EBS CRM foundation. Task templates allow organizations to define standardized sets of tasks, resources, phone numbers, recurrences, and confirmation attributes that can be applied repeatedly when creating runtime tasks, thereby enforcing consistent business processes.

The package is classified as an "OTHER" API in the ETRM 12.2.2 metadata, meaning it is not one of the primary public APIs (such as JTF_TASKS_PUB or JTF_TASK_INST_TEMPLATES_PUB) but serves as a utility layer that those public APIs and related private packages depend upon. Its status is VALID in both the 12.1.1 and 12.2.2 releases, indicating it is a supported object present in the standard application schema.

Key Procedures and Functions

The documented package exposes six procedures and functions, all oriented toward validating and materializing template-related data:

• VALIDATE_TASK_TEMPLATE_GROUP — Validates a task template group, checking that the group definition is consistent and eligible for use within the template framework.
• VALIDATE_CREATE_TEMPLATE — Performs validation logic prior to the creation of a task template, ensuring that the supplied data satisfies the required business rules.
• VALIDATE_CREATE_TASK_RESOURCE — Validates task resource assignments associated with a template, confirming that resource requirements are correctly formed before they are persisted.
• VALIDATE_CREATE_RECUR — Validates recurrence definitions for a task template, checking recurrence rules prior to creation.
• CREATE_TASK_PHONES — Creates the phone number records associated with a task template, inserting into the task phone structures.
• CREATE_TEMPLATE_GROUP_TASKS — Creates the task entries belonging to a task template group, materializing the tasks that constitute the group.

Collectively, these routines separate validation from creation, allowing calling APIs to validate first and only proceed to persistent inserts when the business rules are satisfied.

Tables Accessed

The package references several base tables through APPS synonyms:

• JTF_OBJECTS_B — The base table defining source objects referenced by tasks and templates.
• JTF_TASK_RSC_REQS — Stores task resource requirements used when creating resource assignments for templates.
• JTF_TASK_RECUR_RULES — Holds recurrence rule definitions applied to recurring template tasks.
• JTF_TASK_TEMP_GROUPS_B — The base table for task template groups, written during template group creation.
• PLITBLM — The standard PL/SQL table of messages used for error handling via the FND message framework.

In addition, it depends on views JTF_TASKS_VL and JTF_TASK_TEMPLATES_VL, and on packages including FND_API, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, JTF_TASKS_PUB, JTF_TASK_CONFIRMATION_PUB, JTF_TASK_INST_TEMPLATES_PUB, JTF_TASK_PHONES_PUB, JTF_TASK_RECURRENCES_PUB, JTF_TASK_RESOURCES_PVT, and JTF_TASK_UTL.

Usage Notes

JTF_TASK_TEMPLATES_UTL is not referenced by any other database object per the documented dependency information, and is not intended for direct end-user invocation. It is most commonly called internally by the higher-level public APIs — particularly JTF_TASK_INST_TEMPLATES_PUB and JTF_TASK_TEMPLATES_PUB-related flows — when templates and template groups are defined through the Task Manager administrative forms or through concurrent programs that seed template data. Custom code extending task template functionality should call the published JTF_TASKS_PUB or JTF_TASK_INST_TEMPLATES_PUB APIs rather than this utility package directly, since the utility layer assumes validated inputs and performs no commitment control of its own.