APPS.PO_ADVANCED_PRICE_PVT SQL Statements

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

Line: 616

      SELECT mum.uom_code
      INTO l_uom_code
      FROM mtl_units_of_measure mum
      WHERE mum.unit_of_measure = p_uom;

Line: 628

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'Directly Insert into Temp table');

Line: 683

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'Call INSERT_LINES2');

Line: 686

    QP_PREQ_GRP.INSERT_LINES2
    (p_line_index => l_line_index_tbl,
     p_line_type_code => l_line_type_code_tbl,
     p_pricing_effective_date => l_pricinl_effective_date_tbl,
     p_active_date_first => l_active_date_first_tbl,
     p_active_date_first_type => l_active_date_first_type_tbl,
     p_active_date_second => l_active_date_second_tbl,
     p_active_date_second_type => l_active_date_second_type_tbl,
     p_line_quantity => l_line_quantity_tbl,
     p_line_uom_code => l_line_uom_code_tbl,
     p_request_type_code => l_request_type_code_tbl,
     p_priced_quantity => l_priced_quantity_tbl,
     p_priced_uom_code => l_priced_uom_code_tbl,
     p_currency_code => l_currency_code_tbl,
     p_unit_price => l_unit_price_tbl,
     p_percent_price => l_percent_price_tbl,
     p_uom_quantity => l_uom_quantity_tbl,
     p_adjusted_unit_price => l_adjusted_unit_price_tbl,
     p_upd_adjusted_unit_price => l_upd_adjusted_unit_price_tbl,
     p_processed_flag => l_processed_flag_tbl,
     p_price_flag => l_price_flag_tbl,
     p_line_id => l_line_id_tbl,
     p_processing_order => l_processing_order_tbl,
     p_pricing_status_code => l_pricing_status_code_tbl,
     p_pricing_status_text => l_pricing_status_text_tbl,
     p_rounding_flag => l_rounding_flag_tbl,
     p_rounding_factor => l_rounding_factor_tbl,
     p_qualifiers_exist_flag => l_qualifiers_exist_flag_tbl,
     p_pricing_attrs_exist_flag => l_pricing_attrs_exist_flag_tbl,
     p_price_list_id => l_price_list_id_tbl,
     p_validated_flag => l_pl_validated_flag_tbl,
     p_price_request_code => l_price_request_code_tbl,
     p_usage_pricing_type => l_usage_pricing_type_tbl,
     p_line_category => l_line_category_tbl,
     p_line_unit_price => l_line_unit_price_tbl,
     p_list_price_override_flag => l_list_price_overide_flag_tbl,
     x_status_code => x_return_status,
     x_status_text => l_return_status_text);

Line: 727

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'After Calling INSERT_LINES2');

Line: 752

      SELECT POL.allow_price_override_flag
      INTO l_allow_price_override_flag
      FROM po_lines_all POL
      WHERE POL.po_header_id = p_agreement_id
      AND   POL.po_line_id = p_agreement_line_id;

Line: 787

    l_control_rec.temp_table_insert_flag := 'N';

Line: 883

  SELECT line_unit_price,
         adjusted_unit_price,
         pricing_status_code,
         pricing_status_text
  INTO   x_base_unit_price,
         x_unit_price,
         l_price_status_code,
         l_price_status_text
  FROM   QP_PREQ_LINES_TMP
  WHERE  line_id = l_line_id
  AND    (processed_code IS NULL OR processed_code <> 'INVALID');

Line: 1029

    SELECT purchase_basis,
         -- Bug 3343261: should use value_basis instead of matching_basis
         -- matching_basis,
           order_type_lookup_code
    INTO l_purchase_basis,
         -- Bug 3343261: should use value_basis instead of matching_basis
         -- l_matching_basis,
           l_value_basis
    FROM PO_LINE_TYPES
    WHERE line_type_id = p_line_type_id;

Line: 1396

        SELECT mum.uom_code
        INTO l_uom_code
        FROM mtl_units_of_measure mum
        WHERE mum.unit_of_measure = p_line_rec_tbl(j).unit_of_measure;

Line: 1408

        PO_LOG.stmt(l_log_head, d_pos,'Directly Insert into Temp table');

Line: 1463

      PO_LOG.stmt(l_log_head, d_pos,'Call INSERT_LINES2');

Line: 1466

    QP_PREQ_GRP.INSERT_LINES2
    (p_line_index => l_line_index_tbl,
     p_line_type_code => l_line_type_code_tbl,
     p_pricing_effective_date => l_pricinl_effective_date_tbl,
     p_active_date_first => l_active_date_first_tbl,
     p_active_date_first_type => l_active_date_first_type_tbl,
     p_active_date_second => l_active_date_second_tbl,
     p_active_date_second_type => l_active_date_second_type_tbl,
     p_line_quantity => l_line_quantity_tbl,
     p_line_uom_code => l_line_uom_code_tbl,
     p_request_type_code => l_request_type_code_tbl,
     p_priced_quantity => l_priced_quantity_tbl,
     p_priced_uom_code => l_priced_uom_code_tbl,
     p_currency_code => l_currency_code_tbl,
     p_unit_price => l_unit_price_tbl,
     p_percent_price => l_percent_price_tbl,
     p_uom_quantity => l_uom_quantity_tbl,
     p_adjusted_unit_price => l_adjusted_unit_price_tbl,
     p_upd_adjusted_unit_price => l_upd_adjusted_unit_price_tbl,
     p_processed_flag => l_processed_flag_tbl,
     p_price_flag => l_price_flag_tbl,
     p_line_id => l_line_id_tbl,
     p_processing_order => l_processing_order_tbl,
     p_pricing_status_code => l_pricing_status_code_tbl,
     p_pricing_status_text => l_pricing_status_text_tbl,
     p_rounding_flag => l_rounding_flag_tbl,
     p_rounding_factor => l_rounding_factor_tbl,
     p_qualifiers_exist_flag => l_qualifiers_exist_flag_tbl,
     p_pricing_attrs_exist_flag => l_pricing_attrs_exist_flag_tbl,
     p_price_list_id => l_price_list_id_tbl,
     p_validated_flag => l_pl_validated_flag_tbl,
     p_price_request_code => l_price_request_code_tbl,
     p_usage_pricing_type => l_usage_pricing_type_tbl,
     p_line_category => l_line_category_tbl,
     p_line_unit_price => l_line_unit_price_tbl,
     p_list_price_override_flag => l_list_price_overide_flag_tbl,
     x_status_code => x_return_status,
     x_status_text => l_return_status_text);

Line: 1507

      PO_LOG.stmt(l_log_head, d_pos,'After Calling INSERT_LINES2');

Line: 1535

    l_control_rec.temp_table_insert_flag := 'N';

Line: 1614

        SELECT line_index,
               line_id,
               line_unit_price base_unit_price, -- base price
               order_uom_selling_price adjusted_price, -- adjusted_price
               pricing_status_code, --pricing status code
               pricing_status_text -- pricing status text
               INTO
               x_price_tbl(j).line_index,
               x_price_tbl(j).line_id,
               x_price_tbl(j).base_unit_price,
               x_price_tbl(j).adjusted_price,
               x_price_tbl(j).pricing_status_code,
               x_price_tbl(j).pricing_status_text
        FROM qp_preq_lines_tmp
        WHERE line_index = j;

Line: 1640

        SELECT charge_type_code,
               order_qty_adj_amt freight_charge,
               pricing_status_code,
               pricing_status_text BULK COLLECT INTO l_freight_charge_rec_tbl
        FROM qp_ldets_v
        WHERE line_index = j
        AND list_line_type_code = 'FREIGHT_CHARGE'
        AND applied_flag = 'Y';

Line: 1660

        SELECT pricing_status_code, pricing_status_text INTO
               x_price_tbl(j).pricing_status_code,
               x_price_tbl(j).pricing_status_text
        FROM
        qp_preq_lines_tmp WHERE line_index = j;

Line: 2009

      SELECT mum.uom_code
      INTO l_uom_code
      FROM mtl_units_of_measure mum
      WHERE mum.unit_of_measure = p_uom;

Line: 2021

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'Directly Insert into Temp table');

Line: 2076

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'Call INSERT_LINES2');

Line: 2079

    QP_PREQ_GRP.INSERT_LINES2
    (p_line_index => l_line_index_tbl,
     p_line_type_code => l_line_type_code_tbl,
     p_pricing_effective_date => l_pricing_effective_date_tbl,
     p_active_date_first => l_active_date_first_tbl,
     p_active_date_first_type => l_active_date_first_type_tbl,
     p_active_date_second => l_active_date_second_tbl,
     p_active_date_second_type => l_active_date_second_type_tbl,
     p_line_quantity => l_line_quantity_tbl,
     p_line_uom_code => l_line_uom_code_tbl,
     p_request_type_code => l_request_type_code_tbl,
     p_priced_quantity => l_priced_quantity_tbl,
     p_priced_uom_code => l_priced_uom_code_tbl,
     p_currency_code => l_currency_code_tbl,
     p_unit_price => l_unit_price_tbl,
     p_percent_price => l_percent_price_tbl,
     p_uom_quantity => l_uom_quantity_tbl,
     p_adjusted_unit_price => l_adjusted_unit_price_tbl,
     p_upd_adjusted_unit_price => l_upd_adjusted_unit_price_tbl,
     p_processed_flag => l_processed_flag_tbl,
     p_price_flag => l_price_flag_tbl,
     p_line_id => l_line_id_tbl,
     p_processing_order => l_processing_order_tbl,
     p_pricing_status_code => l_pricing_status_code_tbl,
     p_pricing_status_text => l_pricing_status_text_tbl,
     p_rounding_flag => l_rounding_flag_tbl,
     p_rounding_factor => l_rounding_factor_tbl,
     p_qualifiers_exist_flag => l_qualifiers_exist_flag_tbl,
     p_pricing_attrs_exist_flag => l_pricing_attrs_exist_flag_tbl,
     p_price_list_id => l_price_list_id_tbl,
     p_validated_flag => l_pl_validated_flag_tbl,
     p_price_request_code => l_price_request_code_tbl,
     p_usage_pricing_type => l_usage_pricing_type_tbl,
     p_line_category => l_line_category_tbl,
     p_line_unit_price => l_line_unit_price_tbl,
     p_list_price_override_flag => l_list_price_overide_flag_tbl,
     x_status_code => x_return_status,
     x_status_text => l_return_status_text);

Line: 2120

      PO_DEBUG.debug_stmt(l_log_head, l_progress,'After Calling INSERT_LINES2');

Line: 2150

    l_control_rec.temp_table_insert_flag := 'N';