In new form instance create a trigger for timer
DECLARE
x timer;
BEGIN
IF TO_CHAR (SYSDATE, 'hh24:mi') BETWEEN TO_CHAR (
TO_DATE ('1120', 'hh24:mi'),
'hh24:mi')
AND TO_CHAR (
TO_DATE ('1140', 'hh24:mi'),
'hh24:mi')
THEN
x := CREATE_TIMER ('x', 1000, repeat);
END IF;
END;
And create another trigger when timer expired
DECLARE
timer_id TIMER;
BEGIN
IF TO_CHAR (SYSDATE, 'hh24:mi') BETWEEN TO_CHAR (
TO_DATE ('1120', 'hh24:mi'),
'hh24:mi')
AND TO_CHAR (
TO_DATE ('1140', 'hh24:mi'),
'hh24:mi')
THEN
EXIT_FORM;
END IF;
END;
