1183:
1184: BEGIN
1185: IF X_inv_item_status_code IS NOT NULL THEN
1186: select inventory_item_status_code_tl INTO X_inv_item_status_code_tl 1187: from mtl_item_status 1188: where inventory_item_status_code = X_inv_item_status_code;
1189: END IF;
1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN