Pre-Update trigger

A trigger that functions similar to the pre-update trigger in Oracle forms is created by creating a page process that fires On Submit-Before validations and computations:

-- This example populates the country_code field from a database table
-- based on the value passed in from the state_code field.
BEGIN
IF :P1036_STATE_CODE IS NOT NULL AND :P1036_COUNTRY_CODE IS NULL THEN
select country_code
into :P1036_COUNTRY_CODE
from ct_state_code
where state_code = :P1036_STATE_CODE;
END IF;
END;