Search Results g_entity_shipping_org

Overview

MRP_GLOBALS is a shared constants and control-definition package within the Oracle EBS Advanced Supply Chain Planning / MRP schema (APPS). It does not perform planning calculations itself; instead it centralizes the literal identifiers, API operation flags, record types, and control structures used by the family of MRP "JVC" controller APIs that manage planning entities such as flow schedules, assignment sets, assignments, sourcing rules, receiving organizations, and shipping organizations. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as OTHER, is owned by APPS, and is referenced by twenty-seven other packages, confirming its role as a foundational dependency rather than an end-user-facing program. The presence of the constant G_ENTITY_SHIPPING_ORG (value 'SHIPPING_ORG') is directly relevant to users searching on "shipping_org"; this constant is the canonical entity name consumed by the MRP controllers when validating, creating, updating, or deleting shipping-organization planning data.

Key Procedures and Functions

The ETRM metadata documents five callable units, of which three are exposed as PL/SQL procedures or functions:

• GET_ENTITIES_TBL — Populates the internal table of product entity constants. The source header explicitly notes this is used by the generator to avoid overriding or duplicating existing entity constants, and carries the warning "DO NOT MODIFY." It exists to keep the generated entity list synchronized across the package and its consumers.
• INIT_CONTROL_REC — Initializes a control record of type CONTROL_REC_TYPE. This record governs API behavior through flags such as controlled_operation, default_attributes, change_attributes, validate_entity, write_to_db, process, clear_api_cache, and clear_api_requests. Initialization ensures callers receive a consistent, safe default state before invoking controller logic.
• EQUAL — A comparison utility used to evaluate equivalence between control or request records, supporting the API layer's decision logic (for example, deciding whether an operation should be treated as a no-op or whether cached state matches the incoming request).

The package also declares G_MISS_CONTROL_REC and the REQUEST_REC_TY / INDEX_TBL_TYPE types, along with operation constants G_OPR_CREATE, G_OPR_UPDATE, G_OPR_DELETE, G_OPR_LOCK, and G_OPR_NONE.

Tables Accessed

The documented table reference is PLITBLM (accessed via an APPS synonym). This is the standard EBS PL/SQL table used to hold iteration state for table-driven defaulting logic. It is consistent with the declared constant G_MAX_DEF_ITERATIONS := 5, which caps the number of defaulting passes performed by dependent controllers. MRP_GLOBALS itself does not maintain persistent planning data; entity persistence occurs in the calling controllers, which reference this package for constants and control semantics.

Usage Notes

MRP_GLOBALS is an internal support package and is not intended for direct invocation from forms, concurrent programs, or customer extensions. It is called by the twenty-seven dependent MRP packages that implement the JVC controller pattern, which in turn may be invoked from Oracle Planning forms, concurrent managers, or public APIs. Custom code should not modify the entity constants or call GET_ENTITIES_TBL directly, since the source explicitly marks this procedure as generator-owned and non-modifiable. Where custom logic must reference a planning entity by name, the safest approach is to consume the same constants used by the supported controllers (for example, G_ENTITY_SHIPPING_ORG) rather than hard-coding literal strings, preserving forward compatibility across 12.1.1 and 12.2.2.