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

Line 157: x_sorted_index IN OUT NOCOPY dbms_utility.number_array,

153: p_values_tab IN Sort_Value_Tab_Type,
154: p_low_index IN NUMBER,
155: p_hi_index IN NUMBER,
156: p_sort_type IN VARCHAR2,--To support variations in the future
157: x_sorted_index IN OUT NOCOPY dbms_utility.number_array,
158: x_partition_index OUT NOCOPY NUMBER,
159: x_return_status OUT NOCOPY VARCHAR2)
160: IS
161:

Line 295: x_sorted_index IN OUT NOCOPY dbms_utility.number_array,

291: p_values_tab IN Sort_Value_Tab_Type,
292: p_low_index IN NUMBER,
293: p_hi_index IN NUMBER,
294: p_sort_type IN VARCHAR2,--To support variations in the future
295: x_sorted_index IN OUT NOCOPY dbms_utility.number_array,
296: x_return_status OUT NOCOPY VARCHAR2)
297: IS
298:
299: l_partition_index NUMBER;

Line 411: x_sorted_index OUT NOCOPY dbms_utility.number_array,

407:
408: PROCEDURE Sort(
409: p_values_tab IN Sort_Value_Tab_Type,
410: p_sort_type IN VARCHAR2,--To support variations in the future
411: x_sorted_index OUT NOCOPY dbms_utility.number_array,
412: x_return_status OUT NOCOPY VARCHAR2)
413:
414: IS
415: l_return_status VARCHAR2(1);

Line 537: l_lane_xref dbms_utility.number_array;

533: l_lane_price_tab wsh_util_core.id_tab_type;
534: l_lane_curr_tab wsh_util_core.column_tab_type;
535: l_sched_price_tab wsh_util_core.id_tab_type;
536: l_sched_curr_tab wsh_util_core.column_tab_type;
537: l_lane_xref dbms_utility.number_array;
538: l_sched_xref dbms_utility.number_array;
539:
540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;

Line 538: l_sched_xref dbms_utility.number_array;

534: l_lane_curr_tab wsh_util_core.column_tab_type;
535: l_sched_price_tab wsh_util_core.id_tab_type;
536: l_sched_curr_tab wsh_util_core.column_tab_type;
537: l_lane_xref dbms_utility.number_array;
538: l_sched_xref dbms_utility.number_array;
539:
540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;

Line 541: l_lane_rows dbms_utility.number_array;

537: l_lane_xref dbms_utility.number_array;
538: l_sched_xref dbms_utility.number_array;
539:
540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;

Line 542: l_schedule_rows dbms_utility.number_array;

538: l_sched_xref dbms_utility.number_array;
539:
540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;

Line 543: l_vehicle_rows dbms_utility.number_array;

539:
540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:

Line 544: l_lane_sched_sum_rows dbms_utility.number_array;

540: -- variables for tl_trip_price_compare
541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;

Line 545: l_lane_sched_curr_rows dbms_utility.name_array;

541: l_lane_rows dbms_utility.number_array;
542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;

Line 546: l_tl_xref dbms_utility.number_array;

542: l_schedule_rows dbms_utility.number_array;
543: l_vehicle_rows dbms_utility.number_array;
544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;
550: l_exploded_vehicle_rows dbms_utility.number_array;

Line 548: l_exploded_lane_rows dbms_utility.number_array;

544: l_lane_sched_sum_rows dbms_utility.number_array;
545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;
550: l_exploded_vehicle_rows dbms_utility.number_array;
551: l_exploded_ref_rows dbms_utility.number_array;
552:

Line 549: l_exploded_schedule_rows dbms_utility.number_array;

545: l_lane_sched_curr_rows dbms_utility.name_array;
546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;
550: l_exploded_vehicle_rows dbms_utility.number_array;
551: l_exploded_ref_rows dbms_utility.number_array;
552:
553: l_output_count NUMBER;

Line 550: l_exploded_vehicle_rows dbms_utility.number_array;

546: l_tl_xref dbms_utility.number_array;
547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;
550: l_exploded_vehicle_rows dbms_utility.number_array;
551: l_exploded_ref_rows dbms_utility.number_array;
552:
553: l_output_count NUMBER;
554: l_ref NUMBER;

Line 551: l_exploded_ref_rows dbms_utility.number_array;

547:
548: l_exploded_lane_rows dbms_utility.number_array;
549: l_exploded_schedule_rows dbms_utility.number_array;
550: l_exploded_vehicle_rows dbms_utility.number_array;
551: l_exploded_ref_rows dbms_utility.number_array;
552:
553: l_output_count NUMBER;
554: l_ref NUMBER;
555: k NUMBER;

Line 2641: x_ref OUT NOCOPY dbms_utility.number_array,

2637: PROCEDURE Search_Multi_ShipMethods(
2638: p_ss_attr_rec IN FTE_SS_ATTR_REC,
2639: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2640: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
2641: x_ref OUT NOCOPY dbms_utility.number_array,
2642: x_return_status OUT NOCOPY VARCHAR2)
2643: IS
2644: l_match_result VARCHAR2(1);
2645: i NUMBER;

Line 3160: p_input_ref IN dbms_utility.number_array)

3156: END Display_Rank_Rec;
3157:
3158: PROCEDURE Display_Rank_Tab(
3159: p_rank_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3160: p_input_ref IN dbms_utility.number_array)
3161: IS
3162: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3163: i NUMBER;
3164: BEGIN

Line 3243: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks

3239:
3240:
3241: PROCEDURE Seq_Tender_Sort(
3242: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3243: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3244: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3245: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3246: x_return_status OUT NOCOPY VARCHAR2)
3247: IS

Line 3245: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks

3241: PROCEDURE Seq_Tender_Sort(
3242: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3243: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3244: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3245: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3246: x_return_status OUT NOCOPY VARCHAR2)
3247: IS
3248: i NUMBER;
3249: l_single_currency VARCHAR2(3);

Line 3255: l_sorted_index dbms_utility.number_array;

3251: l_time_uom VARCHAR2(3);
3252: l_transit_time NUMBER;
3253: l_values_tab Sort_Value_Tab_Type;
3254: l_values_rec Sort_Value_Rec_Type;
3255: l_sorted_index dbms_utility.number_array;
3256: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3257: l_return_status VARCHAR2(1);
3258: BEGIN
3259:

Line 3391: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks

3387: END Seq_Tender_Sort;
3388:
3389: PROCEDURE Remove_Duplicate_Lanes(
3390: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3391: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3392: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3393: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3394: x_return_status OUT NOCOPY VARCHAR2)
3395: IS

Line 3393: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks

3389: PROCEDURE Remove_Duplicate_Lanes(
3390: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3391: p_input_ref IN dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3392: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
3393: x_input_ref OUT NOCOPY dbms_utility.number_array ,-- Reference of p_ss_rate_sort_tab to input ranks
3394: x_return_status OUT NOCOPY VARCHAR2)
3395: IS
3396: i NUMBER;
3397: j NUMBER;

Line 3401: l_sorted_index dbms_utility.number_array;

3397: j NUMBER;
3398: l_prev_index NUMBER;
3399: l_values_tab Sort_Value_Tab_Type;
3400: l_values_rec Sort_Value_Rec_Type;
3401: l_sorted_index dbms_utility.number_array;
3402: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3403:
3404: l_eliminated_index dbms_utility.number_array;
3405:

Line 3404: l_eliminated_index dbms_utility.number_array;

3400: l_values_rec Sort_Value_Rec_Type;
3401: l_sorted_index dbms_utility.number_array;
3402: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
3403:
3404: l_eliminated_index dbms_utility.number_array;
3405:
3406: l_index NUMBER;
3407: l_result VARCHAR2(1);
3408: l_return_status VARCHAR2(1);

Line 3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

3663: l_sort_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670:
3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

Line 3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

3664: l_rate_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670:
3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3672:

Line 3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

3665: l_lane_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3666: l_elim_rank_tab FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type;
3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670:
3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3672:
3673: l_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids

Line 3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;

3667: l_lane_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3668: l_rate_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670:
3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3672:
3673: l_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3674: l_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3675: l_mode_tab FTE_CODE_TAB_TYPE;