Search Results jtf_task_custom_colors_pub




Overview
Explore in AI Chat

Overview

JTF_TASK_CUSTOM_COLORS_PUB is a public PL/SQL package in the Oracle E-Business Suite Application Object Library (APPS) schema that resolves the display color assigned to a task record within the Oracle Task Manager / Resource Manager foundation (JTF) framework. Rather than hard-coding task colors in a form or region, Oracle stores color rules as data in the JTF_TASK_CUSTOM_COLORS table, keyed by task type, priority, assignment status, and escalation state. This package reads those rules, applies deterministic precedence, and returns the resulting color to the calling UI component so that task lists, calendars, and work queues present consistent visual cues to end users.

The source header confirms the package is defined in jtfptkfb.pls and was created in October 2002 by developer cjang, with subsequent modifications through December 2002. The header description states plainly: "This package is used to get the color for a task." It is classified as a PUB (public) API, meaning it is supported for direct invocation by other Oracle and customer-developed code.

Key Procedures and Functions

  • GET_TASK_RGB_BGCOLOR — Returns the background color of a task expressed as an RGB value, suitable for programmatic rendering where a numeric color code is required rather than a descriptive label.
  • GET_TASK_DEC_BGCOLOR — Returns the background color of a task in its "dec" (declarative / descriptive) form. This routine was added on 06-Dec-2002 to resolve Bug 2696521, indicating Oracle introduced a separate accessor when consumers needed the color in a form distinct from the RGB representation.
  • GET_TASK_BGCOLORS — Returns background colors for tasks, added 31-Oct-2002 along with the background_col_dec column and the taskcolor_tbl collection type. Its parameter was deliberately changed to the type of the get_task_bgcolors structure, and the NOCOPY option was applied on 03-Dec-2002 under Bug 2667735 to reduce copy overhead for the returned collection.

An internal procedure, GET_CUSTOM_COLOR, populates the package-global cache g_custom_color_tbl from the cursor c_custom_color, which selects the active color rules ordered by COLOR_DETERMINATION_PRIORITY. The cache is loaded only when g_custom_color_tbl.COUNT is zero, and is not repopulated until the session's collection is cleared.

Tables Accessed

  • JTF_TASK_CUSTOM_COLORS — The primary configuration table. The cursor filters on ACTIVE_FLAG = 'Y' and orders by COLOR_DETERMINATION_PRIORITY, retrieving TYPE_ID, PRIORITY_ID, ASSIGNMENT_STATUS_ID, ESCALATED_TASK, BACKGROUND_COL_DEC, and BACKGROUND_COL_RGB.
  • JTF_TASKS_B — The base task entity, supplying the task attributes evaluated against the color rules.
  • JTF_TASK_REFERENCES_B — Referenced in the escalated_task() logic; the cursor c_reference was revised on 30-Oct-2002 from an IN ('L1','L2','L3') predicate to NOT IN ('DE','NE'), changing which task references are treated as escalation indicators.
  • JTF_TASK_STATUSES_B — Provides task status and assignment status context used during rule matching.
  • PLITBLM — The standard Oracle index-by table manipulation utility, used in connection with the taskcolor_tbl collection type.

Usage Notes

This package is invoked at runtime by Oracle Task Manager forms, calendar and worklist regions, and any custom code that needs to color-code tasks. Because it exposes a session-level global cache, repeated calls within a single database session are inexpensive after the first load; however, changes to JTF_TASK_CUSTOM_COLORS made by an administrator will not be reflected until the session ends or the cached collection is cleared. The package is referenced by two other packages in the ETRM inventory, underscoring its role as a shared utility rather than a standalone feature. Consumers searching for the column escalated_task should note that this attribute originates in JTF_TASK_CUSTOM_COLORS and is evaluated inside this package's color-resolution logic, making JTF_TASK_CUSTOM_COLORS_PUB the authoritative place to understand how escalation affects task color in Release 12.1.1 and 12.2.2.