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

Line 3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3518: l_stop_index NUMBER := 0;
3519:
3520:
3521:
3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3519:
3520:
3521:
3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3520:
3521:
3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3521:
3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3522: l_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3523: l_unit_loaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3524: l_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;

Line 3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3525: l_unit_unloaded_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3533:

Line 3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3526: l_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3533:
3534:

Line 3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3527: l_unit_cm_dist_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3533:
3534:
3535: j NUMBER;

Line 3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;

3528: l_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3529: l_unit_unit_base_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3530: l_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3531: l_unit_time_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3532: l_flat_price_tab DBMS_UTILITY.NUMBER_ARRAY;
3533:
3534:
3535: j NUMBER;
3536: l_trip_index NUMBER;

Line 4503: l_non_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;

4499: l_ipl_flag VARCHAR2(1);
4500:
4501:
4502: l_trip_index NUMBER;
4503: l_non_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4504: l_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4505: l_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4506: l_non_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4507:

Line 4504: l_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;

4500:
4501:
4502: l_trip_index NUMBER;
4503: l_non_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4504: l_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4505: l_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4506: l_non_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4507:
4508:

Line 4505: l_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;

4501:
4502: l_trip_index NUMBER;
4503: l_non_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4504: l_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4505: l_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4506: l_non_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4507:
4508:
4509: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;

Line 4506: l_non_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;

4502: l_trip_index NUMBER;
4503: l_non_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4504: l_dummy_row_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4505: l_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4506: l_non_dummy_ipl_count_tab DBMS_UTILITY.NUMBER_ARRAY;
4507:
4508:
4509: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4510: l_method_name VARCHAR2(50) := 'check_qp_ipl';

Line 4627: l_ipl_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;

4623:
4624: l_category VARCHAR2(30);
4625:
4626: l_trip_index NUMBER;
4627: l_ipl_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4628: l_error_flag_tab DBMS_UTILITY.NUMBER_ARRAY;
4629: l_line_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4630:
4631:

Line 4628: l_error_flag_tab DBMS_UTILITY.NUMBER_ARRAY;

4624: l_category VARCHAR2(30);
4625:
4626: l_trip_index NUMBER;
4627: l_ipl_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4628: l_error_flag_tab DBMS_UTILITY.NUMBER_ARRAY;
4629: l_line_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4630:
4631:
4632: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;

Line 4629: l_line_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;

4625:
4626: l_trip_index NUMBER;
4627: l_ipl_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4628: l_error_flag_tab DBMS_UTILITY.NUMBER_ARRAY;
4629: l_line_cnt_tab DBMS_UTILITY.NUMBER_ARRAY;
4630:
4631:
4632: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;
4633: l_method_name VARCHAR2(50) := 'check_tl_qp_op_err_multiple';

Line 4796: x_same_rate_map OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,

4792: p_start_trip_index IN NUMBER,
4793: p_end_trip_index IN NUMBER,
4794: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4795: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4796: x_same_rate_map OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
4797: x_return_status OUT NOCOPY VARCHAR2) IS
4798:
4799: i NUMBER;
4800: l_original_trip_index NUMBER;

Line 4801: l_carrier_hash DBMS_UTILITY.NUMBER_ARRAY;

4797: x_return_status OUT NOCOPY VARCHAR2) IS
4798:
4799: i NUMBER;
4800: l_original_trip_index NUMBER;
4801: l_carrier_hash DBMS_UTILITY.NUMBER_ARRAY;
4802:
4803: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4804: l_method_name VARCHAR2(50) := 'Identify_Same_Rate_Inputs';
4805:

Line 4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,

4854: p_start_trip_index IN NUMBER,
4855: p_end_trip_index IN NUMBER,
4856: p_trip_tab IN FTE_TL_CACHE.TL_trip_data_input_tab_type,
4857: p_stop_tab IN FTE_TL_CACHE.TL_trip_stop_input_tab_type,
4858: p_same_rate_map IN DBMS_UTILITY.NUMBER_ARRAY,
4859: x_trip_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE,
4860: x_stop_charges_tab IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4861: x_exceptions_tab IN OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
4862: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4940: l_same_rate_map DBMS_UTILITY.NUMBER_ARRAY;

4936: l_qp_output_line_rows QP_PREQ_GRP.LINE_TBL_TYPE;
4937: l_qp_output_detail_rows QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
4938: l_implicit_non_dummy_cnt NUMBER := 0;
4939:
4940: l_same_rate_map DBMS_UTILITY.NUMBER_ARRAY;
4941: l_exception_rec tl_exceptions_type;
4942: l_trip_rec FTE_TL_CACHE.TL_trip_data_input_rec_type;
4943: i NUMBER;
4944: l_return_status VARCHAR2(1);