Search Results get_demtree_dem_values

Overview

MSC_UI_PEG_UTIL is a utility package in the Oracle EBS Advanced Supply Chain Planning (ASCP) module, owned by the APPS schema and classified as a UTIL (utility) object. Its principal business function is to support the user interface rendering of pegging information for planned orders, supplies, and demands. Pegging in ASCP identifies the relationship between a supply and the demand it satisfies, and the ASCP Planner Workbench presents this data through interactive "pegging trees." MSC_UI_PEG_UTIL supplies the underlying data structures, record types, and transformation logic that convert raw pegging rows retrieved from the planning tables into hierarchical node values and display labels consumable by the Java-based Planner Workbench UI and associated forms.

The package was last distributed as MSCPEGUS.pls with header version 120.1, dated 2007/10/01. It is referenced by zero other packages, indicating it is an entry point invoked directly by the UI layer rather than a shared library called from other PL/SQL units.

Key Procedures and Functions

The package exposes six documented procedures and supporting PL/SQL types. Two record/collection types are declared: peg_node_rec_values, which holds a single pegging node (item/organization, pegging identifiers, quantity, pegged quantity, peg date, order name and number, order type, demand and transaction identifiers, item identifier, disposition, and end demand class), and peg_node_rec_values_table, an index-by-binary_integer table of those records.

• GET_SUPTREE_DEM_VALUES — Retrieves the supply tree for a given demand node, returning a table of pegging node records. It accepts the plan identifier, transaction identifier, item identifier, pegging identifier, and instance identifier, with optional parameters controlling trigger node type, supply operation condensing, operation hiding, organization, supply pegging, and item description display.
• GET_LABEL_AND_NODEVALUE — Translates a pegging node's attributes into the display label and node value strings used by the UI tree. It accepts the node's item/organization, quantities, peg date, order details, pegging and demand identifiers, and several display-control parameters, returning the label and value.
• GET_DISPOSITION_ID — Derives the disposition identifier and origination type for a given demand, based on the demand identifier and service request instance identifier.
• GET_DEMTREE_DEM_VALUES — Returns the demand-side tree of pegging records.
• GET_SUPTREE_SUP_VALUES — Returns the supply-side tree of pegging records.
• GET_SUPTREE_DEM_VALUES_REP — The variant the user searched for; it provides the supply tree for a demand node in a reporting variant, returning the same pegging node record collection through an OUT NOCOPY parameter.

Tables Accessed

The package reads pegging and planning data through APPS synonyms: MSC_FULL_PEGGING (the primary source of pegging relationships), MSC_DEMANDS and MSC_SUPPLIES (demand and supply rows), MSC_SYSTEM_ITEMS (item attributes), MSC_BOM_COMPONENTS, MSC_OPERATION_COMPONENTS, MSC_ROUTINGS, MSC_ROUTING_OPERATIONS, and MSC_RESOURCE_REQUIREMENTS (routing, component, and resource detail used to expand supply operation nodes). These are Oracle Advanced Planning foundation tables, and the package is expected to perform read-only access to assemble pegging trees for display.

Usage Notes

MSC_UI_PEG_UTIL is invoked from the ASCP Planner Workbench user interface when a planner opens or expands a pegging tree, and it may also be called from custom extensions, OAF pages, or reports that reproduce Planner Workbench pegging behavior. The _REP suffix on GET_SUPTREE_DEM_VALUES_REP suggests a reporting-oriented entry point, likely used by pegging reports or extract programs rather than the interactive tree. Because the package is not referenced by other packages, custom code should call the procedures directly, supplying the plan, transaction, item, pegging, and instance identifiers required for the desired tree, and honor the defaulted parameters where standard Planner Workbench display behavior is intended.