335: -------------------------------------------------------------------------------
336: FUNCTION get_job_name ( p_job_id IN NUMBER )
337: RETURN VARCHAR2
338: IS
339: l_job_name PER_JOBS_VL.name%TYPE;
340: BEGIN
341:
342: IF ( p_job_id IS NULL )
343: THEN
345: END IF;
346:
347: SELECT name
348: INTO l_job_name
349: FROM per_jobs_vl
350: WHERE job_id = p_job_id;
351:
352: return (l_job_name);
353: