Search Results msc_hp_query_s




Overview
Explore in AI Chat

Overview

MSC_HP_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) API. Its name derives from "MSC" (the ASCP schema prefix) and "HP," which refers to the Horizontal Plan feature within the Planner Workbench. The package provides shared helper routines that support the horizontal planning user interface, including bucket and column detail preparation, filter management, query identifier generation, and synchronization of UI data with planning tables.

The package is not intended as a public integration API. It functions as an internal service layer consumed by other ASCP packages and forms. The header comment ($Header: MSCPCUTB.pls 120.0.12020000.3) indicates the file was last revised in November 2012 and is marked noship, meaning it ships with the application but is not a customer-facing object. Note that the user query "dose hp provode storage in IT" appears to be a mistyped question; the package does not provide storage in an "IT" context — it manages horizontal plan display and planning data for ASCP.

Key Procedures and Functions

  • GET_CALENDAR_CODE — Returns the calendar code associated with a given plan. It first checks the profile option MSC_BKT_REFERENCE_CALENDAR; if that value is null, it derives the calendar from the trading partner and plan records.
  • PREPARE_COL_DTLS — Populates the MSC_HP_COL_DTLS table with bucket, week, and period column definitions for a plan. On refresh, it deletes existing rows for the plan before reinserting; otherwise it returns early if rows already exist.
  • PREPARE_FILTERS — Prepares filter criteria used by the horizontal plan UI to restrict or shape the displayed planning data.
  • CREATE_QUERY_ID — Generates a unique query identifier used to track a user's horizontal plan query session.
  • GET_PLAN_ID — Retrieves the plan identifier in the current context, supporting other routines that operate on a specific plan.
  • SYNC_UI_DATA — Synchronizes data between the horizontal plan UI and the underlying planning tables, ensuring edits are reflected consistently.

Tables Accessed

The package reads and writes a range of ASCP planning tables. Calendar and bucket definitions are sourced from MSC_CALENDAR_DATES, MSC_CAL_WEEK_START_DATES, and MSC_PERIOD_START_DATES. Plan metadata is read from MSC_PLANS, MSC_PLAN_BUCKETS, and MSC_TRADING_PARTNERS. UI and query state is managed in MSC_FORM_QUERY, MSC_HP_QUERY_S, MSC_HP_COL_DTLS, and MSC_HP_ROW_DTLS. Update tracking uses MSC_HP_UPDATES, MSC_RES_PLAN_UPDATES, and MSC_RES_PLAN_UPDATES' companion MSC_MATL_PLAN_DATA and MSC_RES_PLAN_DATA. DUAL is used for scalar lookups.

Usage Notes

MSC_HP_UTIL is invoked internally by three other ASCP packages and by the horizontal plan forms. It is not designed to be called directly from custom code; any customization should rely on documented public APIs instead. Because it references MSC_HP_COL_DTLS and performs commits within PREPARE_COL_DTLS, it should be treated as a UI-support utility rather than a batch or integration entry point.