Search Results set_parameter_work_order_wf

Overview

GME_RESERVE_CONC is a Process Manufacturing (OPM) reservation utility package owned by APPS and classified as OTHER within the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. The package encapsulates the logic needed to determine whether order lines qualify for inventory reservation and to perform the actual reservation against inventory, with additional hooks that support workflow-driven reservation parameters. It is a concurrent-oriented wrapper: the naming convention (CONC) and the presence of global program context variables such as G_SET_ID, G_PROGRAM_APPLICATION_ID, G_PROGRAM_ID, and G_RESERVATION_MODE indicate the package is designed to run as part of a scheduled or request-driven process rather than as an interactive form API. The package is classified as a private implementation body with no dependent packages reporting inbound references, meaning it is invoked directly by concurrent program definitions, request sets, or workflow activities rather than by other PL/SQL packages. It operates against OE Order Management line records, consuming the OE_ORDER_PUB.line_rec_type structure, which ties it to the order line reservation model used by Oracle Order Management in the EBS 12.1.1 / 12.2.2 code line.

Key Procedures and Functions

• RESERVE_ELIGIBLE — Evaluates a given order line record to determine whether that line requires reservation. It inspects line state attributes such as the open and shipped flags and, where applicable, the reservation time fence setting, and returns an API-style status. A documented internal comment describes it as a clone of a standard Reserve_Eligible routine that differs by not consulting existing reservations, making it suitable for scenarios where eligibility is judged independently of current reservation records.
• MAKE_TO_ORDER — Supports make-to-order (MTO) processing logic within the reservation flow, distinguishing MTO lines from standard-stock lines so that reservation behavior aligns with the line's sourcing model.
• SET_PARAMETER_FOR_WF — Establishes the parameter context subsequently consumed by the workflow-driven reservation path. It is the procedure most closely associated with the search term set_parameter_work_order_wf, which appears to be a related workflow activity or parameter-setting context referenced in OPM reservation configurations.

Tables Accessed

• MTL_RESERVATIONS — The core inventory reservation table. The package reads and writes reservation rows to create, evaluate, or reconcile reservations against order lines.
• WSH_DELIVERY_DETAILS — Delivery detail records are consulted to associate order lines with shipping/delivery structure, which affects whether and how reservation should proceed.
• DUAL — Used for standard single-row PL/SQL and SQL expressions, such as profile or parameter validation and constant retrieval.
• DBMS_SQL — Indicates dynamic SQL is employed, typically for flexible query construction when filtering reservation candidates or resolving parameters at runtime.

Usage Notes

GME_RESERVE_CONC is generally invoked from a concurrent program registered against the Process Manufacturing application, or from workflow components that drive reservation processing for order lines. Its global variables (G_SET_ID, G_PROGRAM_ID, G_RESERVATION_MODE) are populated from the concurrent request context before the reservation logic executes. Customizations should not call it directly unless the standard concurrent program invocation pattern is replicated, because the package depends on FND profile values such as AFLOG_LEVEL for debug control and on OE debug utilities for trace output. The RESERVE_ELIGIBLE variant that ignores existing reservations is useful for reprocessing scenarios, while SET_PARAMETER_FOR_WF should be treated as the entry point when the reservation is being orchestrated from a workflow or work-order workflow parameter setup. Because the package is not referenced by other packages, any functional extension is best implemented through the standard concurrent program or workflow configuration rather than through package-level modification.