[Home] [Help]
PACKAGE: APPS.WSH_U_TRACK
Source
1 PACKAGE WSH_U_TRACK AUTHID CURRENT_USER AS
2 /* $Header: WSHUTRKS.pls 120.0.12020000.4 2013/02/14 01:23:48 adagur ship $ */
3
4 TYPE EnhancedTrackInRec IS RECORD
5 ( InquiryNumber VARCHAR2(35)
6 , TypeOfInquiryNumber VARCHAR2(1)
7 , InternalKey VARCHAR2(120)
8 , SenderShipperNumber VARCHAR2(10)
9 , FromPickupDate DATE
10 , ToPickupDate DATE
11 , DestinationPostalCode VARCHAR2(16)
12 , DestinationCountry VARCHAR2(3)
13 , Entity VARCHAR2(20) --Added Entity param for Carrier Services Integration with Shipping project Bug 16095594
14 , Entity_Id NUMBER);
15
16 TYPE TrackHeaderRec IS RECORD
17 ( UPSOnLine VARCHAR2(9)
18 , AppVersion NUMBER
19 , TypeofResponse VARCHAR2(1)
20 , InquiryNumber VARCHAR2(35)
21 , TypeOfInquiryNumber VARCHAR2(1)
22 , SenderShiperNumber VARCHAR2(10)
23 , InternalKey VARCHAR2(120)
24 , FromPickupDate DATE
25 , ToPickupDate DATE
26 , DestinationPostalCode VARCHAR2(11)
27 , DestinationCountry VARCHAR2(3));
28
29 TYPE TrackErrorRec IS RECORD
30 ( UPSOnLine VARCHAR2(9)
31 , AppVersion NUMBER
32 , ReturnCode NUMBER
33 , MessageNumber VARCHAR2(4)
34 , MessageText VARCHAR2(500));
35
36 TYPE TrackAddress IS RECORD
37 ( UPSOnLine VARCHAR2(9)
38 , AppVersion NUMBER
39 , TypeOfAddress VARCHAR2(1)
40 , Name VARCHAR2(50)
41 , Address1 VARCHAR2(100)
42 , Address2 VARCHAR2(100)
43 , Address3 VARCHAR2(100)
44 , City VARCHAR2(30)
45 , StateProv VARCHAR2(5)
46 , PostalCode VARCHAR2(16)
47 , Country VARCHAR2(3));
48
49 TYPE TrackAddressTblTyp
50 IS TABLE OF TrackAddress INDEX BY BINARY_INTEGER;
51
52
53 TYPE MultiSumHdrRec IS RECORD
54 ( UPSOnLine VARCHAR2(9)
55 , AppVersion NUMBER
56 , InternalShipmentKey VARCHAR2(120)
57 , ServiceLevelDescription VARCHAR2(70)
58 , PickupDate DATE
59 , ScheduledDeliveryDate DATE
60 , TotalShipmentWeight NUMBER(19,2)
61 , WeightUOM VARCHAR2(3)
62 , NumberOfPackagesInShipment NUMBER
63 , NumberOfPackagesDelivered NUMBER
64 , NumberOfPackagesActive NUMBER
65 , ConsigneeAddressIndex NUMBER
66 , MPieceSummaryDtlIndex NUMBER);
67
68 TYPE MultiSumHdrTblTyp
69 IS TABLE OF MultiSumHdrRec INDEX BY BINARY_INTEGER;
70
71
72 TYPE MultiSumDtlRec IS RECORD
73 ( UPSOnLine VARCHAR2(9)
74 , AppVersion NUMBER
75 , TrackingNumber VARCHAR2(35)
76 , InternalPackageKey VARCHAR2(120)
77 , ActivityDetailIndex NUMBER);
78
79
80 TYPE MultiSumDtlTblTyp
81 IS TABLE OF MultiSumDtlRec INDEX BY BINARY_INTEGER;
82
83
84 TYPE PkgDtlSegRec IS RECORD
85 ( UPSOnLine VARCHAR2(9)
86 , AppVersion NUMBER
87 , TrackingNumber VARCHAR2(35)
88 , InternalPackageKey VARCHAR2(120)
89 , ShipmentNumber VARCHAR2(35)
90 , InternalShipmentKey VARCHAR2(85)
91 , PickupDate DATE
92 , NumberOfPackagesInShipment NUMBER
93 , ServiceLevelDescription VARCHAR2(35)
94 , PackageWeight NUMBER(10,2)
95 , WeightUOM VARCHAR2(3)
96 , SignedForByName VARCHAR2(15)
97 , Location VARCHAR2(15)
98 , CusotmerReferenceNumber VARCHAR2(35)
99 , ConsigneeAddressIndex NUMBER
100 , ActivityDetailIndex NUMBER);
101 /* Row Id for the corresponding row in the Activity Detail Table */
102
103 TYPE PkgDtlSegTblTyp
104 IS TABLE OF PkgDtlSegRec INDEX BY BINARY_INTEGER;
105
106
107 TYPE PkgProgressHdrRec IS RECORD
108 ( UPSOnLine VARCHAR2(9)
109 , AppVersion NUMBER
110 , NumberOfActivityDetailLines VARCHAR2(4)
111 , ActivityDetailIndex NUMBER);
112 /* Row Id for the corresponding row in the Activity Detail Table */
113
114
115 TYPE ActivityDtlSegment IS RECORD
116 ( UPSOnLine VARCHAR2(9)
117 , AppVersion NUMBER
118 , StatusType VARCHAR2(1)
119 , StatusLongDescription VARCHAR2(140)
120 , ActivityDate DATE /*YYYYMMDD HH24:MI:SS*/
121 --, ActivityTime VARCHAR2(6)
122 , ActivityAddressIndex BINARY_INTEGER);
123 /* Pointer to the Address Record in the Address Table.*/
124
125 TYPE ActivityDetailTblTyp
126 IS TABLE OF ActivityDtlSegment INDEX BY BINARY_INTEGER;
127
128 PROCEDURE EnhancedTracking
129 ( p_api_version IN NUMBER
130 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
131 , x_return_status OUT NOCOPY VARCHAR2
132 , x_msg_count OUT NOCOPY NUMBER
133 , x_msg_data OUT NOCOPY VARCHAR2
134 , p_AppVersion IN VARCHAR2
135 , p_AcceptLicenseAgreement IN VARCHAR2
136 , p_ResponseType IN VARCHAR2
137 , p_request_in IN EnhancedTrackInRec
138 , x_track_header OUT NOCOPY TrackHeaderRec
139 , x_track_error OUT NOCOPY TrackErrorRec
140 , x_track_address OUT NOCOPY TrackAddressTblTyp
141 , x_multi_sum_header OUT NOCOPY MultiSumHdrTblTyp
142 , x_multi_sum_detail OUT NOCOPY MultiSumDtlTblTyp
143 , x_pkg_detail_segment OUT NOCOPY PkgDtlSegTblTyp
144 , x_pkg_progress OUT NOCOPY PkgProgressHdrRec
145 , x_activity_detail OUT NOCOPY ActivityDetailTblTyp);
146
147 END WSH_U_TRACK;