The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_req_line_rec.UPDATED_ADJUSTED_UNIT_PRICE := p_Line_rec.line_quote_price;
select line_id,
pricing_status_code,
pricing_status_text
from qp_preq_lines_tmp lines
where lines.line_type_code='LINE'
and lines.pricing_status_code in(
QP_PREQ_GRP.g_status_invalid_price_list,
QP_PREQ_GRP.g_sts_lhs_not_found,
QP_PREQ_GRP.g_status_formula_error,
QP_PREQ_GRP.g_status_other_errors,
fnd_api.g_ret_sts_unexp_error,
fnd_api.g_ret_sts_error,
QP_PREQ_GRP.g_status_calc_error,
QP_PREQ_GRP.g_status_uom_failure,
QP_PREQ_GRP.g_status_invalid_uom,
QP_PREQ_GRP.g_status_dup_price_list,
QP_PREQ_GRP.g_status_invalid_uom_conv,
QP_PREQ_GRP.g_status_invalid_incomp,
QP_PREQ_GRP.g_status_best_price_eval_error);
l_control_rec.TEMP_TABLE_INSERT_FLAG := 'Y';
/*Update all the errored records*/
FOR C_status_code_rec in C_status_code LOOP
IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: C_status_code_rec.line_id:'
||lx_req_line_rec.line_id,1,'N');
/*For this line_id update the pricing_status_code in the x_qte_line_tbl*/
j := x_qte_line_tbl.FIRST;