Search Results mrp_assignment_util




Overview
Explore in AI Chat

Overview

The APPS.MRP_ASSIGNMENT_UTIL package is a utility-tier PL/SQL module within the Oracle E-Business Suite MRP (Material Requirements Planning) schema. It supports the source assignment framework used by Oracle Master Scheduling/MRP and Advanced Supply Chain Planning. Source assignments define the sourcing rules that determine how planned demands are satisfied — for example, whether a supply is sourced from another organization, a supplier, or a specific inventory location. MRP_ASSIGNMENT_UTIL provides the low-level data manipulation and validation services consumed by the higher-level assignment APIs, notably MRP_ASSIGNMENT_PVT, MRP_DEFAULT_ASSIGNMENT, and MRP_SRC_ASSIGNMENT_PUB. Its ETRM classification is UTIL, indicating that it is not itself a public application programming interface but rather an internal helper package invoked by those public APIs. The object holds a VALID status in the APPS schema and is present in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

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

  • CLEAR_DEPENDENT_ATTR — Removes or nullifies attributes that are dependent on another attribute on the assignment record, supporting attribute consistency when a parent attribute is modified.
  • APPLY_ATTRIBUTE_CHANGES — Applies a set of attribute modifications to an assignment record, coordinating the propagation of those changes across dependent fields.
  • COMPLETE_RECORD — Finalizes an assignment record prior to persistence, populating required columns and ensuring the record is complete before it is committed by the calling API.
  • CONVERT_MISS_TO_NULL — Normalizes missing or sentinel values to NULL, so that the assignment tables store a consistent representation of absent data.
  • GET_VALUES — Retrieves the descriptive attribute values for an assignment record, typically to populate a record structure returned to the caller.
  • GET_IDS — Retrieves the identifier values (primary and foreign keys) associated with an assignment record.

These routines are invoked internally by the assignment public APIs rather than directly by end users. Parameter lists are not reproduced here; callers should reference the package specification in the target instance.

Tables Accessed

The ETRM dependency extract for this package does not enumerate specific base tables accessed through APPS synonyms. Based on its role within the source assignment framework, MRP_ASSIGNMENT_UTIL operates on the assignment and sourcing rule entities managed by MRP_SRC_ASSIGNMENT_PUB and MRP_ASSIGNMENT_PVT, which own the underlying DML. The utility package primarily manipulates PL/SQL record structures passed by its callers, performing value normalization through CONVERT_MISS_TO_NULL, key extraction through GET_IDS, and descriptive retrieval through GET_VALUES, before the owning API commits to the assignment tables.

Usage Notes

MRP_ASSIGNMENT_UTIL is an internal utility package and is not intended to be called directly from forms, concurrent programs, or custom extensions. It is referenced by three packages — MRP_ASSIGNMENT_PVT, MRP_DEFAULT_ASSIGNMENT, and MRP_SRC_ASSIGNMENT_PUB — and is also referenced by itself, indicating internal recursion or shared helper logic. It depends in turn on FND_API (the Oracle Application Object Library API foundation) and MRP_SRC_ASSIGNMENT_PUB. Developers extending source assignment functionality should invoke the public API MRP_SRC_ASSIGNMENT_PUB rather than this utility layer, since Oracle may change internal signatures across releases. Customizations that must interact with assignment logic should be validated against the target patch level in both 12.1.1 and 12.2.2, as internal utility behavior is not governed by Oracle's public API compatibility guarantees.