Search Results p_summary

Overview

MSC_MATL_PLAN_PKG is a material planning package in the Oracle Advanced Supply Chain Planning (ASCP) module of Oracle E-Business Suite. The package body belongs to the APPS schema and is classified as an OTHER API in ETRM metadata for release 12.2.2. The header comment indicates a source file of MSCPCMHB.pls and an object version string of 120.0.12020000.3, dated April 2013.

The package supports the interaction layer that displays and manages material plan rows within ASCP planning workbenches. It coordinates query preparation, filter handling, row detail assembly, summary aggregation, and persistence of user modifications. The code relies on global package variables such as g_page_size (default 10) and g_max_fetch_size (capped at 100) to control pagination behavior in the user interface. The package body visible in the metadata demonstrates direct manipulation of msc_form_query and msc_hp_row_dtls tables, and invokes shared utilities including msc_phub_util (logging) and msc_hp_util (filter preparation). The prepare_row_dtls procedure in the source excerpt shows a pattern of clearing prior query state, inserting filter information, counting configured organization, category, and item filters, and then populating row detail records for a given query, plan, and category set.

Key Procedures and Functions

Five procedures are documented for this package:

• INITIALIZE_DATA — Establishes the working context for a material plan display session, preparing query-level structures and filter inputs required by subsequent operations.
• SUMMARIZE_DATA — Aggregates material plan information into summary form, supporting the summarized view of planning data presented to users.
• FETCH_DATA — Retrieves material plan records in page-sized batches, honoring the package pagination variables, and supplies row details to the calling UI.
• SAVE_CHANGES — Persists user modifications made against material plan rows, writing updates back through the relevant detail and change-tracking tables.
• CLOSE_DATA — Releases session resources and clears transient query and row-detail records when a material plan session concludes.

Parameter lists are not asserted here; the procedures operate against the package global variables and the tables documented below.

Tables Accessed

The package reads from and writes to the following tables (via APPS synonyms):

• MSC_FORM_QUERY — Stores query definitions and prepared filter entries keyed by query_id; cleared and repopulated during initialization.
• MSC_HP_ROW_DTLS and MSC_HP_COL_DTLS — Hold row-level and column-level detail records driving the horizontal plan display.
• MSC_HP_UPDATES — Captures pending edits prior to save.
• MSC_MATL_PLAN_DATA — The primary material plan data source.
• MSC_DEMANDS, MSC_DEMANDS_S, MSC_SUPPLIES, MSC_SUPPLIES_S — Demand and supply sources (and their snapshot variants) used to compute plan figures.
• MSC_SAFETY_STOCKS — Safety stock levels included in plan calculations.
• MSC_SYSTEM_ITEMS, MSC_ITEM_CATEGORIES — Item and category definitions used to resolve filters and descriptive attributes.
• MSC_TRADING_PARTNERS — Partner information for sourcing context.

Usage Notes

The package is invoked from ASCP planning workbench forms, including the material plan and horizontal plan windows, where it manages paginated queries, filter application, and edit persistence. It may also be called from custom extensions that need to programmatically initialize and retrieve material plan rows for a specific query_id and plan_id combination. Because it modifies transient tables such as MSC_FORM_QUERY and MSC_HP_ROW_DTLS with deletes and commits, it should be called in a controlled session context. ETRM reports no other packages referencing it, indicating it sits at the top of its call chain rather than serving as a shared lower-layer API.