PACKAGE: APPS.WSH_EXTERNAL_INTERFACE_SV

Source

1 PACKAGE WSH_EXTERNAL_INTERFACE_SV AS
2 /* $Header: WSHEXINS.pls 120.1.12010000.1 2008/07/29 06:03:44 appldev ship $ */
3 
4 C_SDEBUG  CONSTANT   NUMBER := wsh_debug_sv.C_LEVEL1;
5 C_DEBUG   CONSTANT   NUMBER := wsh_debug_sv.C_LEVEL2;
6 
7 
8 FUNCTION Get_Warehouse_Type ( p_organization_id   IN   NUMBER,
9                               p_event_key         IN   VARCHAR2 DEFAULT NULL,
10                               x_return_status     OUT NOCOPY   VARCHAR2,
11 			      p_delivery_id	  IN   NUMBER DEFAULT NULL,
12 			      p_delivery_detail_id IN  NUMBER DEFAULT NULL ,
13                               p_carrier_id       IN   NUMBER DEFAULT NULL,
14                               p_ship_method_code  IN VARCHAR2 DEFAULT NULL,
15                               p_msg_display        IN  VARCHAR2 DEFAULT 'Y'
16 			    ) RETURN VARCHAR2;
17 
18 PROCEDURE Raise_Event ( p_txn_hist_record   IN     WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type,
19                         p_cbod_status       IN     VARCHAR2,
20                         x_return_status     IN OUT NOCOPY  VARCHAR2
21 		      );
22 
23 PROCEDURE Validate_Item ( p_concatenated_segments IN VARCHAR2,
24 			  p_organization_id IN NUMBER,
25 			  x_inventory_item_id OUT NOCOPY  VARCHAR2,
26 			  x_return_status OUT NOCOPY  VARCHAR2
27 			);
28 PROCEDURE Validate_Ship_To ( p_customer_name IN VARCHAR2,
29 			     p_location IN VARCHAR2,
30 			     x_customer_id OUT NOCOPY  NUMBER,
31 			     x_location_id OUT NOCOPY  NUMBER,
32 			     x_return_status OUT NOCOPY  VARCHAR2,
33 			     p_site_use_code IN VARCHAR2 DEFAULT 'SHIP_TO',
34 			     x_site_use_id OUT NOCOPY  NUMBER,
35                              p_org_id      IN NUMBER DEFAULT NULL
36 			   );
37 END WSH_EXTERNAL_INTERFACE_SV;