Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-functions-create.sql,v
diff -u -N -r1.8 -r1.8.2.1
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	29 Aug 2003 00:35:35 -0000	1.8
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	4 Dec 2003 21:00:13 -0000	1.8.2.1
@@ -36,30 +36,30 @@
 create function pm_project__new_root_folder (integer)
 returns integer as '
 declare
-	p_package_id		alias for $1;
+        p_package_id            alias for $1;
 
-	v_folder_id		cr_folders.folder_id%TYPE;
-	v_folder_name		cr_items.name%TYPE;
+        v_folder_id             cr_folders.folder_id%TYPE;
+        v_folder_name           cr_items.name%TYPE;
 begin
 
         -- raise notice ''in new root folder'';
 
-	-- Set the folder name
-	v_folder_name := pm_project__new_unique_name (p_package_id);
+        -- Set the folder name
+        v_folder_name := pm_project__new_unique_name (p_package_id);
 
-	v_folder_id := content_folder__new (
-	    v_folder_name,				-- name
-	    ''Projects'',				-- label
-	    ''Project Repository'',			-- description
-	    null                                        -- parent_id
-	);
+        v_folder_id := content_folder__new (
+            v_folder_name,                              -- name
+            ''Projects'',                               -- label
+            ''Project Repository'',                     -- description
+            null                                        -- parent_id
+        );
 
-	-- Register the standard content types
+        -- Register the standard content types
         PERFORM content_folder__register_content_type (
                 v_folder_id,            -- folder_id
                 ''pm_project'',         -- content_type
                 ''f''                   -- include_subtypes
-	);
+        );
 
         -- there is no facility in the API for adding in the package_id,
         -- so we have to do it ourselves
@@ -68,9 +68,9 @@
         set package_id = p_package_id 
         where folder_id = v_folder_id;
 
-	-- TODO: Handle Permissions here for this folder.
+        -- TODO: Handle Permissions here for this folder.
 
-	return v_folder_id;
+        return v_folder_id;
 end;' language 'plpgsql';
 
 
@@ -83,32 +83,32 @@
 create function pm_project__get_root_folder (integer, boolean)
 returns integer as '
 declare
-	p_package_id		alias for $1;
+        p_package_id            alias for $1;
         p_create_if_not_present_p alias for $2;
 
-	v_folder_id		cr_folders.folder_id%TYPE;
-	v_count			integer;
+        v_folder_id             cr_folders.folder_id%TYPE;
+        v_count                 integer;
 begin
 
         -- raise notice ''in get root folder p_create_if_not_present_p = %'',p_create_if_not_present_p;
 
-	select count(*) into v_count
-	from cr_folders
-	where package_id = p_package_id;
+        select count(*) into v_count
+        from cr_folders
+        where package_id = p_package_id;
 
         -- raise notice ''count is % for package_id %'', v_count, p_package_id;
 
-	if v_count > 1 then
+        if v_count > 1 then
                 raise exception ''More than one project repository for this application instance'';
-	elsif v_count = 1 then
+        elsif v_count = 1 then
                 select folder_id into v_folder_id
                 from cr_folders 
                 where package_id = p_package_id;
-	else
+        else
                 if p_create_if_not_present_p = true then
-        		-- Must be a new instance.  Create a new root folder.
+                        -- Must be a new instance.  Create a new root folder.
                         raise notice ''creating a new root repository folder'';
-	        	v_folder_id := pm_project__new_root_folder(p_package_id);
+                        v_folder_id := pm_project__new_root_folder(p_package_id);
                 else
                         -- raise notice ''setting to null'';
                         v_folder_id := null;
@@ -117,7 +117,7 @@
 
         -- raise notice ''v_folder_id is %'', v_folder_id;
 
-	return v_folder_id;
+        return v_folder_id;
 
 end; ' language 'plpgsql';
 
@@ -130,49 +130,51 @@
 -- is null.  Otherwise a project folder will be created as a sub-folder
 -- of an existing project folder.
 
-select define_function_args('pm_project__new_project_item', 'project_id, project_name, project_code, parent_id, goal, description, planned_start_date, planned_end_date, actual_start_date, actual_end_date, ongoing_p, creation_date, creation_user, creation_ip, package_id');
+select define_function_args('pm_project__new_project_item', 'project_id, project_name, project_code, parent_id, goal, description, planned_start_date, planned_end_date, actual_start_date, actual_end_date, ongoing_p, status_id, creation_date, creation_user, creation_ip, package_id');
 
 create function pm_project__new_project_item (
-	integer,        -- project_id
-	varchar,        -- project_name
-	varchar,        -- project_code
-	integer,        -- parent_id
-	varchar,        -- goal
-	varchar,        -- description
-	timestamptz,    -- planned_start_date
-	timestamptz,    -- planned_end_date
-	timestamptz,    -- actual_start_date
-	timestamptz,    -- actual_end_date
-	char(1),        -- ongoing_p
-	timestamptz,    -- creation_date
-	integer,        -- creation_user
-	varchar,        -- creation_ip
-	integer         -- package_id
+        integer,        -- project_id
+        varchar,        -- project_name
+        varchar,        -- project_code
+        integer,        -- parent_id
+        varchar,        -- goal
+        varchar,        -- description
+        timestamptz,    -- planned_start_date
+        timestamptz,    -- planned_end_date
+        timestamptz,    -- actual_start_date
+        timestamptz,    -- actual_end_date
+        char(1),        -- ongoing_p
+        integer,        -- status_id
+        timestamptz,    -- creation_date
+        integer,        -- creation_user
+        varchar,        -- creation_ip
+        integer         -- package_id
 ) returns integer 
 as '
 declare
-	p_project_id				alias for $1;
-	p_project_name				alias for $2;
-	p_project_code				alias for $3;
-	p_parent_id				alias for $4;
-	p_goal					alias for $5;
-	p_description				alias for $6;
-	p_planned_start_date			alias for $7;
-	p_planned_end_date			alias for $8;
-	p_actual_start_date			alias for $9;
-	p_actual_end_date			alias for $10;
-	p_ongoing_p				alias for $11;
-	p_creation_date				alias for $12;
-	p_creation_user				alias for $13;
-	p_creation_ip				alias for $14;
-	p_package_id				alias for $15;
+        p_project_id                            alias for $1;
+        p_project_name                          alias for $2;
+        p_project_code                          alias for $3;
+        p_parent_id                             alias for $4;
+        p_goal                                  alias for $5;
+        p_description                           alias for $6;
+        p_planned_start_date                    alias for $7;
+        p_planned_end_date                      alias for $8;
+        p_actual_start_date                     alias for $9;
+        p_actual_end_date                       alias for $10;
+        p_ongoing_p                             alias for $11;
+        p_status_id                             alias for $12;
+        p_creation_date                         alias for $13;
+        p_creation_user                         alias for $14;
+        p_creation_ip                           alias for $15;
+        p_package_id                            alias for $16;
 
-	v_item_id		cr_items.item_id%TYPE;
-	v_revision_id		cr_revisions.revision_id%TYPE;
-	v_id			cr_items.item_id%TYPE;
-	v_parent_id		cr_items.parent_id%TYPE;
+        v_item_id               cr_items.item_id%TYPE;
+        v_revision_id           cr_revisions.revision_id%TYPE;
+        v_id                    cr_items.item_id%TYPE;
+        v_parent_id             cr_items.parent_id%TYPE;
 begin
-	select acs_object_id_seq.nextval into v_id from dual;
+        select acs_object_id_seq.nextval into v_id from dual;
 
         v_parent_id := pm_project__get_root_folder (p_package_id, ''t'');
 
@@ -185,64 +187,64 @@
 
         -- raise notice ''v_parent_id (%) p_parent_id (%)'', v_parent_id, p_parent_id;
 
-	v_item_id := content_item__new (
-		v_id::varchar,	        -- name
-		v_parent_id,		-- parent_id
-		v_id,			-- item_id
-		null,			-- locale
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
-		p_parent_id,		-- context_id
-		p_creation_ip,		-- creation_ip
-		''content_item'',	-- item_subtype
-		''pm_project'',		-- content_type
-		p_project_name,		-- title
-		p_description,		-- description
-		''text/plain'',		-- mime_type
-		null,			-- nls_language
-		null			-- data
-	);
+        v_item_id := content_item__new (
+                v_id::varchar,          -- name
+                v_parent_id,            -- parent_id
+                v_id,                   -- item_id
+                null,                   -- locale
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
+                p_parent_id,            -- context_id
+                p_creation_ip,          -- creation_ip
+                ''content_item'',       -- item_subtype
+                ''pm_project'',         -- content_type
+                p_project_name,         -- title
+                p_description,          -- description
+                ''text/plain'',         -- mime_type
+                null,                   -- nls_language
+                null                    -- data
+        );
 
-	v_revision_id := content_revision__new (
-		p_project_name,		-- title
-		p_description,		-- description
-		now(),			-- publish_date
-		''text/plain'',		-- mime_type
-		NULL,			-- nls_language
-		NULL,			-- data
-		v_item_id,		-- item_id
-		NULL,			-- revision_id
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
-		p_creation_ip		-- creation_ip
-	);
+        v_revision_id := content_revision__new (
+                p_project_name,         -- title
+                p_description,          -- description
+                now(),                  -- publish_date
+                ''text/plain'',         -- mime_type
+                NULL,                   -- nls_language
+                NULL,                   -- data
+                v_item_id,              -- item_id
+                NULL,                   -- revision_id
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
+                p_creation_ip           -- creation_ip
+        );
 
-	PERFORM content_item__set_live_revision (v_revision_id);
+        PERFORM content_item__set_live_revision (v_revision_id);
 
-	insert into pm_projects (
-		project_id, project_code, 
-		goal, planned_start_date, 
-		planned_end_date, actual_start_date, actual_end_date, 
-		ongoing_p, estimated_finish_date, 
+        insert into pm_projects (
+                project_id, project_code, 
+                goal, planned_start_date, 
+                planned_end_date, actual_start_date, actual_end_date, 
+                ongoing_p, estimated_finish_date, 
                 earliest_finish_date, latest_finish_date,
                 actual_hours_completed, 
-                estimated_hours_total) 
-	values (
-		v_revision_id, p_project_code, 
-		p_goal, p_planned_start_date, 
-		p_planned_end_date, p_actual_start_date, 
-		p_actual_end_date, p_ongoing_p, p_planned_end_date,
+                estimated_hours_total, status_id) 
+        values (
+                v_revision_id, p_project_code, 
+                p_goal, p_planned_start_date, 
+                p_planned_end_date, p_actual_start_date, 
+                p_actual_end_date, p_ongoing_p, p_planned_end_date,
                 p_planned_end_date, p_planned_end_date, ''0'',
-                ''0''
+                ''0'', p_status_id
                 );
 
-	PERFORM acs_permission__grant_permission(
-		v_revision_id,
-		p_creation_user,
-		''admin''
-	);
+        PERFORM acs_permission__grant_permission(
+                v_revision_id,
+                p_creation_user,
+                ''admin''
+        );
 
-	return v_revision_id;
+        return v_revision_id;
 end;' language 'plpgsql';
 
 
@@ -253,13 +255,13 @@
 create or replace function pm_project__delete_project_item (integer)
 returns integer as '
 declare
-	p_project_id				alias for $1;
+        p_project_id                            alias for $1;
         v_child                                 cr_items%ROWTYPE;
 begin
         raise NOTICE ''Deleting pm_project...'';
 
-	delete from acs_permissions
-		where object_id = p_project_id;
+        delete from acs_permissions
+                where object_id = p_project_id;
 
         for v_child in select 
                 item_id
@@ -272,90 +274,92 @@
                 PERFORM pm_project__delete_project_item(v_child.item_id);
         end loop;
 
-	delete from pm_projects
-		where project_id = p_project_id;
+        delete from pm_projects
+                where project_id = p_project_id;
 
         PERFORM content_item__delete(p_project_id);
         return 0;
 end;' language 'plpgsql';
 
 
-select define_function_args('pm_project__new_project_revision', 'item_id, project_name, project_code, parent_id, goal, description, planned_start_date, planned_end_date, actual_start_date, actual_end_date, ongoing_p, creation_date, creation_user, creation_ip, package_id');
+select define_function_args('pm_project__new_project_revision', 'item_id, project_name, project_code, parent_id, goal, description, planned_start_date, planned_end_date, actual_start_date, actual_end_date, ongoing_p, status_id, creation_date, creation_user, creation_ip, package_id');
 
 create function pm_project__new_project_revision (
-	integer,        -- item_id
-	varchar,        -- project_name
-	varchar,        -- project_code
-	integer,        -- parent_id
-	varchar,        -- goal
-	varchar,        -- description
-	timestamptz,    -- planned_start_date
-	timestamptz,    -- planned_end_date
-	timestamptz,    -- actual_start_date
-	timestamptz,    -- actual_end_date
-	char(1),        -- ongoing_p
-	timestamptz,    -- creation_date
-	integer,        -- creation_user
-	varchar,        -- creation_ip
+        integer,        -- item_id
+        varchar,        -- project_name
+        varchar,        -- project_code
+        integer,        -- parent_id
+        varchar,        -- goal
+        varchar,        -- description
+        timestamptz,    -- planned_start_date
+        timestamptz,    -- planned_end_date
+        timestamptz,    -- actual_start_date
+        timestamptz,    -- actual_end_date
+        char(1),        -- ongoing_p
+        integer,        -- status_id
+        timestamptz,    -- creation_date
+        integer,        -- creation_user
+        varchar,        -- creation_ip
         integer         -- package_id
 ) returns integer 
 as '
 declare
-	p_item_id                               alias for $1;
-	p_project_name				alias for $2;
-	p_project_code				alias for $3;
-	p_parent_id				alias for $4;
-	p_goal					alias for $5;
-	p_description				alias for $6;
-	p_planned_start_date			alias for $7;
-	p_planned_end_date			alias for $8;
-	p_actual_start_date			alias for $9;
-	p_actual_end_date			alias for $10;
-	p_ongoing_p				alias for $11;
-	p_creation_date				alias for $12;
-	p_creation_user				alias for $13;
-	p_creation_ip				alias for $14;
-	p_package_id				alias for $15;
+        p_item_id                               alias for $1;
+        p_project_name                          alias for $2;
+        p_project_code                          alias for $3;
+        p_parent_id                             alias for $4;
+        p_goal                                  alias for $5;
+        p_description                           alias for $6;
+        p_planned_start_date                    alias for $7;
+        p_planned_end_date                      alias for $8;
+        p_actual_start_date                     alias for $9;
+        p_actual_end_date                       alias for $10;
+        p_ongoing_p                             alias for $11;
+        p_status_id                             alias for $12;
+        p_creation_date                         alias for $13;
+        p_creation_user                         alias for $14;
+        p_creation_ip                           alias for $15;
+        p_package_id                            alias for $16;
 
-	v_revision_id		cr_revisions.revision_id%TYPE;
+        v_revision_id           cr_revisions.revision_id%TYPE;
 begin
 
         -- the item_id is the project_id
 
-	v_revision_id := content_revision__new (
-		p_project_name,		-- title
-		p_description,		-- description
-		now(),			-- publish_date
-		''text/plain'',		-- mime_type
-		NULL,			-- nls_language
-		NULL,			-- data
-		p_item_id,              -- item_id
-		NULL,			-- revision_id
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
-		p_creation_ip		-- creation_ip
-	);
+        v_revision_id := content_revision__new (
+                p_project_name,         -- title
+                p_description,          -- description
+                now(),                  -- publish_date
+                ''text/plain'',         -- mime_type
+                NULL,                   -- nls_language
+                NULL,                   -- data
+                p_item_id,              -- item_id
+                NULL,                   -- revision_id
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
+                p_creation_ip           -- creation_ip
+        );
 
-	PERFORM content_item__set_live_revision (v_revision_id);
+        PERFORM content_item__set_live_revision (v_revision_id);
 
-	insert into pm_projects (
-		project_id, project_code, 
-		goal, planned_start_date, 
-		planned_end_date, actual_start_date, actual_end_date, 
-		ongoing_p) 
-	values (
-		v_revision_id, p_project_code, 
-		p_goal, p_planned_start_date, 
-		p_planned_end_date, p_actual_start_date, 
-		p_actual_end_date, p_ongoing_p);
+        insert into pm_projects (
+                project_id, project_code, 
+                goal, planned_start_date, 
+                planned_end_date, actual_start_date, actual_end_date, 
+                ongoing_p, status_id) 
+        values (
+                v_revision_id, p_project_code, 
+                p_goal, p_planned_start_date, 
+                p_planned_end_date, p_actual_start_date, 
+                p_actual_end_date, p_ongoing_p, p_status_id);
 
-	PERFORM acs_permission__grant_permission(
-		v_revision_id,
-		p_creation_user,
-		''admin''
-	);
+        PERFORM acs_permission__grant_permission(
+                v_revision_id,
+                p_creation_user,
+                ''admin''
+        );
 
-	return v_revision_id;
+        return v_revision_id;
 end;' language 'plpgsql';
 
 
@@ -367,23 +371,23 @@
 create function pm_project__new_unique_name (integer)
 returns text as '
 declare
-	p_package_id		alias for $1;
+        p_package_id            alias for $1;
 
-	v_name			cr_items.name%TYPE;
-	v_package_key		apm_packages.package_key%TYPE;
-	v_id			integer;
+        v_name                  cr_items.name%TYPE;
+        v_package_key           apm_packages.package_key%TYPE;
+        v_id                    integer;
 begin
-	select package_key into v_package_key from apm_packages
-	    where package_id = p_package_id;
+        select package_key into v_package_key from apm_packages
+            where package_id = p_package_id;
 
-	select acs_object_id_seq.nextval into v_id from dual;
+        select acs_object_id_seq.nextval into v_id from dual;
 
-	-- Set the name
-	select v_package_key || ''_'' || 
-	    to_char(current_timestamp, ''YYYYMMDD'') || ''_'' ||
-	    v_id into v_name;
+        -- Set the name
+        select v_package_key || ''_'' || 
+            to_char(current_timestamp, ''YYYYMMDD'') || ''_'' ||
+            v_id into v_name;
 
-	return v_name;
+        return v_name;
 end;' language 'plpgsql';
 
 ----------------------------------
@@ -421,171 +425,171 @@
 select define_function_args('pm_task__new_task_item', 'task_id, project_id, title, description, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, creation_date, creation_user, creation_ip, package_id');
 
 create function pm_task__new_task_item (
-	integer,        -- task_id
+        integer,        -- task_id
         integer,        -- project_id
         varchar,        -- title
-	varchar,        -- description
-	timestamptz,    -- end_date
+        varchar,        -- description
+        timestamptz,    -- end_date
         numeric,        -- percent_complete
         numeric,        -- estimated_hours_work
         numeric,        -- estimated_hours_work_min
         numeric,        -- estimated_hours_work_max,
-	timestamptz,    -- creation_date
-	integer,        -- creation_user
-	varchar,        -- creation_ip
-	integer         -- package_id
+        timestamptz,    -- creation_date
+        integer,        -- creation_user
+        varchar,        -- creation_ip
+        integer         -- package_id
 ) returns integer 
 as '
 declare
         p_task_id                               alias for $1;
-	p_project_id				alias for $2;
+        p_project_id                            alias for $2;
         p_title                                 alias for $3;
-	p_description				alias for $4;
-	p_end_date                              alias for $5;
+        p_description                           alias for $4;
+        p_end_date                              alias for $5;
         p_percent_complete                      alias for $6;
         p_estimated_hours_work                  alias for $7;
         p_estimated_hours_work_min              alias for $8;
         p_estimated_hours_work_max              alias for $9;
-	p_creation_date				alias for $10;
-	p_creation_user				alias for $11;
-	p_creation_ip				alias for $12;
-	p_package_id				alias for $13;
+        p_creation_date                         alias for $10;
+        p_creation_user                         alias for $11;
+        p_creation_ip                           alias for $12;
+        p_package_id                            alias for $13;
 
-	v_item_id		cr_items.item_id%TYPE;
-	v_revision_id		cr_revisions.revision_id%TYPE;
-	v_id			cr_items.item_id%TYPE;
+        v_item_id               cr_items.item_id%TYPE;
+        v_revision_id           cr_revisions.revision_id%TYPE;
+        v_id                    cr_items.item_id%TYPE;
         v_task_number           integer;
 begin
-	select acs_object_id_seq.nextval into v_id from dual;
+        select acs_object_id_seq.nextval into v_id from dual;
 
         -- We want to put the task under the project item
 
         -- create the task_number
         
-	v_item_id := content_item__new (
-		v_id::varchar,          -- name
-		p_project_id,		-- parent_id
-		v_id,			-- item_id
-		null,			-- locale
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
+        v_item_id := content_item__new (
+                v_id::varchar,          -- name
+                p_project_id,           -- parent_id
+                v_id,                   -- item_id
+                null,                   -- locale
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
                 p_package_id,           -- context_id
-		p_creation_ip,		-- creation_ip
-		''content_item'',	-- item_subtype
-		''pm_task'',            -- content_type
-		p_title,                -- title
-		p_description,		-- description
-		''text/plain'',		-- mime_type
-		null,			-- nls_language
-		null			-- data
-	);
+                p_creation_ip,          -- creation_ip
+                ''content_item'',       -- item_subtype
+                ''pm_task'',            -- content_type
+                p_title,                -- title
+                p_description,          -- description
+                ''text/plain'',         -- mime_type
+                null,                   -- nls_language
+                null                    -- data
+        );
 
-	v_revision_id := content_revision__new (
-		p_title,                -- title
-		p_description,		-- description
-		now(),			-- publish_date
-		''text/plain'',		-- mime_type
-		NULL,			-- nls_language
-		NULL,			-- data
-		v_item_id,		-- item_id
-		NULL,			-- revision_id
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
-		p_creation_ip		-- creation_ip
-	);
+        v_revision_id := content_revision__new (
+                p_title,                -- title
+                p_description,          -- description
+                now(),                  -- publish_date
+                ''text/plain'',         -- mime_type
+                NULL,                   -- nls_language
+                NULL,                   -- data
+                v_item_id,              -- item_id
+                NULL,                   -- revision_id
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
+                p_creation_ip           -- creation_ip
+        );
 
-	PERFORM content_item__set_live_revision (v_revision_id);
+        PERFORM content_item__set_live_revision (v_revision_id);
 
-	insert into pm_tasks (
+        insert into pm_tasks (
                 task_id, task_number)
-	values (
+        values (
                 v_item_id, v_task_number);
 
         insert into pm_tasks_revisions (
                 task_revision_id, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, actual_hours_worked)
         values (
                 v_revision_id, p_end_date, p_percent_complete, p_estimated_hours_work, p_estimated_hours_work_min, p_estimated_hours_work_max, ''0'');
 
-	PERFORM acs_permission__grant_permission(
-		v_revision_id,
-		p_creation_user,
-		''admin''
-	);
+        PERFORM acs_permission__grant_permission(
+                v_revision_id,
+                p_creation_user,
+                ''admin''
+        );
 
-	return v_revision_id;
+        return v_revision_id;
 end;' language 'plpgsql';
 
 
 select define_function_args('pm_task__new_task_revision', 'task_id, project_id, title, description, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, actual_hours_worked, creation_date, creation_user, creation_ip, package_id');
 
 create function pm_task__new_task_revision (
-	integer,        -- task_id (the item_id)
+        integer,        -- task_id (the item_id)
         integer,        -- project_id
         varchar,        -- title
-	varchar,        -- description
-	timestamptz,    -- end_date
+        varchar,        -- description
+        timestamptz,    -- end_date
         numeric,        -- percent_complete
         numeric,        -- estimated_hours_work
         numeric,        -- estimated_hours_work_min
         numeric,        -- estimated_hours_work_max
         numeric,        -- actual_hours_worked
-	timestamptz,    -- creation_date
-	integer,        -- creation_user
-	varchar,        -- creation_ip
-	integer         -- package_id
+        timestamptz,    -- creation_date
+        integer,        -- creation_user
+        varchar,        -- creation_ip
+        integer         -- package_id
 ) returns integer 
 as '
 declare
         p_task_id                               alias for $1;
-	p_project_id				alias for $2;
+        p_project_id                            alias for $2;
         p_title                                 alias for $3;
-	p_description				alias for $4;
-	p_end_date                              alias for $5;
+        p_description                           alias for $4;
+        p_end_date                              alias for $5;
         p_percent_complete                      alias for $6;
         p_estimated_hours_work                  alias for $7;
         p_estimated_hours_work_min              alias for $8;
         p_estimated_hours_work_max              alias for $9;
         p_actual_hours_worked                   alias for $10;
-	p_creation_date				alias for $11;
-	p_creation_user				alias for $12;
-	p_creation_ip				alias for $13;
-	p_package_id				alias for $14;
+        p_creation_date                         alias for $11;
+        p_creation_user                         alias for $12;
+        p_creation_ip                           alias for $13;
+        p_package_id                            alias for $14;
 
-	v_revision_id		cr_revisions.revision_id%TYPE;
-	v_id			cr_items.item_id%TYPE;
+        v_revision_id           cr_revisions.revision_id%TYPE;
+        v_id                    cr_items.item_id%TYPE;
 begin
-	select acs_object_id_seq.nextval into v_id from dual;
+        select acs_object_id_seq.nextval into v_id from dual;
 
         -- We want to put the task under the project item
 
-	v_revision_id := content_revision__new (
-		p_title,                -- title
-		p_description,		-- description
-		now(),			-- publish_date
-		''text/plain'',		-- mime_type
-		NULL,			-- nls_language
-		NULL,			-- data
-                p_task_id,		-- item_id
-		NULL,			-- revision_id
-		now(),			-- creation_date
-		p_creation_user,	-- creation_user
-		p_creation_ip		-- creation_ip
-	);
+        v_revision_id := content_revision__new (
+                p_title,                -- title
+                p_description,          -- description
+                now(),                  -- publish_date
+                ''text/plain'',         -- mime_type
+                NULL,                   -- nls_language
+                NULL,                   -- data
+                p_task_id,              -- item_id
+                NULL,                   -- revision_id
+                now(),                  -- creation_date
+                p_creation_user,        -- creation_user
+                p_creation_ip           -- creation_ip
+        );
 
-	PERFORM content_item__set_live_revision (v_revision_id);
+        PERFORM content_item__set_live_revision (v_revision_id);
 
         insert into pm_tasks_revisions (
                 task_revision_id, end_date, percent_complete, estimated_hours_work, estimated_hours_work_min, estimated_hours_work_max, actual_hours_worked)
         values (
                 v_revision_id, p_end_date, p_percent_complete, p_estimated_hours_work, p_estimated_hours_work_min, p_estimated_hours_work_max, p_actual_hours_worked);
 
-	PERFORM acs_permission__grant_permission(
-		v_revision_id,
-		p_creation_user,
-		''admin''
-	);
+        PERFORM acs_permission__grant_permission(
+                v_revision_id,
+                p_creation_user,
+                ''admin''
+        );
 
-	return v_revision_id;
+        return v_revision_id;
 end;' language 'plpgsql';
 
 
@@ -596,15 +600,15 @@
 create or replace function pm_task__delete_task_item (integer)
 returns integer as '
 declare
-	p_task_id				alias for $1;
+        p_task_id                               alias for $1;
 begin
         -- will not work because permissions are on revision_id not
         -- item_id
-	-- delete from acs_permissions
-	-- 	where object_id = p_task_id;
+        -- delete from acs_permissions
+        --      where object_id = p_task_id;
 
-	delete from pm_tasks_revisions
-		where task_revision_id in (select revision_id from pm_tasks_revisionsx where item_id = p_task_id);
+        delete from pm_tasks_revisions
+                where task_revision_id in (select revision_id from pm_tasks_revisionsx where item_id = p_task_id);
 
         delete from pm_tasks
                 where task_id = p_task_id;