[Home] [Help]
PACKAGE: APPS.FTE_MLS_UTIL
Source
1 PACKAGE FTE_MLS_UTIL AS
2 /* $Header: FTEMLUTS.pls 120.2 2005/06/20 06:40:56 appldev ship $ */
3
4 FTE_CHAR CONSTANT VARCHAR2(1) := chr(0);
5 FTE_NUM CONSTANT NUMBER := -9999;
6 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
7 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
8
9 --{
10 PROCEDURE api_post_call
11 (
12 p_api_name IN VARCHAR2,
13 p_api_return_status IN VARCHAR2,
14 p_message_name IN VARCHAR2,
15 p_trip_segment_id IN VARCHAR2 DEFAULT NULL,
16 p_trip_segment_name IN VARCHAR2 DEFAULT NULL,
17 p_trip_stop_id IN NUMBER DEFAULT NULL,
18 p_stop_seq_number IN NUMBER DEFAULT NULL,
19 p_trip_id IN VARCHAR2 DEFAULT NULL,
20 p_trip_name IN VARCHAR2 DEFAULT NULL,
21 p_delivery_id IN VARCHAR2 DEFAULT NULL,
22 p_delivery_name IN VARCHAR2 DEFAULT NULL,
23 x_number_of_errors IN OUT NOCOPY NUMBER,
24 x_number_of_warnings IN OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2
26 );
27 --
28 --
29 PROCEDURE get_trip_segment_name
30 (
31 p_trip_segment_id IN NUMBER,
32 x_trip_segment_name OUT NOCOPY VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2
34 );
35 --
36 FUNCTION all_other_segments_closed
37 (
38 P_trip_segment_id IN NUMBER,
39 p_trip_id IN NUMBER
40 )
41 RETURN BOOLEAN;
42 --
43 --IF x_next_segment_id IS NULL, it implies there is no next segment
44 --
45 --
46 PROCEDURE get_next_segment_id
47 (
48 P_trip_segment_id IN NUMBER,
49 p_sequence_number IN NUMBER,
50 p_trip_id IN NUMBER,
51 x_trip_name IN OUT NOCOPY VARCHAR2,
52 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
53 x_next_segment_id OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56 --
57 --
58 --IF x_previous_segment_id IS NULL, it implies there is no previous segment
59 --
60 --
61 PROCEDURE get_previous_segment_id
62 (
63 P_trip_segment_id IN NUMBER,
64 p_sequence_number IN NUMBER,
65 p_trip_id IN NUMBER,
66 x_trip_name IN OUT NOCOPY VARCHAR2,
67 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
68 x_previous_segment_id OUT NOCOPY NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2
70 );
71 --
72 --
73 --IF x_first_stop_location_id IS NULL, it implies there are no stops
74 --
75 --
76 PROCEDURE get_first_stop_location_id
77 (
78 P_trip_segment_id IN NUMBER,
79 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
80 x_first_stop_location_id OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2
82 );
83 --
84 --
85 --IF x_last_stop_location_id IS NULL, it implies there are no stops
86 --
87 --
88 PROCEDURE get_last_stop_location_id
89 (
90 P_trip_segment_id IN NUMBER,
91 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
92 x_last_stop_location_id OUT NOCOPY NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2
94 );
95 --
96 --
97 -- p_trip_id : FTE Trip ID
98 -- P_trip_segment_id : WSH Trip ID
99 -- p_sequence_number : Sequence of WSH Trip within FTE Trip
100 -- p_last_stop_location_id : Last Stop location for WSH Trip
101 -- x_trip_name : Name of FTE Trip
102 -- x_trip_segment_name : Name of WSH Trip
103 --
104 --
105 --
106 PROCEDURE check_next_segment
107 (
108 p_trip_id IN NUMBER,
109 P_trip_segment_id IN NUMBER,
110 p_sequence_number IN NUMBER,
111 p_last_stop_location_id IN NUMBER DEFAULT NULL,
112 x_trip_name IN OUT NOCOPY VARCHAR2,
113 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
114 x_connected OUT NOCOPY BOOLEAN,
115 x_return_status OUT NOCOPY VARCHAR2
116 );
117 --
118 --
119 -- p_trip_id : FTE Trip ID
120 -- P_trip_segment_rec : WSH Trip REcord
121 -- p_sequence_number : Sequence of WSH Trip within FTE Trip
122 -- p_last_stop_location_id : Last Stop location for WSH Trip
123 -- x_trip_name : Name of FTE Trip
124 -- x_trip_segment_name : Name of WSH Trip
125 --
126 --
127 PROCEDURE check_next_segment
128 (
129 p_trip_id IN NUMBER,
130 p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
131 p_sequence_number IN NUMBER,
132 p_last_stop_location_id IN NUMBER DEFAULT NULL,
133 x_trip_name IN OUT NOCOPY VARCHAR2,
134 x_connected OUT NOCOPY BOOLEAN,
135 x_return_status OUT NOCOPY VARCHAR2
136 );
137 --
138 --
139 -- p_trip_id : FTE Trip ID
140 -- P_trip_segment_id : WSH Trip ID
141 -- p_sequence_number : Sequence of WSH Trip within FTE Trip
142 -- p_first_stop_location_id : First Stop location for WSH Trip
143 -- x_trip_name : Name of FTE Trip
144 -- x_trip_segment_name : Name of WSH Trip
145 --
146 --
147 PROCEDURE check_previous_segment
148 (
149 p_trip_id IN NUMBER,
150 P_trip_segment_id IN NUMBER,
151 p_sequence_number IN NUMBER,
152 p_first_stop_location_id IN NUMBER DEFAULT NULL,
153 x_trip_name IN OUT NOCOPY VARCHAR2,
154 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
155 x_connected OUT NOCOPY BOOLEAN,
156 x_return_status OUT NOCOPY VARCHAR2
157 );
158 --
159 --
160 PROCEDURE check_previous_segment
161 (
162 p_trip_id IN NUMBER,
163 p_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
164 p_sequence_number IN NUMBER,
165 p_first_stop_location_id IN NUMBER DEFAULT NULL,
166 x_trip_name IN OUT NOCOPY VARCHAR2,
167 x_connected OUT NOCOPY BOOLEAN,
168 x_return_status OUT NOCOPY VARCHAR2
169 );
170 --
171 --
172 FUNCTION segment_has_intransit_dlvy
173 (
174 P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type
175 )
176 RETURN BOOLEAN;
177 --
178 --
179 FUNCTION stop_has_intransit_dlvy
180 (
181 P_trip_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_stop_Pub_Rec_Type
182 )
183 RETURN BOOLEAN;
184 --
185 --
186 FUNCTION stop_has_intransit_dlvy
187 (
188 P_trip_stop_id IN NUMBER
189 )
190 RETURN BOOLEAN;
191 --
192 FUNCTION get_carrier_name
193 (
194 p_carrier_id IN NUMBER
195 )
196 RETURN VARCHAR2;
197 --
198 --
199 PROCEDURE get_location_info
200 (
201 p_location_id IN NUMBER,
202 x_location OUT NOCOPY VARCHAR2,
203 x_csz OUT NOCOPY VARCHAR2,
204 x_country OUT NOCOPY VARCHAR2,
205 x_return_status OUT NOCOPY VARCHAR2
206 );
207 --
208 --
209 PROCEDURE derive_ship_method
210 (
211 p_carrier_id IN NUMBER,
212 p_mode_of_transport IN VARCHAR2,
213 p_service_level IN VARCHAR2,
214 p_carrier_name IN VARCHAR2,
215 p_mode_of_transport_meaning IN VARCHAR2,
216 p_service_level_meaning IN VARCHAR2,
217 x_ship_method_code OUT NOCOPY VARCHAR2,
218 x_return_status OUT NOCOPY VARCHAR2
219 );
220 --
221 --
222 FUNCTION segment_has_other_deliveries
223 (
224 P_trip_segment_id IN NUMBER,
225 p_delivery_id IN NUMBER
226 )
227 RETURN BOOLEAN;
228 --
229 --
230 FUNCTION get_delivery_legs
231 (
232 p_trip_segment_id IN NUMBER
233 )
234 RETURN VARCHAR2;
235
236 -- Added Pack I - HBHAGAVA
237 FUNCTION get_message
238 (
239 p_msg_count IN NUMBER,
240 p_msg_data IN VARCHAR2
241 )
242 RETURN VARCHAR2;
243 --
244 --
245 -- Return Mode of Transport meaning
246 --
247 FUNCTION get_mode_of_transport
248 (
249 p_mode_code IN VARCHAR2
250 )
251 RETURN VARCHAR2;
252 --
253 --
254 FUNCTION GET_SERVICE_LEVEL
255 (
256 p_service_level IN VARCHAR2
257 )
258 RETURN VARCHAR2;
259 --
260 --
261 PROCEDURE get_location_info
262 (
263 p_location_id IN NUMBER,
264 x_location OUT NOCOPY VARCHAR2,
265 x_return_status OUT NOCOPY VARCHAR2
266 );
267 --
268 --
269 PROCEDURE GET_CARRIER_CONTACT_INFO
270 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
271 p_tender_number IN NUMBER,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 x_contact_email OUT NOCOPY VARCHAR2,
276 x_contact_fax OUT NOCOPY VARCHAR2,
277 x_contact_phone OUT NOCOPY VARCHAR2,
278 x_contact_name OUT NOCOPY VARCHAR2);
279 --
280
281 FUNCTION GET_ORG_NAME_BY_FIRSTSTOP
282 (p_stop_id IN NUMBER)
283 RETURN VARCHAR2;
284
285 FUNCTION GET_PICKUP_DLVY_ORG_BY_TRIP
286 (p_trip_id IN NUMBER)
287 RETURN VARCHAR2;
288
289
290 FUNCTION GET_PICKUP_DLVY_ORGID_BY_TRIP
291 (p_trip_id IN NUMBER)
292 RETURN NUMBER;
293
294 PROCEDURE GET_SHIPPER_CONTACT_INFO
295 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
296 p_shipper_name IN VARCHAR2,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 x_shipper_name OUT NOCOPY VARCHAR2,
301 x_contact_email OUT NOCOPY VARCHAR2,
305
302 x_contact_phone OUT NOCOPY VARCHAR2,
303 x_contact_fax OUT NOCOPY VARCHAR2);
304 --
306 FUNCTION GET_CARRIER_ID(
307 p_tender_id IN NUMBER
308 )
309 RETURN NUMBER;
310
311
312 FUNCTION FTE_UOM_CONV
313 (
314 p_from_quantity IN NUMBER,
315 p_from_uom IN VARCHAR2,
316 p_to_uom IN VARCHAR2
317 )
318 RETURN NUMBER;
319
320 --
321 --========================================================================
322 -- PROCEDURE : COPY_FTE_ID_TO_WSH_ID
323 --
324 -- PARAMETERS: p_fte_id_tab IN FTE_ID_TAB_TYPE
325 -- x_wsh_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type
326 -- VERSION : current version 1.0
327 -- initial version 1.0
328 --========================================================================
329
330 PROCEDURE COPY_FTE_ID_TO_WSH_ID (p_fte_id_tab IN FTE_ID_TAB_TYPE,
331 x_wsh_id_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE);
332
333
334 --
335 --========================================================================
336 -- PROCEDURE : COPY_WSH_ID_TO_FTE_ID
337 --
338 -- PARAMETERS: p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type
339 -- x_fte_id_tab OUT NOCOPY FTE_ID_TAB_TYPE
340 --
341 -- VERSION : current version 1.0
342 -- initial version 1.0
343 --========================================================================
344
345 PROCEDURE COPY_WSH_ID_TO_FTE_ID (p_wsh_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
346 x_fte_id_tab IN OUT NOCOPY FTE_ID_TAB_TYPE);
347
348
349
350 --{Rel 12 HBHAGAVA
351
352 PROCEDURE GET_MESSAGE_MEANING (p_message_name IN VARCHAR2,
353 x_message_text OUT NOCOPY VARCHAR2);
354
355
356 --{Rel 12 HBHAGAVA
357
358 FUNCTION Get_Lookup_Meaning(p_lookup_type IN VARCHAR2,
359 P_lookup_code IN VARCHAR2)
360 RETURN VARCHAR2;
361
362
363
364 FUNCTION GET_TRIP_ORGANIZATION_ID(p_trip_id NUMBER) RETURN NUMBER;
365
366
367 PROCEDURE GET_FIRST_LAST_STOP_INFO(x_return_status OUT NOCOPY VARCHAR2,
368 x_arrival_date OUT NOCOPY DATE,
369 x_departure_date OUT NOCOPY DATE,
370 x_first_stop_id OUT NOCOPY NUMBER,
371 x_last_stop_id OUT NOCOPY NUMBER,
372 x_first_stop_loc_id OUT NOCOPY NUMBER,
373 x_last_stop_loc_id OUT NOCOPY NUMBER,
374 p_trip_id NUMBER);
375
376
377 PROCEDURE GET_CURRENCY_CODE(
378 p_init_msg_list IN VARCHAR2,
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2,
382 x_currency_code OUT NOCOPY VARCHAR2,
383 p_entity_type IN VARCHAR2,
384 p_entity_id IN NUMBER,
385 p_carrier_id IN NUMBER);
386
387
388 PROCEDURE GET_SUPPLIER_INFO(
389 p_init_msg_list IN VARCHAR2,
390 x_return_status OUT NOCOPY VARCHAR2,
391 x_msg_count OUT NOCOPY NUMBER,
392 x_msg_data OUT NOCOPY VARCHAR2,
393 x_currency_code OUT NOCOPY VARCHAR2,
394 x_supplier_id OUT NOCOPY NUMBER,
395 x_supplier_site_id OUT NOCOPY NUMBER,
396 x_carrier_site_id OUT NOCOPY NUMBER,
397 p_entity_type IN VARCHAR2,
398 p_entity_id IN NUMBER);
399
400
401 --}
402 END FTE_MLS_UTIL;