845: --Bug 2786689
846: FUNCTION get_task_name (p_task_id IN NUMBER)
847: RETURN VARCHAR2
848: AS
849: l_task_name jtf_tasks_vl.task_name%TYPE;
850: BEGIN
851: IF p_task_id IS NULL
852: THEN
853: RETURN NULL;
853: RETURN NULL;
854: ELSE
855: SELECT task_name
856: INTO l_task_name
857: FROM jtf_tasks_vl
858: WHERE task_id = p_task_id;
859: END IF;
860:
861: RETURN l_task_name;