Search Results p_db_subinventory

Overview

OE_SO_PLD_PACKAGE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as an OTHER API. Its scope is confined to the Order Management module, where it supports the scheduling and reservation logic applied to picking line detail records. The package encapsulates two documented program units, GET_SCHEDULE_DB_VALUES and WHEN_VALIDATE_RECORD, and its internal comments state its central purpose explicitly: to perform record-level validation against a set of business rules governing lot, revision, subinventory, reservation, demand, and scheduling changes on picking lines. The header comment indicates a porting reconstruction dated July 1999, which places the package among the older-tier Order Management utilities that persist largely unchanged across 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_SCHEDULE_DB_VALUES — A procedure that retrieves the current database values of a picking line detail row, identified by its ROWID, and returns them through OUT parameters. The returned attributes correspond to the scheduling-relevant columns of the row: requested quantity, warehouse, schedule date, subinventory, lot number, revision, and demand class code. The procedure initialises an OUT result flag to 'Y', returns silently on NO_DATA_FOUND, and on any other exception delegates to OE_MSG.Internal_Exception before setting the result flag to 'N'.
• WHEN_Validate_Record — A validation procedure that applies the package's documented business rules for a picking line detail record. The rule set prohibits specifying a lot or revision unless a reservation is being placed, requires subinventory and lot when revision control is enabled and a revision is supplied, requires a subinventory when lot control is enabled and a lot is supplied, prohibits undemand, unreserve, or unschedule operations when changing warehouse, schedule date, or demand class, and prohibits undemand, unreserve, unschedule, or ATP inquiry operations when changing quantity, subinventory, lot, or revision.

Tables Accessed

The package operates against a single documented table, SO_PICKING_LINE_DETAILS, accessed through an APPS synonym. GET_SCHEDULE_DB_VALUES reads this table directly by ROWID to obtain the persisted scheduling attributes of an individual picking line detail row, providing the baseline values against which user-entered modifications are compared. The table is the operative detail store for Order Management picking and reservation processing, and the package performs no documented writes to it; its role is confined to retrieval and to validation of prospective changes handled elsewhere in the picking workflow.

Usage Notes

Because the ETRM metadata records no dependent packages and no inbound package references, OE_SO_PLD_PACKAGE is not positioned as a general-purpose shared API. It is instead a narrow order-management utility, consistent with an internal helper invoked from Order Management forms or from supporting PL/SQL during picking line validation. Typical invocation patterns include the Oracle Forms-based sales order and picking windows, where record-level validation is expected on commit or on navigation, and custom extensions that need to compare a user's proposed schedule, reservation, lot, revision, subinventory, or demand class values against the values currently stored in SO_PICKING_LINE_DETAILS. The ROWID-driven retrieval makes GET_SCHEDULE_DB_VALUES unsuitable for set-based processing; it is designed for single-row lookups. The exception handler's dependency on OE_MSG.Internal_Exception means callers should expect error information to be surfaced through the standard Order Management message stack rather than through a raised exception. Release-dependent behaviour is minimal, as the package's column set and rule logic are unchanged between 12.1.1 and 12.2.2.