Search Results jtf_task_utl_ext




Overview
Explore in AI Chat

Overview

JTF_TASK_UTL_EXT is an APPS-owned PL/SQL package in the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as an extension utility layer that supports the core task management infrastructure used throughout Oracle EBS 12.1.1 and 12.2.2. Where the sibling package JTF_TASK_UTL provides the primary task-handling routines, JTF_TASK_UTL_EXT supplies supplementary helper logic for date derivation, calendar resolution, sequence number allocation, duplicate reference validation, and object-code lookups. The package status is documented as VALID, and its API classification is recorded as OTHER, indicating it is an internal utility package rather than a public, published API.

The package operates at the center of the task, assignment, dependency, recurrence, and reference subsystems, acting as a shared library that these higher-level private packages call rather than duplicating validation and date-handling logic.

Key Procedures and Functions

The ETRM metadata documents twelve procedures and functions:

  • SET_CALENDAR_DATES and SET_START_N_DUE_DATE — derive or assign calendar-based start and due dates for a task, applying calendar working-day rules.
  • ADJUST_DATE — shifts a supplied date, typically to honour calendar or business-day constraints.
  • GET_BSD / GET_BED — retrieve the business start date and business end date respectively, used when scheduling tasks within a working period.
  • GET_OPEN_FLAG — returns the open/closed indicator for a task or related entity.
  • GET_LAST_NUMBER — allocates the next available sequence number, supporting task or reference numbering.
  • VALIDATE_CYCLIC_TASK — checks for circular task dependencies before they are committed, protecting the dependency hierarchy from invalid loops.
  • UPDATE_OBJECT_CODE — maintains the object code associated with a task reference.
  • GET_OBJECT_DETAILS — retrieves descriptive details for a referenced object.
  • GET_TASK_NAME — resolves and returns a task name.
  • CHECK_DUP_REFERENCE_FOR_UPDATE — validates a task reference during update to prevent duplicate references.

Parameter lists are not reproduced here; the documented purpose of each routine is as described above.

Tables Accessed

The package references the following tables through APPS synonyms:

  • JTF_TASKS_B — the base task table, the primary source and target of task date, name, and open-flag logic.
  • JTF_TASK_REFERENCES_B — supports reference validation and object-code updates.
  • HZ_RELATIONSHIPS and HZ_PARTIES — resolve the party and relationship context in which tasks are created and assigned.
  • JTF_OBJECTS_B — supplies object definitions for object-code and object-detail resolution.
  • JTF_TASK_STATUSES_B — provides task status values used by the open-flag logic.
  • MTL_UNITS_OF_MEASURE — referenced for unit-of-measure lookups in task scheduling or recurrence contexts.
  • ALL_SEQUENCES — queried by GET_LAST_NUMBER to obtain the next sequence value.

Usage Notes

JTF_TASK_UTL_EXT is an internal utility package. It is invoked indirectly by six higher-level private packages: JTF_TASKS_PVT, JTF_TASK_ASSIGNMENTS_PVT, JTF_TASK_DEPENDENCY_PVT, JTF_TASK_RECURRENCES_PVT, JTF_TASK_REFERENCES_PVT, and JTF_TASK_UTL. In addition, it recurses upon itself, as reflected in the dependency metadata.

Because it is not exposed as a public API, direct invocation from forms, concurrent programs, or custom code is not the intended pattern. Customers and integrators should call the public task APIs (for example, through the JTF task private packages invoked by the CRM Foundation forms and the Task Manager UI), which in turn delegate to JTF_TASK_UTL_EXT. In Oracle EBS 12.1.1 and 12.2.2 this package ships under the APPS schema and remains VALID, forming part of the embedded task infrastructure that supports Service, Sales, and Resource Manager task functionality.