Search Results get_drop_ship_info

Overview

POS_DROP_SHIP_PVT is a private PL/SQL package in the Oracle E-Business Suite Order Management (ONT) and Purchasing (PO) integration layer that supports the drop-ship order fulfillment process. Drop shipping allows a selling organization to fulfill a sales order by having a supplier ship goods directly to the end customer, bypassing the seller's warehouse. The package specification, defined with AUTHID CURRENT_USER, is the private implementation body behind the drop-ship information retrieval logic used when printing or transmitting drop-ship documents, such as purchase order releases, ASNs, and customer-facing shipping paperwork. Its responsibilities include assembling the ship-to, contact, and customer reference data required to correctly route and communicate a drop-ship transaction between the selling entity, the supplier, and the ultimate consignee.

Key Procedures and Functions

• GET_DROP_SHIP_INFO — The principal public entry point. It accepts the purchase order header, line, line location, and release identifiers as inbound parameters, and returns a comprehensive set of outbound fields describing both the sold-to and deliver-to parties. Documented outbound values include customer name, contact name, phone, fax, and email, ship method, shipping and packing instructions, customer PO number, customer line number, customer ship number, product description, and a full deliver-to address block covering name, contact details, address lines, city, state, zip, and country. It also returns a return status and message data for error handling.
• GET_DROP_SHIP_XML_INFO — The companion routine that produces the same drop-ship information in an XML-oriented representation, supporting document generation and electronic transmission scenarios where structured markup is required rather than discrete scalar values.

Both routines are classified as private (PVT) APIs and are intended for internal package consumers rather than direct customer-facing integration.

Tables Accessed

The package retrieves its source data primarily through the PO_HEADERS_ALL table, accessed via APPS synonyms. This table supplies the purchasing document context that ties a drop-ship purchase order line back to its originating sales order and, in turn, to the customer and deliver-to information that GET_DROP_SHIP_INFO surfaces. Because the parameters include po_header_id, po_line_id, line_location_id, and po_release_id, the lookups are keyed to the specific purchasing document and shipment line being processed.

Usage Notes

POS_DROP_SHIP_PVT is invoked indirectly rather than called directly by end users. Typical callers include Order Management drop-ship workflows, shipping and document-printing routines, and Oracle XML Publisher or equivalent reporting programs that require formatted drop-ship data. In EBS 12.1.1 and 12.2.2 the package is not referenced by other documented packaged APIs within the metadata set, indicating its callers are forms, concurrent programs, or internal PL/SQL routines invoked during drop-ship processing. Customizations requiring drop-ship details should generally consume the public Order Management APIs rather than calling this private package directly, since its signature is not a supported external interface and may change between releases.