Index: openacs-4/packages/organizations/organizations.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/organizations.info,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/organizations/organizations.info 25 Jun 2004 17:09:54 -0000 1.6
+++ openacs-4/packages/organizations/organizations.info 25 Jul 2004 11:26:28 -0000 1.7
@@ -7,7 +7,7 @@
f
f
-
+
Jon Griffin
Jade Rubick
Implementation of HR-XML organizations datamodel.
@@ -20,7 +20,7 @@
what needs to be updated to make things work correctly [Jade Rubick].
-
+
Index: openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql 25 Jun 2004 17:09:54 -0000 1.4
+++ openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql 25 Jul 2004 11:26:28 -0000 1.5
@@ -167,7 +167,7 @@
reg_number = p_reg_number
where organization_id = p_organization_id;
- raise NOTICE ''Updating - organization - %'',organization_id;
+ raise NOTICE ''Updating - organization - %'',p_organization_id;
return v_return;
end;' language 'plpgsql';
Index: openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql 25 Jul 2004 11:26:28 -0000 1.1
@@ -0,0 +1,28 @@
+-- raise statement said organization rather than p_organization
+
+create or replace function organization__set (varchar,varchar,text,integer,varchar)
+returns integer as '
+declare
+ p_legal_name alias for $1; -- comment
+ p_name alias for $2; -- comment
+ p_notes alias for $3; -- comment
+ p_organization_id alias for $4; -- comment
+ p_reg_number alias for $5; -- comment
+
+ v_return integer := 0;
+begin
+
+ update organizations
+ set
+ legal_name = p_legal_name,
+ name = p_name,
+ notes = p_notes,
+ organization_id = p_organization_id,
+ reg_number = p_reg_number
+ where organization_id = p_organization_id;
+
+ raise NOTICE ''Updating - organization - %'',p_organization_id;
+
+return v_return;
+end;' language 'plpgsql';
+