DBA Data[Home] [Help]

PACKAGE: APPS.WSH_U_GTT

Source


1 PACKAGE WSH_U_GTT AUTHID CURRENT_USER AS
2 /* $Header: WSHUGTTS.pls 120.0.12020000.3 2013/02/14 01:09:19 adagur ship $ */
3 
4 
5 TYPE  TimeInTransitOutRec IS RECORD
6    ( UPSOnLine              VARCHAR2(9)
7    , AppVersion             VARCHAR2(20)
8    , ReturnCode             NUMBER
9    , MessageNumber          NUMBER
10    , MessageText            VARCHAR2(500)
11    , TransitTime            VARCHAR2(16)
12    , OriginCity             VARCHAR2(30)
13    , OriginStateProv        VARCHAR2(5)
14    , DestinationCity        VARCHAR2(30)
15    , DestinationStateProv   VARCHAR2(5));
16 
17 
18 --Added for Carrier Services Integration with Shipping project Bug 16095594
19 TYPE tnt_request_rec IS RECORD
20    ( OriginNumber           VARCHAR2(30)
21    , DestinationNumber      VARCHAR2(30)
22    , ship_from_location_id  NUMBER
23    , ship_to_location_id    NUMBER
24    , entity                 VARCHAR2(20)
25    , entity_id              NUMBER);
26 
27 
28 PROCEDURE Time_In_Transit
29         ( p_api_version            IN            NUMBER
30         , p_init_msg_list          IN            VARCHAR2 DEFAULT FND_API.G_FALSE
31         , x_return_status          OUT NOCOPY    VARCHAR2
32         , x_msg_count              OUT NOCOPY    NUMBER
33         , x_msg_data               OUT NOCOPY    VARCHAR2
34         , p_AppVersion             IN            VARCHAR2
35         , p_AcceptLicenseAgreement IN            VARCHAR2
36         , p_ResponseType           IN            VARCHAR2
37         , p_tnt_request_in         IN            tnt_request_rec --Added for Carrier Services Integration with Shipping project Bug 16095594
38         , x_TimeInTransit_out      OUT NOCOPY    TimeInTransitOutRec);
39 
40 
41 
42 END WSH_U_GTT;