Search Results mrp_default_assignment




Overview
Explore in AI Chat

Overview

The APPS.MRP_DEFAULT_ASSIGNMENT package is a lightweight PL/SQL utility within the Oracle Manufacturing and Planning module of Oracle E-Business Suite. Its documented purpose is to produce a defaulted instance of a source assignment record, expressed through the public record type MRP_Src_Assignment_PUB.Assignment_Rec_Type. Source assignments define the relationship between planning source organizations, assignment sets, and the supply/demand sources consumed by Oracle Master Scheduling/MRP and Oracle Supply Chain Planning. By centralizing the construction of a defaulted assignment record, the package ensures that callers throughout the planning application obtain a consistently initialized structure rather than assembling default values independently.

The ETRM classification of this package is OTHER, indicating that it is not one of the officially published, supported public APIs such as those in the MRP_Src_Assignment_PUB family. It is better understood as an internal helper used by the planning code base to seed assignment records before they are validated, inserted, or passed to the public assignment API. The single documented entry point, Attributes, reflects this narrow, single-purpose design.

Key Procedures and Functions

The package exposes one documented procedure, Attributes. Its role is to populate an assignment record with default attribute values. Callers pass an existing assignment record (or rely on the declared default of MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_REC, a standard "missing" record constant used throughout the planning public APIs) together with an iteration counter, and receive the defaulted record through an OUT NOCOPY parameter. The G_MISS_ASSIGNMENT_REC default allows a caller to invoke the procedure without supplying an input record, obtaining a fully defaulted structure. The NOCOPY hint, annotated in the package source, avoids the overhead of copying the record on return — a performance consideration for a routine that may be invoked repeatedly during bulk assignment processing.

Tables Accessed

The metadata documents two tables referenced through APPS synonyms: MRP_SR_ASSIGNMENTS_S and DUAL. MRP_SR_ASSIGNMENTS_S is the base table for source assignment definitions. The procedure reads from it to determine existing default values or to validate the defaulting logic against currently defined assignments. DUAL is used for single-row scalar evaluation — typically to compute a sequence-derived or expression-based default value within a SELECT ... INTO statement. No direct writes to MRP_SR_ASSIGNMENTS_S are documented; the procedure appears to be read-only, producing an in-memory record rather than persisting data.

Usage Notes

Because the package is classified as OTHER and marked noship in its header, it is an internal component rather than a supported public interface. It is referenced by one other package in the ETRM inventory, indicating limited, targeted reuse within the planning schema. Typical invocation occurs from Oracle Forms-based planning setup windows, concurrent programs that mass-create or refresh source assignments, and internal package logic that needs a pre-seeded assignment record before invoking MRP_Src_Assignment_PUB validation and write routines.

For Oracle EBS 12.1.1 and 12.2.2, the package source is essentially unchanged (version 120.1). Custom code should not depend directly on this package; supported integration should use the public MRP_Src_Assignment_PUB APIs instead. Where custom extensions must default assignment records consistently with standard behavior, the package may be called defensively, but Oracle does not warrant its signature across patches or upgrades.