64: lane_service_rec
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE schedule_rec IS RECORD (
68: vessel_name fte_schedules.vessel_name%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE schedule_rec IS RECORD (
68: vessel_name fte_schedules.vessel_name%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
66:
67: TYPE schedule_rec IS RECORD (
68: vessel_name fte_schedules.vessel_name%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
67: TYPE schedule_rec IS RECORD (
68: vessel_name fte_schedules.vessel_name%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
68: vessel_name fte_schedules.vessel_name%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
69: vessel_type fte_schedules.vessel_type%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
70: voyage_number fte_schedules.voyage_number%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
71: arrival_date_indicator fte_schedules.arrival_date_indicator%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
72: transit_time fte_schedules.transit_time%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
73: port_of_loading fte_schedules.port_of_loading%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
74: port_of_discharge fte_schedules.port_of_discharge%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
75: frequency_type fte_schedules.frequency_type%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
76: frequency fte_schedules.frequency%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
77: frequency_arrival fte_schedules.frequency_arrival%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
78: departure_time fte_schedules.departure_time%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
79: arrival_time fte_schedules.arrival_time%TYPE,
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
80: departure_date fte_schedules.departure_date%TYPE,
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
88:
81: arrival_date fte_schedules.arrival_date%TYPE,
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
88:
89: TYPE schedule_tbl IS TABLE OF
82: effective_date fte_schedules.effective_date%TYPE,
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
88:
89: TYPE schedule_tbl IS TABLE OF
90: fte_schedules%ROWTYPE
83: expiry_date fte_schedules.expiry_date%TYPE,
84: transit_time_uom fte_schedules.transit_time_uom%TYPE,
85: lane_id fte_schedules.lane_id%TYPE,
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
88:
89: TYPE schedule_tbl IS TABLE OF
90: fte_schedules%ROWTYPE
91: INDEX BY BINARY_INTEGER;
86: schedules_id fte_schedules.schedules_id%TYPE,
87: lane_number fte_schedules.lane_number%TYPE);
88:
89: TYPE schedule_tbl IS TABLE OF
90: fte_schedules%ROWTYPE
91: INDEX BY BINARY_INTEGER;
92:
93: TYPE prc_parameter_rec IS RECORD (
94: value_from fte_prc_parameters.value_from%TYPE,