DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL SQL Statements

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

Line: 20

        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: 143

      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: 185

           oe_delayed_requests_pvt.g_delayed_requests.delete(I);
Line: 294

      l_qualifiers_tbl.DELETE;
Line: 362

      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: 368

      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: 375

      oe_delayed_requests_pvt.g_delayed_requests.delete(l_hdr_req_index);
Line: 389

      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: 395

      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: 399

      oe_delayed_requests_pvt.g_delayed_requests.delete
                                      (l_line_req_index_tbl(I));
Line: 459

      gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
Line: 465

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

      l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
Line: 548

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

     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: 640

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

     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: 791

     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: 843

     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: 909

     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: 991

     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: 1071

     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;