Search Results jtf_task_recurrences_pub




Overview
Explore in AI Chat

Overview

The APPS.JTF_TASK_RECURRENCES_PVT package is the private implementation layer of the Oracle E-Business Suite Task Manager recurrence framework. Its business purpose is to translate a recurrence rule definition—an appointment or task that repeats on a daily, weekly, monthly, or user-defined pattern—into the individual dated task instances that a user ultimately sees in the Calendar and Task Manager windows. In Oracle EBS 12.1.1 and 12.2.2, this functionality is essential for CRM and resource scheduling, where a single recurring appointment (for example, a weekly account review or a monthly maintenance visit) must expand into a discrete, schedulable set of tasks.

The package is classified as PVT, meaning it is not the sanctioned public entry point. Public calls flow through JTF_TASK_RECURRENCES_PUB, which in turn calls this private package for the heavy lifting. Keeping the date-expansion and rule-matching logic private allows Oracle to refine algorithms without exposing unstable signatures to customer extensions.

Key Procedures and Functions

  • CREATE_TASK_RECURRENCE — Establishes a new recurrence definition in the repository, recording the rule that governs how the base task repeats.
  • GENERATE_DATES — Computes the set of concrete occurrence dates implied by a recurrence rule. This is the computational core that interprets frequency, interval, and boundary conditions.
  • RECUR_MAIN — Serves as the main driver routine, orchestrating the processing flow that ties rule retrieval, date generation, and task persistence together.
  • UPDATE_TASK_RECURRENCE — Modifies an existing recurrence definition, supporting changes to the repeat pattern after initial creation.

Each routine participates in the shared recurrence lifecycle: a rule is created or updated, dates are derived from it, and the driver coordinates the resulting task generation. Exact parameter lists are defined by Oracle's implementation and should be obtained from the package specification.

Tables Accessed

  • JTF_TASK_RECUR_RULES and JTF_TASK_RECUR_RULES_S — the base and translation tables where recurrence rule definitions are stored and retrieved.
  • JTF_TASKS_B — the core task base table, written to for generated occurrence records.
  • JTF_TASK_ALL_ASSIGNMENTS — assignment records that propagate owners and resources across generated instances.
  • JTF_TASK_TEMPLATES_B — template definitions that supply default attributes for recurring tasks.
  • JTA_SYNC_TASK_MAPPING — mapping data used when tasks are synchronized between systems.
  • DUAL and PLITBLM — utility references for scalar selection and PL/SQL table handling.

Usage Notes

This package is not intended for direct invocation. It is called by JTF_TASK_RECURRENCES_PUB and by synchronization packages including CAC_SYNC_TASK_COMMON, JTA_SYNC_TASK_COMMON, JTF_TASKS_PUB, and JTF_TASK_SYNC_UPGRADE_PKG. End users interact with it implicitly through the Task Manager and Calendar forms whenever they save a recurring appointment or open a series and modify "this and future" occurrences. Five other packages reference it, confirming its role as a shared internal utility. Customizations should call the public layer; direct reliance on JTF_TASK_RECURRENCES_PVT risks breakage on patching because its specification is exempt from backward-compatibility guarantees.