Results for “mrp_default_assignment_set”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.MRP_DEFAULT_ASSIGNMENT_SET package body is a Oracle EBS Oracle Manufacturing / Materials Resource Planning (MRP) utility package. It is the implementation half of the MRP_Default_Assignment_Set specification and belongs to the assignment set infrastructure used by Oracle Sourcing and MRP rules. Assignment sets determine which sourcing rules and bills of distribution apply to a given planning entity, and each assignment set is identified by a surrogate primary key generated at creation time. The body carries the standard RDBMS header $Header: MRPDASTB.pls 115.2 99/07/16 12:18:46 porting ship $, indicating it is a long-standing, ported PL/SQL unit carried forward through the 11i and Release 12 code lines (12.1.1 and 12.2.2). Its runtime classification in ETRM is OTHER, meaning it is a generic package rather than a public API or a concurrent-program entry point. The package provides a centralized, canonical set of getter routines for assignment set attributes, so that calling modules do not need to embed direct queries against the assignment set table.

Key Procedures and Functions

ETRM documents a single procedure listing, ATTRIBUTES, which in this body resolves to the family of getter functions declared in the package specification. The documented functions are:

• Get_Assignment_Set_Id — returns a NUMBER. It obtains the next primary key for a new assignment set by selecting mrp_assignment_sets_s.nextval from DUAL, and is the only function in the body that performs real work.
• Get_Assignment_Set_Name — returns VARCHAR2. A placeholder that returns NULL.
• Get_Attribute1 through Get_Attribute15 — return VARCHAR2. These are the descriptive flexfield attribute accessors; in this body each is stubbed and returns NULL. The user search term get_attribute7 corresponds directly to Get_Attribute7 in this series, which follows the same nullable-return pattern as its siblings.

No parameter lists are published for any of these units; each is a parameterless function invoked as an expression. The package global g_Assignment_Set_rec (of type MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type) and the Boolean_Tbl_Type associative array type are declared for internal use by other members of the package family.

Tables Accessed

The package reads and writes only two documented database objects, both through APPS synonyms:

• MRP_ASSIGNMENT_SETS_S — the sequence that supplies the assignment set identifier. Referenced exclusively by Get_Assignment_Set_Id.
• DUAL — the single-row pseudo-table used to evaluate the sequence call.

Notably, the body does not query the base assignment set table directly; the attribute getters return NULL rather than reading column values, which confirms that this body functions as a stub/default implementation, with the concrete attribute population handled elsewhere (for example, in the corresponding public API package MRP_Src_Assignment_PUB).

Usage Notes

In a Release 12.1.1 or 12.2.2 environment this package is typically invoked from PL/SQL rather than from a form or concurrent program. Its practical role is limited to identifier generation: a calling module executes MRP_Default_Assignment_Set.Get_Assignment_Set_Id to obtain a unique, sequence-derived key before inserting a new assignment set record. Because the attribute getters and name getter are documented as returning NULL, they should not be relied on to surface stored data; they exist to satisfy the structural contract expected by callers and by the one other package documented as referencing this unit. Developers extending assignment set functionality should treat this package as a low-level utility and route any real attribute retrieval through the sourcing assignment public API instead.