Acceptance Testing/Attribute set script postgreSQL

CREATE OR REPLACE FUNCTION create_attributeSet()
 RETURNS void AS
$BODY$ DECLARE

v_attributeset_id NUMERIC(10);
v_client_id NUMERIC(10);

BEGIN

SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;

SELECT COALESCE(MAX(M_ATTRIBUTESET_ID),999999)+1 INTO v_attributeset_id FROM   M_ATTRIBUTESET;

INSERT INTO M_ATTRIBUTESET (M_ATTRIBUTESET_ID, AD_CLIENT_ID, AD_ORG_ID,  ISACTIVE, CREATED,CREATEDBY, UPDATED, UPDATEDBY, NAME, ISLOT, ISGUARANTEEDATE,  ISSERNO)
VALUES(v_attributeset_id, v_client_id, 0, 'Y', now(),  100,now(),100,'Lots','Y','Y','N');                            

PERFORM AD_UPDATE_SEQUENCE();

END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;

SELECT create_attributeSet();

drop function create_attributeSet();