Apex Validations:

                                                                         Apex Validations:

Read only :

SELECT PARTY_NAME  FROM OGS_CM_PARTIES
WHERE PARTY_ID = :P42_PARTY_ID

Date :

if TO_DATE(:P42_START_DATE,'DD-MON-YYYY') <=TO_DATE(:P42_END_DATE,'DD-MON-YYYY' ) or :P42_END_DATE is null then
   return true;
else
   return false;
end if;

TO_DATE(:P2_HIRE_DATE,'DD-MM-YYYY') < SYSDATE

Read only :

PL/SQL Function body ret bol:

IF :P22_EMPLOYEE_NUMBER IS NOT NULL THEN
   RETURN TRUE;
ELSE
   RETURN FALSE;
END IF;