Search Results mrp_project_parameters_v

Overview

MRP_DEFAULT_FLOW_SCHEDULE is an Oracle EBS PL/SQL package body owned by the APPS schema. It supports the flow scheduling and sequencing functionality used by Oracle Flow Manufacturing and the planning applications. Its principal business role is to derive and persist the default flow schedule attributes for manufactured items, including line and routing associations, calendar assignments, and scheduling parameters required before a flow schedule can be released to the shop floor.

The package is classified as OTHER in the ETRM metadata, indicating that it is not a public, supported API but an internal implementation unit invoked by other EBS components. It is validated and active in Oracle EBS 12.1.1 and 12.2.2. It is referenced by one other database package, confirming that it operates as a subordinate utility rather than an entry point.

Key Procedures and Functions

The documented metadata lists a single procedure or function named ATTRIBUTES. This routine encapsulates the attribute-resolution logic for a default flow schedule. It reads the relevant project and item parameters, resolves the applicable flow line and routing, and applies the derived default attribute values. Because the metadata does not publish a parameter list, the precise signature is not documented here; consumers should treat ATTRIBUTES as internal.

Although only ATTRIBUTES is documented, the dependency list shows the package delegates significant work to sibling units, including MRP_FLOW_SCHEDULE_PVT, MRP_FLOW_SCHEDULE_UTIL, MRP_LINE_SCHEDULE_ALGORITHM, WIP_FLOW_DERIVE, and MRP_CALENDAR. Calendar and time-zone resolution is performed through FLM_TIMEZONE and MRP_CALENDAR. Error handling and message propagation use FND_API, FND_MESSAGE, and FND_MSG_PUB.

Tables Accessed

The package reads and writes the following documented tables and views:

• MRP_PROJECT_PARAMETERS_V — the project-level planning parameter view. This is the object returned by the user's search term and is central to determining project-specific defaults.
• MTL_SYSTEM_ITEMS and MTL_PARAMETERS — item attribute and organization parameter validation.
• BOM_OPERATIONAL_ROUTINGS and BOM_CALENDAR_DATES — routing and workday calendar resolution.
• WIP_ENTITIES_S, WIP_LINES, WIP_PARAMETERS, and WIP_ACCOUNTING_CLASSES — flow line, entity, and accounting class defaults.
• DUAL — scalar evaluations and sequence-free lookups.

Usage Notes

MRP_DEFAULT_FLOW_SCHEDULE is not intended for direct invocation by custom code. It is typically called from flow scheduling forms and concurrent programs in Oracle Flow Manufacturing, and from the internal MRP planning routines that create or refresh flow schedules. The presence of MRP_PROJECT_PARAMETERS_V in its dependency set means project-aware flows (for example, project manufacturing or contract-based scheduling) rely on this package to supply project-scoped defaults.

Because the package is not listed as referenced by any external object and exposes a single documented procedure, developers should avoid binding to it and instead use supported flow scheduling APIs such as MRP_FLOW_SCHEDULE_PVT. Any customization should be validated against both 12.1.1 and 12.2.2, since flow scheduling internals can change between releases.