function F_salFormatTrigger return boolean is
  l_min_sal      emp.sal%type;
  l_max_hiredate date;
begin
  select min(sal) into l_min_sal
    from emp
    where deptno = :deptno;
    
  select max(hiredate) into l_max_hiredate
    from emp
    where deptno = :deptno;    

  if (:sal = l_min_sal) and (:hiredate = l_max_hiredate)
  then
     srw.set_text_color('red');
  end if;

  return (TRUE);
end;

function F_BASICSALRYFormatTrigger return boolean is
	V_COUNT NUMBER;
	BEGIN
		SELECT COUNT(*) 
		INTO V_COUNT
		FROM PAHEMPM
		WHERE  CATEGORY=(SELECT CATEGORY
	                   FROM PAHEMPM
	                   WHERE EMPNO=:EMPNO)
	                     AND BASICSALRY >(SELECT BASICSALRY
				                                      FROM PAHEMPM
				                               	                                     WHERE EMPNO=:EMPNO)
AND TO_CHAR(HIREDATE,'YYYY') <= (SELECT TO_CHAR(HIREDATE,'YYYY')
		               	FROM PAHEMPM					WHERE EMPNO=:EMPNO);
		 
		 IF V_COUNT > 0 THEN 
		 		SRW.SET_TEXT_COLOR('RED');
		 
		 ELSE 
		 		SRW.SET_TEXT_COLOR('BLACK');
		 
		 END IF;
		 		return (TRUE);

end;