Line 3212: l_media_name ams_media_tl.media_name%type;
3208: IS
3209: CURSOR c_media_name(p_media_id NUMBER) IS
3210: SELECT media_name FROM ams_media_vl
3211: WHERE media_id = p_media_id; 3212: l_media_name ams_media_tl.media_name%type; 3213:
3214: BEGIN
3215: OPEN c_media_name(p_media_id);
3216: FETCH c_media_name INTO l_media_name;