Search Results get_tooltip_data_gantt

Overview

APPS.CSF_GANTT_DATA_PKG is a server-side PL/SQL package body that supplies the data layer for the Oracle E-Business Suite Field Service Gantt chart and scheduling workbench. In EBS 12.1.1 and 12.2.2 it underpins the graphical dispatch board, where dispatchers view tasks and service requests as bars on a timeline, inspect tooltips, drag and drop assignments, and run schedule-advise planning. The package assembles the derived data (task colours, tooltips, resource names, skills, capacity and drag/drop updates) that the Java/applet Gantt front end consumes. Its structure is typical of a Gantt support package: a prominent block of package-level globals holds tooltip and label text, user and language context, time-zone state, and colour configuration, while the procedures and functions perform the actual queries and rule evaluation. One such global is a boolean flag named IS_TASK_ESCALATED, referenced when the chart must reflect whether a task has been escalated; escalation status is surfaced through the tooltip and colour logic rather than stored by this package. The source header identifies version 120.52.12010000.3.

Key Procedures and Functions

• GET_MESSAGE_TEXT — returns message or label text, supporting the language/localisation globals declared at package level.
• GET_DISPATCH_TASK_DTLS — retrieves the detailed attributes of a dispatch task for display and processing.
• GET_SCHEDULE_ADVISE_OPTIONS — returns the available schedule-advise planning options that drive the planner.
• GET_TOOLTIP_DATA_SCH_ADVISE / _CU — assemble tooltip content for schedule-advise tasks (the _CU variant applies the customer-specific configuration).
• GET_TOOLTIP_DATA_GANTT / _CUST — assemble standard and customer-specific Gantt tooltips.
• GET_TOOLTIP_FOR_PLAN_TASK — builds tooltip text for planned tasks.
• GET_GREEN — returns colour/threshold information used in chart rendering.
• GET_GANTT_TASK_COLOR — determines the bar colour for a task based on setup and custom colour configuration.
• GET_PLANNED_TASK — returns planned task rows for the chart.
• CONVERT_TO_DAYS — converts a duration into days for timeline positioning.
• DRAG_N_DROP — applies drag-and-drop changes made in the Gantt UI.
• GET_SKILLED_RESOURCES — returns resources matching required skills.
• GET_RESOURCE_NAME / GET_RESOURCE_TYPE_NAME — resolve resource identifiers into display names and type names.
• G_DO_MATCH — matching routine used in resource/skill evaluation.
• INSERT_ROWS / DELETE_ROWS — perform row-level insert and delete operations for the chart's task set.

Tables Accessed

The package reads and writes through APPS synonyms. Task masters and translations come from JTF_TASKS_B and JTF_TASKS_TL, with task type translations in JTF_TASK_TYPES_TL. Service requests are sourced from CS_INCIDENTS_ALL_B, CS_INCIDENT_TYPES_TL and the field-service capacity table CAC_SR_OBJECT_CAPACITY. Inventory context is supplied by CSI_ITEM_INSTANCES and MTL_SYSTEM_ITEMS_KFV. Scheduling configuration and capabilities draw on CSF_ACCESS_HOURS_B, CSF_GANTT_CHART_SETUP, CSF_REQUIRED_SKILLS_B, CSF_RESOURCE_SKILLS_B, CSF_R_PLAN_OPTIONS, CSF_R_PLAN_OPTION_TASKS and CSF_R_REQUEST_TASKS. Together these support tooltip assembly, colour determination, skill matching and capacity checks.

Usage Notes

CSF_GANTT_DATA_PKG is invoked by the Field Service Gantt and dispatch forms and by the scheduling/planning concurrent programs that refresh chart data, not by end users directly. It is referenced by at least two other packages, indicating that customisations or wrapper packages also call it. Custom code should call the package through its public procedures rather than rely on its globals; private internal procedures such as the tooltip-label setter are implementation details. Because colours, tooltips and escalation indicators are driven by configuration tables, changes appear only after the chart data is refreshed. Behaviour is version-sensitive between 12.1.1 and 12.2.2, so always validate against the instance's own documented package specification before extending it.