Search Results mrp_sourcing_rule_pub




Overview
Explore in AI Chat

Overview

APPS.MRP_SHIPPING_ORG_UTIL is a utility package in the Oracle E-Business Suite Oracle Planning (MRP) module that supports the maintenance of shipping organization records used by the sourcing rules framework. Shipping organization records define the source organizations from which a given organization may receive material, together with associated shipping methods, secondary inventory, allocation percentages, and descriptive attribute columns. This package provides the low-level attribute-handling logic that a public API cannot reasonably expose to callers, allowing the sourcing rule public API layer to keep dependent columns consistent whenever a shipping organization row is inserted, updated, or validated.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, so callers must themselves hold the necessary object privileges. It is classified in the ETRM repository as a UTIL package rather than a public API, confirming that it is intended for internal consumption by the sourcing rule infrastructure and by carefully written custom extensions.

Key Procedures and Functions

The package header exposes the following documented procedures and functions. Parameter lists are intentionally omitted; only purpose is described.

  • CLEAR_DEPENDENT_ATTR — Resets attribute columns that become invalid or redundant when a controlling field on a shipping organization record changes. The signature accepts an attribute identifier and the current and prior shipping organization record structures, so the caller can compare old and new values and blank out only the dependent columns that no longer apply.
  • APPLY_ATTRIBUTE_CHANGES — Applies the net set of attribute modifications to a shipping organization record after dependent attributes have been cleared, producing a coherent record image suitable for persistence.
  • COMPLETE_RECORD — Populates default and mandatory values on a partially specified shipping organization record, returning a complete record that satisfies the structural expectations of the sourcing rule API.
  • CONVERT_MISS_TO_NULL — Translates the FND_API.G_MISS_NUM sentinel values used in the API record types into SQL NULL, so that unchanged attributes are not overwritten during updates.
  • GET_VALUES — Retrieves the stored attribute values for a shipping organization record, typically by primary key or unique identifier, and returns them in the API record structure.
  • GET_IDS — Resolves the surrogate identifiers associated with a shipping organization record, supporting the foreign key relationships required by the sourcing rule tables.

Tables Accessed

The ETRM metadata documents no table references through APPS synonyms for this package, which is consistent with a utility whose structure is dominated by attribute constants and record manipulation. The g_ship_method constant, value 31, is one of the attribute index constants declared at the top of the package, alongside allocation percent, secondary inventory, source organization, source type, vendor, and vendor site identifiers. These constants map the positional attribute columns of the underlying shipping organization entity to meaningful names. In practice the package operates against the shipping organization attribute table maintained by the sourcing rule schema, reading and writing attribute values keyed by the identifiers resolved through GET_IDS.

Usage Notes

MRP_SHIPPING_ORG_UTIL is referenced by three other packages in the ETRM repository, all of which are part of the sourcing rule maintenance stack. It is therefore invoked indirectly whenever a user or concurrent program creates or changes a shipping organization record through the supported sourcing rule API. Direct invocation from custom code is possible but not recommended, because the package carries no compatibility guarantee and its attribute constants are positional. A developer searching for g_ship_method is most likely tracing how the shipping method column of a sourcing rule is populated or validated; the correct entry point remains the public sourcing rule API, with this utility package handling the dependent attribute bookkeeping behind it.