Search Results inv_reservation_validate_pvt




Overview
Explore in AI Chat

Overview

INV_RESERVATION_VALIDATE_PVT is a private PL/SQL package in the Oracle E-Business Suite Inventory (INV) application. It provides the internal validation layer used by the reservations APIs to verify that a requested reservation action is internally consistent before the reservation is written to the material transaction and reservation tables. The package is classified as PVT (private), which means it is not a public API; it is called by other packages in the reservation stack and is not intended for direct customer invocation.

The package validates the input parameters and the serial number information associated with a reservation request. Its central purpose is to confirm that every reservation record — both the original record (p_orig_rsv_rec) and the target record (p_to_rsv_rec) — references a valid organization, item, demand source, supply source, and quantity, and that the reservation action requested is one of the supported action types. As the excerpt header indicates, the reservation action must be CREATE, UPDATE, TRANSFER, or DELETE for validation to proceed. The package was introduced with the R12 enhanced reservations code changes and is identified in the header as INVRSV1S.pls.

Key Procedures and Functions

  • VALIDATE_INPUT_PARAMETERS — The primary validation entry point. It evaluates whether the supplied reservation request is valid. For a CREATE, UPDATE, TRANSFER, or DELETE action it applies the organization, item, demand source, supply source, and quantity validations against the original reservation record. For UPDATE and TRANSFER actions it additionally applies the same validations against the target reservation record. The procedure returns a return status and a series of cache index output parameters (orig/to item, org, demand, supply, and substitute indexes) that the calling package uses to avoid repeated lookups. It also carries a substitute flag parameter added under Bug 6044651.
  • VALIDATE_SERIALS — Validates the supply and demand sources for serial-controlled reservation lines. It returns an error if the supply source is not INV or if the demand source is not CMRO, SO, or another permitted source. This procedure forms part of the R12 enhanced reservations changes introduced to support serial number processing.

Tables Accessed

The package reads reference and transactional data through APPS synonyms. Validation of organizations and items relies on MTL_PARAMETERS, MTL_SYSTEM_ITEMS, MTL_SECONDARY_INVENTORIES, and MTL_ITEM_LOCATIONS. Serial-related validation uses MTL_SERIAL_NUMBERS and MTL_LOT_NUMBERS. Demand and supply source validation touches OE_ORDER_LINES_ALL, OE_DROP_SHIP_SOURCES, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL, allowing internal order, sales order, drop-ship, and purchasing demand to be recognized. FND_ID_FLEX_STRUCTURES is used for key flexfield structure validation, and PLITBLM supports descriptive flexfield handling. The tables are used for read/validation purposes; the package does not itself create or update reservation records.

Usage Notes

Because the package is private, it is normally invoked indirectly. The reservations API INV_RESERVATION_PUB and the enhanced reservation modules call the private validation package before performing the actual reservation, update, transfer, or deletion. The validate_quantity reference that prompts this search appears in the package header comments as one of the checks applied to both the original and target reservation records; the quantity check confirms that the reservation quantity is present and valid for the action requested.

Custom code should not call INV_RESERVATION_VALIDATE_PVT directly. Instead, callers should use the public reservation APIs, which enforce the same rules and manage the validation cache indexes internally. The package is referenced by one other package in the INV reservation stack, reinforcing that its role is an internal helper rather than an integration point.