Search Results msc_gantt_pkg




Overview
Explore in AI Chat

Overview

MSC_GANTT_UTILS is an internal helper package in the APPS schema that supports the Gantt chart visualization components of Oracle Advanced Supply Chain Planning (ASCP). It provides the constant definitions, view-type enumerations, node classifications, and row-type identifiers that the Gantt engine and its supporting packages use to interpret planning data and render it graphically. The package does not represent a public application programming interface; the ETRM classification is OTHER, indicating it is invoked internally by Oracle's scheduling and planning UI rather than by external integrations.

The package establishes a shared vocabulary for the Gantt subsystem. It defines field, record, and resource separators (including escaped equivalents such as %pipe; and %amp;), a date format mask, view types (order, resource activities, resource hours, resource units, supplier, and demand views), node types (job, operation, resource, coproduct, resource instance, and end demand), pegging modes, and resource row types. These constants allow multiple callers to agree on the structure of the delimited data streams passed between the planning engine and the Gantt user interface.

Key Procedures and Functions

The package exposes 96 documented procedures and functions. The following highlights the representative members named in the ETRM metadata:

  • ISCRITICALSUPPLY — Determines whether a given supply is flagged as critical to the plan, supporting critical-path highlighting in the Gantt display.
  • GETDMDPRIORITY — Returns the priority ranking associated with a demand, used to order or color demand rows.
  • ISRESCHARGEABLE — Indicates whether a resource is chargeable, influencing how resource consumption is reflected.
  • ISCRITICALRES — Identifies critical resources so the UI can emphasize constraint-bearing resources.
  • ISSUPPLYLATE — Flags supplies that are late relative to plan dates.
  • GETACTUALSTARTDATE — Retrieves the actual start date for a scheduled entity.
  • ISRESCONSTRAINT — Determines whether a resource constitutes a constraint.
  • ISRESOVERLOAD — Detects resource overload conditions.
  • ISEXCPEXISTS — Checks for the existence of exceptions tied to a plan element.
  • GETSUPPLYTYPE — Returns the classification of a supply record.
  • GETPLANINFO — Supplies plan-level attributes needed by the caller.
  • GETDISPLAYTYPE — Resolves the display category for a Gantt row.
  • GETRESREQTYPE — Returns the resource requirement type.
  • GETSETUPCODE — Retrieves the setup code associated with a resource requirement.
  • GETRESREQSTARTDATE / GETRESREQENDDATE — Return the start and end dates of a resource requirement.
  • GETDEPENDENCYTYPE — Classifies the dependency between planning entities.
  • GETBATCHVALUES — Returns batched resource values for display.
  • GETTANSITIONVALUE — Returns the transition value used when sequencing resource activities.
  • GETDEPTRESINSTCODE — Resolves the department resource instance code.

Tables Accessed

All table access occurs through APPS synonyms. The package reads planning and Gantt-specific data, including:

Usage Notes

MSC_GANTT_UTILS is invoked from the ASCP Gantt chart UI and its supporting server-side packages; the ETRM metadata records two dependent packages referencing it. It is not intended for direct custom invocation. The constants it defines are the reliable integration surface: any code that parses or produces Gantt data streams must honor the separator, view-type, node-type, and row-type values defined here. When extending or troubleshooting Gantt behavior, developers should treat this package as read-only internal infrastructure and rely on the documented planning tables rather than on undocumented implementation details.