Search Results oe_so_pld_package

Overview

OE_SO_PLD_PACKAGE is a PL/SQL package in the APPS schema that supports the Oracle Order Management shipping execution flow, specifically the picking line detail (PLD) processing associated with the Oracle Shipping module. The package name references "SO" (Sales Order), "PLD" (Picking Line Details), and the "WHEN_VALIDATE_RECORD" naming convention typical of Oracle Forms record-level validation triggers, indicating the package is bound to a shipping or picking form used in Release 12.1.1 and 12.2.2. Its documented API classification is OTHER, meaning it is not exposed as a public transactional interface (such as a process order or ship-confirm API), but rather serves as an internal helper package invoked by the user interface layer or by validating business logic during record entry and query operations.

The package is listed as VALID in the APPS schema and depends only on the SYS.STANDARD package, confirming that it relies solely on base PL/SQL constructs and does not directly compile against Oracle EBS database objects at the package level. Table access is resolved at runtime through APPS synonyms, which is why the dependency list shows no direct table dependencies.

Key Procedures and Functions

• GET_SCHEDULE_DB_VALUES — Retrieves schedule-related values from the database for use by the picking line detail form. It supplies the form with the current database values needed to initialize or refresh scheduling attributes on the record, enabling the UI to display accurate order scheduling information alongside picking detail data.
• WHEN_VALIDATE_RECORD — Executes the record-level validation logic applied when a record is validated in the associated Oracle Forms block. This routine enforces business rules on picking line detail records, verifying that the entered or modified data conforms to expected values before the record is committed or processed further.

No parameter signatures are documented in the ETRM metadata; these procedures are intended for internal use by the Shipping forms and are not published as callable API entry points.

Tables Accessed

• SO_PICKING_LINE_DETAILS — Accessed through its APPS synonym. This table stores the detailed picking information for sales order lines, including quantities, locators, and status attributes used during the pick-release and pick-confirmation process. OE_SO_PLD_PACKAGE reads from this table to populate the form and validates records that are ultimately written back to the same structure by the standard shipping flow.

No other tables are documented as referenced by this package, and the package is not referenced by any other documented package, confirming its role as a leaf-level UI support utility.

Usage Notes

OE_SO_PLD_PACKAGE is typically invoked from Oracle Shipping's picking line detail form. The WHEN_VALIDATE_RECORD procedure can be expected to be called from a WHEN-VALIDATE-RECORD trigger on the associated form block, and GET_SCHEDULE_DB_VALUES would be called from trigger or program-unit logic that requires schedule values to be loaded from the database. Because the package is classified as OTHER and references only SO_PICKING_LINE_DETAILS, it should not be treated as a substitute for public shipping APIs in customizations.

When extending or troubleshooting picking line behavior in 12.1.1 or 12.2.2, developers should inspect the form trigger that calls this package rather than invoking it directly from custom code. Any direct invocation risks bypassing form-level validation state. The package is compiled valid in APPS, so its dependencies are intact; however, since no reverse dependencies on other packages are documented, changes to it should be scoped to the Shipping UI functionality it supports and regression-tested against the picking line detail form.