Search Results copy_item_info_rec

Overview

MSC_ATP_SUBST is an Oracle Advanced Supply Chain Planning (ASCP) PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. Its business purpose is to support Available-to-Promise (ATP) processing in a multi-level, multi-organization supply chain where item substitution and pegging relationships must be evaluated. The package combines ATP availability checking with substitute-item logic, resolving whether a demand can be satisfied by a substitute item before falling back to the originally requested item. It also maintains the pegging relationships that link supplies to demands across parent and child organizations, which is essential for accurate ATP results in a distributed planning environment.

The package defines the record type ATP_Org_Info_Rec_Typ, a composite structure that carries organization and item context through ATP calculations. Fields such as Demand_Pegging_id, Supply_pegging_id, and PO_pegging_id reflect the package's emphasis on tracking exactly which supply satisfies which demand, while fields such as atp_flag, atp_comp_flag, steal_qty, and Quantity_from_children support the availability computations performed against substitute items.

Key Procedures and Functions

The documented procedures and functions (10 total) serve the following purposes:

• ATP_CHECK_SUBST — Performs the ATP availability check in a substitution context, determining whether demand can be met by available supply, potentially through substitute items.
• GET_ITEM_SUBSTITUTES — Retrieves the substitute items defined for a given item, forming the candidate set used during substitution-based ATP.
• ADD_PEGGING — Establishes pegging records that associate a demand with the supply intended to satisfy it. This is the procedure most directly relevant to the user search term "add_pegging," as it creates and maintains these links.
• ADD_MAT_DEMAND — Adds material demand records to the planning demand tables so they are visible to ATP and pegging logic.
• UPDATE_DEMAND — Modifies existing demand records, typically to reflect changed quantities, dates, or substitution outcomes.
• DELETE_DEMAND_SUBST — Removes demand records associated with substitution processing.
• EXTEND_ORG_AVAIL_INFO_REC — Extends the organization availability information record to accommodate additional ATP data.
• EXTEND_ITEM_INFO_REC_TYP — Extends the item information record type used in ATP computations.
• COPY_ITEM_INFO_REC — Copies item information records for reuse within ATP processing.
• DETAILS_OUTPUT — Produces diagnostic or detailed output from the ATP and substitution processing.

Tables Accessed

The package reads and writes several ASCP tables through APPS synonyms. MSC_ITEM_SUBSTITUTES supplies the substitute-item definitions used by GET_ITEM_SUBSTITUTES and ATP_CHECK_SUBST. MSC_DEMANDS and MSC_ALLOC_DEMANDS hold demand records that are added, updated, or deleted by ADD_MAT_DEMAND, UPDATE_DEMAND, and DELETE_DEMAND_SUBST. MSC_FULL_PEGGING_S is the pegging source table central to ADD_PEGGING. MRP_ATP_DETAILS_TEMP stores intermediate ATP detail results, while MSC_PLANS, MSC_SYSTEM_ITEMS, MSC_TP_ID_LID, and MSC_TP_SITE_ID_LID provide plan, item, and trading-partner identifier context. DUAL and PLITBLM are used as utility references.

Usage Notes

MSC_ATP_SUBST is an internal ASCP engine package rather than a public API. It is referenced by one other package and is typically invoked indirectly during ATP and supply chain planning runs, including multi-level ATP and item substitution scenarios, rather than called directly from Oracle Forms or standard concurrent programs. Custom extensions should treat it as a dependent internal component and avoid direct invocation, since its behavior is tied to the planning engine's internal data structures and pegging lifecycle.