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_COST_ALLOCATION dependencies on WSH_TRIP_STOPS

Line 286: TYPE stop_id_tbl_type IS TABLE of wsh_trip_stops.stop_id%type INDEX BY BINARY_INTEGER;

282:
283: --Index for arrays
284: G_B_T_index NUMBER;
285:
286: TYPE stop_id_tbl_type IS TABLE of wsh_trip_stops.stop_id%type INDEX BY BINARY_INTEGER;
287: TYPE distance_to_next_stop_tbl_type IS TABLE of wsh_trip_stops.distance_to_next_stop%type INDEX BY BINARY_INTEGER;
288:
289: g_stop_id_tbl stop_id_tbl_type;
290: g_distance_to_next_stop_tbl distance_to_next_stop_tbl_type;

Line 287: TYPE distance_to_next_stop_tbl_type IS TABLE of wsh_trip_stops.distance_to_next_stop%type INDEX BY BINARY_INTEGER;

283: --Index for arrays
284: G_B_T_index NUMBER;
285:
286: TYPE stop_id_tbl_type IS TABLE of wsh_trip_stops.stop_id%type INDEX BY BINARY_INTEGER;
287: TYPE distance_to_next_stop_tbl_type IS TABLE of wsh_trip_stops.distance_to_next_stop%type INDEX BY BINARY_INTEGER;
288:
289: g_stop_id_tbl stop_id_tbl_type;
290: g_distance_to_next_stop_tbl distance_to_next_stop_tbl_type;
291:

Line 8116: l_distance_uom WSH_TRIP_STOPS.distance_uom%type;

8112:
8113: l_warning_count NUMBER:=0;
8114:
8115: i NUMBER;
8116: l_distance_uom WSH_TRIP_STOPS.distance_uom%type;
8117: l_stop_index_low NUMBER;
8118: l_stop_index_high NUMBER;
8119:
8120: CURSOR c_lock_wts(c_trip_id NUMBER)

Line 8123: FROM wsh_trip_stops

8119:
8120: CURSOR c_lock_wts(c_trip_id NUMBER)
8121: IS
8122: SELECT stop_id
8123: FROM wsh_trip_stops
8124: WHERE trip_id = c_trip_id
8125: FOR UPDATE NOWAIT;
8126:
8127: BEGIN

Line 8298: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'trying to get lock of wsh_trip_stops...');

8294: IF ((FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id <> FTE_TL_CACHE.FAKE_TRIP_ID) AND (p_cost_allocation_parameters.output_type='M' OR
8295: (p_cost_allocation_parameters.output_type='T'
8296: AND p_trip_index = FTE_TL_CACHE.g_tl_trip_rows.LAST))) THEN
8297:
8298: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'trying to get lock of wsh_trip_stops...');
8299: OPEN c_lock_wts(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
8300: CLOSE c_lock_wts;
8301: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'got update lock of wsh_trip_stops');
8302:

Line 8301: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'got update lock of wsh_trip_stops');

8297:
8298: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'trying to get lock of wsh_trip_stops...');
8299: OPEN c_lock_wts(FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
8300: CLOSE c_lock_wts;
8301: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'got update lock of wsh_trip_stops');
8302:
8303: l_stop_index_low := FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).stop_reference;
8304: IF p_cost_allocation_parameters.output_type='M' THEN
8305: IF p_trip_index = FTE_TL_CACHE.g_tl_trip_rows.LAST THEN

Line 8328: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk updating wsh_trip_stops...');

8324: END LOOP;
8325:
8326: l_distance_uom := FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).distance_uom;
8327:
8328: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk updating wsh_trip_stops...');
8329: FORALL i IN g_stop_id_tbl.FIRST..g_stop_id_tbl.LAST
8330: UPDATE wsh_trip_stops
8331: SET distance_to_next_stop = g_distance_to_next_stop_tbl(i),
8332: distance_uom = l_distance_uom

Line 8330: UPDATE wsh_trip_stops

8326: l_distance_uom := FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).distance_uom;
8327:
8328: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk updating wsh_trip_stops...');
8329: FORALL i IN g_stop_id_tbl.FIRST..g_stop_id_tbl.LAST
8330: UPDATE wsh_trip_stops
8331: SET distance_to_next_stop = g_distance_to_next_stop_tbl(i),
8332: distance_uom = l_distance_uom
8333: WHERE stop_id = g_stop_id_tbl(i);
8334: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk update wsh_trip_stops done');

Line 8334: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk update wsh_trip_stops done');

8330: UPDATE wsh_trip_stops
8331: SET distance_to_next_stop = g_distance_to_next_stop_tbl(i),
8332: distance_uom = l_distance_uom
8333: WHERE stop_id = g_stop_id_tbl(i);
8334: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk update wsh_trip_stops done');
8335:
8336: ELSE -- l_stop_index_low <= l_stop_index_high
8337: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,
8338: 'stop index range is wrong. wsh_trip_stops is not updated with distance');

Line 8338: 'stop index range is wrong. wsh_trip_stops is not updated with distance');

8334: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk update wsh_trip_stops done');
8335:
8336: ELSE -- l_stop_index_low <= l_stop_index_high
8337: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,
8338: 'stop index range is wrong. wsh_trip_stops is not updated with distance');
8339: END IF;
8340: END IF;
8341:
8342: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');