APPS.INV_SERIAL_NUMBER_ATTR SQL Statements

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

Line: 15

procedure Update_Serial_number_attr(
   x_return_status              OUT  NOCOPY VARCHAR2,
   x_msg_count                  OUT  NOCOPY NUMBER,
   x_msg_data                   OUT  NOCOPY VARCHAR2,

   p_serial_number             IN   VARCHAR2,
   p_inventory_item_id         IN   NUMBER,
   p_attribute_category        IN   VARCHAR2  DEFAULT NULL,
   p_attributes_tbl            IN   inv_serial_number_attr.char_table) IS

    TYPE seg_name IS TABLE OF VARCHAR2(500)
      INDEX BY BINARY_INTEGER;

Line: 73

      SELECT 1
         INTO l_tempvar
         FROM mtl_serial_numbers
         WHERE inventory_item_id = p_inventory_item_id
         AND   serial_number = p_serial_number
         AND   current_status in (1,3,4); --Bug4493227

Line: 359

      UPDATE mtl_serial_numbers
      SET
	  attribute_category = l_default_attr_category
        , attribute1  = DECODE(l_inv_attributes_tbl(1), g_miss_char, NULL, NULL, attribute1, l_inv_attributes_tbl(1))
        , attribute2  = DECODE(l_inv_attributes_tbl(2), g_miss_char, NULL, NULL, attribute2, l_inv_attributes_tbl(2))
        , attribute3  = DECODE(l_inv_attributes_tbl(3), g_miss_char, NULL, NULL, attribute3, l_inv_attributes_tbl(3))
        , attribute4  = DECODE(l_inv_attributes_tbl(4), g_miss_char, NULL, NULL, attribute4, l_inv_attributes_tbl(4))
        , attribute5  = DECODE(l_inv_attributes_tbl(5), g_miss_char, NULL, NULL, attribute5, l_inv_attributes_tbl(5))
        , attribute6  = DECODE(l_inv_attributes_tbl(6), g_miss_char, NULL, NULL, attribute6, l_inv_attributes_tbl(6))
        , attribute7  = DECODE(l_inv_attributes_tbl(7), g_miss_char, NULL, NULL, attribute7, l_inv_attributes_tbl(7))
        , attribute8  = DECODE(l_inv_attributes_tbl(8), g_miss_char, NULL, NULL, attribute8, l_inv_attributes_tbl(8))
        , attribute9  = DECODE(l_inv_attributes_tbl(9), g_miss_char, NULL, NULL, attribute9, l_inv_attributes_tbl(9))
        , attribute10 = DECODE(l_inv_attributes_tbl(10), g_miss_char, NULL, NULL, attribute10, l_inv_attributes_tbl(10))
        , attribute11 = DECODE(l_inv_attributes_tbl(11), g_miss_char, NULL, NULL, attribute11, l_inv_attributes_tbl(11))
        , attribute12 = DECODE(l_inv_attributes_tbl(12), g_miss_char, NULL, NULL, attribute12, l_inv_attributes_tbl(12))
        , attribute13 = DECODE(l_inv_attributes_tbl(13), g_miss_char, NULL, NULL, attribute13, l_inv_attributes_tbl(13))
        , attribute14 = DECODE(l_inv_attributes_tbl(14), g_miss_char, NULL, NULL, attribute14, l_inv_attributes_tbl(14))
        , attribute15 = DECODE(l_inv_attributes_tbl(15), g_miss_char, NULL, NULL, attribute15, l_inv_attributes_tbl(15))
      WHERE inventory_item_id = p_inventory_item_id
      AND   serial_number = p_serial_number
      AND   current_status in (1,3,4);  --Bug4493227

Line: 383

           print_debug('Upd Serial Attr: Update successfully completed');

Line: 387

           print_debug('Serial not found for update');

Line: 428

END Update_Serial_number_attr;