510: End;
511:
512: Begin
513: Select description Into l_item_description
514: From mtl_system_items_tl
515: Where inventory_item_id = p_new_inventory_item_id
516: And organization_id = p_new_organization_id
517: And language = userenv('LANG');
518: Exception When others then
1017: End;
1018:
1019: Begin
1020: Select description Into l_item_description
1021: From mtl_system_items_tl
1022: Where inventory_item_id = l_item_id
1023: And organization_id = l_organization_id
1024: And language = userenv('LANG');
1025: Exception When others then