Search Results process_sourcing_rule

Overview

The APPS.MRP_SOURCING_RULE_PVT package is a private PL/SQL API within Oracle E-Business Suite that supports the definition, maintenance, and validation of sourcing rules used by Oracle Planning products, including Material Requirements Planning (MRP) and Advanced Supply Chain Planning (ASCP). A sourcing rule is a planning directive that determines the source from which an item is supplied to a given organization, including whether the item is transferred between organizations or procured externally. This package acts as the private implementation layer consumed by the public API MRP_SOURCING_RULE_PUB, which controls the transactional interface exposed to callers. The package is declared with AUTHID CURRENT_USER and references global constants and record types defined in MRP_GLOBALS and MRP_SOURCING_RULE_PUB, providing standardized control records, validation levels, and generic error-handling semantics consistent with the Oracle Application Object Library (FND_API) framework. Because it is classified as a private (PVT) API, it should not be called directly by external integrations or custom code; the public wrapper is the supported entry point.

Key Procedures and Functions

• PROCESS_SOURCING_RULE — The primary worker procedure for creating, updating, or otherwise processing a sourcing rule and its associated assignment records. It received the p_Sourcing_Rule_rec and its previous version (p_old_Sourcing_Rule_rec), together with receiving organization and shipping organization collections and their prior versions. It returned the processed sourcing rule and receiving/shipping organization collections via OUT parameters. Standard FND_API parameters (p_api_version_number, p_init_msg_list, p_commit, p_validation_level, p_control_rec, x_return_status, x_msg_count, x_msg_data) govern initialization, validation, commit behavior, and message reporting.
• LOCK_SOURCING_RULE — Provides pessimistic locking of an existing sourcing rule prior to modification, ensuring serialized access and preventing concurrent updates from corrupting the sourcing rule definition during multi-step processing.
• GET_SOURCING_RULE — Retrieves a sourcing rule and its dependent organization assignment information, populating the record and table structures required for display, validation, or subsequent processing.

Tables Accessed

• MRP_SOURCING_RULES — The primary table storing the header and definition attributes of each sourcing rule; the package inserts, updates, or queries this entity.
• MRP_SR_RECEIPT_ORG — Stores receiving organization details associated with a sourcing rule assignment, maintained alongside the rule definition.
• MRP_SR_SOURCE_ORG — Stores shipping (source) organization details for the sourcing rule assignment, managed in parallel with receiving organization records.
• MTL_INTERORG_PARAMETERS — Validates inter-organization transfer configuration when sourcing rules reference internal transfers between organizations.
• PLITBLM — An Oracle Applications temporary/global temporary utility table used during in-memory record processing and validation.

Usage Notes

This private package is invoked indirectly through the public API MRP_SOURCING_RULE_PUB, which is itself referenced by one other documented package. It is typically triggered from the Sourcing Rules and Bills of Distribution forms in Oracle Planning, from concurrent programs that load or maintain sourcing data, and from internal planning engine routines that require rule definition or retrieval. In Oracle EBS 12.1.1 and 12.2.2 the package resides under the APPS schema with the standard $Header version marker (MRPVSRLS.pls 115.1). Custom code should always call the public wrapper rather than the private procedures, since the private signatures and record structures may change without notice across patches or upgrades.