DBA Data[Home] [Help]

PACKAGE: APPS.WSH_EXTERNAL_CUSTOM

Source


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;