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,
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,
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,
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,
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,
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,
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 ,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 ,
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,
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 ,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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
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
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: );
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:
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 (
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:
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: --===================
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
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: --===================
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,