29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_action_code IN VARCHAR2,
33: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_action_code IN VARCHAR2,
33: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_action_code IN VARCHAR2,
33: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
32: p_action_code IN VARCHAR2,
33: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
33: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
36: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
38: x_stop_id OUT NOCOPY NUMBER,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
39: --add trip stop info rec fields
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
40: pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
41: pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42: pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
43: pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44: pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45: pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
46: pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
47: pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
48: pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
49: pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50: pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
51: pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
52: pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53: pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54: pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
55: pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
56: pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
57: pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
58: pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
59: pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
60: pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
61: pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
62: pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
63: pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
64: pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
65: pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66: pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
67: pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
68: pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
69: pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
70: pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71: pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
72: pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73: pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
74: pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75: pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
76: pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77: pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
78: pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
79: pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
80: pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
81: pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82: pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
83: pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
84: pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85: pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86: pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
87: pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
89: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
91: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
94: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
95: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
96: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
97: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
98: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
99: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
100: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
101: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
102: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
103: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
104: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
105: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
106: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
107: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
108: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
109: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
117: p_shipments_type_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
111: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
117: p_shipments_type_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
118: );
119:
112: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
117: p_shipments_type_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
118: );
119:
120: -- Wrapper around wsh_trip_stops_pub.Stop_Action for deleting stops
113: p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114: p_is_temp IN VARCHAR2 DEFAULT 'N',
115: p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116: p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
117: p_shipments_type_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
118: );
119:
120: -- Wrapper around wsh_trip_stops_pub.Stop_Action for deleting stops
121: -- PROCEDURE : Stop_Action
186: x_msg_data OUT NOCOPY VARCHAR2,
187: x_trip_id OUT NOCOPY NUMBER,
188: x_trip_name OUT NOCOPY VARCHAR2,
189: p_action_code IN VARCHAR2,
190: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
187: x_trip_id OUT NOCOPY NUMBER,
188: x_trip_name OUT NOCOPY VARCHAR2,
189: p_action_code IN VARCHAR2,
190: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
188: x_trip_name OUT NOCOPY VARCHAR2,
189: p_action_code IN VARCHAR2,
190: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
189: p_action_code IN VARCHAR2,
190: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
190: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
191: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
195: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
196: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
197: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
201: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
204: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
221: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
222: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
225: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
226: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
227: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
228: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
232: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
233: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
234: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
235: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
236: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
237: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
239: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
240: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
241: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243: p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
246: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247: p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250: p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
251: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
252: p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253: p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
254: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
262: );
255: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
262: );
263:
256: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
262: );
263:
264:
257: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
262: );
263:
264:
265:
288: x_LAST_UPDATE_DATE OUT NOCOPY DATE,
289: x_LAST_UPDATED_BY OUT NOCOPY NUMBER,
290: x_LAST_UPDATE_LOGIN OUT NOCOPY NUMBER,
291: p_action_code IN VARCHAR2,
292: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
289: x_LAST_UPDATED_BY OUT NOCOPY NUMBER,
290: x_LAST_UPDATE_LOGIN OUT NOCOPY NUMBER,
291: p_action_code IN VARCHAR2,
292: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
290: x_LAST_UPDATE_LOGIN OUT NOCOPY NUMBER,
291: p_action_code IN VARCHAR2,
292: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
291: p_action_code IN VARCHAR2,
292: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
292: p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
293: p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294: p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295: p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296: p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
297: p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
298: p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
299: p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300: p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301: p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302: p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
303: p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304: p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305: p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
306: p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307: p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308: p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309: p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310: p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311: p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312: p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313: p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314: p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315: p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316: p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317: p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318: p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319: p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320: p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
323: p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
324: p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
325: p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
327: p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
328: p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
329: p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
330: p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331: p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332: p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333: p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
334: p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
335: p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336: p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338: p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
339: p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
340: p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
341: p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
342: p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
343: p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
344: p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345: p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346: p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
348: p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: );
349: p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: );
357:
350: p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: );
357:
358:
351: p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352: p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353: p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354: p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355: p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356: );
357:
358:
359:
382: --========================================================================
383: -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
384: --
385: -- PARAMETERS: p_api_version_number known api version error number
386: -- p_init_msg_list FND_API.G_TRUE to reset list
387: -- p_trip_id_tab table of trip id's
388: -- p_action_prms Record of caller, phase, action_code and other
389: -- parameters specific to the actions.
390: -- x_action_out_rec Out rec based on actions.
410: --========================================================================
411: -- PROCEDURE : STOP_ACTION Wrapper API PUBLIC
412: --
413: -- PARAMETERS: p_api_version_number known api version error number
414: -- p_init_msg_list FND_API.G_TRUE to reset list
415: -- p_stop_id_tab table of stop id's
416: -- p_action_prms Record of caller, phase, action_code and other
417: -- parameters specific to the actions.
418: -- x_action_out_rec Out rec based on actions.
469:
470:
471: PROCEDURE REPRICE_TRIP (
472: p_api_version IN NUMBER DEFAULT 1.0,
473: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
474: p_trip_id IN NUMBER,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2
577: -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
578: -- Added for Rel 12
579: --
580: -- PARAMETERS: p_api_version_number known api version error number
581: -- p_init_msg_list FND_API.G_TRUE to reset list
582: -- x_return_status return status
583: -- x_msg_count number of messages in the list
584: -- x_msg_data text of messages
585: -- x_action_out_rec Out rec based on actions.
607: -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
608: -- Added for Rel 12
609: --
610: -- PARAMETERS: p_api_version_number known api version error number
611: -- p_init_msg_list FND_API.G_TRUE to reset list
612: -- x_return_status return status
613: -- x_msg_count number of messages in the list
614: -- x_msg_data text of messages
615: -- x_action_out_rec Out rec based on actions.