[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;