DBA Data[Home] [Help]

APPS.FTE_LANE_PKG dependencies on FTE_SCHEDULES

Line 68: vessel_name fte_schedules.vessel_name%TYPE,

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,

Line 69: vessel_type fte_schedules.vessel_type%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,

Line 70: voyage_number fte_schedules.voyage_number%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,

Line 71: arrival_date_indicator fte_schedules.arrival_date_indicator%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,

Line 72: transit_time fte_schedules.transit_time%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,

Line 73: port_of_loading fte_schedules.port_of_loading%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,

Line 74: port_of_discharge fte_schedules.port_of_discharge%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,

Line 75: frequency_type fte_schedules.frequency_type%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,

Line 76: frequency fte_schedules.frequency%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,

Line 77: frequency_arrival fte_schedules.frequency_arrival%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,

Line 78: departure_time fte_schedules.departure_time%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,

Line 79: arrival_time fte_schedules.arrival_time%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,

Line 80: departure_date fte_schedules.departure_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,

Line 81: arrival_date fte_schedules.arrival_date%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,

Line 82: effective_date fte_schedules.effective_date%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,

Line 83: expiry_date fte_schedules.expiry_date%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);

Line 84: transit_time_uom fte_schedules.transit_time_uom%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:

Line 85: lane_id fte_schedules.lane_id%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:
89: TYPE schedule_tbl IS TABLE OF

Line 86: schedules_id fte_schedules.schedules_id%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
90: fte_schedules%ROWTYPE

Line 87: lane_number fte_schedules.lane_number%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
91: INDEX BY BINARY_INTEGER;

Line 90: fte_schedules%ROWTYPE

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,