Search Results extend_tables

Overview

APPS.WSH_BULK_PROCESS_PVT is a private PL/SQL package within the Oracle E-Business Suite Shipping (WSH) module. As indicated by the PVT suffix, it is an internal API package not intended for direct invocation by external subscribers; it implements the low-level processing logic that supports the public bulk processing infrastructure used to create and validate delivery details in high volume. Its primary business function is to enable the mass creation of delivery detail records — the line-level rows in the Shipping Execution data model that link an order or inventory transaction to a specific delivery — while applying validation rules and mandatory-information checks before the records are persisted.

The package is declared VALID in the APPS schema and operates as part of the bulk processing framework that supports Shipping Execution transactions, including ASN processing, inbound matching, and outbound delivery generation. It is referenced by six other packages, confirming its role as a shared internal utility rather than a standalone entry point.

Key Procedures and Functions

• CREATE_DELIVERY_DETAILS — Creates delivery detail records, forming the core of the bulk delivery-detail generation flow.
• BULK_INSERT_DETAILS — Performs the bulk insert of delivery detail rows, providing the set-based insert path that distinguishes bulk processing from row-by-row creation.
• VALIDATE_LINES — Validates input lines prior to insertion, applying Shipping Execution business rules.
• VALIDATE_MANDATORY_INFO — Verifies that required attributes are present on the records being processed.
• EXTEND_TABLES — Supports table extension or staging logic used during the bulk processing run.
• SET_MESSAGE — Manages message text for validation outcomes and error reporting.
• GET_OPM_QUANTITY — Retrieves quantity information relevant to Oracle Process Manufacturing (OPM) integration.
• CALC_SERVICE_MODE — Determines or calculates service mode behavior affecting how details are processed.

Tables Accessed

The package operates against the principal Shipping Execution delivery tables through APPS synonyms:

• WSH_DELIVERY_DETAILS — The primary delivery detail table, written during detail creation and read during validation.
• WSH_DELIVERY_DETAILS_S — The sequence (or seed) table associated with delivery details, used to obtain identifiers for newly created rows.
• WSH_DELIVERY_ASSIGNMENTS_S — The sequence table supporting assignment of details to deliveries.
• PLITBLM — A standard Oracle numeric/index-by table used for bulk collections during set-based processing.

Usage Notes

WSH_BULK_PROCESS_PVT is invoked through the public bulk processing entry points rather than being called directly. Its documented callers include WSH_BULK_PROCESS_GRP, WSH_ASN_RECEIPT_PVT, WSH_INBOUND_UTIL_PKG, WSH_IB_TXN_MATCH_PKG, WSH_PO_CMG_PVT, and WSH_ROUTING_REQUEST. These callers reflect Shipping Execution scenarios such as ASN receipt processing, inbound transaction matching, and routing requests. In practice, the package is reached via concurrent programs and public APIs responsible for mass delivery creation and validation. Because the PVT classification denotes a private interface, customizations and integrations should target the corresponding public API or concurrent program rather than calling WSH_BULK_PROCESS_PVT directly, since its signature and behavior are not guaranteed across releases.