1 PACKAGE WSH_EXTERNAL_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: WSHUOPNS.pls 115.0 99/07/16 08:23:18 porting ship $ */
3
4 FUNCTION Order_value ( header_id IN NUMBER ) RETURN NUMBER;
5
6 -- This should only return FROM and WHERE clause
7 FUNCTION PickRelease_SLQs( batch_id IN NUMBER,
8 release_mode IN VARCHAR2 ) RETURN VARCHAR2;
9
10 FUNCTION Departure_Name ( departure_id IN NUMBER ) RETURN VARCHAR2;
11
12 FUNCTION Delivery_Name ( delivery_id IN NUMBER ) RETURN VARCHAR2;
13
14 FUNCTION Bill_Of_Lading ( departure_id IN NUMBER ) RETURN VARCHAR2;
15
16 FUNCTION WayBill ( departure_id IN NUMBER, del_id IN NUMBER )
17 RETURN VARCHAR2;
18
19 END WSH_EXTERNAL_CUSTOM;