Search Results get_alloc_rule_variables

Overview

APPS.MSC_SCH_WB is an Oracle Advanced Supply Chain Planning (ASCP) and Available-to-Promise (ATP) workbench utility package. Its name reflects its heritage as the "Schedule Workbench" package, and its procedures support the data-retrieval, session-management, and assignment-set logic used by the ATP and allocation workbench screens in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as the defining APPS owner.

The package header carries the RCS identifier $Header: MSCOSCWS.pls 120.4 2007/12/14, indicating that the publicly exposed interface has been stable since the 12.x line. It is classified as an OTHER API in the ETRM repository, and it is referenced by 37 other packages, which confirms its role as a shared internal utility rather than a standalone business API. The documented interface exposes 24 procedures and functions, of which ten are declared in the excerpted source.

Key Procedures and Functions

The following procedures are documented for this package.

• GET_SUPPLY_SOURCES_LOCAL — Populates supply source information for the current planning session, scoped by session ID, source instance, assignment set, and plan.
• GET_SUPPLY_DEMAND_SOURCE_NAME — Resolves the descriptive name of a supply or demand source; this is the procedure users locate when troubleshooting source-name display in the workbench.
• GET_ATP_RESULT — Retrieves the outcome of an ATP calculation for a session, with a commit flag and an option to call directly into Order Management logic.
• CLEANUP_DATA — Removes temporary session data after an ATP or allocation run completes.
• GET_ALLOC_RULE_VARIABLES — Returns allocation-rule variable data used by the allocation workbench.
• GET_LABEL — Returns a display label for a given demand class.
• GET_ATP_RULE_NAME — Resolves the ATP rule name applicable to an item and organization at a given source instance.
• GET_MSC_ASSIGN_SET and GET_ASSIGNMENT_SET — Resolve assignment set identifiers, names, and associated plan information across a database link.
• GET_PERIOD_ATP_STRINGS — Builds the period-level ATP display strings used in the workbench grid.
• CALC_EXCEPTIONS, PIPE_UTILITY, SET_SESSION_ID, GET_MASTER_ORG, DELETE_LINES, EXTEND_OTHER_COLS, COMMIT_DB, GET_PROFILE, MRP_TIMING, ATP_DEBUG — Auxiliary routines for exception calculation, session coordination, master-organization resolution, line maintenance, commit control, profile lookup, and diagnostic tracing.

Tables Accessed

The package reads and writes through APPS synonyms. Planning and ATP setup data is drawn from MRP_ASSIGNMENT_SETS, MSC_ASSIGNMENT_SETS, MTL_ATP_RULES, MSC_DEMAND_CLASSES, and MSC_TRADING_PARTNERS. Temporary work data is held in MRP_ATP_DETAILS_TEMP, MRP_ATP_SCHEDULE_TEMP, and MRP_ATP_SCHEDULE_TEMP_S, which underpin the workbench grid and are purged by CLEANUP_DATA. Calendar and scheduling information comes from MRP_SCHEDULE_DATES, BOM_CAL_WEEK_START_DATES, BOM_PERIOD_START_DATES, MSC_CAL_WEEK_START_DATES, and MSC_PERIOD_START_DATES. Instance and organization context is resolved through MSC_APPS_INSTANCES and MTL_PARAMETERS.

Usage Notes

MSC_SCH_WB is an internal package and is not intended for direct customer invocation. It is called by the ASCP and ATP workbench forms and by dependent concurrent programs during planning runs, and it is invoked indirectly by the 37 packages that reference it. Customizations should not call these procedures directly, since the signature includes OUT NOCOPY parameters and a global error variable (G_ATP_ERROR_CODE) that are managed by the calling form layer. When diagnosing source-name, assignment-set, or ATP-result issues, DBMS_OUTPUT tracing can be enabled through the package's own ATP_DEBUG and MRP_TIMING routines rather than by modifying the code.