APPS.OE_BLKT_RELEASE_UTIL SQL Statements

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

Line: 20

  SELECT LINE_NUMBER
    INTO l_line_number
    FROM OE_ORDER_LINES
   WHERE LINE_ID = p_line_id;

Line: 50

  SELECT SHIPMENT_NUMBER
    INTO l_shipment_number
    FROM OE_ORDER_LINES
   WHERE LINE_ID = p_line_id;

Line: 207

  SELECT  L.HEADER_ID
	 ,L.LINE_ID
         ,BL.OVERRIDE_BLANKET_CONTROLS_FLAG
         ,BL.OVERRIDE_RELEASE_CONTROLS_FLAG
         ,nvl(BL.RELEASED_AMOUNT,0)
         ,BL.MIN_RELEASE_AMOUNT
         ,BL.MAX_RELEASE_AMOUNT
         ,BL.BLANKET_LINE_MAX_AMOUNT
         ,BL.BLANKET_MAX_QUANTITY
         ,BL.RELEASED_QUANTITY
         ,BL.FULFILLED_QUANTITY
         ,BL.FULFILLED_AMOUNT
         ,BL.MIN_RELEASE_QUANTITY
         ,BL.MAX_RELEASE_QUANTITY
         ,L.ORDER_QUANTITY_UOM
         ,nvl(BL.RETURNED_QUANTITY,0)
         ,nvl(BL.RETURNED_AMOUNT,0)
         ,'N' -- locked_flag
    FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL
   WHERE L.LINE_ID = p_blanket_line_id
     AND L.LINE_ID = BL.LINE_ID
     AND L.SALES_DOCUMENT_TYPE_CODE = 'B';

Line: 231

  SELECT  H.HEADER_ID
	 ,BH.OVERRIDE_AMOUNT_FLAG
         ,nvl(BH.RELEASED_AMOUNT,0)
         ,nvl(BH.RETURNED_AMOUNT,0)
         ,nvl(BH.FULFILLED_AMOUNT,0)
         ,BH.BLANKET_MAX_AMOUNT
         ,H.TRANSACTIONAL_CURR_CODE
         ,H.CONVERSION_TYPE_CODE
         ,'N' -- locked_flag
    FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH
   WHERE H.HEADER_ID = p_blanket_header_id
     AND H.ORDER_NUMBER = BH.ORDER_NUMBER
     AND H.SALES_DOCUMENT_TYPE_CODE = 'B';

Line: 260

  SELECT line_id
    INTO x_blanket_line_id
    FROM OE_BLANKET_LINES_EXT BL
   WHERE BL.ORDER_NUMBER = p_blanket_number
     AND BL.LINE_NUMBER  = p_blanket_line_number;

Line: 323

        SELECT 'Y'
         INTO g_blkt_line_tbl(x_blanket_line_id).locked_flag
         FROM oe_blanket_lines_all
        WHERE line_id = l_blanket_line_id --bug8465849
          FOR UPDATE NOWAIT;

Line: 370

        SELECT 'Y'
         INTO g_blkt_hdr_tbl(x_blanket_header_id).locked_flag
         FROM oe_blanket_headers_all
        WHERE header_id = l_blanket_header_id --bug8465849
          FOR UPDATE NOWAIT;

Line: 402

PROCEDURE Update_Released_Qty_Amount
  (p_line_id                   IN NUMBER
  ,p_line_set_id               IN NUMBER
  ,p_blanket_number            IN NUMBER
  ,p_blanket_line_number       IN NUMBER
  ,p_old_quantity              IN NUMBER
  ,p_quantity                  IN NUMBER
  ,p_old_order_qty_uom         IN VARCHAR2
  ,p_order_qty_uom             IN VARCHAR2
  ,p_old_unit_selling_price    IN NUMBER
  ,p_unit_selling_price        IN NUMBER
  ,p_old_inv_item_id           IN NUMBER
  ,p_inv_item_id               IN NUMBER
  ,p_currency_code             IN VARCHAR2
  ,p_fulfilled_flag            IN VARCHAR2
  ,x_return_status             OUT NOCOPY VARCHAR2
  )
IS

  l_blanket_line_id          NUMBER;

Line: 924

            ,'Update_Released_Qty_Amount'
            );

Line: 927

END Update_Released_Qty_Amount;

Line: 933

PROCEDURE Update_Blankets
  (x_return_status    OUT NOCOPY VARCHAR2
  )
IS
  l_index            NUMBER;

Line: 940

oe_debug_pub.add('Inside update blanket');

Line: 945

      UPDATE OE_BLANKET_HEADERS_EXT
         SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
             ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
       WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
                                 FROM OE_BLANKET_HEADERS H
                                 WHERE  H.HEADER_ID = g_blkt_hdr_tbl(l_index).header_id);

Line: 952

      UPDATE OE_BLANKET_HEADERS
         SET LOCK_CONTROL    = LOCK_CONTROL + 1
       WHERE HEADER_ID = g_blkt_hdr_tbl(l_index).header_id;--bug8465849

Line: 965

      UPDATE OE_BLANKET_LINES_EXT
         SET RELEASED_AMOUNT = g_blkt_line_tbl(l_index).released_amount
             ,RELEASED_QUANTITY = g_blkt_line_tbl(l_index).released_quantity
             ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
             ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity
         WHERE  LINE_ID = g_blkt_line_tbl(l_index).line_id;

Line: 972

      UPDATE OE_BLANKET_LINES
         SET LOCK_CONTROL = LOCK_CONTROL + 1
       WHERE LINE_ID =  g_blkt_line_tbl(l_index).line_id;--bug8465849

Line: 983

oe_debug_pub.add('Leaving update blanket');

Line: 992

            ,'Update_Blankets'
            );

Line: 995

END Update_Blankets;

Line: 1028

    SELECT line_number
      INTO l_set_line_number
      FROM OE_ORDER_LINES
     WHERE LINE_SET_ID = p_line_set_id
       AND ROWNUM = 1;

Line: 1060

  SELECT ordered_quantity_uom, inventory_item_id
    INTO l_uom, l_inv_item_id
    FROM OE_SETS
   WHERE set_id = p_line_set_id;

Line: 1065

  SELECT SUM(nvl(ordered_quantity,0))
         ,SUM(nvl(ordered_quantity,0) * nvl(unit_selling_price,0))
    INTO l_set_quantity
         ,l_set_amount
    FROM OE_ORDER_LINES
   WHERE line_set_id = p_line_set_id
     AND blanket_number = p_blanket_number
     AND blanket_line_number = p_blanket_line_number;

Line: 1269

  g_blkt_line_tbl.delete;

Line: 1270

  g_blkt_hdr_tbl.delete;

Line: 1351

	     select header_id
	     into l_hdr_id
	     from oe_order_lines
	     where line_id = p_request_tbl_temp(I).entity_id;

Line: 1366

        OE_MSG_PUB.Update_Msg_Context(
            p_order_source_id       => OE_Order_Cache.g_header_rec.order_source_id
          , p_orig_sys_document_ref => OE_Order_Cache.g_header_rec.orig_sys_document_ref );

Line: 1396

        oe_debug_pub.add('Update qty/amt for existing blanket num :'
                          ||p_request_tbl_temp(I).param11);

Line: 1400

        Update_Released_Qty_Amount
            (p_line_id             => p_request_tbl_temp(I).entity_id
            ,p_blanket_number      => p_request_tbl_temp(I).param11
            ,p_blanket_line_number => p_request_tbl_temp(I).param12
            ,p_old_quantity        => p_request_tbl_temp(I).param3
            ,p_quantity            => p_request_tbl_temp(I).param13
            ,p_old_order_qty_uom   => p_request_tbl_temp(I).param4
            ,p_order_qty_uom       => p_request_tbl_temp(I).param14
            ,p_old_unit_selling_price => p_request_tbl_temp(I).param5
            ,p_unit_selling_price  => p_request_tbl_temp(I).param15
            ,p_old_inv_item_id     => p_request_tbl_temp(I).param6
            ,p_inv_item_id         => p_request_tbl_temp(I).param16
            ,p_currency_code       => l_currency_code
            ,p_fulfilled_flag      => p_request_tbl_temp(I).param8
            ,p_line_set_id         => p_request_tbl_temp(I).param9
            ,x_return_status       => l_return_status
            );

Line: 1436

          Update_Released_Qty_Amount
            (p_line_id             => p_request_tbl_temp(I).entity_id
            ,p_blanket_number      => p_request_tbl_temp(I).param11
            ,p_blanket_line_number => p_request_tbl_temp(I).param12
            ,p_old_quantity        => 0
            ,p_quantity            => p_request_tbl_temp(I).param13
            ,p_old_order_qty_uom   => null
            ,p_order_qty_uom       => p_request_tbl_temp(I).param14
            ,p_old_unit_selling_price => 0
            ,p_unit_selling_price  => p_request_tbl_temp(I).param15
            ,p_old_inv_item_id     => null
            ,p_inv_item_id         => p_request_tbl_temp(I).param16
            ,p_currency_code       => l_currency_code
            ,p_fulfilled_flag      => p_request_tbl_temp(I).param8
            ,p_line_set_id         => p_request_tbl_temp(I).param9
            ,x_return_status       => l_return_status
            );

Line: 1472

          Update_Released_Qty_Amount
            (p_line_id             => p_request_tbl_temp(I).entity_id
            ,p_blanket_number      => p_request_tbl_temp(I).param1
            ,p_blanket_line_number => p_request_tbl_temp(I).param2
            ,p_old_quantity        => p_request_tbl_temp(I).param3
            ,p_quantity            => 0
            ,p_old_order_qty_uom   => p_request_tbl_temp(I).param4
            ,p_order_qty_uom       => null
            ,p_old_unit_selling_price => p_request_tbl_temp(I).param5
            ,p_unit_selling_price  => 0
            ,p_old_inv_item_id     => p_request_tbl_temp(I).param6
            ,p_inv_item_id         => null
            ,p_currency_code       => l_currency_code
            ,p_fulfilled_flag      => p_request_tbl_temp(I).param8
            ,p_line_set_id         => p_request_tbl_temp(I).param9
            ,x_return_status       => l_return_status
            );

Line: 1554

      Update_Blankets(l_return_status);

Line: 1560

         oe_debug_pub.add('delete cache');

Line: 1561

         g_bl_order_val_tbl.delete;

Line: 1562

         g_bh_order_val_tbl.delete;

Line: 1645

          SELECT HEADER_ID, ORDERED_QUANTITY, UNIT_SELLING_PRICE
            INTO l_header_id, l_old_quantity, l_old_unit_sp
            FROM OE_ORDER_LINES_ALL
           WHERE LINE_ID = p_line_id;

Line: 1681

         SELECT sum(nvl(ordered_quantity,0)),
                sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
           INTO l_rem_bl_line_qty
                ,l_rem_bl_line_amt
           FROM OE_ORDER_LINES_ALL
          WHERE HEADER_ID = l_header_id
            AND BLANKET_NUMBER = p_blanket_number
            AND BLANKET_LINE_NUMBER = p_blanket_line_number
            AND LINE_ID <> p_line_id;

Line: 1702

         SELECT sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
           INTO l_rem_bl_hdr_amt
           FROM OE_ORDER_LINES_ALL
          WHERE HEADER_ID = l_header_id
            AND BLANKET_NUMBER = p_blanket_number
            AND LINE_ID <> p_line_id;