APPS.OE_BLANKET_PRICING_UTIL SQL Statements

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

Line: 21

        SELECT 'VALID'
        INTO l_dummy
        FROM QP_LIST_HEADERS
        WHERE LIST_HEADER_ID = p_price_list_id
        AND LIST_SOURCE_CODE = 'BSO'
        AND orig_system_header_ref = to_char(p_blanket_header_id);

Line: 130

	the precedence as 700 and not the user updated value.*/
	SELECT a.user_precedence INTO l_user_precedence
	FROM   qp_segments_v a,
	       qp_prc_contexts_b b,
	       qp_pte_segments c
	WHERE
		b.prc_context_type = 'QUALIFIER' and
		b.prc_context_code = 'ORDER' and
		b.prc_context_id = a.prc_context_id and
		a.segment_mapping_column = 'QUALIFIER_ATTRIBUTE5' and
		a.segment_id = c.segment_id and
	        c.pte_code = 'ORDFUL';

Line: 164

      SELECT /* MOAC_SQL_CHANGE */ he.new_modifier_list_id
        INTO l_modifier_list_id
        FROM oe_blanket_headers_ext he, oe_blanket_headers_all h
       WHERE h.header_id = l_blanket_header_id
         AND he.order_number = h.order_number
         AND h.org_id = mo_global.get_current_org_id;

Line: 206

           oe_delayed_requests_pvt.g_delayed_requests.delete(I);

Line: 315

      l_qualifiers_tbl.DELETE;

Line: 383

      update oe_blanket_headers
         set lock_control = lock_control + 1
             ,last_updated_by = FND_GLOBAL.USER_ID
             ,last_update_date = sysdate
       where header_id = l_blanket_header_id;

Line: 389

      update oe_blanket_headers_ext
         set new_modifier_list_id = l_x_modifier_list_rec.list_header_id
       where order_number = (select  /* MOAC_SQL_CHANGE */ order_number
                               from oe_blanket_headers_all
                              where header_id = l_blanket_header_id
                              and org_id = mo_global.get_current_org_id);

Line: 396

      oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);

Line: 410

      update oe_blanket_lines
         set lock_control = lock_control + 1
             ,last_updated_by = FND_GLOBAL.USER_ID
             ,last_update_date = sysdate
       where line_id = l_line_id_tbl(I);

Line: 416

      update oe_blanket_lines_ext
         set modifier_list_line_id = l_x_modifiers_tbl(I).list_line_id
       where line_id = l_line_id_tbl(I);

Line: 420

      oe_delayed_requests_pvt.g_delayed_requests.delete
                                      (l_line_req_index_tbl(I));

Line: 480

      gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 486

      gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 563

      l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 569

      l_modifiers_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 654

     SELECT qp_list_line_id, modifier_list_line_id
       INTO l_qp_list_line_id, l_mod_list_line_id
       FROM OE_BLANKET_LINES_EXT
      WHERE line_id = p_blanket_line_id;

Line: 661

        select 'Y'
          into l_exist_qp_list_line_id
          from qp_list_lines
         where list_line_id = l_qp_list_line_id;

Line: 760

     select /* MOAC_SQL_CHANGE */ header_id
       into l_blanket_header_id
       from oe_blanket_headers_all
      where order_number = p_blanket_number
      and org_id = mo_global.get_current_org_id;

Line: 812

     select line_id
       into l_blanket_line_id
       from oe_blanket_lines_ext
      where order_number = p_blanket_number
        and line_number = p_blanket_line_number;

Line: 864

     select qp_list_line_id
       into l_list_line_id
       from oe_blanket_lines_ext
      where order_number = p_blanket_number
        and line_number = p_blanket_line_number;

Line: 930

     select   /* MOAC_SQL_CHANGE */ nvl(bhe.released_amount,0)
            ,nvl(bhe.returned_amount,0)
            ,bh.header_id
       into  l_released_amount
            ,l_returned_amount
            ,l_blanket_header_id
       from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
      where bhe.order_number = p_blanket_number
        and bhe.order_number = bh.order_number
        and bh.org_id = mo_global.get_current_orG_id;

Line: 1014

     select  nvl(released_amount,0)
            ,nvl(returned_amount,0)
            ,line_id
       into  l_released_amount
            ,l_returned_amount
            ,l_blanket_line_id
       from oe_blanket_lines_ext
      where order_number = p_blanket_number
        and line_number = p_blanket_line_number;

Line: 1096

     select  nvl(released_quantity,0)
            ,nvl(returned_quantity,0)
            ,line_id
       into  l_released_quantity
            ,l_returned_quantity
            ,l_blanket_line_id
       from oe_blanket_lines_ext
      where order_number = p_blanket_number
        and line_number = p_blanket_line_number;