Index: openacs-4/packages/dotlrn-ecommerce/tcl/dotlrn-ecommerce-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/tcl/dotlrn-ecommerce-procs.tcl,v
diff -u -N -r1.12 -r1.13
--- openacs-4/packages/dotlrn-ecommerce/tcl/dotlrn-ecommerce-procs.tcl	24 Sep 2005 08:16:14 -0000	1.12
+++ openacs-4/packages/dotlrn-ecommerce/tcl/dotlrn-ecommerce-procs.tcl	23 Jan 2006 08:04:42 -0000	1.13
@@ -186,7 +186,7 @@
 	    create or replace view dotlrn_member_rels_approved
 	    as select *
 	    from dotlrn_member_rels_full
-	    where member_state in ('approved', 'waitinglist approved', 'request approved', 'payment received');
+	    where member_state in ('approved', 'waitinglist approved', 'request approved', 'application approved');
 
 	    drop trigger membership_rels_up_tr on membership_rels;
 	    drop function membership_rels_up_tr ();
@@ -204,7 +204,7 @@
 	    from group_element_index
 	    where rel_id = new.rel_id
 	    loop
-	    if new.member_state in (''approved'', ''waitinglist approved'', ''request approved'', ''payment received'') then
+	    if new.member_state in (''approved'', ''waitinglist approved'', ''request approved'', ''application approved'') then
 	    perform party_approved_member__add(map.group_id, map.element_id, new.rel_id, map.rel_type);
 	    else
 	    perform party_approved_member__remove(map.group_id, map.element_id, new.rel_id, map.rel_type);
@@ -223,7 +223,7 @@
 	db_foreach current_users {
 	    select rel_id, community_id, user_id
 	    from dotlrn_member_rels_full
-	    where member_state in ('waitinglist approved', 'request approved', 'payment received')
+	    where member_state in ('waitinglist approved', 'request approved', 'application approved')
 	} {
 	    db_exec_plsql approve_current_users {
 		declare
@@ -355,7 +355,7 @@
 	db_foreach current_users {
 	    select rel_id, community_id, user_id
 	    from dotlrn_member_rels_full
-	    where member_state in ('waitinglist approved', 'request approved', 'payment received')
+	    where member_state in ('waitinglist approved', 'request approved', 'application approved')
 	} {
 	    db_exec_plsql approve_current_users {
 		declare