DBA Data[Home] [Help]

PACKAGE: APPS.WSH_U_CSPV

Source


1 PACKAGE WSH_U_CSPV AUTHID CURRENT_USER AS
2 /* $Header: WSHUCSPS.pls 115.5 2002/11/12 01:59:47 nparikh ship $ */
3 
4 TYPE CSPValidateInRec IS RECORD (
5 				City				VARCHAR2(30),
6 				StateProv		VARCHAR2(5),
7 				PostalCode		VARCHAR2(16));
8 
9 
10 TYPE CSPValidateOutRec IS RECORD (
11 				UPSOnLine		VARCHAR2(9),
12 				AppVersion		VARCHAR2(20),
13 				ReturnCode		NUMBER,
14 				MessageNumber	NUMBER,
15 				MessageText		VARCHAR2(500),
16 				Rank				NUMBER,
17 				Quality			NUMBER,
18 				City				VARCHAR2(30),
19 				StateProv		VARCHAR2(5),
20 				PostalCodeLow	VARCHAR2(16),
21 				PostalCodeHigh VARCHAR2(16));
22 
23 
24 TYPE CSPValidateOutTblTyp IS TABLE OF CSPValidateOutRec
25 				INDEX BY BINARY_INTEGER;
26 
27 PROCEDURE CSP_Validate(
28 				p_api_version            IN   NUMBER,
29 				p_init_msg_list          IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
30 				x_return_status         OUT NOCOPY    VARCHAR2,
31 				x_msg_count             OUT NOCOPY    NUMBER,
32 				x_msg_data              OUT NOCOPY    VARCHAR2,
33 				p_AppVersion				 IN	VARCHAR2,
34 				p_AcceptLicenseAgreement IN   VARCHAR2,
35 				p_ResponseType				 IN	VARCHAR2,
36 				p_Request_in				 IN	CSPValidateInRec,
37 				x_CSPValidate_out			OUT NOCOPY 	CSPValidateOutTblTyp
38 				);
39 
40 
41 
42 END WSH_U_CSPV;