Search Results msc_select_all_for_release_pub




Overview
Explore in AI Chat

Overview

MSC_SELECT_ALL_FOR_RELEASE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Advanced Supply Chain Planning (ASCP) module and supports the plan release process — the phase in which planned orders, supplies, and recommendations held in the MSC (planning) tables are transferred to their execution systems, such as Work in Process, Purchasing, and Discrete Manufacturing. The suffix "_PUB" classifies the package as a public API, indicating it is designed to be called by other application code rather than used only internally. Its documented status is VALID, and it is referenced by MSC_RELEASE_PK, MSC_REL_PLAN_PUB, and by itself, confirming its role as a building block within the broader release infrastructure.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents six procedures and functions within this package:

  • UPDATE_IMPLEMENT_ATTRIB — Updates the implement attribute that governs whether a planned item or order is eligible for transfer to the execution system during release.
  • GET_ALTERNATE_BOM — Retrieves alternate bill of material information for an item so the correct BOM structure accompanies the released entity.
  • GET_ALTERNATE_RTG — Retrieves alternate routing information, the routing counterpart to the alternate BOM lookup, ensuring released jobs carry the correct process definition.
  • GET_WIP_JOB_PREFIX — Returns the job prefix used when generating Work in Process job names for released planned orders, supporting site-level naming conventions.
  • CHILD_SUPPLIES_ONHAND — Evaluates child component supplies and on-hand quantities, typically to determine whether dependent demand can be satisfied from existing inventory before release.
  • GET_IMPLEMENT_AS — Returns the "implement as" disposition for a planned order, indicating the target execution entity (for example, a WIP job or a purchase requisition) into which the plan element should be converted.

Tables Accessed

The package reads and writes the core ASCP planning tables through APPS synonyms:

Usage Notes

MSC_SELECT_ALL_FOR_RELEASE_PUB is invoked indirectly through the planning release flow rather than directly by end users. Its documented callers are MSC_RELEASE_PK, MSC_REL_PLAN_PUB, and itself, so it is primarily reached when a planner runs the release of a plan or plan segment from the ASCP workbench or through the plan release concurrent program. It may also be called from custom PL/SQL that extends the release process, provided the calling code respects the public API conventions and the AMS/ASCP setup. Because the package performs selection, attribute evaluation, and retrieval of manufacturing structures rather than the final write to execution tables, customizations should treat it as a supporting utility and avoid modifying its behavior directly; extensions should instead wrap or follow the standard MSC_RELEASE_PK entry points.