2: /* $Header: FTELANES.pls 120.1 2005/06/28 22:48:37 pkaliyam noship $ */
3:
4: TYPE lane_rec IS RECORD (
5: action VARCHAR2(10),
6: carrier_id fte_lanes.carrier_id%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
3:
4: TYPE lane_rec IS RECORD (
5: action VARCHAR2(10),
6: carrier_id fte_lanes.carrier_id%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
4: TYPE lane_rec IS RECORD (
5: action VARCHAR2(10),
6: carrier_id fte_lanes.carrier_id%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
5: action VARCHAR2(10),
6: carrier_id fte_lanes.carrier_id%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
6: carrier_id fte_lanes.carrier_id%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
7: lane_id fte_lanes.lane_id%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
8: origin_id fte_lanes.origin_id%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
9: destination_id fte_lanes.destination_id%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
10: distance fte_lanes.distance%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
11: distance_uom fte_lanes.distance_uom%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
12: transit_time fte_lanes.transit_time%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
13: transit_time_uom fte_lanes.transit_time_uom%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
14: basis fte_lanes.basis%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
15: comm_fc_class_code fte_lanes.comm_fc_class_code%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
16: effective_date fte_lanes.effective_date%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
17: expiry_date fte_lanes.expiry_date%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
18: pricelist_view_flag fte_lanes.pricelist_view_flag%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
19: editable_flag fte_lanes.editable_flag%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
20: lane_number fte_lanes.lane_number%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
28: equipment_type_code fte_lanes.equipment_type_code%TYPE,
21: mode_of_transportation_code fte_lanes.mode_of_transportation_code%TYPE,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
28: equipment_type_code fte_lanes.equipment_type_code%TYPE,
29: container_all_flag BOOLEAN,
22: additional_instructions fte_lanes.additional_instructions%TYPE,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
28: equipment_type_code fte_lanes.equipment_type_code%TYPE,
29: container_all_flag BOOLEAN,
30: basis_flag BOOLEAN,
23: special_handling fte_lanes.special_handling%TYPE,
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
28: equipment_type_code fte_lanes.equipment_type_code%TYPE,
29: container_all_flag BOOLEAN,
30: basis_flag BOOLEAN,
31: line_number NUMBER);
24: lane_type fte_lanes.lane_type%TYPE,
25: tariff_name fte_lanes.tariff_name%TYPE,
26: service_type_code fte_lanes.service_type_code%TYPE,
27: commodity_catg_id fte_lanes.commodity_catg_id%TYPE,
28: equipment_type_code fte_lanes.equipment_type_code%TYPE,
29: container_all_flag BOOLEAN,
30: basis_flag BOOLEAN,
31: line_number NUMBER);
32: