Search Results get_entities_tbl

Overview

MRP_GLOBALS is a foundational PL/SQL package within the Oracle E-Business Suite Advanced Supply Chain Planning and Material Requirements Planning modules. It resides in the APPS schema and is classified under the generic API category "OTHER," indicating that it is an internal utility package rather than a public, interface-oriented API. Its principal role is to expose shared global constants, entity definitions, and control-record initialization logic that other planning-related packages reference during their execution. The package is referenced by twenty-seven other packages, underscoring its position as a common dependency across the planning code base in both release 12.1.1 and 12.2.2.

The package header declares a global constant G_PKG_NAME that holds the package name, a convention widely used throughout EBS PL/SQL for consistent error and message logging. The body also declares global operation identifiers, such as G_OPR_NONE and G_OPR_CREATE, which drive the behaviour of control records consumed by downstream APIs.

Key Procedures and Functions

Five documented program units make up the public surface of MRP_GLOBALS:

• GET_ENTITIES_TBL — Populates the shared global table FND_API.g_entity_tbl with the set of entity names known to the planning application. It first clears any existing rows with a DELETE, then inserts entries for entities including ALL, FLOW_SCHEDULE, ASSIGNMENT_SET, ASSIGNMENT, SOURCING_RULE, RECEIVING_ORG, and SHIPPING_ORG. The source comment explicitly states the procedure is used by the generator to avoid overriding or duplicating existing entity constants and carries a "DO NOT REMOVE" warning, signalling that generation tooling depends on its presence.
• INIT_CONTROL_REC — Accepts an operation name and an existing control record, and returns an initialised Control_Rec_Type. It short-circuits when the incoming record is already marked as a controlled operation. For G_OPR_NONE or a null operation it disables defaulting, attribute changes, entity validation, and database writes while propagating process and request metadata. For G_OPR_CREATE it enables default attribute derivation.
• EQUAL — A comparison helper used to determine whether two values or structures are equivalent, supporting the package's internal validation logic.

Tables Accessed

The only documented table reference associated with MRP_GLOBALS is PLITBLM, accessed through an APPS synonym. PLITBLM is the standard EBS PL/SQL integer table used for bulk-processing index collections. Its presence here is consistent with the package's role in managing entity lists and control structures that are passed between planning APIs. The package does not maintain persistent application data of its own; it operates on in-memory PL/SQL collections and the global FND_API entity table.

Usage Notes

MRP_GLOBALS is an internal dependency rather than a user-facing interface. It is not invoked directly from Oracle Forms or from standard concurrent program submission screens. Instead, it is called by the twenty-seven packages that reference it, typically at the start of an API call to resolve which entities are in scope and to establish default control-record behaviour before any business logic executes. Custom developers extending planning functionality may call INIT_CONTROL_REC when building their own wrappers around MRP APIs, and may inspect GET_ENTITIES_TBL output when writing code that must enumerate the planning entity set. Because the procedures are documented as internal utilities, customisations should treat them as read-only dependencies and avoid modifying the entity list, which is regenerated by Oracle tooling. In release 12.1.1 and 12.2.2 the package remains unchanged in its documented form.