3228: --========================================================================
3229: FUNCTION get_media_name(p_media_id IN NUMBER) RETURN VARCHAR2
3230: IS
3231: CURSOR c_media_name(p_media_id NUMBER) IS 3232: SELECT media_name FROM ams_media_vl 3233: WHERE media_id = p_media_id;
3234: l_media_name ams_media_tl.media_name%type;
3235:
3236: BEGIN