DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on FTE_TL_COST_ALLOCATION

Line 1802: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;

1798: j NUMBER;
1799: k NUMBER;
1800: l_cm_discount NUMBER;
1801: l_effective_discount NUMBER;
1802: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
1803: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
1804:
1805: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1806: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

Line 1823: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(

1819:
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1821:
1822:
1823: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
1824: x_cost_allocation_parameters=> l_cost_allocation_parameters,
1825: x_return_status=> l_return_status);
1826:
1827: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 1879: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(

1875: END IF;
1876:
1877: --Get total cost of the trip(without cm disc)
1878:
1879: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(
1880: p_trip_index=> i,
1881: p_trip_charges_rec=> l_trip_charges_rec,
1882: p_stop_charges_tab=> l_stop_charges_tab,
1883: x_charge=>l_total_trip_charge,

Line 1957: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(

1953: LOOP
1954: IF((FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N') AND
1955: NOT((FTE_TL_CACHE.g_tl_carrier_pref_rows(i).cm_first_load_discount_flag='N')AND (i= l_store_trip_rows.FIRST)))
1956: THEN
1957: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
1958: p_discount=> l_effective_discount,
1959: x_trip_charges_rec=> l_store_trip_rows(i),
1960: x_return_status=> l_return_status);
1961: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 1983: FTE_TL_COST_ALLOCATION.Scale_Stop_Charges(

1979: THEN
1980: EXIT;
1981: END IF;
1982:
1983: FTE_TL_COST_ALLOCATION.Scale_Stop_Charges(
1984: p_discount=> l_effective_discount,
1985: x_stop_charges_rec=> l_store_trip_stop_rows(j),
1986: x_return_status=> l_return_status);
1987:

Line 2017: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(

2013:
2014:
2015: END IF;
2016:
2017: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(
2018: p_trip_index=> i,
2019: p_trip_charges_rec=> l_trip_charges_rec,
2020: p_stop_charges_tab=> l_stop_charges_tab,
2021: p_cost_allocation_parameters=> l_cost_allocation_parameters,

Line 2140: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;

2136: k NUMBER;
2137: l_total_trip_charge NUMBER;
2138: l_factor NUMBER;
2139:
2140: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2141: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2144:

Line 2173: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(

2169:
2170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2171:
2172:
2173: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2174: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2175: x_return_status=> l_return_status);
2176:
2177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 2221: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(

2217: END IF;
2218:
2219: --Get total cost of the trip(without cm disc)
2220:
2221: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(
2222: p_trip_index=> i,
2223: p_trip_charges_rec=> l_trip_charges_rec,
2224: p_stop_charges_tab=> l_stop_charges_tab,
2225: x_charge=>l_total_trip_charge,

Line 2294: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(

2290:
2291: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Effective discount (Rate)trip: '||
2292: FTE_TL_CACHE.g_tl_trip_rows(i).trip_id||' : '||l_factor);
2293:
2294: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
2295: p_discount=> l_factor,
2296: x_trip_charges_rec=> l_store_trip_rows(i),
2297: x_return_status=> l_return_status);
2298:

Line 2319: FTE_TL_COST_ALLOCATION.Scale_Stop_Charges(

2315: THEN
2316: EXIT;
2317: END IF;
2318:
2319: FTE_TL_COST_ALLOCATION.Scale_Stop_Charges(
2320: p_discount=> l_factor,
2321: x_stop_charges_rec=> l_store_trip_stop_rows(j),
2322: x_return_status=> l_return_status);
2323:

Line 2354: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(

2350:
2351: END IF;
2352:
2353:
2354: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(
2355: p_trip_index=> i,
2356: p_trip_charges_rec=> l_trip_charges_rec,
2357: p_stop_charges_tab=> l_stop_charges_tab,
2358: p_cost_allocation_parameters=> l_cost_allocation_parameters,

Line 2617: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;

2613:
2614:
2615: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2616: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2617: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2618: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
2619:
2620: l_return_status VARCHAR2(1);
2621:

Line 2656: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(

2652: END IF;
2653: END IF;
2654:
2655:
2656: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2657: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2658: x_return_status=> l_return_status);
2659:
2660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 2671: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(

2667:
2668: l_cost_allocation_parameters.comparison_request_id := p_request_id;
2669: l_cost_allocation_parameters.output_type := p_output_type;
2670:
2671: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(
2672: p_trip_index=> p_trip_index,
2673: p_trip_charges_rec=> l_trip_charges_rec,
2674: p_stop_charges_tab=> l_stop_charges_tab,
2675: p_cost_allocation_parameters=> l_cost_allocation_parameters,

Line 2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_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;
2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2754:
2755:
2756: l_return_status VARCHAR2(1);
2757:

Line 2803: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(

2799:
2800:
2801:
2802:
2803: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2804: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2805: x_return_status=> l_return_status);
2806:
2807: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 2847: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(

2843: x_lane_sched_sum_rows(k):=NULL;
2844:
2845: --Populate summary rates
2846:
2847: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(
2848: p_trip_index=> i,
2849: p_trip_charges_rec=> l_trip_charges_tab(i),
2850: p_stop_charges_tab=> l_stop_charges_one_trip_tab,
2851: x_charge=>x_lane_sched_sum_rows(k),

Line 2870: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(

2866: IF (p_allocate_flag = 'Y')
2867: THEN
2868:
2869:
2870: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(
2871: p_trip_index=> i,
2872: p_trip_charges_rec=> l_trip_charges_tab(i),
2873: p_stop_charges_tab=> l_stop_charges_one_trip_tab,
2874: p_cost_allocation_parameters=> l_cost_allocation_parameters,

Line 4065: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(

4061: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Base_Accessory_Charges','start');
4062:
4063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4064:
4065: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(
4066: p_trip_index=>p_trip_index,
4067: p_trip_charges_rec=>p_trip_charges_rec,
4068: p_stop_charges_tab=>p_stop_charges_tab,
4069: x_charge=> l_charge,

Line 5606: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;

5602: IS
5603:
5604:
5605: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5606: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
5607:
5608:
5609: l_return_status VARCHAR2(1);
5610: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 5623: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(

5619: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5620:
5621:
5622:
5623: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
5624: x_cost_allocation_parameters => l_cost_allocation_parameters,
5625: x_return_status => l_return_status);
5626:
5627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 5638: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(

5634:
5635:
5636: l_cost_allocation_parameters.output_type := 'M';
5637:
5638: FTE_TL_COST_ALLOCATION.TL_COST_ALLOCATION(
5639: p_trip_index => p_trip_index,
5640: p_trip_charges_rec => p_trip_charges_rec,
5641: p_stop_charges_tab => p_stop_charges_tab,
5642: p_cost_allocation_parameters=> l_cost_allocation_parameters,