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_CACHE dependencies on DBMS_UTILITY

Line 248: g_tl_delivery_detail_hash DBMS_UTILITY.NUMBER_ARRAY;

244: --Delivery to delivery detail hash
245:
246: -- This is a hash indexed by delivery id, it returns an index into the Delivery detail map cache. It points to the begining of the list of
247: --dlv-details belonging to that dlv
248: g_tl_delivery_detail_hash DBMS_UTILITY.NUMBER_ARRAY;
249:
250:
251: --For MDC, all containers that are above the top level detail of deliveries
252: g_tl_int_shipment_line_rows FTE_FREIGHT_PRICING.shipment_line_tab_type;

Line 271: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,

267:
268: PROCEDURE TL_Build_Cache_For_Delivery(
269: p_wsh_new_delivery_id IN NUMBER,
270: p_wsh_delivery_leg_id IN NUMBER ,
271: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,
272: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,
273: x_return_status OUT NOCOPY VARCHAR2);
274:
275: PROCEDURE TL_Build_Cache_For_OM(

Line 272: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,

268: PROCEDURE TL_Build_Cache_For_Delivery(
269: p_wsh_new_delivery_id IN NUMBER,
270: p_wsh_delivery_leg_id IN NUMBER ,
271: p_lane_rows IN DBMS_UTILITY.NUMBER_ARRAY,
272: p_schedule_rows IN DBMS_UTILITY.NUMBER_ARRAY,
273: x_return_status OUT NOCOPY VARCHAR2);
274:
275: PROCEDURE TL_Build_Cache_For_OM(
276: x_return_status OUT NOCOPY VARCHAR2);

Line 280: p_lane_rows IN dbms_utility.number_array ,

276: x_return_status OUT NOCOPY VARCHAR2);
277:
278: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
279: p_wsh_trip_id IN Number ,
280: p_lane_rows IN dbms_utility.number_array ,
281: p_schedule_rows IN dbms_utility.number_array,
282: p_vehicle_rows IN dbms_utility.number_array,
283: x_return_status OUT NOCOPY Varchar2);
284:

Line 281: p_schedule_rows IN dbms_utility.number_array,

277:
278: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
279: p_wsh_trip_id IN Number ,
280: p_lane_rows IN dbms_utility.number_array ,
281: p_schedule_rows IN dbms_utility.number_array,
282: p_vehicle_rows IN dbms_utility.number_array,
283: x_return_status OUT NOCOPY Varchar2);
284:
285:

Line 282: p_vehicle_rows IN dbms_utility.number_array,

278: PROCEDURE TL_BUILD_CACHE_FOR_TRP_COMPARE(
279: p_wsh_trip_id IN Number ,
280: p_lane_rows IN dbms_utility.number_array ,
281: p_schedule_rows IN dbms_utility.number_array,
282: p_vehicle_rows IN dbms_utility.number_array,
283: x_return_status OUT NOCOPY Varchar2);
284:
285:
286: PROCEDURE TL_BUILD_CACHE_FOR_LCS(

Line 288: p_lane_rows IN dbms_utility.number_array ,

284:
285:
286: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
287: p_wsh_trip_id IN Number ,
288: p_lane_rows IN dbms_utility.number_array ,
289: p_schedule_rows IN dbms_utility.number_array ,
290: p_vehicle_rows IN dbms_utility.number_array,
291: x_return_status OUT NOCOPY Varchar2);
292:

Line 289: p_schedule_rows IN dbms_utility.number_array ,

285:
286: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
287: p_wsh_trip_id IN Number ,
288: p_lane_rows IN dbms_utility.number_array ,
289: p_schedule_rows IN dbms_utility.number_array ,
290: p_vehicle_rows IN dbms_utility.number_array,
291: x_return_status OUT NOCOPY Varchar2);
292:
293:

Line 290: p_vehicle_rows IN dbms_utility.number_array,

286: PROCEDURE TL_BUILD_CACHE_FOR_LCS(
287: p_wsh_trip_id IN Number ,
288: p_lane_rows IN dbms_utility.number_array ,
289: p_schedule_rows IN dbms_utility.number_array ,
290: p_vehicle_rows IN dbms_utility.number_array,
291: x_return_status OUT NOCOPY Varchar2);
292:
293:
294:

Line 319: p_lane_rows IN dbms_utility.number_array ,

315: x_return_status OUT NOCOPY VARCHAR2);
316:
317:
318: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
319: p_lane_rows IN dbms_utility.number_array ,
320: p_schedule_rows IN dbms_utility.number_array,
321: p_vehicle_rows IN dbms_utility.number_array,
322: p_pickup_location_id IN NUMBER,
323: p_dropoff_location_id IN NUMBER,

Line 320: p_schedule_rows IN dbms_utility.number_array,

316:
317:
318: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
319: p_lane_rows IN dbms_utility.number_array ,
320: p_schedule_rows IN dbms_utility.number_array,
321: p_vehicle_rows IN dbms_utility.number_array,
322: p_pickup_location_id IN NUMBER,
323: p_dropoff_location_id IN NUMBER,
324: p_ship_date IN DATE,

Line 321: p_vehicle_rows IN dbms_utility.number_array,

317:
318: PROCEDURE TL_BUILD_CACHE_FOR_ESTIMATE(
319: p_lane_rows IN dbms_utility.number_array ,
320: p_schedule_rows IN dbms_utility.number_array,
321: p_vehicle_rows IN dbms_utility.number_array,
322: p_pickup_location_id IN NUMBER,
323: p_dropoff_location_id IN NUMBER,
324: p_ship_date IN DATE,
325: p_delivery_date IN DATE,

Line 357: p_lane_rows IN dbms_utility.number_array ,

353:
354:
355: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
356: p_wsh_delivery_id IN Number ,
357: p_lane_rows IN dbms_utility.number_array ,
358: p_schedule_rows IN dbms_utility.number_array,
359: p_vehicle_rows IN dbms_utility.number_array,
360: p_dep_date IN DATE DEFAULT sysdate,
361: p_arr_date IN DATE DEFAULT sysdate,

Line 358: p_schedule_rows IN dbms_utility.number_array,

354:
355: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
356: p_wsh_delivery_id IN Number ,
357: p_lane_rows IN dbms_utility.number_array ,
358: p_schedule_rows IN dbms_utility.number_array,
359: p_vehicle_rows IN dbms_utility.number_array,
360: p_dep_date IN DATE DEFAULT sysdate,
361: p_arr_date IN DATE DEFAULT sysdate,
362: p_pickup_location_id IN NUMBER,

Line 359: p_vehicle_rows IN dbms_utility.number_array,

355: PROCEDURE TL_BUILD_CACHE_FOR_DLV_COMPARE(
356: p_wsh_delivery_id IN Number ,
357: p_lane_rows IN dbms_utility.number_array ,
358: p_schedule_rows IN dbms_utility.number_array,
359: p_vehicle_rows IN dbms_utility.number_array,
360: p_dep_date IN DATE DEFAULT sysdate,
361: p_arr_date IN DATE DEFAULT sysdate,
362: p_pickup_location_id IN NUMBER,
363: p_dropoff_location_id IN NUMBER,

Line 370: p_lane_rows IN dbms_utility.number_array ,

366:
367: PROCEDURE TL_BUILD_CACHE_FOR_OM(
368: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
369: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
370: p_lane_rows IN dbms_utility.number_array ,
371: p_schedule_rows IN dbms_utility.number_array,
372: p_vehicle_rows IN dbms_utility.number_array,
373: x_return_status OUT NOCOPY Varchar2);
374:

Line 371: p_schedule_rows IN dbms_utility.number_array,

367: PROCEDURE TL_BUILD_CACHE_FOR_OM(
368: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
369: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
370: p_lane_rows IN dbms_utility.number_array ,
371: p_schedule_rows IN dbms_utility.number_array,
372: p_vehicle_rows IN dbms_utility.number_array,
373: x_return_status OUT NOCOPY Varchar2);
374:
375:

Line 372: p_vehicle_rows IN dbms_utility.number_array,

368: p_source_header_rec IN FTE_PROCESS_REQUESTS.fte_source_header_rec,
369: p_source_lines_tab IN FTE_PROCESS_REQUESTS.fte_source_line_tab,
370: p_lane_rows IN dbms_utility.number_array ,
371: p_schedule_rows IN dbms_utility.number_array,
372: p_vehicle_rows IN dbms_utility.number_array,
373: x_return_status OUT NOCOPY Varchar2);
374:
375:
376: