Search Results jtf_task_template_number_s

Overview

JTF_TASK_TEMPLATES_PVT is the private implementation package body for Oracle E-Business Suite's Task Template functionality, part of the CRM Foundation (JTF) module. Task Templates provide a reusable blueprint mechanism for defining standard task structures that can be instantiated repeatedly across sales, service, and field service operations. The package encapsulates the core business logic for creating, maintaining, and removing task template definitions and their associated child tasks and dependencies, shielding that logic behind the public API layer, JTF_TASK_TEMPLATES_PUB. As an API-classified (PVT) object owned by the APPS schema, it is not intended for direct invocation by external consumers. In Oracle EBS 12.1.1 and 12.2.2, it supports the Task Template setup screens and the programmatic generation of task hierarchies, ensuring consistent validation, numbering, and error handling across all callers.

Key Procedures and Functions

The documented package exposes five procedures/functions, centered on three core operations:

• CREATE_TASK — Creates a new task template (or a task within a template) by validating input, invoking the template entity handlers, and inserting the corresponding base and translation rows. It also manages the template number sequence via JTF_TASK_TEMPLATE_NUMBER_S.
• UPDATE_TASK — Modifies an existing task template record, applying validated changes to the base table and related translation and dependency records. It preserves referential integrity with dependent tasks.
• DELETE_TASK — Removes a task template or constituent task, cascading to dependent tasks and dependency relationships (JTF_TASK_DEPENDS) to maintain data consistency across the template hierarchy.

These procedures leverage shared utility logic from JTF_TASK_TEMPLATES_PKG, JTF_TASK_UTL, and the entity handlers, and they propagate errors using the FND_API / FND_MSG_PUB error-stack conventions.

Tables Accessed

• JTF_TASK_TEMPLATES_B — Base table storing task template header records.
• JTF_TASK_TEMPLATES_TL — Translation table holding language-specific template text.
• JTF_TASK_TEMPLATES_S — Denormalized search/security table enabling efficient querying of templates.
• JTF_TASKS_B — Base task table, used when creating tasks associated with or generated from templates.
• JTF_TASK_DEPENDS / JTF_TASK_DEPENDENCY_PUB — Store and manage predecessor/successor relationships between tasks in a template.
• JTF_TASK_TEMPLATE_NUMBER_S — Sequence source for generating unique template numbers.
• JTF_TASK_TEMP_GROUPS_VL and DUAL — Reference view for template grouping lookups and general PL/SQL selection.

Usage Notes

JTF_TASK_TEMPLATES_PVT is invoked indirectly through JTF_TASK_TEMPLATES_PUB rather than being called directly. Typical call paths include the Task Template setup forms and other Task Manager UI components, where user actions on template definitions trigger the public API, which in turn delegates to the private procedures described above. Concurrent programs and other internal JTF components that instantiate tasks from templates also route through this package. In custom development, the recommended practice is to call the public wrapper (JTF_TASK_TEMPLATES_PUB) to preserve validation, security, and error-handling behavior. Because the private package shares the JTF_TASKS_B and JTF_TASK_DEPENDS structures with the broader task model, any custom integration manipulating templates directly should respect the dependency and translation tables to avoid orphaned or inconsistent template definitions.