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 DBMS_UTILITY

Line 1757: x_stop_input_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,

1753:
1754: PROCEDURE Create_Stop_Hashes(
1755: p_trip_index IN NUMBER,
1756: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
1757: x_stop_input_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
1758: x_stop_output_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
1759: x_return_status OUT NOCOPY Varchar2) IS
1760:
1761: i NUMBER;

Line 1758: x_stop_output_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,

1754: PROCEDURE Create_Stop_Hashes(
1755: p_trip_index IN NUMBER,
1756: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
1757: x_stop_input_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
1758: x_stop_output_hash IN OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
1759: x_return_status OUT NOCOPY Varchar2) IS
1760:
1761: i NUMBER;
1762: l_stop_index_first NUMBER;

Line 1915: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,

1911: PROCEDURE Get_StopOff_Chrg_Per_Stop(
1912: p_stopoff_charge IN NUMBER,
1913: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
1914: p_alloc_params IN TL_allocation_params_rec_type,
1915: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
1916: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
1917: x_stopoff_charge IN OUT NOCOPY NUMBER,
1918: x_return_status OUT NOCOPY Varchar2) IS
1919:

Line 1916: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,

1912: p_stopoff_charge IN NUMBER,
1913: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
1914: p_alloc_params IN TL_allocation_params_rec_type,
1915: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
1916: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
1917: x_stopoff_charge IN OUT NOCOPY NUMBER,
1918: x_return_status OUT NOCOPY Varchar2) IS
1919:
1920: l_stop_count NUMBER;

Line 2101: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,

2097: p_trip_index IN NUMBER,
2098: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
2099: p_stop_charges_tab IN
2100: FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2101: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
2102: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
2103: p_cost_allocation_parameters IN TL_allocation_params_rec_type,
2104: x_dleg_alloc_tab IN OUT NOCOPY TL_dleg_alloc_TAB_TYPE ,
2105: x_return_status OUT NOCOPY Varchar2) IS

Line 2102: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,

2098: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
2099: p_stop_charges_tab IN
2100: FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2101: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
2102: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
2103: p_cost_allocation_parameters IN TL_allocation_params_rec_type,
2104: x_dleg_alloc_tab IN OUT NOCOPY TL_dleg_alloc_TAB_TYPE ,
2105: x_return_status OUT NOCOPY Varchar2) IS
2106:

Line 2800: p_child_dleg_hash IN DBMS_UTILITY.NUMBER_ARRAY,

2796:
2797:
2798: PROCEDURE Get_Top_Most_Dleg(
2799: p_child_dleg_id IN NUMBER,
2800: p_child_dleg_hash IN DBMS_UTILITY.NUMBER_ARRAY,
2801: p_dleg_alloc_tab IN TL_dleg_alloc_TAB_TYPE,
2802: x_top_dleg_id OUT NOCOPY NUMBER,
2803: x_return_status OUT NOCOPY Varchar2)
2804: IS

Line 3039: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;

3035: x_dleg_alloc_tab IN OUT NOCOPY TL_dleg_alloc_TAB_TYPE ,
3036: x_return_status OUT NOCOPY Varchar2)
3037: IS
3038:
3039: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
3040: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
3041: l_child_dleg_index_first NUMBER;
3042: l_child_dleg_index_last NUMBER;
3043: l_dleg_index_first NUMBER;

Line 3040: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;

3036: x_return_status OUT NOCOPY Varchar2)
3037: IS
3038:
3039: l_parent_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
3040: l_child_dleg_hash DBMS_UTILITY.NUMBER_ARRAY;
3041: l_child_dleg_index_first NUMBER;
3042: l_child_dleg_index_last NUMBER;
3043: l_dleg_index_first NUMBER;
3044: l_dleg_index_last NUMBER;

Line 3353: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,

3349: p_trip_index IN NUMBER,
3350: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
3351: p_stop_charges_tab IN
3352: FTE_TL_CACHE.TL_trip_stop_output_tab_type,
3353: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
3354: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
3355: p_cost_allocation_parameters IN TL_allocation_params_rec_type,
3356: x_dleg_alloc_tab IN OUT NOCOPY TL_dleg_alloc_TAB_TYPE ,
3357: x_return_status OUT NOCOPY Varchar2) IS

Line 3354: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,

3350: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
3351: p_stop_charges_tab IN
3352: FTE_TL_CACHE.TL_trip_stop_output_tab_type,
3353: p_stop_input_hash IN DBMS_UTILITY.NUMBER_ARRAY,
3354: p_stop_output_hash IN DBMS_UTILITY.NUMBER_ARRAY,
3355: p_cost_allocation_parameters IN TL_allocation_params_rec_type,
3356: x_dleg_alloc_tab IN OUT NOCOPY TL_dleg_alloc_TAB_TYPE ,
3357: x_return_status OUT NOCOPY Varchar2) IS
3358:

Line 8105: l_stop_input_hash DBMS_UTILITY.NUMBER_ARRAY;

8101: FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
8102: x_return_status OUT NOCOPY VARCHAR2) IS
8103:
8104:
8105: l_stop_input_hash DBMS_UTILITY.NUMBER_ARRAY;
8106: l_stop_output_hash DBMS_UTILITY.NUMBER_ARRAY;
8107: l_dleg_alloc_tab TL_dleg_alloc_TAB_TYPE;
8108:
8109: l_return_status VARCHAR2(1);

Line 8106: l_stop_output_hash DBMS_UTILITY.NUMBER_ARRAY;

8102: x_return_status OUT NOCOPY VARCHAR2) IS
8103:
8104:
8105: l_stop_input_hash DBMS_UTILITY.NUMBER_ARRAY;
8106: l_stop_output_hash DBMS_UTILITY.NUMBER_ARRAY;
8107: l_dleg_alloc_tab TL_dleg_alloc_TAB_TYPE;
8108:
8109: l_return_status VARCHAR2(1);
8110:

Line 8422: l_lane_rows dbms_utility.number_array;

8418: l_dlv_id NUMBER;
8419: l_map_index NUMBER;
8420:
8421:
8422: l_lane_rows dbms_utility.number_array;
8423: l_schedule_rows dbms_utility.number_array;
8424: l_vehicle_rows dbms_utility.number_array;
8425:
8426: BEGIN

Line 8423: l_schedule_rows dbms_utility.number_array;

8419: l_map_index NUMBER;
8420:
8421:
8422: l_lane_rows dbms_utility.number_array;
8423: l_schedule_rows dbms_utility.number_array;
8424: l_vehicle_rows dbms_utility.number_array;
8425:
8426: BEGIN
8427:

Line 8424: l_vehicle_rows dbms_utility.number_array;

8420:
8421:
8422: l_lane_rows dbms_utility.number_array;
8423: l_schedule_rows dbms_utility.number_array;
8424: l_vehicle_rows dbms_utility.number_array;
8425:
8426: BEGIN
8427:
8428: