--
-- template_demo_note__del/1
--
create or replace function template_demo_note__del(
  integer
) returns int4 as $$

declare
  p_template_demo_note_id                alias for $1;
begin
    delete from acs_permissions
           where object_id = p_template_demo_note_id;

    delete from template_demo_notes
           where template_demo_note_id = p_template_demo_note_id;

    raise NOTICE 'Deleting note...';
    PERFORM acs_object__delete(p_template_demo_note_id);

    return 0;

end;$$ language plpgsql;