Search Results get_lookup_name

Overview

MSC_X_HZ_PLAN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the horizontal plan (HZ Plan) infrastructure within Oracle Advanced Supply Chain Planning (ASCP), the planning engine delivered under the MSC schema family. Its principal business purpose is to assemble and populate the horizontal plan workbench display: the time-phased grid in which planners view supply, demand, and projected available balance across bucketed planning periods. The package operates against staging and UI-oriented tables that back the Horizontal Plan window rather than the core planning engine tables, which indicates a display-and-presentation role rather than a plan-generation role. The documented API classification is OTHER, reflecting that this is an internal, non-public interface not intended as a supported integration point. Its status is recorded as VALID, and it references the SYS.STANDARD package, which confirms it is a conventional PL/SQL unit compiled against standard Oracle built-ins.

Key Procedures and Functions

Two program units are documented for this package:

• POPULATE_BUCKETED_QUANTITY — Populates bucketed quantity values for the horizontal plan display. This routine aggregates or derives quantities into calendar buckets (for example, days, weeks, or periods) so that the workbench can render time-phased supply and demand totals per bucket. It is the central routine responsible for translating detailed planning data into the bucketed form expected by the Horizontal Plan user interface.
• GET_LOOKUP_NAME — Retrieves a lookup meaning or display name from the Oracle lookup framework, used to translate stored lookup codes into user-facing labels within the horizontal plan output. This supports consistent presentation of enumerated values such as line types or category descriptors on the plan grid.

No parameter signatures are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

The package reads and writes a set of ASCP support tables through APPS synonyms. Those documented include MSC_HZ_UI_HEADERS and MSC_HZ_UI_LINES, which store the header and line definitions of the horizontal plan display; MSC_X_HZ_UI_QUERY_ID_S and MSC_X_HZ_UI_LINE_ID_S, sequences supplying surrogate keys for those records; MSC_FORM_QUERY and MSC_FORM_QUERY_S, which store saved query criteria and their sequence; MSC_SUP_DEM_ENTRIES, holding supply and demand entries consumed by the plan; MSC_ITEM_CATEGORIES for item categorization; and MSC_CALENDAR_DATES, MSC_CAL_WEEK_START_DATES, and MSC_PERIOD_START_DATES, which supply the calendar bucketing structure. MSC_WORKBENCH_DISPLAY_OPTIONS stores user display preferences, while MSC_FORM_QUERY and the lookup table FND_LOOKUP_VALUES provide query and lookup metadata. DUAL and PLITBLM are used for utility purposes, the latter supporting bulk collection operations.

Usage Notes

MSC_X_HZ_PLAN is typically invoked indirectly. Its primary consumer is the Horizontal Plan workbench in the ASCP Planner Workbench, where user actions such as refreshing the plan, changing the bucketing profile, or rerunning a saved query trigger the population routines. The package is referenced by one other APPS package, MSC_X_HZ_UPDATE, which handles the update side of the same UI data set, and it references MSC_X_HZ_PLAN itself in the dependency listing. It is not a public or supported API: because the API classification is OTHER and the package is absent from Oracle's supported interface documentation, customizations, extensions, or direct calls from concurrent programs are not recommended. Any customer code requiring horizontal plan data should instead use the supported ASCP data model and reporting interfaces. Because the package name carries the MSC_X_ prefix common to ASCP internal extensions, it is version-sensitive and may differ between 12.1.1 and 12.2.2 patch levels.