APPS.ASO_VALIDATE_PRICING_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 178

       l_req_line_rec.UPDATED_ADJUSTED_UNIT_PRICE := p_Line_rec.line_quote_price;

Line: 281

         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);

Line: 535

      l_control_rec.TEMP_TABLE_INSERT_FLAG := 'Y';

Line: 615

      /*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');

Line: 626

	     /*For this line_id update the pricing_status_code in the x_qte_line_tbl*/
		j := x_qte_line_tbl.FIRST;