asked on
declare
alert_button number;
begin
if :V_STAT_D.RESRV is not null then
if Empl_Exists(:v_emp.emp_no,:V_STAT_D.RESRV) = 0 then (if record not exist)
alert_button:=show_alert('A_CONF');
if alert_button=alert_button1 then -- alert asking user to confirm add new record
-- here we need the form to receive one value from the user
then insert into