eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CARRIERS_GRP dependencies on WSH_CARRIERS

Line 1: PACKAGE WSH_CARRIERS_GRP AUTHID CURRENT_USER as

1: PACKAGE WSH_CARRIERS_GRP AUTHID CURRENT_USER as
2: /* $Header: WSHCAGPS.pls 120.0 2005/05/26 18:02:13 appldev noship $ */
3: --===================
4: -- PUBLIC VARS
5: --===================

Line 8: CARRIER_ID WSH_CARRIERS.CARRIER_ID%TYPE,

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,

Line 9: FREIGHT_CODE WSH_CARRIERS.FREIGHT_CODE%TYPE,

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,

Line 10: SCAC_CODE WSH_CARRIERS.SCAC_CODE%TYPE DEFAULT NULL,

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,

Line 11: MANIFESTING_ENABLED_FLAG WSH_CARRIERS.MANIFESTING_ENABLED_FLAG%TYPE DEFAULT NULL,

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,

Line 12: CURRENCY_CODE WSH_CARRIERS.CURRENCY_CODE%TYPE DEFAULT NULL,

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,

Line 13: ATTRIBUTE_CATEGORY WSH_CARRIERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

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,

Line 14: ATTRIBUTE1 WSH_CARRIERS.ATTRIBUTE1%TYPE DEFAULT NULL,

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,

Line 15: ATTRIBUTE2 WSH_CARRIERS.ATTRIBUTE2%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,

Line 16: ATTRIBUTE3 WSH_CARRIERS.ATTRIBUTE3%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,

Line 17: ATTRIBUTE4 WSH_CARRIERS.ATTRIBUTE4%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,

Line 18: ATTRIBUTE5 WSH_CARRIERS.ATTRIBUTE5%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,

Line 19: ATTRIBUTE6 WSH_CARRIERS.ATTRIBUTE6%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,

Line 20: ATTRIBUTE7 WSH_CARRIERS.ATTRIBUTE7%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,

Line 21: ATTRIBUTE8 WSH_CARRIERS.ATTRIBUTE8%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,

Line 22: ATTRIBUTE9 WSH_CARRIERS.ATTRIBUTE9%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,

Line 23: ATTRIBUTE10 WSH_CARRIERS.ATTRIBUTE10%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,

Line 24: ATTRIBUTE11 WSH_CARRIERS.ATTRIBUTE11%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,

Line 25: ATTRIBUTE12 WSH_CARRIERS.ATTRIBUTE12%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 ,

Line 26: ATTRIBUTE13 WSH_CARRIERS.ATTRIBUTE13%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 ,

Line 27: ATTRIBUTE14 WSH_CARRIERS.ATTRIBUTE14%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 ,

Line 28: ATTRIBUTE15 WSH_CARRIERS.ATTRIBUTE15%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 ,

Line 29: CREATION_DATE WSH_CARRIERS.CREATION_DATE%TYPE ,

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

Line 30: CREATED_BY WSH_CARRIERS.CREATED_BY%TYPE ,

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,

Line 31: LAST_UPDATE_DATE WSH_CARRIERS.LAST_UPDATE_DATE%TYPE ,

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,

Line 32: LAST_UPDATED_BY WSH_CARRIERS.LAST_UPDATED_BY%TYPE ,

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,

Line 35: MAX_NUM_STOPS_PERMITTED WSH_CARRIERS.MAX_NUM_STOPS_PERMITTED%TYPE DEFAULT NULL,

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,

Line 36: MAX_TOTAL_DISTANCE WSH_CARRIERS.MAX_TOTAL_DISTANCE%TYPE DEFAULT NULL,

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,

Line 37: MAX_TOTAL_TIME WSH_CARRIERS.MAX_TOTAL_TIME%TYPE DEFAULT NULL,

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,

Line 38: ALLOW_INTERSPERSE_LOAD WSH_CARRIERS.ALLOW_INTERSPERSE_LOAD%TYPE DEFAULT NULL,

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,

Line 39: MAX_LAYOVER_TIME WSH_CARRIERS.MAX_LAYOVER_TIME%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,

Line 40: MIN_LAYOVER_TIME WSH_CARRIERS.MIN_LAYOVER_TIME%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,

Line 41: MAX_TOTAL_DISTANCE_IN_24HR WSH_CARRIERS.MAX_TOTAL_DISTANCE_IN_24HR%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,

Line 42: MAX_DRIVING_TIME_IN_24HR WSH_CARRIERS.MAX_DRIVING_TIME_IN_24HR%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,

Line 43: MAX_DUTY_TIME_IN_24HR WSH_CARRIERS.MAX_DUTY_TIME_IN_24HR%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,

Line 44: ALLOW_CONTINUOUS_MOVE WSH_CARRIERS.ALLOW_CONTINUOUS_MOVE%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,

Line 45: MAX_CM_DISTANCE WSH_CARRIERS.MAX_CM_DISTANCE%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,

Line 46: MAX_CM_TIME WSH_CARRIERS.MAX_CM_TIME%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,

Line 47: MAX_CM_DH_DISTANCE WSH_CARRIERS.MAX_CM_DH_DISTANCE%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,

Line 48: MAX_CM_DH_TIME WSH_CARRIERS.MAX_CM_DH_TIME%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,

Line 49: MAX_SIZE_WIDTH WSH_CARRIERS.MAX_SIZE_WIDTH%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,

Line 50: MAX_SIZE_HEIGHT WSH_CARRIERS.MAX_SIZE_LENGTH%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,

Line 51: MAX_SIZE_LENGTH WSH_CARRIERS.MAX_SIZE_LENGTH%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,

Line 52: MIN_SIZE_WIDTH WSH_CARRIERS.MIN_SIZE_WIDTH%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,

Line 53: MIN_SIZE_HEIGHT WSH_CARRIERS.MIN_SIZE_HEIGHT%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,

Line 54: MIN_SIZE_LENGTH WSH_CARRIERS.MIN_SIZE_LENGTH%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,

Line 55: TIME_UOM WSH_CARRIERS.TIME_UOM%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,

Line 56: DIMENSION_UOM WSH_CARRIERS.DIMENSION_UOM%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,

Line 57: DISTANCE_UOM WSH_CARRIERS.DISTANCE_UOM%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,

Line 58: MAX_OUT_OF_ROUTE WSH_CARRIERS.MAX_OUT_OF_ROUTE%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,

Line 59: CM_FREE_DH_MILEAGE WSH_CARRIERS.CM_FREE_DH_MILEAGE%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,

Line 60: MIN_CM_DISTANCE WSH_CARRIERS.MIN_CM_DISTANCE%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,

Line 61: CM_FIRST_LOAD_DISCOUNT WSH_CARRIERS.CM_FIRST_LOAD_DISCOUNT%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,

Line 62: MIN_CM_TIME WSH_CARRIERS.MIN_CM_TIME%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,

Line 63: UNIT_RATE_BASIS WSH_CARRIERS.UNIT_RATE_BASIS%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,

Line 64: WEIGHT_UOM WSH_CARRIERS.WEIGHT_UOM%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,

Line 65: VOLUME_UOM WSH_CARRIERS.VOLUME_UOM%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,

Line 66: GENERIC_FLAG WSH_CARRIERS.GENERIC_FLAG%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,

Line 67: FREIGHT_BILL_AUTO_APPROVAL WSH_CARRIERS.FREIGHT_BILL_AUTO_APPROVAL%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,

Line 68: FREIGHT_AUDIT_LINE_LEVEL WSH_CARRIERS.FREIGHT_AUDIT_LINE_LEVEL%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,

Line 69: SUPPLIER_ID WSH_CARRIERS.SUPPLIER_ID%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,

Line 70: SUPPLIER_SITE_ID WSH_CARRIERS.SUPPLIER_SITE_ID%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

Line 71: CM_RATE_VARIANT WSH_CARRIERS.CM_RATE_VARIANT%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,

Line 72: DISTANCE_CALCULATION_METHOD WSH_CARRIERS.DISTANCE_CALCULATION_METHOD%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,

Line 73: ORIGIN_DSTN_SURCHARGE_LEVEL WSH_CARRIERS.ORIGIN_DSTN_SURCHARGE_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,

Line 75: DIM_DIMENSIONAL_FACTOR WSH_CARRIERS.DIM_DIMENSIONAL_FACTOR%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

Line 76: DIM_WEIGHT_UOM WSH_CARRIERS.DIM_WEIGHT_UOM%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

Line 77: DIM_VOLUME_UOM WSH_CARRIERS.DIM_VOLUME_UOM%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: );

Line 78: DIM_DIMENSION_UOM WSH_CARRIERS.DIM_DIMENSION_UOM%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:

Line 79: DIM_MIN_PACK_VOL WSH_CARRIERS.DIM_MIN_PACK_VOL%TYPE DEFAULT NULL

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:

Line 248: carrier_id wsh_carriers.carrier_id%type,

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,

Line 249: freight_code wsh_carriers.freight_code%type,

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,

Line 250: scac_code wsh_carriers.scac_code%type,

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,

Line 251: manifesting_enabled_flag wsh_carriers.manifesting_enabled_flag%type,

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,

Line 252: currency_code wsh_carriers.currency_code%type,

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,

Line 253: generic_flag wsh_carriers.generic_flag%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);

Line 279: -- COMMENT : Creates or updates a record in wsh_carriers

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,

Line 418: END WSH_CARRIERS_GRP;

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;