ACS3 Data Model

     1: procedure sec_rotate_last_visit(
     2:     v_browser_id IN sec_browser_properties.browser_id%TYPE,
     3:     v_time IN integer
     4: ) is
     5:     pragma autonomous_transaction;
     6: begin
     7:     delete from sec_browser_properties
     8:         where browser_id = v_browser_id and module = 'acs' and property_name = 'second_to_last_visit';
     9:     update sec_browser_properties
    10:         set property_name = 'second_to_last_visit'
    11:         where module = 'acs' and property_name = 'last_visit' and browser_id = v_browser_id;
    12:     insert into sec_browser_properties(browser_id, module, property_name, property_value, secure_p)
    13:         values(v_browser_id, 'acs', 'last_visit', to_char(v_time), 'f');
    14:     commit;
    15: end;