-- Survey
--
-- @author dave@thedesignexperience.org, ben@openforce.biz
-- @creation-date 2002-08-03
--
-- integration with Notifications
create function inline_0 ()
returns integer as '

declare
        impl_id integer;
        v_foo   integer;
begin


      v_foo := acs_sc_impl_alias__delete (
		    ''NotificationType'',
                    ''survey_response_notif_type'',
                    ''GetURL''
                 );

      v_foo := acs_sc_impl_alias__delete (
                    ''NotificationType'',
                    ''survey_response_notif_type'',
                    ''ProcessReply''
                 );

      v_foo := acs_sc_binding__delete (
                    ''NotificationType'',
                    ''survey_response_notif_type''
                 );

       SELECT type_id from notification_types where short_name = ''survey_response_notif''
       INTO v_foo;

       v_foo := notification_type__delete(v_foo);

       v_foo := acs_sc_impl__delete (
                     ''NotificationType'',
                     ''survey_response_notif_type''
                  );

return 0;
end;' language 'plpgsql';

select inline_0();

drop function inline_0();