Search Results display_none

Overview

APPS.MSC_GANTT_PKG is the core PL/SQL package that implements the Gantt chart visualization engine within Oracle Advanced Supply Chain Planning (ASCP), part of the MSC (Manufacturing Supply Chain) application module in Oracle E-Business Suite 12.1.1 and 12.2.2. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, an important consideration for security and synonym resolution through APPS.

Its business purpose is to construct, manipulate, and persist the in-memory query structures that back the interactive Gantt views displayed in the Planner Workbench. These views represent demands, supplies, resources, and supplier requirements across a planning horizon, supporting peg-up and peg-down navigation through the supply chain network. The package also exposes routines for directly editing resource units and hours, adding simulation alternative resources to a view, firming or unfirming plan entries, and moving nodes—capabilities required for the interactive, drag-and-drop behavior typical of graphical planning interfaces.

Key Procedures and Functions

The package exposes twenty-six documented program units. The most significant include:

• ORDERVIEW — Primary entry point that builds an order or demand view for a given query, plan, and filter criteria, returning a node count and honoring peg type and view type.
• UPDATERESUNITSDIRECTLY and UPDATERESHOURSDIRECTLY — Apply manual edits to assigned units/hours or resource hours against a specific node, returning status and output messages.
• ADDSIMUALTRESTOVIEW — Injects simulation alternative resources into an existing Gantt view.
• ADDRESTORESVIEW, ADDSUPPTOSUPPVIEW, and ADDTOORDERSVIEW — Expand views by chaining from a source query into a target query, supporting drill-down.
• RESOURCEVIEW and SUPPLIERVIEW — Construct resource-centric and supplier-centric views.
• SORTRESSUPPVIEW — Orders resource and supplier rows within the current view.
• FIRMUNFIRM, MOVENODE, and MOVEANDFIRM — Combined operations for repositioning plan nodes and committing firming decisions.
• RESCHARGES, SEGMENTPEGGING — Compute resource charges and resolve pegging across segments.
• GETUSERPREF, GETPLANINFO, GETSIMURESOURCE — Retrieve user preferences, plan configuration, and simulation resource data.
• ISPLANGANTTENABLED and ISPLANDSENABLED — Boolean-style checks gating Gantt and data-store functionality.

Tables Accessed

The package reads and writes through APPS synonyms against the MSC planning schema. View construction and pegging rely on MSC_DEMANDS, MSC_SUPPLIES, MSC_FULL_PEGGING, and MSC_OPERATION_NETWORKS. Resource analysis draws on MSC_DEPT_RES_INSTANCES, MSC_RESOURCE_INSTANCES_REQS, MSC_ROUTING_OPERATIONS, and MSC_RESOURCE_REQUIREMENTS. Supplier-side data comes from MSC_SUPPLIER_REQUIREMENTS. Gantt view state is persisted in MSC_GANTT_QUERY, MSC_GANTT_DTL_QUERY, and MSC_FORM_QUERY. Plan context and item metadata are pulled from MSC_PLANS, MSC_PLAN_ORGANIZATIONS, and MSC_SYSTEM_ITEMS. In the ETRM 12.2.2 metadata, MSC_GANTT_PKG is not referenced by any other package, indicating it is invoked directly rather than as a shared library.

Usage Notes

MSC_GANTT_PKG is invoked by the ASCP Planner Workbench Gantt form and associated Java/Forms UI components rather than by concurrent programs. Custom code extending Gantt behavior should call these APIs through the APPS schema, supplying valid query IDs managed by MSC_GANTT_QUERY. Because the package is AUTHID CURRENT_USER, callers must possess direct object privileges or rely on APPS synonyms. The "display_none" search term likely relates to view-type or filter-type flags passed into ORDERVIEW and related routines, which control which node categories are rendered in the Gantt panel.