eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TL_RATING dependencies on DBMS_UTILITY

Line 81: p_lane_rows IN dbms_utility.number_array ,

77: --rates the given TL trip, using lanes/schedules. Used for multileg search services
78:
79: PROCEDURE TL_TRIP_PRICE_COMPARE(
80: p_wsh_trip_id IN Number ,
81: p_lane_rows IN dbms_utility.number_array ,
82: p_schedule_rows IN dbms_utility.number_array,
83: p_vehicle_rows IN dbms_utility.number_array,
84: x_request_id IN OUT NOCOPY NUMBER,
85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

Line 82: p_schedule_rows IN dbms_utility.number_array,

78:
79: PROCEDURE TL_TRIP_PRICE_COMPARE(
80: p_wsh_trip_id IN Number ,
81: p_lane_rows IN dbms_utility.number_array ,
82: p_schedule_rows IN dbms_utility.number_array,
83: p_vehicle_rows IN dbms_utility.number_array,
84: x_request_id IN OUT NOCOPY NUMBER,
85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
86: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

Line 83: p_vehicle_rows IN dbms_utility.number_array,

79: PROCEDURE TL_TRIP_PRICE_COMPARE(
80: p_wsh_trip_id IN Number ,
81: p_lane_rows IN dbms_utility.number_array ,
82: p_schedule_rows IN dbms_utility.number_array,
83: p_vehicle_rows IN dbms_utility.number_array,
84: x_request_id IN OUT NOCOPY NUMBER,
85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
86: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
87: x_return_status OUT NOCOPY Varchar2);

Line 85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

81: p_lane_rows IN dbms_utility.number_array ,
82: p_schedule_rows IN dbms_utility.number_array,
83: p_vehicle_rows IN dbms_utility.number_array,
84: x_request_id IN OUT NOCOPY NUMBER,
85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
86: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
87: x_return_status OUT NOCOPY Varchar2);
88:
89:

Line 86: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

82: p_schedule_rows IN dbms_utility.number_array,
83: p_vehicle_rows IN dbms_utility.number_array,
84: x_request_id IN OUT NOCOPY NUMBER,
85: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
86: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
87: x_return_status OUT NOCOPY Varchar2);
88:
89:
90: -- This copies over rated from fte_freight_cost_temp to wsh_freight_costs

Line 114: p_lane_rows IN dbms_utility.number_array ,

110: --Used for Freight Estimate. Pickup/dropoff location can be null.
111: --It returns rates as base price, accessory charges
112:
113: PROCEDURE TL_FREIGHT_ESTIMATE(
114: p_lane_rows IN dbms_utility.number_array ,
115: p_schedule_rows IN dbms_utility.number_array,
116: p_vehicle_rows IN dbms_utility.number_array,
117: p_pickup_location_id IN NUMBER,
118: p_dropoff_location_id IN NUMBER,

Line 115: p_schedule_rows IN dbms_utility.number_array,

111: --It returns rates as base price, accessory charges
112:
113: PROCEDURE TL_FREIGHT_ESTIMATE(
114: p_lane_rows IN dbms_utility.number_array ,
115: p_schedule_rows IN dbms_utility.number_array,
116: p_vehicle_rows IN dbms_utility.number_array,
117: p_pickup_location_id IN NUMBER,
118: p_dropoff_location_id IN NUMBER,
119: p_ship_date IN DATE,

Line 116: p_vehicle_rows IN dbms_utility.number_array,

112:
113: PROCEDURE TL_FREIGHT_ESTIMATE(
114: p_lane_rows IN dbms_utility.number_array ,
115: p_schedule_rows IN dbms_utility.number_array,
116: p_vehicle_rows IN dbms_utility.number_array,
117: p_pickup_location_id IN NUMBER,
118: p_dropoff_location_id IN NUMBER,
119: p_ship_date IN DATE,
120: p_delivery_date IN DATE,

Line 127: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,

123: p_volume IN NUMBER,
124: p_volume_uom IN VARCHAR2,
125: p_distance IN NUMBER,
126: p_distance_uom in VARCHAR2,
127: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
128: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
129: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
130: x_return_status OUT NOCOPY Varchar2,
131: --Bug 6625274

Line 128: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,

124: p_volume_uom IN VARCHAR2,
125: p_distance IN NUMBER,
126: p_distance_uom in VARCHAR2,
127: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
128: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
129: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
130: x_return_status OUT NOCOPY Varchar2,
131: --Bug 6625274
132: p_origin_id IN NUMBER DEFAULT NULL,

Line 129: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

125: p_distance IN NUMBER,
126: p_distance_uom in VARCHAR2,
127: x_lane_sched_base_rows OUT NOCOPY dbms_utility.number_array,
128: x_lane_sched_acc_rows OUT NOCOPY dbms_utility.number_array,
129: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
130: x_return_status OUT NOCOPY Varchar2,
131: --Bug 6625274
132: p_origin_id IN NUMBER DEFAULT NULL,
133: p_destination_id IN NUMBER DEFAULT NULL);

Line 139: p_lane_rows IN dbms_utility.number_array,

135:
136:
137: PROCEDURE Get_Vehicles_For_LaneSchedules(
138: p_trip_id IN NUMBER DEFAULT NULL,
139: p_lane_rows IN dbms_utility.number_array,
140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,

Line 140: p_schedule_rows IN dbms_utility.number_array,

136:
137: PROCEDURE Get_Vehicles_For_LaneSchedules(
138: p_trip_id IN NUMBER DEFAULT NULL,
139: p_lane_rows IN dbms_utility.number_array,
140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,

Line 141: p_vehicle_rows IN dbms_utility.number_array,

137: PROCEDURE Get_Vehicles_For_LaneSchedules(
138: p_trip_id IN NUMBER DEFAULT NULL,
139: p_lane_rows IN dbms_utility.number_array,
140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
145: x_ref_rows OUT NOCOPY dbms_utility.number_array,

Line 142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,

138: p_trip_id IN NUMBER DEFAULT NULL,
139: p_lane_rows IN dbms_utility.number_array,
140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
145: x_ref_rows OUT NOCOPY dbms_utility.number_array,
146: x_return_status OUT NOCOPY Varchar2);

Line 143: x_lane_rows OUT NOCOPY dbms_utility.number_array,

139: p_lane_rows IN dbms_utility.number_array,
140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
145: x_ref_rows OUT NOCOPY dbms_utility.number_array,
146: x_return_status OUT NOCOPY Varchar2);
147:

Line 144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,

140: p_schedule_rows IN dbms_utility.number_array,
141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
145: x_ref_rows OUT NOCOPY dbms_utility.number_array,
146: x_return_status OUT NOCOPY Varchar2);
147:
148:

Line 145: x_ref_rows OUT NOCOPY dbms_utility.number_array,

141: p_vehicle_rows IN dbms_utility.number_array,
142: x_vehicle_rows OUT NOCOPY dbms_utility.number_array,
143: x_lane_rows OUT NOCOPY dbms_utility.number_array,
144: x_schedule_rows OUT NOCOPY dbms_utility.number_array,
145: x_ref_rows OUT NOCOPY dbms_utility.number_array,
146: x_return_status OUT NOCOPY Varchar2);
147:
148:
149:

Line 152: p_lane_rows IN dbms_utility.number_array ,

148:
149:
150: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
151: p_wsh_delivery_id IN Number ,
152: p_lane_rows IN dbms_utility.number_array ,
153: p_schedule_rows IN dbms_utility.number_array,
154: p_vehicle_rows IN dbms_utility.number_array,
155: p_dep_date IN DATE DEFAULT sysdate,
156: p_arr_date IN DATE DEFAULT sysdate,

Line 153: p_schedule_rows IN dbms_utility.number_array,

149:
150: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
151: p_wsh_delivery_id IN Number ,
152: p_lane_rows IN dbms_utility.number_array ,
153: p_schedule_rows IN dbms_utility.number_array,
154: p_vehicle_rows IN dbms_utility.number_array,
155: p_dep_date IN DATE DEFAULT sysdate,
156: p_arr_date IN DATE DEFAULT sysdate,
157: p_pickup_location_id IN NUMBER,

Line 154: p_vehicle_rows IN dbms_utility.number_array,

150: PROCEDURE TL_DELIVERY_PRICE_COMPARE(
151: p_wsh_delivery_id IN Number ,
152: p_lane_rows IN dbms_utility.number_array ,
153: p_schedule_rows IN dbms_utility.number_array,
154: p_vehicle_rows IN dbms_utility.number_array,
155: p_dep_date IN DATE DEFAULT sysdate,
156: p_arr_date IN DATE DEFAULT sysdate,
157: p_pickup_location_id IN NUMBER,
158: p_dropoff_location_id IN NUMBER,

Line 160: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,

156: p_arr_date IN DATE DEFAULT sysdate,
157: p_pickup_location_id IN NUMBER,
158: p_dropoff_location_id IN NUMBER,
159: x_request_id IN OUT NOCOPY NUMBER,
160: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
161: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
162: x_return_status OUT NOCOPY Varchar2);
163:
164:

Line 161: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,

157: p_pickup_location_id IN NUMBER,
158: p_dropoff_location_id IN NUMBER,
159: x_request_id IN OUT NOCOPY NUMBER,
160: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
161: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
162: x_return_status OUT NOCOPY Varchar2);
163:
164:
165:

Line 167: p_lane_rows IN dbms_utility.number_array ,

163:
164:
165:
166: PROCEDURE TL_OM_RATING(
167: p_lane_rows IN dbms_utility.number_array ,
168: p_schedule_rows IN dbms_utility.number_array,
169: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
170: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
171: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,

Line 168: p_schedule_rows IN dbms_utility.number_array,

164:
165:
166: PROCEDURE TL_OM_RATING(
167: p_lane_rows IN dbms_utility.number_array ,
168: p_schedule_rows IN dbms_utility.number_array,
169: p_lane_info_tab IN FTE_FREIGHT_RATING_PUB.lane_info_tab_type,
170: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
171: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
172: p_LCSS_flag IN VARCHAR2,

Line 181: p_lane_rows IN dbms_utility.number_array ,

177:
178:
179: PROCEDURE BEGIN_LCSS (
180: p_trip_id IN NUMBER,
181: p_lane_rows IN dbms_utility.number_array ,
182: x_trip_index OUT NOCOPY NUMBER,
183: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type ,
184: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
185: x_total_cost OUT NOCOPY NUMBER,

Line 205: p_lane_rows IN dbms_utility.number_array ,

201:
202:
203: PROCEDURE LCSS (
204: p_trip_id IN NUMBER,
205: p_lane_rows IN dbms_utility.number_array ,
206: x_return_status OUT NOCOPY VARCHAR2);
207:
208:
209: PROCEDURE Move_Dlv_Records_To_Main(