APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_FREIGHT_COSTS

Line 1745: FROM wsh_freight_costs

1741:
1742: cursor c_get_dleg_summ_recs (c_dleg_id NUMBER)
1743: is
1744: SELECT freight_cost_id
1745: FROM wsh_freight_costs
1746: WHERE delivery_leg_id = c_dleg_id
1747: AND line_type_code = 'SUMMARY'
1748: AND delivery_detail_id IS NULL ;
1749:

Line 2019: FROM WSH_FREIGHT_COSTS

2015:
2016: l_fc_count := 0;
2017:
2018: SELECT count(freight_cost_id) INTO l_fc_count
2019: FROM WSH_FREIGHT_COSTS
2020: WHERE delivery_leg_id = g_dlv_leg_tab(i).delivery_leg_id
2021: AND (
2022: ( charge_source_code = 'PRICING_ENGINE'
2023: AND line_type_code <> 'SUMMARY'

Line 2042: DELETE FROM WSH_FREIGHT_COSTS

2038: -- TO DO: handle locking issues
2039:
2040: IF (l_fc_count >0) THEN
2041:
2042: DELETE FROM WSH_FREIGHT_COSTS
2043: WHERE delivery_leg_id = g_dlv_leg_tab(i).delivery_leg_id
2044: AND (
2045: ( charge_source_code = 'PRICING_ENGINE'
2046: AND line_type_code <> 'SUMMARY'

Line 2069: UPDATE wsh_freight_costs

2065: CLOSE c_get_dleg_summ_recs;
2066:
2067:
2068: IF ( l_freight_cost_id IS NOT NULL ) THEN
2069: UPDATE wsh_freight_costs
2070: SET freight_cost_type_id = -1,
2071: charge_source_code = NULL,
2072: unit_amount = NULL,
2073: total_amount = NULL,

Line 4630: -- update wsh_freight_costs with l_lowest_rate

4626:
4627: END IF;
4628:
4629: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move freight costs to main...');
4630: -- update wsh_freight_costs with l_lowest_rate
4631: fte_freight_pricing.Move_fc_temp_to_main (
4632: p_delivery_leg_id => l_dleg_id,
4633: p_freight_cost_temp_price => l_lowest_lane_fct_price,
4634: p_freight_cost_temp_charge => l_lowest_lane_fct_charge,

Line 5702: -- update wsh_freight_costs with l_lowest_rate

5698: x_return_status := l_return_status;
5699: END IF;
5700: ELSE
5701: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'move freight costs to main...');
5702: -- update wsh_freight_costs with l_lowest_rate
5703: fte_freight_pricing.Move_fc_temp_to_main (
5704: p_delivery_leg_id => l_dleg_id,
5705: p_freight_cost_temp_price => l_lowest_lane_fct_price,
5706: p_freight_cost_temp_charge => l_lowest_lane_fct_charge,