Results for “inv_mgd_pos_organization_mdtr”

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

Overview

The APPS.INV_MGD_POS_ORGANIZATION_MDTR package is a PL/SQL mediator component within the Oracle E-Business Suite Inventory Management module. Its name and header comments identify it as the "Organization Mediator" for the Inventory Position View and Export feature set, a family of utilities that presents on-hand inventory position data and exports it for reporting or downstream consumption. The package was created in September 2000 by Oracle and carries a source header revision consistent with early Application Release 11i lineage that has been carried forward, largely unchanged, into the 12.1.1 and 12.2.2 releases.

The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. It is classified in the ETRM metadata as an OTHER API type, indicating it is an internal, supporting utility rather than a public, documented business API. The "MGD POS" naming convention ties it to the Inventory Position (POS) subsystem, and "MDTR" denotes its role as a mediator — a coordinating layer that resolves organization context on behalf of higher-level inventory position and export routines.

In practice, the package exists to translate a requested organization hierarchy and hierarchy level into a concrete list of organization identifiers. This separation of concerns allows the Inventory Position View and Export code to remain independent of the mechanics of hierarchy traversal.

Key Procedures and Functions

The ETRM metadata documents a single public procedure in this package: BUILD_ORGANIZATION_LIST.

• BUILD_ORGANIZATION_LIST — Builds the list of organizations that belong to a specified hierarchy level. The header documentation describes it as a public procedure that accepts a hierarchy identifier and a hierarchy level identifier, and returns a collection of organizations through an output parameter typed as INV_MGD_POS_UTIL.organization_tbl_type. The documented post-condition is that the returned organization table is not empty. Optional message-list parameters support the standard Oracle API error-handling convention, permitting callers to reset the FND message list and to retrieve return status, message count, and message text.

No other procedures or functions are documented for this package. Callers should treat BUILD_ORGANIZATION_LIST as the sole supported entry point.

Tables Accessed

The ETRM metadata lists two tables referenced through APPS synonyms:

• MTL_PARAMETERS — The Inventory organization parameters table. It supplies organization-level configuration and validation context, allowing the mediator to confirm that candidate organizations are properly defined inventory organizations before they are added to the returned collection.
• PLITBLM — A general-purpose numeric and character table used internally by Oracle EBS as a temporary storage and working area. The mediator uses it to stage or expand hierarchy membership data while assembling the organization list.

The package is also reported as being referenced by one other package, confirming its role as a shared dependency for the broader Inventory Position View and Export code.

Usage Notes

This package is an internal utility and is not intended for direct invocation by end users or customer extensions. It is typically called programmatically by the companion Inventory Position View and Export packages, which supply the hierarchy and level identifiers and then consume the returned organization collection to scope subsequent inventory position queries and export operations. Because the procedure is an internal mediator, it may be invoked from concurrent program logic, from Oracle Forms-based inquiry screens that drive the inventory position view, or from other PL/SQL utilities within the same feature set.

Developers integrating with this package must exercise caution: the signature is subject to change between releases, the collection type belongs to INV_MGD_POS_UTIL, and the AUTHID CURRENT_USER declaration means the invoking user requires direct privileges on the underlying tables. Where hierarchy-aware organization resolution is required in custom code, the supported Oracle organization hierarchy APIs are the recommended alternative.