The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT uom_for_num_of_units
FROM wsh_global_parameters;
SELECT fpp.lane_id,
fppd.lane_function,
fppd.parameter_sub_type,
fppd.parameter_name,
fpp.value_from,
fppd.default_value_from
FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
WHERE fppd.parameter_id = fpp.parameter_id (+)
AND fpp.lane_id (+) = c_lane_id
AND fppd.lane_function = c_lane_function
AND fppd.parameter_type = 'RULE'
AND fppd.parameter_sub_type = c_pattern_name
ORDER BY fppd.parameter_sub_type, fppd.parameter_name;
SELECT DISTINCT fppd.parameter_sub_type pattern_name
FROM fte_prc_parameter_defaults fppd
WHERE fppd.lane_function = c_lane_function
AND fppd.parameter_type = 'RULE'
ORDER BY 1;
g_lane_rules_tab.DELETE;
l_def_values.delete;
SELECT fpp.parameter_instance_id,fpp.lane_id,
fppd.lane_function,fppd.parameter_sub_type, fppd.parameter_name,
nvl(fpp.value_from,fppd.default_value_from),
nvl(fpp.value_to,fppd.default_value_to),
fpp.uom_class, fpp.uom_code, fpp.currency_code
FROM fte_prc_parameter_defaults fppd, fte_prc_parameters fpp
WHERE fppd.parameter_id = fpp.parameter_id (+)
AND fpp.lane_id (+) = c_lane_id
AND fppd.parameter_type = 'PARAMETER'
ORDER BY fppd.parameter_type, fppd.parameter_sub_type, fppd.parameter_name;
g_lane_parameters.DELETE;
SELECT
wc.dim_dimensional_factor,
wc.dim_weight_uom,
wc.dim_volume_uom,
wc.dim_dimension_uom,
wc.dim_min_pack_vol
FROM
wsh_carriers wc
WHERE
wc.carrier_id=p_carrier_id;
SELECT
wcs.dim_dimensional_factor,
wcs.dim_weight_uom,
wcs.dim_volume_uom,
wcs.dim_dimension_uom,
wcs.dim_min_pack_vol
FROM
wsh_carrier_services wcs
WHERE
wcs.carrier_id = p_carrier_id
AND wcs.service_level = p_service_code;
l_set_num :=1; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
l_set_num :=2; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
WHEN fte_freight_pricing_util.g_delete_set_failed THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
l_set_num :=2; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
g_bumped_rolledup_lines.DELETE;
l_set_num :=1; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
g_bumped_rolledup_lines.DELETE;
l_set_num :=2; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
g_bumped_rolledup_lines.DELETE;
l_set_num :=1; --set to delete
fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
x_return_status => l_return_status);
fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
raise fte_freight_pricing_util.g_delete_set_failed;
g_bumped_rolledup_lines.DELETE;
WHEN fte_freight_pricing_util.g_delete_set_failed THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
x_summary_lanesched_price OUT NOCOPY NUMBER,
x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2 )
IS
l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
x_fc_main_update_rows(j).delivery_leg_id := l_leg_id_array(i);
x_fc_main_update_rows(j).delivery_id := l_delivery_id_array(i);
x_fc_main_update_rows(j).freight_cost_id := fte_freight_pricing.get_fc_id_from_dleg(l_leg_id_array(i));
x_fc_main_update_rows(j).line_type_code := 'SUMMARY';
x_fc_main_update_rows(j).freight_cost_type_id := l_freight_cost_type_id;
x_fc_main_update_rows(j).unit_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
x_fc_main_update_rows(j).total_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
x_fc_main_update_rows(j).currency_code := l_currency_code;
x_fc_main_update_rows(j).charge_source_code := 'PRICING_ENGINE';
x_fc_main_update_rows(j).estimated_flag := 'Y';
SELECT TO_NUMBER(segment2)
FROM mtl_categories
WHERE category_id = c_category_id;
x_fc_main_update_rows OUT NOCOPY fte_freight_pricing.Freight_Cost_Main_Tab_Type,
x_summary_lanesched_price OUT NOCOPY NUMBER,
x_summary_lanesched_price_uom OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2 )
IS
l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
l_main_update_count NUMBER;
l_main_update_count:=0;
l_pricing_engine_rows.DELETE;
FTE_FREIGHT_PRICING.g_rolledup_lines.DELETE;
l_pricing_attribute_rows.DELETE;
x_fc_main_update_rows(j).delivery_leg_id := l_leg_id_array(i);
x_fc_main_update_rows(j).delivery_id := l_delivery_id_array(i);
x_fc_main_update_rows(j).freight_cost_id := fte_freight_pricing.get_fc_id_from_dleg(l_leg_id_array(i));
x_fc_main_update_rows(j).line_type_code := 'SUMMARY';
x_fc_main_update_rows(j).freight_cost_type_id := l_freight_cost_type_id;
x_fc_main_update_rows(j).unit_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
x_fc_main_update_rows(j).total_amount := round(l_delivery_summary(l_delivery_id_array(i)),2);
x_fc_main_update_rows(j).currency_code := l_currency_code;
x_fc_main_update_rows(j).charge_source_code := 'PRICING_ENGINE';
x_fc_main_update_rows(j).estimated_flag := 'Y';