PACKAGE: APPS.WSH_U_CSPV

Source

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