[Home] [Help]
485: BEGIN
486: IF (STATUS_CODE_VAL IS NOT NULL) THEN
487: select status_code
488: into ret_string
489: from MTL_MATERIAL_STATUSES_TL
490: where status_id = status_code_val AND language =
491: userenv('LANG');
492: return (ret_string);
493: ELSE