ACS3 Data Model

     1: function hp_user_quota_used (userid IN integer, dir_requirement IN integer)
     2: return integer
     3: IS
     4: 	return_value		integer;
     5: 	file_space		integer;
     6: 	dir_space		integer;
     7: BEGIN
     8: 	select (count(*) * dir_requirement) into dir_space
     9:         from users_files
    10:         where directory_p='t'
    11:         and owner_id=userid;
    12: 
    13: 	select nvl(sum(file_size),0) into file_space
    14:         from users_files
    15:         where directory_p='f'
    16:         and owner_id=userid;
    17: 
    18: 	return_value := dir_space + file_space;
    19: 
    20: 	return return_value;
    21: END;