Results for “get_wip_entity_type”

14 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INV_RESERVATION_PVT is the private implementation package for the Oracle E-Business Suite Inventory reservation API layer. In Oracle EBS 12.1.1 and 12.2.2 it encapsulates the core business logic that creates, maintains, queries, and relieves material reservations against the MTL_RESERVATIONS table and associated supply and demand sources. Reservations represent a firm commitment of on-hand inventory or expected receipts to a specific demand — for example a sales order line, a work order component requirement, or an internal requisition — and are central to availability calculation, allocation, and shipping execution.

The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling schema rather than with the definer's rights of APPS. It is classified as a PVT (private) API, meaning it is not published for general customer use. It is the internal workhorse invoked by the public reservation API, INV_RESERVATION_PUB, and by ETRM's own extensibility infrastructure. The header revision, INVRSV3S.pls 120.8, dates from the R12 enhanced reservations code changes, which introduced support for the expanded reservation model used across 12.1.1 and 12.2.2. The package is referenced by 27 other packages, confirming its role as a foundational dependency within the Inventory and Order Management stack.

Key Procedures and Functions

The documented surface exposes 28 procedures and functions. The principal transactional entry points are:

Query and reporting support is provided by QUERY_RESERVATION, which returns all reservations matching user-specified criteria, with options to lock matching records, sort by requirement date, and operate in cancel-order mode; and by QUERY_RESERVATION_OM_HDR_LINE, which retrieves reservations keyed to Order Management header and line identifiers. Data preparation and utility routines include CONVERT_MISSING_TO_NULL, an R12 enhancement that normalizes absent values in the reservation record type; INSERT_RSV_TEMP and PRINT_RSV_REC, used for temporary staging and diagnostic output; and CONVERT_QUANTITY, which performs UOM conversions. Serial number handling is covered by UPDATE_SERIAL_RSV_QUANTITY, IS_SERIAL_NUMBER_RESERVED, and IS_SERIAL_RESERVED. Picking and update-batch processing is served by UPD_RESERVATION_PUP and UPD_RESERVATION_PUP_NEW. Additional routines such as DO_CHECK_FOR_COMMIT and GET_WIP_ENTITY_TYPE provide commit control and work-in-process entity classification.

Tables Accessed

The package operates against a broad set of APPS-synonym tables. The central table is MTL_RESERVATIONS, which stores reservation records and their quantities, demand references, and source allocations. Supporting Inventory tables include MTL_PARAMETERS for organization-level defaults, MTL_SYSTEM_ITEMS for item attributes, MTL_SERIAL_NUMBERS for serial-controlled reservations, and MTL_LOT_UOM_CLASS_CONVERSIONS for lot and unit-of-measure conversion logic.

Demand and supply context is drawn from OE_ORDER_LINES_ALL for sales order demand, MTL_TXN_REQUEST_LINES for internal requisitions and move orders, and WIP_DISCRETE_JOBS, WIP_ENTITIES, and AHL_WORKORDERS for manufacturing and depot repair demand. Warehouse management integration uses WMS_LICENSE_PLATE_NUMBERS and WMS_TXN_CONTEXT_TEMP. Staging and temporary structures include RSV_TEMP and MTL_TRANSACTION_LOTS_TEMP. AHL_SCHEDULE_MATERIALS supports depot repair scheduling requirements.

Usage Notes

INV_RESERVATION_PVT is never called directly from Oracle Forms or concurrent programs. It is invoked internally by INV_RESERVATION_PUB, which is the sanctioned public entry point, and by the 27 dependent packages that constitute the reservation and Order Management integration chain. Typical invocation contexts include the Sales Order form and Order Import when reservations are created or modified against order lines, Shipping Execution during pick confirmation and ship confirmation, Inventory transaction processing during subinventory transfers and issues, and Work in Process component reservation during discrete job release.

Because the package is classified PVT and carries no guaranteed interface contract, customizations should use INV_RESERVATION_PUB rather than calling these procedures directly; signatures may change between releases and patches. The AUTHID CURRENT_USER declaration means callers must hold the requisite privileges on the referenced tables. The presence of WMS and AHL tables indicates that sites implementing Warehouse Management or Depot Repair must apply the corresponding licenses for full functionality. On the query side, QUERY_RESERVATION supports a p_lock_records option suitable for use inside a locking transaction, and a cancel-order mode that orders results by ship-ready flag and detailed quantity for order cancellation processing. All transactional routines follow the standard EBS API return pattern using x_return_status, x_msg_count, and x_msg_data, with x_error_code meaningful only when x_return_status equals fnd_api.g_ret_sts_error.