1 PACKAGE WSH_CUSTOM_PUB AUTHID CURRENT_USER as
2 /* $Header: WSHCSPBS.pls 120.6.12020000.4 2013/03/24 04:07:53 adagur ship $ */
3
4 --
5 -- Package type declarations
6 --
7
8 --
9 -- Function: Delivery_Name
10 -- Parameters: p_delivery_id - Delivery_Id
11 -- p_delivery_info - Other attributes specified
12 -- in the delivery entity
13 -- Description: This function is designed for the user to
14 -- customize the name of the delivery when
15 -- creating it. It accepts all the related information
16 -- of the delivery entity from which customizations
17 -- can be designed.
18 -- Oracle Default: Provide a character version of the
19 -- delivery_id
20 --
21
22 FUNCTION Delivery_Name
23 (
24 p_delivery_id IN NUMBER,
25 p_delivery_info IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
26 ) RETURN VARCHAR2;
27
28 --
29 -- Function: Trip_Name
30 -- Parameters: p_trip_id - trip_id
31 -- p_trip_info - Other attributes specified
32 -- in the delivery entity
33 -- Description: This function is designed for the user to
34 -- customize the name of the trip when
35 -- creating it. It accepts all the related information
36 -- of the trip entity from which customizations
37 -- can be designed.
38 -- Oracle Default: Provide a character version of the
39 -- delivery_id
40 --
41
42
43 FUNCTION Trip_Name(
44 p_trip_id IN NUMBER,
45 p_trip_info IN wsh_trips_pvt.trip_rec_type
46 ) RETURN VARCHAR2;
47
48 --
49 -- Function: Run_PR_SMC_SS_Parallel
50 -- Description: This function is designed for the user to
51 -- customize the running of Pick Release for Ship Sets and SMCs
52 -- in parallel with Regular Items.
53 -- If this is set to 'Y', then Ship Sets/SMCs are not given a
54 -- priority over Regular Items. This can lead to scenarios where
55 -- Ship Sets/SMCs are backordered while Regular Items are picked.
56 -- Oracle Default: Ship Sets/SMCs are not run in Parallel
57 -- Function Default: 'N'
58 --
59
60 FUNCTION Run_PR_SMC_SS_Parallel
61 RETURN VARCHAR2;
62
63 --
64 -- Function: Credit_Check_Details_Option
65 -- Description: This function is designed for the user to
66 -- customize credit checking for details.
67 -- By default, credit check will be done for all details ('A')
68 -- If the credit check is to be run only for Non-Backordered details,
69 -- then this is set to 'R'.
70 -- If the credit check is to be run only for Backordered details,
71 -- then this is set to 'B'.
72 -- Oracle Default: Credit check for all details.
73 -- Function Default: 'A'
74 --
75
76 FUNCTION Credit_Check_Details_Option
77 RETURN VARCHAR2;
78
79 --Added as a part of bugfix4995478
80 -- PROCEDURE: ui_location_code
81 -- Parameters: p_location_type IN VARCHAR2,
82 -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83 -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84 -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85 -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86 -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87 -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88 -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89 -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90 -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91 -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92 -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93 -- x_use_custom_ui_location OUT VARCHAR2,
94 -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
95 -- This procedure is designed for the user to customize the location (ui_location_code)
96 -- information displayed in Shipping Forms.
97 -- To use this procedure user has to set the value of PL/SQL variable
98 -- x_use_custom_ui_location to 'Y' in package body.
99 --
100 PROCEDURE ui_location_code(
101 p_location_type IN VARCHAR2,
102 p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103 p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104 p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105 p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106 p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107 p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108 p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109 p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110 p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111 p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112 p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113 x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114 x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115 );
116
117 PROCEDURE Shipped_Lines(
118 p_source_header_id in number,
119 p_source_code in varchar2,
120 p_contact_type in varchar2,
121 p_contact_id in number,
122 p_last_notif_date in date,
123 p_shipped out NOCOPY boolean,
124 p_shipped_lines out NOCOPY varchar2);
125
126 PROCEDURE Backordered_Lines(
127 p_source_header_id in number,
128 p_source_code in varchar2,
129 p_contact_type in varchar2,
130 p_contact_id in number,
131 p_last_notif_date in date,
132 p_backordered out NOCOPY boolean,
133 p_backordered_lines out NOCOPY varchar2);
134
135 PROCEDURE Start_Workflow(
136 p_source_header_id in number,
137 p_source_code in varchar2,
138 p_contact_type in varchar2,
139 p_contact_id in number,
140 p_result out NOCOPY boolean);
141
142 --PROCEDURE calculate_tp_dates
143 --Based on different parameters from OM, customers can customize their
144 --calculation of the TP dates (Earliest/Latest Ship Dates and Earliest/Latest Delivery Dates).
145 --These will be then used for population at the delivery detail level and will
146 --get propogated upto container or delivery levels at action points such as
147 --assign/pack etc.
148 --NOTE : x_modified out parameter must be returned as 'Y' in order to use this
149 --customized calculation
150
151 PROCEDURE calculate_tp_dates(
152 p_source_line_id NUMBER,
153 p_source_code IN VARCHAR2,
154 x_earliest_pickup_date OUT NOCOPY DATE,
155 x_latest_pickup_date OUT NOCOPY DATE,
156 x_earliest_dropoff_date OUT NOCOPY DATE,
157 x_latest_dropoff_date OUT NOCOPY DATE,
158 x_modified OUT NOCOPY VARCHAR2
159 );
160
161 -- Procedure Override_RIQ_XML_Attributes
162 -- Provides a way to override the attributes: Weight, Volume, Item Dimensions: Length, Width and Height
163 -- for any of the following RIQ actions:
164 -- 1) Choose Ship Method
165 -- 2) Get Ship Method
166 -- 3) Get Ship Method and Rates
167 -- 4) Get Freight Rates
168 -- All the attributes values should be Non-Negative.
169 -- For the Header Level (Consolidation), p_line_id_tab will have more than 1
170 -- record containing all the order line_ids that have been consolidated at the header level
171 -- The only attributes that can be overridden at the Header Level are Weight and Volume.
172 -- For the Line Level/Ship Unit Level, p_line_id_tab will have only 1 record
173 -- with the order line_id and all the attributes can be overridden.
174 -- For Item Dimensions values to be sent as part of RIQ XML, the OTM Item Dimension UOM must be defined
175 -- and the Item Dimensions (Length, Width and Height) should all have valid values
176 PROCEDURE Override_RIQ_XML_Attributes(
177 p_line_id_tab IN WSH_UTIL_CORE.Id_Tab_Type,
178 x_weight IN OUT NOCOPY NUMBER,
179 x_volume IN OUT NOCOPY NUMBER,
180 x_length IN OUT NOCOPY NUMBER,
181 x_height IN OUT NOCOPY NUMBER,
182 x_width IN OUT NOCOPY NUMBER,
183 x_return_status OUT NOCOPY VARCHAR2
184 );
185 -- Bug 7131800
186 -- This Function is the Custom Hook provided to Customers , When OverShip/UnderShip Tolerances are set
187 -- Purpose : As part of OM interface, When the tolerance is met for a line set this custom api
188 -- : can be used to decide if the non-staged delivery details (of all order lines in a
189 -- : line set) should be cancelled or not.
190 -- : The valid return values should be 'Y', if all non-staged details should be cancelled.
191 -- or 'N', if all the non-staged details should not be cancelled
192 -- : and No DML statement should be the part of this hook, since it may cause inconsistent data.
193 -- : User should only modify code considering the purpose/scope of the API and use it appropriately.
194 -- Parameters: p_source_line_id - Line id of the Details that are to be Cancelled
195 -- : p_source_line_set_id - Lines Set Id of the Details
196 -- : p_remain_details_id - List of Delivery Details (belonging to the p_source_line_id)
197 -- : that are going to be cancelled
198 -- Return : Return Value should be
199 -- : - 'Y', if all non-staged details should be cancelled
200 -- : (the current default behavior)
201 -- : - 'N', if all the non-staged details should not be cancelled
202 FUNCTION Cancel_Unpicked_Details_At_ITS(
203 p_source_header_id IN NUMBER,
204 p_source_line_id IN NUMBER,
205 p_source_line_set_id IN NUMBER,
206 p_remain_details_id IN WSH_UTIL_CORE.Id_Tab_Type
207 ) RETURN VARCHAR2;
208
209 -- Standalone Project -- Start
210 -- This Procedure is the Custom Hook provided to Customers to return default values.
211 -- Purpose : Customer should set default values for Order Type, Price List,
212 -- Payment Term and Currency Code.
213 -- Parameters: x_order_type_id - Order Type
214 -- : x_price_list_id - Price List
215 -- : x_payment_term_id - Payment Term
216 -- : x_currency_code - Currency Code
217 PROCEDURE Get_Standalone_WMS_Defaults (
218 p_transaction_id IN NUMBER,
219 x_order_type_id OUT NOCOPY NUMBER,
220 x_price_list_id OUT NOCOPY NUMBER,
221 x_payment_term_id OUT NOCOPY NUMBER,
222 x_currency_code OUT NOCOPY VARCHAR2 );
223
224 -- This Procedure is the Custom Hook provided to Customers to handle post process
225 -- of Shipment Request processing.
226 PROCEDURE Post_Process_Shipment_Request (
227 p_transaction_id IN NUMBER,
228 x_return_status OUT NOCOPY VARCHAR2 );
229
230 -- Standalone Project - End
231
232 -- 8424489
233 -- Function Name: Dsno_Output_File_Prefix
234 -- Purpose :
235 -- This function is the custom hook provided for customers to customize
236 -- DSNO output file name. Value returned from this custom function will
237 -- be used as prefix for DSNO output file name to be generated
238 --
239 -- DEFAULT RETURN VALUE IS => DSNO
240 --
241 -- Parameters:
242 -- p_trip_stop_id - Trip Stop Id for which ITS/Outbound Trigerring process is being submitted
243 -- p_doc_number - Document Number suffixed to DSNO output file name
244 -- p_dsno_file_ext - File Extension for DSNO output file to be generated
245 -- Parameter value will be NULL, if Profile 'WSH: DSNO Output File Extension'
246 -- (WSH_DSNO_OUTPUT_FILE_EXT) is NOT set.
247 -- Return:
248 -- If value returned is NULL then DSNO will be prefixed for DSNO Output Filename
249 -- Return value should be VARCHAR2. While customizing customer should take care that length of
250 -- "return value || p_doc_number || '.' || p_dsno_file_ext" is NOT greater than 30 Characters.
251 -- Example:
252 -- Return Value => CUSTOM_FILE_NAME
253 -- p_doc_number => 123456789
254 -- p_dsno_file_ext => txt
255 -- DSNO Output File Name => CUSTOM_FILE_NAME123456789.txt
256 -- length(CUSTOM_FILE_NAME123456789.txt) should not be greater than 30 Characters.
257 --
258 FUNCTION Dsno_Output_File_Prefix(
259 p_trip_stop_id IN NUMBER,
260 p_doc_number IN NUMBER,
261 p_dsno_file_ext IN VARCHAR2 )
262 RETURN VARCHAR2;
263
264 -- TPW - Distributed Organization Changes - Start
265 -- Procedure Name: Shipment_Batch_Group_Criteria
266 -- Purpose :
267 -- This procedure is the custom hook provided for customers to customize
268 -- grouping criteria for Shipment Batches to be generated.
269 --
270 -- Possible return values for all parameter is either 'Y' or 'N'
271 -- 1) If NULL value is returned then it will be treated as 'Y'
272 -- 2) If value returned is other than Y/N then it will be treated as 'N'
273 --
274 -- By Default value for all Grouping criteria is set to 'Y'.
275 --
276 -- Parameters:
277 -- x_grp_by_invoice_to_site - Group By Invoice To Site
278 -- x_grp_by_deliver_to_site - Group By Deliver To Site
279 -- x_grp_by_ship_to_contact - Group By Ship To Contact
280 -- x_grp_by_invoice_to_contact - Group By Invoice To Contact
281 -- x_grp_by_deliver_to_contact - Group By Deliver To Contact
282 -- x_grp_by_ship_method - Group By Ship Method Code
283 -- x_grp_by_freight_terms - Group By Freight Terms
284 -- x_grp_by_fob_code - Group By FOB Code
285 -- x_grp_by_within_order - Group Lines Within Sales Order
286 --
287 PROCEDURE Shipment_Batch_Group_Criteria(
288 x_grp_by_invoice_to_site OUT NOCOPY VARCHAR2,
289 x_grp_by_deliver_to_site OUT NOCOPY VARCHAR2,
290 x_grp_by_ship_to_contact OUT NOCOPY VARCHAR2,
291 x_grp_by_invoice_to_contact OUT NOCOPY VARCHAR2,
292 x_grp_by_deliver_to_contact OUT NOCOPY VARCHAR2,
293 x_grp_by_ship_method OUT NOCOPY VARCHAR2,
294 x_grp_by_freight_terms OUT NOCOPY VARCHAR2,
295 x_grp_by_fob_code OUT NOCOPY VARCHAR2,
296 x_grp_by_within_order OUT NOCOPY VARCHAR2 );
297
298 -- TPW - Distributed Organization Changes - End
299 -- Carrier Services Shipping integration Project 16095594
300 -- Start of comments
301 -- API Name : csp_shipment_services
302 -- Type : CUSTOM PUB
303 -- Purpose : for address validation
304 -- Pre-reqs : None.
305 -- Function : Need to Uncomment the code written in package body to make it work with UPS address validation
306 -- However it can be customized to get this work with other carrier services
307 -- To make this API work for UPS the customer also needs to set the below variables in package body
308 -- G_UPS_WS_USERNAME -- Customer Needs to get this from UPS.
309 -- G_UPS_WS_PASSWD -- Customer Needs to get this from UPS.
310 -- G_UPS_ACCESS_TOKEN -- Customer Needs to get this from UPS.
311 -- G_ORA_WALLET_PATH -- This is path where customer have the oracle wallet installed
312 -- -- In the wallet they need to import the UPS certificate.
313 -- G_ORA_WALLET_PASSSWD -- Password of oracle wallet
314 --
315 -- The valid return values should be returned by x_cspvalidate_out
316 -- and No DML statement should be the part of this hook, since it may cause inconsistent data.
317 -- User should only modify code considering the purpose/scope of the API and use it appropriately.
318 --
319 --
320 -- PARAMETERS : p_request_in This is an input parameter. Ct. needs to pass
321 -- --City
322 -- --Stateprov
323 -- --Postalcode
324 -- x_cspvalidate_out This is the output variable and will give the quality
325 -- City/StateProv/PostalCode after validation.
326 -- --Rank
327 -- --Quality
328 -- --City
329 -- --StateProv
330 -- --PostalCodeLow
331 -- --PostalCodeHigh
332 -- x_msg_count Message count
333 -- x_msg_data Message details
334 -- x_return_status return status
335 -- End of comments
336
337 PROCEDURE csp_shipment_services
338 ( p_request_in IN WSH_U_CSPV.CSPValidateInRec
339 , x_cspvalidate_out OUT NOCOPY WSH_U_CSPV.CSPValidateOutTblTyp
340 , x_msg_count OUT NOCOPY NUMBER
341 , x_msg_data OUT NOCOPY VARCHAR2
342 , x_return_status OUT NOCOPY VARCHAR2 );
343
344 -- Start of comments
345 --
346 -- API Name : rate_shipment_services
347 -- Type : CUSTOM PUB
348 -- Purpose : for address validation
349 -- Pre-reqs : None.
350 -- Function : Need to Uncomment the code written in package body to make it work with UPS shipment rates
351 -- However it can be customized to get this work with other carrier services
352 -- To make this API work for UPS the customer also needs to set the below variables in package body
353 -- G_UPS_WS_USERNAME -- Customer Needs to get this from UPS.
354 -- G_UPS_WS_PASSWD -- Customer Needs to get this from UPS.
355 -- G_UPS_ACCESS_TOKEN -- Customer Needs to get this from UPS.
356 -- G_ORA_WALLET_PATH -- This is path where customer have the oracle wallet installed
357 -- -- In the wallet they need to import the UPS certificate.
358 -- G_ORA_WALLET_PASSSWD -- Password of oracle wallet
359 --
360 -- The valid return values should be returned by x_output
361 -- and No DML statement should be the part of this hook, since it may cause inconsistent data.
362 -- User should only modify code considering the purpose/scope of the API and use it appropriately.
363 --
364 -- PARAMETERS : p_request_in This is an input parameter. Ct. needs to pass
365 -- -- RateChart
366 -- -- ShipperPostalCode
367 -- -- ConsigneePostalCode
368 -- -- ConsigneeCountry
369 -- -- PackageActualWeight
370 -- -- DeclaredValueInsurance
371 -- -- PackageLength
372 -- -- PackageWidth
373 -- -- PackageHight
374 -- -- OverSizeIndicator
375 -- -- CODIndicator
376 -- -- HazMat
377 -- -- AdditionalHandlingInd
378 -- -- CallTagARSInd
379 -- -- SatDeliveryInd
380 -- -- SatPickupInd
381 -- -- DCISInd
382 -- -- VerbalConfirmationInd
383 -- -- SNDestinationInd1
384 -- -- SNDestinationInd2
385 -- -- ResidentialInd
386 -- -- PackagingType
387 -- -- ship_from_location_id
388 -- -- ship_to_location_id
389 -- x_output This is the output variable and will give the rate and services
390 -- -- ServiceLevelCode
391 -- -- ShipperPostalCode
392 -- -- ShipperCountry
393 -- -- ConsigneePostalCode
394 -- -- ConsigneeCountry
395 -- -- DeliverZone
396 -- -- PackageActualWeight
397 -- -- ProductCharge
398 -- -- AccessorySurcharge
399 -- -- TotalCharge
400 -- -- CommitTime
401 -- x_msg_count Message count
402 -- x_msg_data Message details
403 -- x_return_status return status
404 -- End of comments
405
406 PROCEDURE rate_shipment_services
407 ( p_request_in IN WSH_U_RASS.RateServiceInRec
408 , x_output OUT NOCOPY WSH_U_RASS.RateServTableTyp
409 , x_msg_count OUT NOCOPY NUMBER
410 , x_msg_data OUT NOCOPY VARCHAR2
411 , x_return_status OUT NOCOPY VARCHAR2 );
412
413 -- Start of comments
414 --
415 -- API Name : trk_shipment_services
416 -- Type : CUSTOM PUB
417 -- Purpose : for Tracking
418 -- Pre-reqs : None.
419 -- Function : Need to Uncomment the code written in package body to make it work with UPS Tracking
420 -- However it can be customized to get this work with other carrier services
421 -- To make this API work for UPS the customer also needs to set the below variables in package body
422 -- G_UPS_WS_USERNAME -- Customer Needs to get this from UPS.
423 -- G_UPS_WS_PASSWD -- Customer Needs to get this from UPS.
424 -- G_UPS_ACCESS_TOKEN -- Customer Needs to get this from UPS.
425 -- G_ORA_WALLET_PATH -- This is path where customer have the oracle wallet installed
426 -- -- In the wallet they need to import the UPS certificate.
427 -- G_ORA_WALLET_PASSSWD -- Password of oracle wallet
428 --
429 -- The valid return values should be returned by x_track_address,x_pkg_detail_segment and x_activity_detail
430 -- and No DML statement should be the part of this hook, since it may cause inconsistent data.
431 -- User should only modify code considering the purpose/scope of the API and use it appropriately.
432 --
433 --
434 -- PARAMETERS p_request_in This is an input parameter. Ct. needs to pass
435 -- --InquiryNumber tracking number from delivery detail
436 -- x_track_address Tracking Address
437 -- --City
438 -- --StateProv
439 -- --Country
440 -- x_pkg_detail_segment Package related Details
441 -- --ServiceLevelDescription
442 -- --ConsigneeAddressIndex
443 -- --SignedForByName
444 -- --PickupDate
445 -- --CusotmerReferenceNumber
446 -- --PackageWeight
447 -- --weightuom
448 -- --location
449 -- x_activity_detail Tracking activity details
450 -- --ActivityAddressIndex
451 -- --ActivityDate
452 -- --StatusLongDescription
453 -- --StatusType
454 -- x_msg_count Message count
455 -- x_msg_data Message details
456 -- x_return_status return status
457 -- End of comments
458 PROCEDURE trk_shipment_services
459 ( p_request_in IN WSH_U_TRACK.EnhancedTrackInRec
460 , x_track_address OUT NOCOPY WSH_U_TRACK.TrackAddressTblTyp
461 , x_pkg_detail_segment OUT NOCOPY WSH_U_TRACK.PkgDtlSegTblTyp
462 , x_activity_detail OUT NOCOPY WSH_U_TRACK.ActivityDetailTblTyp
463 , x_msg_count OUT NOCOPY NUMBER
464 , x_msg_data OUT NOCOPY VARCHAR2
465 , x_return_status OUT NOCOPY VARCHAR2 );
466
467 -- Start of comments
468 --
469 -- API Name : tnt_shipment_services
470 -- Type : CUSTOM PUB
471 -- Purpose : for Time in Transit
472 -- Pre-reqs : None.
473 -- Function : Need to Uncomment the code written in package body to make it work with UPS Tracking
474 -- However it can be customized to get this work with other carrier services
475 -- To make this API work for UPS the customer also needs to set the below variables in package body
476 -- G_UPS_WS_USERNAME -- Customer Needs to get this from UPS.
477 -- G_UPS_WS_PASSWD -- Customer Needs to get this from UPS.
478 -- G_UPS_ACCESS_TOKEN -- Customer Needs to get this from UPS.
479 -- G_ORA_WALLET_PATH -- This is path where customer have the oracle wallet installed
480 -- -- In the wallet they need to import the UPS certificate.
481 -- G_ORA_WALLET_PASSSWD -- Password of oracle wallet
482 --
483 -- The valid return values should be returned by x_timeintransit_out
484 -- and No DML statement should be the part of this hook, since it may cause inconsistent data.
485 -- User should only modify code considering the purpose/scope of the API and use it appropriately.
486 --
487 -- PARAMETERS : p_request_in This is an input parameter. Ct. needs to pass
488 -- --OriginNumber
489 -- --DestinationNumber
490 -- --ship_from_location_id
491 -- --ship_to_location_id
492 -- x_timeintransit_out various service option and time taken
493 -- --TransitTime
494 -- --OriginCity
495 -- --OriginStateProv
496 -- --DestinationCity
497 -- --DestinationStateProv
498 -- x_msg_count Message count
499 -- x_msg_data Message details
500 -- x_return_status return status
501 -- End of comments
502
503 PROCEDURE tnt_shipment_services
504 ( p_request_in IN WSH_U_GTT.tnt_request_rec
505 , x_timeintransit_out OUT NOCOPY WSH_U_GTT.timeintransitoutrec
506 , x_msg_count OUT NOCOPY NUMBER
507 , x_msg_data OUT NOCOPY VARCHAR2
508 , x_return_status OUT NOCOPY VARCHAR2 );
509 -- Carrier Services Shipping integration Project 16095594 End
510 END WSH_CUSTOM_PUB;
[Home] [Help]