15: -- PUBLIC VARS
16: --===================
17:
18: TYPE Trip_Pub_Rec_Type IS RECORD (
19: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: --===================
17:
18: TYPE Trip_Pub_Rec_Type IS RECORD (
19: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
17:
18: TYPE Trip_Pub_Rec_Type IS RECORD (
19: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
18: TYPE Trip_Pub_Rec_Type IS RECORD (
19: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
19: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
20: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
21: ARRIVE_AFTER_TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ARRIVE_AFTER_TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23: VEHICLE_ITEM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
24: VEHICLE_ITEM_DESC VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
25: VEHICLE_ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
26: VEHICLE_ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
27: VEHICLE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
28: VEHICLE_NUM_PREFIX VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
29: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
30: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
31: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
32: ROUTE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
33: ROUTING_INSTRUCTIONS VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
34: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
35: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
36: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
43: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
44: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
45: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
46: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
47: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
48: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
49: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
51: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
52: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
53: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
55: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
56: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
57: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
58: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
66: SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR);
59: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
66: SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR);
67:
60: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
66: SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR);
67:
68: TYPE Action_Param_Rectype IS RECORD (
61: OPERATOR VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
66: SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR);
67:
68: TYPE Action_Param_Rectype IS RECORD (
69: ACTION_CODE VARCHAR2(500)
62: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
63: FREIGHT_TERMS_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
64: CARRIER_REFERENCE_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
65: CONSIGNEE_CARRIER_AC_NO VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
66: SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR);
67:
68: TYPE Action_Param_Rectype IS RECORD (
69: ACTION_CODE VARCHAR2(500)
70: ,ORGANIZATION_ID NUMBER
90: --========================================================================
91: -- PROCEDURE : Create_Update_Trip PUBLIC
92: --
93: -- PARAMETERS: p_api_version_number known api versionerror buffer
94: -- p_init_msg_list FND_API.G_TRUE to reset list
95: -- x_return_status return status
96: -- x_msg_count number of messages in the list
97: -- x_msg_data text of messages
98: -- p_trip_info Attributes for the trip entity
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_action_code IN VARCHAR2,
134: p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
135: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
136: x_trip_id OUT NOCOPY NUMBER,
137: x_trip_name OUT NOCOPY VARCHAR2);
138:
139:
140: --========================================================================
141: -- PROCEDURE : Trip_Action PUBLIC
142: --
143: -- PARAMETERS: p_api_version_number known api version error number
144: -- p_init_msg_list FND_API.G_TRUE to reset list
145: -- x_return_status return status
146: -- x_msg_count number of messages in the list
147: -- x_msg_data text of messages
148: -- p_action_code Trip action code. Valid action codes are
194: --========================================================================
195: -- PROCEDURE : Trip_Action PUBLIC
196: --
197: -- PARAMETERS: p_api_version_number known api version error number
198: -- p_init_msg_list FND_API.G_TRUE to reset list
199: -- p_commit FND_API.G_TRUE to commit
200: -- x_return_status return status
201: -- x_msg_count number of messages in the list
202: -- x_msg_data text of messages
195: -- PROCEDURE : Trip_Action PUBLIC
196: --
197: -- PARAMETERS: p_api_version_number known api version error number
198: -- p_init_msg_list FND_API.G_TRUE to reset list
199: -- p_commit FND_API.G_TRUE to commit
200: -- x_return_status return status
201: -- x_msg_count number of messages in the list
202: -- x_msg_data text of messages
203: -- p_action_param_rec Record of Parameters for various actions
236:
237: PROCEDURE Trip_Action
238: ( p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2,
240: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_action_param_rec IN WSH_TRIPS_PUB.Action_Param_Rectype,