ACS3 Data Model

     1: function hp_get_filesystem_root_node (u_id IN integer)
     2: return integer
     3: IS
     4: 	CURSOR root_cursor IS
     5: 		select file_id from users_files
     6: 	        where filename=u_id
     7:         	and parent_id is null
     8: 	        and owner_id=u_id;
     9: 	root_id		integer;
    10: BEGIN
    11: 	OPEN root_cursor;
    12: 	FETCH root_cursor INTO root_id;
    13: 	CLOSE root_cursor;
    14: 	return root_id;
    15: END;