Search Results get_sync_line_details

Overview

WSH_PR_PICKING_ROWS is a PL/SQL package in the APPS schema that supports the Oracle Shipping Execution (WSH) picking and release process. Its declared purpose is to manage the row sets that the shipping user interface and pick-release workflows display and process. Specifically, the package opens and fetches cursors for three categories of order lines: unreleased lines, backordered lines, and non-shippable lines. These cursors feed the structured record type relRecTyp, which carries line, header, organization, inventory item, shipment, delivery, departure, and container identifiers together with scheduling, quantity, and priority attributes. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking session rather than those of its owner. This makes it a tightly coupled, internal shipping component rather than a general-purpose public API.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions. Note that parameter lists are not reproduced here; only documented purposes are described.

• INIT — Initializes the package state, cursor handles, and working structures prior to fetching line rows.
• GET_SIZE — Returns the size or count associated with the package's internal collections or cursor row sets. This is the object the user searched for under the term "get_size".
• GET_LINE_DETAILS — Retrieves detail attributes for unreleased shipping lines into the package record structure.
• SET_SYNC_LINE — Sets or marks a line for synchronization processing within the picking row set.
• GET_SYNC_LINE_DETAILS — Returns details of lines flagged for synchronization, complementing SET_SYNC_LINE.
• SET_REQUEST_LINES — Establishes the set of request lines the package will process for the current invocation.
• GET_NON_SHIP_LINES — Fetches lines that cannot be shipped, supporting the non-shippable cursor referenced in the header comments.
• CLOSE_CURSORS — Closes open cursors and releases associated resources when processing completes.

Tables Accessed

The ETRM metadata lists only two referenced dependencies, both accessed through APPS synonyms:

• DBMS_SQL — The Oracle supplied dynamic SQL package, indicating that the package opens and parses cursors dynamically rather than exclusively through static SQL. This is consistent with the "open and fetch cursor" responsibilities described in the source header.
• PLITBLM — An Oracle supplied package that supports PL/SQL table (associative array) memory management, used here to manage the in-memory row collections built by the cursor fetches.

No application tables are documented as direct references in the ETRM excerpt. The underlying picking, delivery, and order data is presumably reached through the dynamic cursors defined inside the package body rather than through named table references in the metadata.

Usage Notes

WSH_PR_PICKING_ROWS is an internal shipping component, not a public API. ETRM classifies it as OTHER and records that it is referenced by zero other packages, meaning it is not consumed through package-to-package dependency chains. It is most likely invoked from the Shipping Execution forms and from pick-release concurrent processing that display or process picking row sets. Typical use begins with INIT, followed by GET_LINE_DETAILS, GET_SYNC_LINE_DETAILS, or GET_NON_SHIP_LINES to populate the record collections, with GET_SIZE used to determine how many rows were returned. SET_SYNC_LINE and SET_REQUEST_LINES configure which lines participate, and CLOSE_CURSORS releases resources at the end of processing. Because the package uses DBMS_SQL and PLITBLM and depends on session privileges through AUTHID CURRENT_USER, custom code should treat it as version-sensitive and should not assume parameter signatures beyond those documented in ETRM for the target release (12.1.1 or 12.2.2).