5: -- PUBLIC VARS
6: --===================
7:
8: TYPE Trip_Pub_Rec_Type IS RECORD (
9: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
6: --===================
7:
8: TYPE Trip_Pub_Rec_Type IS RECORD (
9: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
7:
8: TYPE Trip_Pub_Rec_Type IS RECORD (
9: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
8: TYPE Trip_Pub_Rec_Type IS RECORD (
9: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
9: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
11: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
13: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
14: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
15: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
16: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
25: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
26: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
33: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
39: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
40: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42: CONSOLIDATION_ALLOWED VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
43: PLANNED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
45: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
46: -- anxsharm for Load Tender, increase to 30
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: LOAD_TENDER_STATUS VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
48: ROUTE_LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
49: LANE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
50: SCHEDULE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: BOOKING_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
52: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
53: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
54: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
55: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
63:
56: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
63:
64:
57: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
63:
64:
65: --Harmonizing Project -I
58: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
60: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
61: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
62: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR);
63:
64:
65: --Harmonizing Project -I
66: TYPE TripInRecType is RECORD(
130: --========================================================================
131: -- PROCEDURE : Create_Update_Trip PUBLIC
132: --
133: -- PARAMETERS: p_api_version_number known api versionerror buffer
134: -- p_init_msg_list FND_API.G_TRUE to reset list
135: -- x_return_status return status
136: -- x_msg_count number of messages in the list
137: -- x_msg_data text of messages
138: -- p_trip_info Attributes for the trip entity
156: --========================================================================
157: -- PROCEDURE : Trip_Action PUBLIC
158: --
159: -- PARAMETERS: p_api_version_number known api version error number
160: -- p_init_msg_list FND_API.G_TRUE to reset list
161: -- x_return_status return status
162: -- x_msg_count number of messages in the list
163: -- x_msg_data text of messages
164: -- p_trip_info Attributes for the trip entity
193: --========================================================================
194: -- PROCEDURE : Create_Update_Trip PUBLIC
195: --
196: -- PARAMETERS: p_api_version_number known api versionerror buffer
197: -- p_init_msg_list FND_API.G_TRUE to reset list
198: -- x_return_status return status
199: -- x_msg_count number of messages in the list
200: -- x_msg_data text of messages
201: -- p_trip_info Attributes for the trip entity
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_action_code IN VARCHAR2,
217: p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
218: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: x_trip_id OUT NOCOPY NUMBER,
220: x_trip_name OUT NOCOPY VARCHAR2);
221:
222:
223: --========================================================================
224: -- PROCEDURE : Trip_Action PUBLIC
225: --
226: -- PARAMETERS: p_api_version_number known api version error number
227: -- p_init_msg_list FND_API.G_TRUE to reset list
228: -- x_return_status return status
229: -- x_msg_count number of messages in the list
230: -- x_msg_data text of messages
231: -- p_action_code Trip action code. Valid action codes are