DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on FTE_TL_CORE

Line 1846: FTE_TL_CORE.tl_core (

1842: i:=p_trip_index_start;
1843: WHILE(i <= p_trip_index_end)
1844: LOOP
1845:
1846: FTE_TL_CORE.tl_core (
1847: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
1848: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
1849: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
1850: x_trip_charges_rec => l_trip_charges_rec,

Line 2197: FTE_TL_CORE.tl_core (

2193: LOOP
2194:
2195: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'trip index:'||i||'stop ref'||FTE_TL_CACHE.g_tl_trip_rows(i).stop_reference);
2196:
2197: FTE_TL_CORE.tl_core (
2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2200: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
2201: x_trip_charges_rec => l_trip_charges_rec,

Line 2633: FTE_TL_CORE.tl_core (

2629:
2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2631:
2632:
2633: FTE_TL_CORE.tl_core (
2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),
2635: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2636: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index),
2637: x_trip_charges_rec => l_trip_charges_rec,

Line 2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,

2735: p_allocate_flag IN VARCHAR2,
2736: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
2738: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,
2741: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2742: x_return_status OUT NOCOPY VARCHAR2) IS
2743:

Line 2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

2744:
2745: i NUMBER;
2746: j NUMBER;
2747: k NUMBER;
2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;
2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

Line 2771: FTE_TL_CORE.TL_Core_Multiple (

2767:
2768:
2769: l_exceptions_tab.delete;
2770:
2771: FTE_TL_CORE.TL_Core_Multiple (
2772: p_start_trip_index=>p_start_trip_index,
2773: p_end_trip_index=>p_end_trip_index,
2774: p_trip_tab=>FTE_TL_CACHE.g_tl_trip_rows,
2775: p_stop_tab=>FTE_TL_CACHE.g_tl_trip_stop_rows,

Line 3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,

3288: p_schedule_rows IN dbms_utility.number_array,
3289: p_vehicle_rows IN dbms_utility.number_array,
3290: p_start_trip_index IN NUMBER,
3291: p_end_trip_index IN NUMBER,
3292: p_exceptions_tab IN FTE_TL_CORE.tl_exceptions_tab_type,
3293: x_lane_sched_sum_rows IN OUT NOCOPY dbms_utility.number_array,
3294: x_lane_sched_curr_rows IN OUT NOCOPY dbms_utility.name_array,
3295: x_summary_cache_ref OUT NOCOPY dbms_utility.number_array,
3296: x_return_status OUT NOCOPY Varchar2) IS

Line 3420: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

3416:
3417: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
3418: i NUMBER;
3419: l_request_id NUMBER;
3420: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3421: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3422: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3423: l_summary_cache_ref dbms_utility.number_array;
3424:

Line 3774: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

3770:
3771: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
3772: i NUMBER;
3773: l_request_id NUMBER;
3774: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3775: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3776: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3777: l_summary_cache_ref dbms_utility.number_array;
3778:

Line 4237: FTE_TL_CORE.tl_core (

4233:
4234: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Now Rating Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
4240: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
4241: x_trip_charges_rec => l_trip_charges_rec,

Line 5021: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

5017:
5018: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5019: i NUMBER;
5020: l_request_id NUMBER;
5021: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;

Line 5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;

5355: l_vehicle_rows dbms_utility.number_array;
5356:
5357: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5358: l_request_id NUMBER;
5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;