32-HOW TO CREATE VALIDATIONS
→ Validation Method : SQL (compares page item with a data in table )
→ Select l from staff-mst where staff-code =
:Pl-STAFF-CODE;
It checks whether the data exists in data'
→ Validation Method : PLlSQL (to validate complex logic )
→ begin
if :Pl-STAFF-CATEGORY = 'ADMINISTRATOR' AND :Pl-STAFF-BASIC-PAY <=20000 THEN
RETURN FALSE; ELSE
RETURN TRUE;
end if;
end;
normally this type of the validation comes under function returning boolean'
→ Validation Method : PLlSQL Expression
NOT ( :Pl-STAFF-CATEGORY = 'ADMINISTRATOR' AND :Pl-STAFF-BASIC-PAY <=20000 );
→ Validation Method : ITEM NOT NULL
:Pl-STAFF-CATEGORY (in expression l box)
Any column given in expression l box will be checked against not null status and pass the validations'