Search Results get_resource_type_name

Overview

APPS.CSF_GANTT_DATA_PKG is a PL/SQL package belonging to the Oracle Field Service / TeleService (CSF) module of Oracle E-Business Suite. Its principal business function is to supply, manipulate, and validate the data that drives the Gantt chart user interface used in field service scheduling and dispatch. The package forms the server-side backbone of the graphical scheduling tools that allow dispatchers and planners to visualize tasks, resources, shifts, and schedule recommendations across a timeline.

The package header carries a change history that documents its incremental evolution from its initial creation in May 2004 through a series of functional extensions in late 2004 and 2005. Early revisions added a global variable for userenv('lang'), modified the parameters of the scheduled-task and virtual-task procedures, and introduced procedures for real tasks in the plan option window. Subsequent revisions removed embedded tooltip, color, and contact-point logic and reorganized it into dedicated procedures. Support for drag-and-drop, skilled-resource validation, and resource naming was added in early 2005, and schedule-advise Gantt procedures followed in April 2005.

The package is classified as OTHER in the API classification scheme and is referenced by two other packages, indicating its role as an internal data provider rather than a public, supported API.

Key Procedures and Functions

The ETRM metadata documents nineteen procedures and functions. The primary data-retrieval routines include GET_PLANNED_TASK, which returns planned task records for display on the chart; GET_DISPATCH_TASK_DTLS, which returns the details of dispatched tasks; and GET_SCHEDULE_ADVISE_OPTIONS, which returns the available schedule-advise configurations. CONVERT_TO_DAYS performs the unit conversion required to align task durations and offsets with the Gantt timeline.

Tooltip and presentation logic is handled by a dedicated group: GET_TOOLTIP_DATA_GANTT, GET_TOOLTIP_DATA_GANTT_CUST, GET_TOOLTIP_DATA_SCH_ADVISE, GET_TOOLTIP_DATA_SCH_ADVISE_CU, and GET_TOOLTIP_FOR_PLAN_TASK retrieve the text and metadata displayed when a user hovers over a task bar. GET_GANTT_TASK_COLOR, GET_GREEN, and G_DO_MATCH support visual differentiation of tasks by computing and matching colors, with G_DO_MATCH resolving the color assigned to a given task.

Interactive editing is supported by DRAG_N_DROP, which processes task reassignment within the chart. GET_SKILLED_RESOURCES validates that a resource receiving a dragged task possesses the required skills and is active on the target date. GET_RESOURCE_NAME and GET_RESOURCE_TYPE_NAME populate the resource entries in the left-hand pane of the Gantt chart. GET_MESSAGE_TEXT returns user-facing messages. Finally, INSERT_ROWS and DELETE_ROWS manage persistence of the underlying Gantt data records.

Tables Accessed

The package reads and writes a range of service, inventory, and planning tables accessed through APPS synonyms. Service request data is drawn from CS_INCIDENTS_ALL_B, CS_INCIDENT_TYPES_TL, and CSI_ITEM_INSTANCES, providing incident details and the installed-base item associated with a task. Task definitions come from JTF_TASKS_B, JTF_TASKS_TL, and JTF_TASK_TYPES_TL. Item descriptions are resolved from MTL_SYSTEM_ITEMS_KFV.

Resource and scheduling configuration is held in CSF_ACCESS_HOURS_B (working hours), CSF_GANTT_CHART_SETUP (chart configuration), CSF_REQUIRED_SKILLS_B and CSF_RESOURCE_SKILLS_B (skill requirements and assignments), and CSF_R_PLAN_OPTIONS and CSF_R_PLAN_OPTION_TASKS (plan options and their tasks). CSF_R_REQUEST_TASKS links requests to tasks, while CAC_SR_OBJECT_CAPACITY covers service-request capacity constraints.

Usage Notes

CSF_GANTT_DATA_PKG is invoked indirectly by the field service Gantt user interface, typically through Java data-source classes and the scheduling forms that render the chart. It is not intended for direct invocation by end users or as a published integration API. Its procedures also service drag-and-drop interactions, tooltip rendering, resource-pane population, and color matching driven by user actions in the chart. The search term estimated_start relates to the scheduling attributes returned by the task-retrieval procedures such as GET_PLANNED_TASK and GET_DISPATCH_TASK_DTLS. Customizations should avoid modifying the package directly; extensions are best implemented through wrapper code or the documented tooltip customization entry points.