Results for “attribute_catego”

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

Overview

MRP_Receiving_Org_Handlers is an Oracle EBS PL/SQL package owned by the APPS schema that functions as the data-access and persistence layer for receiving organization sourcing rules used by Oracle Material Requirements Planning (MRP) and the broader Advanced Supply Chain Planning (ASCP) product family. The package is classified as an OTHER API in the ETRM 12.2.2 metadata, meaning it is an internal handler rather than a formally published public interface, yet it is referenced by three other packages within the application code base. Its central purpose is to implement the standard CRUD (create, read, update, delete) and locking operations against the receiving-organization records that define which inventory organizations may act as receiving destinations for a given sourcing rule. Because it uses the AUTHID CURRENT_USER clause, the package executes with the privileges of the calling session, and it depends on the shared record and table types declared in MRP_Sourcing_Rule_PUB for its parameter and return signatures.

Key Procedures and Functions

The package exposes eight documented program units. INSERT_ROW creates a new receiving-organization record for a sourcing rule. UPDATE_ROW modifies an existing receiving-organization record. DELETE_ROW removes a receiving-organization record identified by its unique sourcing receipt identifier. LOCK_ROW provides concurrency control by attempting to lock the underlying row and returning the locked record along with a return status, allowing callers to detect contention before applying changes. QUERY_ROW is a function that retrieves a single receiving-organization record by sourcing receipt identifier. QUERY_ENTITY retrieves both the base record and its associated validation record for a single receiving-organization entry. QUERY_ROWS is a function returning a collection of receiving-organization records, filtered optionally by sourcing receipt identifier or sourcing rule identifier. QUERY_ENTITIES performs the equivalent collection retrieval while returning both the base entity table and the validation entity table.

Tables Accessed

The ETRM metadata documents three tables accessed through APPS synonyms. MRP_SR_RECEIPT_ORG stores the primary receiving-organization records for sourcing rules, including the sourcing receipt identifier that acts as the principal key for the single-row operations. MRP_SR_SOURCE_ORG holds the sourcing organization associations that link sourcing rules to their source and destination organizations. PLITBLM is an Oracle Application Object Library utility table used internally by the PL/SQL table-handling APIs, particularly for session or collection management support during collection-based query operations. All write operations target MRP_SR_RECEIPT_ORG; the companion tables provide the relational context required for validation and query joins.

Usage Notes

This package is invoked indirectly. The ETRM metadata records three dependent packages, which typically include the public MRP_Sourcing_Rule_PUB API and form or concurrent-processing layers that delegate persistence to this handler. Typical consumers are the Sourcing Rules setup forms in Oracle Advanced Supply Chain Planning, concurrent programs that import or maintain sourcing rules, and custom extensions that need to maintain receiving-organization data. Because the package is not classified as a public API, custom code should prefer the published MRP_Sourcing_Rule_PUB interfaces and treat MRP_Receiving_Org_Handlers as an internal implementation layer. Direct invocation is nonetheless supported for bulk data fixes provided callers supply the MRP_Sourcing_Rule_PUB record and table types and populate the PL/SQL table collections correctly. The metadata does not associate this object with the Chennai-based vendor query that produced the search; the package is purely an EBS supply-chain data handler.