The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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
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
print_debug('Upd Serial Attr: Update successfully completed');
print_debug('Serial not found for update');
END Update_Serial_number_attr;