[Home] [Help]
PACKAGE: APPS.WSH_CARRIERS_GRP
Source
1 PACKAGE WSH_CARRIERS_GRP as
2 /* $Header: WSHCAGPS.pls 120.0 2005/05/26 18:02:13 appldev noship $ */
3 --===================
4 -- PUBLIC VARS
5 --===================
6
7 TYPE Carrier_Rec_Type IS RECORD (
8 CARRIER_ID WSH_CARRIERS.CARRIER_ID%TYPE,
9 FREIGHT_CODE WSH_CARRIERS.FREIGHT_CODE%TYPE,
10 SCAC_CODE WSH_CARRIERS.SCAC_CODE%TYPE DEFAULT NULL,
11 MANIFESTING_ENABLED_FLAG WSH_CARRIERS.MANIFESTING_ENABLED_FLAG%TYPE DEFAULT NULL,
12 CURRENCY_CODE WSH_CARRIERS.CURRENCY_CODE%TYPE DEFAULT NULL,
13 ATTRIBUTE_CATEGORY WSH_CARRIERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
14 ATTRIBUTE1 WSH_CARRIERS.ATTRIBUTE1%TYPE DEFAULT NULL,
15 ATTRIBUTE2 WSH_CARRIERS.ATTRIBUTE2%TYPE DEFAULT NULL,
16 ATTRIBUTE3 WSH_CARRIERS.ATTRIBUTE3%TYPE DEFAULT NULL,
17 ATTRIBUTE4 WSH_CARRIERS.ATTRIBUTE4%TYPE DEFAULT NULL,
18 ATTRIBUTE5 WSH_CARRIERS.ATTRIBUTE5%TYPE DEFAULT NULL,
19 ATTRIBUTE6 WSH_CARRIERS.ATTRIBUTE6%TYPE DEFAULT NULL,
20 ATTRIBUTE7 WSH_CARRIERS.ATTRIBUTE7%TYPE DEFAULT NULL,
21 ATTRIBUTE8 WSH_CARRIERS.ATTRIBUTE8%TYPE DEFAULT NULL,
22 ATTRIBUTE9 WSH_CARRIERS.ATTRIBUTE9%TYPE DEFAULT NULL,
23 ATTRIBUTE10 WSH_CARRIERS.ATTRIBUTE10%TYPE DEFAULT NULL,
24 ATTRIBUTE11 WSH_CARRIERS.ATTRIBUTE11%TYPE DEFAULT NULL,
25 ATTRIBUTE12 WSH_CARRIERS.ATTRIBUTE12%TYPE DEFAULT NULL,
26 ATTRIBUTE13 WSH_CARRIERS.ATTRIBUTE13%TYPE DEFAULT NULL,
27 ATTRIBUTE14 WSH_CARRIERS.ATTRIBUTE14%TYPE DEFAULT NULL,
28 ATTRIBUTE15 WSH_CARRIERS.ATTRIBUTE15%TYPE DEFAULT NULL,
29 CREATION_DATE WSH_CARRIERS.CREATION_DATE%TYPE ,
30 CREATED_BY WSH_CARRIERS.CREATED_BY%TYPE ,
31 LAST_UPDATE_DATE WSH_CARRIERS.LAST_UPDATE_DATE%TYPE ,
32 LAST_UPDATED_BY WSH_CARRIERS.LAST_UPDATED_BY%TYPE ,
33 -- Pack J
34 CARRIER_NAME HZ_PARTIES.PARTY_NAME%TYPE DEFAULT NULL,
35 MAX_NUM_STOPS_PERMITTED WSH_CARRIERS.MAX_NUM_STOPS_PERMITTED%TYPE DEFAULT NULL,
36 MAX_TOTAL_DISTANCE WSH_CARRIERS.MAX_TOTAL_DISTANCE%TYPE DEFAULT NULL,
37 MAX_TOTAL_TIME WSH_CARRIERS.MAX_TOTAL_TIME%TYPE DEFAULT NULL,
38 ALLOW_INTERSPERSE_LOAD WSH_CARRIERS.ALLOW_INTERSPERSE_LOAD%TYPE DEFAULT NULL,
39 MAX_LAYOVER_TIME WSH_CARRIERS.MAX_LAYOVER_TIME%TYPE DEFAULT NULL,
40 MIN_LAYOVER_TIME WSH_CARRIERS.MIN_LAYOVER_TIME%TYPE DEFAULT NULL,
41 MAX_TOTAL_DISTANCE_IN_24HR WSH_CARRIERS.MAX_TOTAL_DISTANCE_IN_24HR%TYPE DEFAULT NULL,
42 MAX_DRIVING_TIME_IN_24HR WSH_CARRIERS.MAX_DRIVING_TIME_IN_24HR%TYPE DEFAULT NULL,
43 MAX_DUTY_TIME_IN_24HR WSH_CARRIERS.MAX_DUTY_TIME_IN_24HR%TYPE DEFAULT NULL,
44 ALLOW_CONTINUOUS_MOVE WSH_CARRIERS.ALLOW_CONTINUOUS_MOVE%TYPE DEFAULT NULL,
45 MAX_CM_DISTANCE WSH_CARRIERS.MAX_CM_DISTANCE%TYPE DEFAULT NULL,
46 MAX_CM_TIME WSH_CARRIERS.MAX_CM_TIME%TYPE DEFAULT NULL,
47 MAX_CM_DH_DISTANCE WSH_CARRIERS.MAX_CM_DH_DISTANCE%TYPE DEFAULT NULL,
48 MAX_CM_DH_TIME WSH_CARRIERS.MAX_CM_DH_TIME%TYPE DEFAULT NULL,
49 MAX_SIZE_WIDTH WSH_CARRIERS.MAX_SIZE_WIDTH%TYPE DEFAULT NULL,
50 MAX_SIZE_HEIGHT WSH_CARRIERS.MAX_SIZE_LENGTH%TYPE DEFAULT NULL,
51 MAX_SIZE_LENGTH WSH_CARRIERS.MAX_SIZE_LENGTH%TYPE DEFAULT NULL,
52 MIN_SIZE_WIDTH WSH_CARRIERS.MIN_SIZE_WIDTH%TYPE DEFAULT NULL,
53 MIN_SIZE_HEIGHT WSH_CARRIERS.MIN_SIZE_HEIGHT%TYPE DEFAULT NULL,
54 MIN_SIZE_LENGTH WSH_CARRIERS.MIN_SIZE_LENGTH%TYPE DEFAULT NULL,
55 TIME_UOM WSH_CARRIERS.TIME_UOM%TYPE DEFAULT NULL,
56 DIMENSION_UOM WSH_CARRIERS.DIMENSION_UOM%TYPE DEFAULT NULL,
57 DISTANCE_UOM WSH_CARRIERS.DISTANCE_UOM%TYPE DEFAULT NULL,
58 MAX_OUT_OF_ROUTE WSH_CARRIERS.MAX_OUT_OF_ROUTE%TYPE DEFAULT NULL,
59 CM_FREE_DH_MILEAGE WSH_CARRIERS.CM_FREE_DH_MILEAGE%TYPE DEFAULT NULL,
60 MIN_CM_DISTANCE WSH_CARRIERS.MIN_CM_DISTANCE%TYPE DEFAULT NULL,
61 CM_FIRST_LOAD_DISCOUNT WSH_CARRIERS.CM_FIRST_LOAD_DISCOUNT%TYPE DEFAULT NULL,
62 MIN_CM_TIME WSH_CARRIERS.MIN_CM_TIME%TYPE DEFAULT NULL,
63 UNIT_RATE_BASIS WSH_CARRIERS.UNIT_RATE_BASIS%TYPE DEFAULT NULL,
64 WEIGHT_UOM WSH_CARRIERS.WEIGHT_UOM%TYPE DEFAULT NULL,
65 VOLUME_UOM WSH_CARRIERS.VOLUME_UOM%TYPE DEFAULT NULL,
66 GENERIC_FLAG WSH_CARRIERS.GENERIC_FLAG%TYPE DEFAULT NULL,
67 FREIGHT_BILL_AUTO_APPROVAL WSH_CARRIERS.FREIGHT_BILL_AUTO_APPROVAL%TYPE DEFAULT NULL,
68 FREIGHT_AUDIT_LINE_LEVEL WSH_CARRIERS.FREIGHT_AUDIT_LINE_LEVEL%TYPE DEFAULT NULL,
69 SUPPLIER_ID WSH_CARRIERS.SUPPLIER_ID%TYPE DEFAULT NULL,
70 SUPPLIER_SITE_ID WSH_CARRIERS.SUPPLIER_SITE_ID%TYPE DEFAULT NULL,
71 CM_RATE_VARIANT WSH_CARRIERS.CM_RATE_VARIANT%TYPE DEFAULT NULL,
72 DISTANCE_CALCULATION_METHOD WSH_CARRIERS.DISTANCE_CALCULATION_METHOD%TYPE DEFAULT NULL,
73 ORIGIN_DSTN_SURCHARGE_LEVEL WSH_CARRIERS.ORIGIN_DSTN_SURCHARGE_LEVEL%TYPE DEFAULT NULL,
74 -- R12 Code Changes
75 DIM_DIMENSIONAL_FACTOR WSH_CARRIERS.DIM_DIMENSIONAL_FACTOR%TYPE DEFAULT NULL,
76 DIM_WEIGHT_UOM WSH_CARRIERS.DIM_WEIGHT_UOM%TYPE DEFAULT NULL,
77 DIM_VOLUME_UOM WSH_CARRIERS.DIM_VOLUME_UOM%TYPE DEFAULT NULL,
78 DIM_DIMENSION_UOM WSH_CARRIERS.DIM_DIMENSION_UOM%TYPE DEFAULT NULL,
79 DIM_MIN_PACK_VOL WSH_CARRIERS.DIM_MIN_PACK_VOL%TYPE DEFAULT NULL
80 -- R12 Code Changes
81 );
82
83
84 TYPE Carrier_Service_Rec_Type IS RECORD (
85 CARRIER_SERVICE_ID WSH_CARRIER_SERVICES.CARRIER_SERVICE_ID%TYPE,
86 CARRIER_ID WSH_CARRIER_SERVICES.CARRIER_ID%TYPE ,
87 SERVICE_LEVEL WSH_CARRIER_SERVICES.SERVICE_LEVEL%TYPE ,
88 MODE_OF_TRANSPORT WSH_CARRIER_SERVICES.MODE_OF_TRANSPORT%TYPE ,
89 SL_TIME_UOM WSH_CARRIER_SERVICES.SL_TIME_UOM%TYPE DEFAULT NULL,
90 MIN_SL_TIME WSH_CARRIER_SERVICES.MIN_SL_TIME%TYPE DEFAULT NULL,
91 MAX_SL_TIME WSH_CARRIER_SERVICES.MAX_SL_TIME%TYPE DEFAULT NULL,
92 ENABLED_FLAG WSH_CARRIER_SERVICES.ENABLED_FLAG%TYPE DEFAULT NULL,
93 WEB_ENABLED WSH_CARRIER_SERVICES.WEB_ENABLED%TYPE DEFAULT NULL,
94 SHIP_METHOD_MEANING WSH_CARRIER_SERVICES.SHIP_METHOD_MEANING%TYPE,
95 ATTRIBUTE_CATEGORY WSH_CARRIER_SERVICES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL ,
96 ATTRIBUTE1 WSH_CARRIER_SERVICES.ATTRIBUTE1%TYPE DEFAULT NULL,
97 ATTRIBUTE2 WSH_CARRIER_SERVICES.ATTRIBUTE2%TYPE DEFAULT NULL,
98 ATTRIBUTE3 WSH_CARRIER_SERVICES.ATTRIBUTE3%TYPE DEFAULT NULL,
99 ATTRIBUTE4 WSH_CARRIER_SERVICES.ATTRIBUTE4%TYPE DEFAULT NULL,
100 ATTRIBUTE5 WSH_CARRIER_SERVICES.ATTRIBUTE5%TYPE DEFAULT NULL,
101 ATTRIBUTE6 WSH_CARRIER_SERVICES.ATTRIBUTE6%TYPE DEFAULT NULL,
102 ATTRIBUTE7 WSH_CARRIER_SERVICES.ATTRIBUTE7%TYPE DEFAULT NULL,
103 ATTRIBUTE8 WSH_CARRIER_SERVICES.ATTRIBUTE8%TYPE DEFAULT NULL,
104 ATTRIBUTE9 WSH_CARRIER_SERVICES.ATTRIBUTE9%TYPE DEFAULT NULL,
105 ATTRIBUTE10 WSH_CARRIER_SERVICES.ATTRIBUTE10%TYPE DEFAULT NULL,
106 ATTRIBUTE11 WSH_CARRIER_SERVICES.ATTRIBUTE11%TYPE DEFAULT NULL,
107 ATTRIBUTE12 WSH_CARRIER_SERVICES.ATTRIBUTE12%TYPE DEFAULT NULL,
108 ATTRIBUTE13 WSH_CARRIER_SERVICES.ATTRIBUTE13%TYPE DEFAULT NULL,
109 ATTRIBUTE14 WSH_CARRIER_SERVICES.ATTRIBUTE14%TYPE DEFAULT NULL,
110 ATTRIBUTE15 WSH_CARRIER_SERVICES.ATTRIBUTE15%TYPE DEFAULT NULL,
111 CREATION_DATE WSH_CARRIER_SERVICES.CREATION_DATE%TYPE,
112 CREATED_BY WSH_CARRIER_SERVICES.CREATED_BY%TYPE ,
113 LAST_UPDATE_DATE WSH_CARRIER_SERVICES.LAST_UPDATE_DATE%TYPE,
114 LAST_UPDATED_BY WSH_CARRIER_SERVICES.LAST_UPDATED_BY%TYPE ,
115 -- Pack J
116 MAX_NUM_STOPS_PERMITTED WSH_CARRIER_SERVICES.MAX_NUM_STOPS_PERMITTED%TYPE DEFAULT NULL,
117 MAX_TOTAL_DISTANCE WSH_CARRIER_SERVICES.MAX_TOTAL_DISTANCE%TYPE DEFAULT NULL,
118 MAX_TOTAL_TIME WSH_CARRIER_SERVICES.MAX_TOTAL_TIME%TYPE DEFAULT NULL,
119 ALLOW_INTERSPERSE_LOAD WSH_CARRIER_SERVICES.ALLOW_INTERSPERSE_LOAD%TYPE DEFAULT NULL,
120 MAX_LAYOVER_TIME WSH_CARRIER_SERVICES.MAX_LAYOVER_TIME%TYPE DEFAULT NULL,
121 MIN_LAYOVER_TIME WSH_CARRIER_SERVICES.MIN_LAYOVER_TIME%TYPE DEFAULT NULL,
122 MAX_TOTAL_DISTANCE_IN_24HR WSH_CARRIER_SERVICES.MAX_TOTAL_DISTANCE_IN_24HR%TYPE DEFAULT NULL,
123 MAX_DRIVING_TIME_IN_24HR WSH_CARRIER_SERVICES.MAX_DRIVING_TIME_IN_24HR%TYPE DEFAULT NULL,
124 MAX_DUTY_TIME_IN_24HR WSH_CARRIER_SERVICES.MAX_DUTY_TIME_IN_24HR%TYPE DEFAULT NULL,
125 ALLOW_CONTINUOUS_MOVE WSH_CARRIER_SERVICES.ALLOW_CONTINUOUS_MOVE%TYPE DEFAULT NULL,
126 MAX_CM_DISTANCE WSH_CARRIER_SERVICES.MAX_CM_DISTANCE%TYPE DEFAULT NULL,
127 MAX_CM_TIME WSH_CARRIER_SERVICES.MAX_CM_TIME%TYPE DEFAULT NULL,
128 MAX_CM_DH_DISTANCE WSH_CARRIER_SERVICES.MAX_CM_DH_DISTANCE%TYPE DEFAULT NULL,
129 MAX_CM_DH_TIME WSH_CARRIER_SERVICES.MAX_CM_DH_TIME%TYPE DEFAULT NULL,
130 MAX_SIZE_WIDTH WSH_CARRIER_SERVICES.MAX_SIZE_WIDTH%TYPE DEFAULT NULL,
131 MAX_SIZE_HEIGHT WSH_CARRIER_SERVICES.MAX_SIZE_HEIGHT%TYPE DEFAULT NULL,
132 MAX_SIZE_LENGTH WSH_CARRIER_SERVICES.MAX_SIZE_LENGTH%TYPE DEFAULT NULL,
133 MIN_SIZE_WIDTH WSH_CARRIER_SERVICES.MIN_SIZE_WIDTH%TYPE DEFAULT NULL,
134 MIN_SIZE_HEIGHT WSH_CARRIER_SERVICES.MIN_SIZE_HEIGHT%TYPE DEFAULT NULL,
135 MIN_SIZE_LENGTH WSH_CARRIER_SERVICES.MIN_SIZE_LENGTH%TYPE DEFAULT NULL,
136 MAX_OUT_OF_ROUTE WSH_CARRIER_SERVICES.MAX_OUT_OF_ROUTE%TYPE DEFAULT NULL,
137 CM_FREE_DH_MILEAGE WSH_CARRIER_SERVICES.CM_FREE_DH_MILEAGE%TYPE DEFAULT NULL,
138 MIN_CM_DISTANCE WSH_CARRIER_SERVICES.MIN_CM_DISTANCE%TYPE DEFAULT NULL,
139 CM_FIRST_LOAD_DISCOUNT WSH_CARRIER_SERVICES.CM_FIRST_LOAD_DISCOUNT%TYPE DEFAULT NULL,
140 MIN_CM_TIME WSH_CARRIER_SERVICES.MIN_CM_TIME%TYPE DEFAULT NULL,
141 UNIT_RATE_BASIS WSH_CARRIER_SERVICES.UNIT_RATE_BASIS%TYPE DEFAULT NULL,
142 CM_RATE_VARIANT WSH_CARRIER_SERVICES.CM_RATE_VARIANT%TYPE DEFAULT NULL,
143 DISTANCE_CALCULATION_METHOD WSH_CARRIER_SERVICES.DISTANCE_CALCULATION_METHOD%TYPE DEFAULT NULL,
144 ORIGIN_DSTN_SURCHARGE_LEVEL WSH_CARRIER_SERVICES.ORIGIN_DSTN_SURCHARGE_LEVEL%TYPE DEFAULT NULL,
145 -- R12 Code Changes
146 DIM_DIMENSIONAL_FACTOR WSH_CARRIER_SERVICES.DIM_DIMENSIONAL_FACTOR%TYPE DEFAULT NULL,
147 DIM_WEIGHT_UOM WSH_CARRIER_SERVICES.DIM_WEIGHT_UOM%TYPE DEFAULT NULL,
148 DIM_VOLUME_UOM WSH_CARRIER_SERVICES.DIM_VOLUME_UOM%TYPE DEFAULT NULL,
149 DIM_DIMENSION_UOM WSH_CARRIER_SERVICES.DIM_DIMENSION_UOM%TYPE DEFAULT NULL,
150 DIM_MIN_PACK_VOL WSH_CARRIER_SERVICES.DIM_MIN_PACK_VOL%TYPE DEFAULT NULL,
151 DEFAULT_VEHICLE_TYPE_ID WSH_CARRIER_SERVICES.DEFAULT_VEHICLE_TYPE_ID%TYPE DEFAULT NULL
152 -- R12 Code Changes
153 );
154
155 TYPE Org_Carrier_Service_Rec_Type IS RECORD (
156 ORG_CARRIER_SERVICE_ID NUMBER(38) ,
157 CARRIER_SERVICE_ID NUMBER(38) ,
158 ORGANIZATION_ID NUMBER(38) ,
159 ENABLED_FLAG VARCHAR2(1) DEFAULT NULL,
160 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT NULL,
161 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
162 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
163 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
164 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
165 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
166 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
167 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
168 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
169 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
170 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
171 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
172 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
173 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
174 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
175 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
176 CREATION_DATE DATE ,
180 DISTRIBUTION_ACCOUNT NUMBER DEFAULT NULL -- BugFix#3296461
177 CREATED_BY NUMBER(38) ,
178 LAST_UPDATE_DATE DATE,
179 LAST_UPDATED_BY NUMBER(38),
181 );
182
183 TYPE Carrier_Info_Dff_Type IS RECORD (
184 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT NULL
185 , ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL
186 , ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL
187 , ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL
188 , ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL
189 , ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL
190 , ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL
191 , ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL
192 , ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL
193 , ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL
194 , ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL
195 , ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL
196 , ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL
197 , ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL
198 , ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL
199 , ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL
200 , Creation_Date DATE
201 , Created_By NUMBER
202 , Last_Update_Date DATE
203 , Last_Updated_By NUMBER
204 , Last_Update_Login NUMBER
205 );
206
207
208 TYPE Ship_Method_Dff_Type IS RECORD (
209 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT NULL
210 , ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL
211 , ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL
212 , ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL
213 , ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL
214 , ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL
215 , ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL
216 , ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL
217 , ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL
218 , ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL
219 , ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL
220 , ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL
221 , ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL
222 , ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL
223 , ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL
224 , ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL
225 , Creation_Date DATE
226 , Created_By NUMBER
227 , Last_Update_Date DATE
228 , Last_Updated_By NUMBER
229 , Last_Update_Login NUMBER
230 );
231 TYPE Carrier_Out_Rec_Type is RECORD (
232 carrier_id NUMBER,
233 rowid VARCHAR2(4000));
234
235 TYPE Carrier_Ser_Out_Rec_Type is RECORD (
236 carrier_service_id NUMBER,
237 ship_method_code VARCHAR2(30),
238 rowid VARCHAR2(4000));
239
240 TYPE Org_Carrier_Ser_Out_Rec_Type is RECORD (
241 carrier_service_id NUMBER,
242 org_carrier_service_id NUMBER,
243 rowid VARCHAR2(4000));
244
245 TYPE Org_Carrier_Ser_Out_Tab_Type IS Table of Org_Carrier_Ser_Out_Rec_Type INDEX BY BINARY_INTEGER;
246
247 TYPE Carrier_Service_InOut_Rec_Type is RECORD (
248 carrier_id wsh_carriers.carrier_id%type,
249 freight_code wsh_carriers.freight_code%type,
250 scac_code wsh_carriers.scac_code%type,
251 manifesting_enabled_flag wsh_carriers.manifesting_enabled_flag%type,
252 currency_code wsh_carriers.currency_code%type,
253 generic_flag wsh_carriers.generic_flag%type,
254 carrier_service_id wsh_carrier_services.carrier_service_id%type,
255 service_level wsh_carrier_services.service_level%type,
256 mode_of_transport wsh_carrier_services.mode_of_transport%type,
257 ship_method_code wsh_carrier_services.ship_method_code%type);
258
259 --===================
260 -- PROCEDURES
261 --===================
262
263 --========================================================================
264 -- PROCEDURE : Create_Update_Carrier
265 --
266 --
267 -- PARAMETERS: p_api_version known api version error buffer
268 -- p_init_msg_list FND_API.G_TRUE to reset list
269 -- x_return_status return status
270 -- x_msg_count number of messages in the list
271 -- x_msg_data text of messages
272 -- p_action_code action_code ( CREATE,UPDATE and CREATE_UPDATE )
273 -- p_rec_attr_tab Table of attributes for the carrier entity
274 -- p_carrier_name carrier Name
275 -- p_status status
276 -- x_car_out_rec_tab Table of carrier_id
277 -- VERSION : current version 1.0
278 -- initial version 1.0
279 -- COMMENT : Creates or updates a record in wsh_carriers
280 --========================================================================
281 PROCEDURE Create_Update_Carrier
282 ( p_api_version_number IN NUMBER,
283 p_init_msg_list IN VARCHAR2,
284 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
288 p_status IN VARCHAR2,
285 p_action_code IN VARCHAR2,
286 p_rec_attr_tab IN Carrier_Rec_Type,
287 p_carrier_name IN VARCHAR2,
289 x_car_out_rec_tab OUT NOCOPY Carrier_Out_Rec_Type,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2);
293
294
295 --========================================================================
296 -- PROCEDURE : Create_Update_Service
297 --
298 --
299 -- PARAMETERS: p_api_version known api version error buffer
300 -- p_init_msg_list FND_API.G_TRUE to reset list
301 -- x_return_status return status
302 -- x_msg_count number of messages in the list
303 -- x_msg_data text of messages
304 -- p_action_code action_code ( CREATE,UPDATE and CREATE_UPDATE )
305 -- p_rec_attr_tab Table of attributes for the carrier service entity
306 -- x_car_ser_out_rec_tab Table of carrier_service_id, and ship_method_code.
307 -- VERSION : current version 1.0
308 -- initial version 1.0
309 -- COMMENT : Creates or updates a record in wsh_carrier_services and fnd_lookups
310 --========================================================================
311 PROCEDURE Create_Update_Carrier_Service
312 ( p_api_version_number IN NUMBER,
313 p_init_msg_list IN VARCHAR2,
314 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315 p_action_code IN VARCHAR2,
316 p_rec_attr_tab IN Carrier_Service_Rec_Type,
317 x_car_ser_out_rec_tab OUT NOCOPY Carrier_Ser_Out_Rec_Type,
318 x_return_status OUT NOCOPY VARCHAR2,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2);
321
322 --========================================================================
323 -- PROCEDURE : Assign_Org_Carrier_Service
324 --
325 --
326 -- PARAMETERS: p_api_version known api version error buffer
327 -- p_init_msg_list FND_API.G_TRUE to reset list
328 -- x_return_status return status
329 -- x_msg_count number of messages in the list
330 -- x_msg_data text of messages
331 -- p_action_code action_code (ASSIGN)
332 -- p_rec_attr_tab Table of attributes for the organization carrier service entity
333 -- p_rec_car_dff_tab Carrier Info DFF details
334 -- p_shp_methods_dff Ship Method Info DFF details
335 -- x_orgcar_ser_out_rec_tab Table of orgcarrier_service_id and ship_method_code.
336 -- VERSION : current version 1.0
337 -- initial version 1.0
338 -- COMMENT : Creates or updates a record in wsh_org_carrier_services,org_freight_tl,wsh_carrier_ship_methods
339 --========================================================================
340 PROCEDURE Assign_Org_Carrier_Service
341 ( p_api_version_number IN NUMBER,
342 p_init_msg_list IN VARCHAR2,
343 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344 p_action_code IN VARCHAR2,
345 p_rec_org_car_ser_tab IN Org_Carrier_Service_Rec_Type,
346 p_rec_car_dff_tab IN Carrier_Info_Dff_Type,
347 p_shp_methods_dff IN Ship_Method_Dff_Type,
348 x_orgcar_ser_out_rec_tab OUT NOCOPY Org_Carrier_Ser_Out_Rec_Type,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY NUMBER,
351 x_msg_data OUT NOCOPY VARCHAR2);
352
353 --========================================================================
354 -- PROCEDURE : Assign_Org_Carrier
355 --
356 --
357 -- PARAMETERS: p_api_version known api version error buffer
358 -- p_init_msg_list FND_API.G_TRUE to reset list
359 -- x_return_status return status
360 -- x_msg_count number of messages in the list
361 -- x_msg_data text of messages
362 -- p_action_code action_code (ASSIGN)
363 -- p_rec_attr_tab Table of attributes for the organization carrier service entity
364 -- x_orgcar_ser_out_tab Table of orgcarrier_service_id and ship_method_code.
365 -- VERSION : current version 1.0
366 -- initial version 1.0
367 -- COMMENT : The Organization is assigned to all present carrier services the carrier at that poing of time
368 -- Creates or updates a record in wsh_org_carrier_services,org_freight_tl,wsh_carrier_ship_methods
369 --========================================================================
370 PROCEDURE Assign_Org_Carrier
371 ( p_api_version_number IN NUMBER,
372 p_init_msg_list IN VARCHAR2,
373 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
374 p_action_code IN VARCHAR2,
375 p_carrier_id IN NUMBER,
376 p_organization_id IN NUMBER,
377 x_orgcar_ser_out_tab OUT NOCOPY Org_Carrier_Ser_Out_Tab_Type,
378 x_return_status OUT NOCOPY VARCHAR2,
379 x_msg_count OUT NOCOPY NUMBER,
383 (
380 x_msg_data OUT NOCOPY VARCHAR2);
381
382 PROCEDURE Generate_Ship_Method
384 service_level_code IN VARCHAR2,
385 freight_code IN VARCHAR2,
386 mode_of_trans_code IN VARCHAR2,
387 ship_method_meaning IN VARCHAR2 DEFAULT NULL,
388 x_ship_method_code OUT NOCOPY VARCHAR2
389 );
390
391 PROCEDURE Get_Meanings
392 (
393 sl_time_uom IN VARCHAR2,
394 service_level_code IN VARCHAR2,
395 mode_of_trans_code IN VARCHAR2,
396 x_service_level OUT NOCOPY VARCHAR2,
397 x_mode_of_transport OUT NOCOPY VARCHAR2,
398 x_sl_time_uom_desc OUT NOCOPY VARCHAR2
399 );
400
401 PROCEDURE Get_Carrier_Name
402 (
403 p_carrier_id IN NUMBER,
404 x_carrier_name OUT NOCOPY VARCHAR2,
405 x_freight_code OUT NOCOPY VARCHAR2
406 );
407
408 --========================================================================
409 -- PROCEDURE : get_carrier_service_mode
410 --
411 --========================================================================
412 PROCEDURE get_carrier_service_mode
413 (
414 p_carrier_service_inout_rec IN OUT NOCOPY Carrier_Service_InOut_Rec_Type,
415 x_return_status OUT NOCOPY VARCHAR2
416 );
417
418 END WSH_CARRIERS_GRP;