318: lv_sty_name OKL_STRM_TMPT_FULL_UV.sty_name%TYPE;
319: -- cursor to pick up the stream name to show in the message
320: CURSOR l_sty_name_csr IS
321: SELECT st.NAME 322: FROM OKL_STRM_TYPE_V st 323: WHERE id = p_tilv_rec.sty_id;
324:
325: -- sjalasut. end of code changes
326: BEGIN