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

Line 1431: l_first_line_index_tab dbms_utility.number_array;

1427:
1428: i NUMBER;
1429: j NUMBER;
1430: l_first_line_index_offset NUMBER;
1431: l_first_line_index_tab dbms_utility.number_array;
1432: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1433: l_api_name CONSTANT VARCHAR2(30) := 'Append_Rates';
1434: l_return_status VARCHAR2(1);
1435:

Line 1526: l_value dbms_utility.number_array;

1522: l_values_tab FTE_TRIP_RATING_GRP.Sort_Value_Tab_Type;
1523: i NUMBER;
1524: j NUMBER;
1525: l_value_rec FTE_TRIP_RATING_GRP.Sort_Value_Rec_Type;
1526: l_value dbms_utility.number_array;
1527: l_sorted_index dbms_utility.number_array;
1528: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
1529:
1530: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 1527: l_sorted_index dbms_utility.number_array;

1523: i NUMBER;
1524: j NUMBER;
1525: l_value_rec FTE_TRIP_RATING_GRP.Sort_Value_Rec_Type;
1526: l_value dbms_utility.number_array;
1527: l_sorted_index dbms_utility.number_array;
1528: l_source_header_rates_tab FTE_PROCESS_REQUESTS.fte_source_header_rates_tab;
1529:
1530: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1531: l_api_name CONSTANT VARCHAR2(30) := 'Sort_Source_Rates';

Line 1614: l_lane_rows dbms_utility.number_array;

1610: x_return_status OUT NOCOPY Varchar2)
1611: IS
1612:
1613: i NUMBER;
1614: l_lane_rows dbms_utility.number_array;
1615: l_schedule_rows dbms_utility.number_array;
1616: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1617: l_api_name CONSTANT VARCHAR2(30) := 'OM_TL_Rate';
1618: l_return_status VARCHAR2(1);

Line 1615: l_schedule_rows dbms_utility.number_array;

1611: IS
1612:
1613: i NUMBER;
1614: l_lane_rows dbms_utility.number_array;
1615: l_schedule_rows dbms_utility.number_array;
1616: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
1617: l_api_name CONSTANT VARCHAR2(30) := 'OM_TL_Rate';
1618: l_return_status VARCHAR2(1);
1619:

Line 1990: l_lane_rows dbms_utility.number_array;

1986: l_lane_rate NUMBER;
1987: l_lane_rate_uom VARCHAR2(10);
1988: l_lane_fct_price fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1989: l_lane_fct_charge fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1990: l_lane_rows dbms_utility.number_array;
1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;

Line 1991: l_schedule_rows dbms_utility.number_array;

1987: l_lane_rate_uom VARCHAR2(10);
1988: l_lane_fct_price fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1989: l_lane_fct_charge fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1990: l_lane_rows dbms_utility.number_array;
1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;

Line 1992: l_vehicle_rows dbms_utility.number_array;

1988: l_lane_fct_price fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1989: l_lane_fct_charge fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1990: l_lane_rows dbms_utility.number_array;
1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;
1996: l_tl_curr_rows dbms_utility.name_array;

Line 1993: l_ref_rows dbms_utility.number_array;

1989: l_lane_fct_charge fte_freight_pricing.Freight_Cost_Temp_Tab_Type;
1990: l_lane_rows dbms_utility.number_array;
1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;
1996: l_tl_curr_rows dbms_utility.name_array;
1997: i NUMBER;

Line 1994: l_tl_base_rows dbms_utility.number_array;

1990: l_lane_rows dbms_utility.number_array;
1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;
1996: l_tl_curr_rows dbms_utility.name_array;
1997: i NUMBER;
1998: j NUMBER;

Line 1995: l_tl_chrg_rows dbms_utility.number_array;

1991: l_schedule_rows dbms_utility.number_array;
1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;
1996: l_tl_curr_rows dbms_utility.name_array;
1997: i NUMBER;
1998: j NUMBER;
1999: k NUMBER;

Line 1996: l_tl_curr_rows dbms_utility.name_array;

1992: l_vehicle_rows dbms_utility.number_array;
1993: l_ref_rows dbms_utility.number_array;
1994: l_tl_base_rows dbms_utility.number_array;
1995: l_tl_chrg_rows dbms_utility.number_array;
1996: l_tl_curr_rows dbms_utility.name_array;
1997: i NUMBER;
1998: j NUMBER;
1999: k NUMBER;
2000: kk NUMBER;

Line 2001: l_lane_out_rows dbms_utility.number_array;

1997: i NUMBER;
1998: j NUMBER;
1999: k NUMBER;
2000: kk NUMBER;
2001: l_lane_out_rows dbms_utility.number_array;
2002: l_schedule_out_rows dbms_utility.number_array;
2003: l_vehicle_out_rows dbms_utility.number_array;
2004: --Bug 6625274 Added l_origin_id and l_destination_id variables to pass origin and destination to TL_FREIGHT_ESTIMATE
2005: l_origin_id NUMBER;

Line 2002: l_schedule_out_rows dbms_utility.number_array;

1998: j NUMBER;
1999: k NUMBER;
2000: kk NUMBER;
2001: l_lane_out_rows dbms_utility.number_array;
2002: l_schedule_out_rows dbms_utility.number_array;
2003: l_vehicle_out_rows dbms_utility.number_array;
2004: --Bug 6625274 Added l_origin_id and l_destination_id variables to pass origin and destination to TL_FREIGHT_ESTIMATE
2005: l_origin_id NUMBER;
2006: l_destination_id NUMBER;

Line 2003: l_vehicle_out_rows dbms_utility.number_array;

1999: k NUMBER;
2000: kk NUMBER;
2001: l_lane_out_rows dbms_utility.number_array;
2002: l_schedule_out_rows dbms_utility.number_array;
2003: l_vehicle_out_rows dbms_utility.number_array;
2004: --Bug 6625274 Added l_origin_id and l_destination_id variables to pass origin and destination to TL_FREIGHT_ESTIMATE
2005: l_origin_id NUMBER;
2006: l_destination_id NUMBER;
2007: