Search Results single_org




Overview
Explore in AI Chat

Overview

The APPS.MRP_UPDATE_PLAN_OPTIONS_PK package body is a supporting PL/SQL component within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) and Material Requirements Planning (MRP) module. Its principal business function is to persist and refresh planning option settings associated with a specific MRP plan, identified by an organization identifier and a compile designator. The package is classified as an "OTHER" API in the ETRM repository for release 12.2.2, indicating that it is an internal utility rather than a formally published public interface. It operates at the boundary between the user-defined plan configuration and the runtime state of the plan, updating timestamps and option flags that govern how the plan engine explodes, reads, and writes data.

Key Procedures and Functions

Two documented procedures are exposed by this package:

  • MRP_UPDATE_OPTIONS — The primary routine. It reads the organization selection mode from MRP_PLANS and branches on whether the plan is defined for a single organization (SINGLE_ORG) or for multiple organizations. In both branches it stamps the explosion and data start/completion dates, the last update date and user, and carries forward a large set of current-session configuration values such as schedule designator, schedule type, operation schedule type, plan type, cutoff date, part include type, planning and demand time fence flags, reservation handling, safety stock, WIP and PO consideration, snapshot lock, overwrite option, append planned orders, and full/hard pegging levels. The single-org branch additionally commits within the procedure. This routine effectively synchronizes the plan record with the user's current planning parameters.
  • MRP_SET_COMPLETION_TIME — A secondary routine used to set or record the completion timing of the plan update operation, allowing the plan record to reflect when processing finished.

Tables Accessed

Three base tables, accessed through APPS synonyms, are documented:

  • MRP_PLANS — The central repository of plan definitions and option settings. The package performs a SELECT against organization_selection and issues UPDATE statements against multiple option columns, so this is the primary read/write target.
  • MRP_PLAN_ORGANIZATIONS — Stores the association between a plan and the organizations it covers; referenced to support the multi-organization branch of the update logic.
  • MRP_PLAN_SCHEDULES — Holds plan schedule information used when synchronizing schedule designator and schedule type values.

Usage Notes

The package is not directly referenced by any other documented package (referenced-by count is zero in the ETRM metadata), which indicates it is invoked from Oracle Forms or concurrent program logic rather than through a chained API call graph. In the 12.1.1 and 12.2.2 code lines, it is typically triggered when a planner saves or launches a plan from the MRP planning workbench or the Define Plans form, causing the stored plan options to be refreshed with the session values held in the curr_* package globals. The SINGLE_ORG constant is the value compared against organization_selection, which explains why a search for "single_org" surfaces this object. Because the procedure commits internally in the single-org path, callers should not wrap it in an outer transaction that expects atomic rollback. Custom code should treat this package as an internal utility: it is not a supported public API, and direct invocation risks misaligning plan option state with the standard planner workflow.