declare begin end; update dotlrn_community_types set package_id= :package_id where community_type= :community_type insert into dotlrn_communities (community_id, community_type, community_key, pretty_name, description) values (:community_id, :community_type, :name, :pretty_name, :description) update dotlrn_communities set package_id= :package_id where community_id= :community_id select rel_id, rel_type, users.user_id, first_names, last_name, email from registered_users users, dotlrn_member_rels_full where community_id= :community_id and users.user_id = dotlrn_member_rels_full.user_id order by rel_type select count(*) from dotlrn_member_rels_full where community_id= :community_id and user_id= :user_id select rel_id, page_id from dotlrn_member_rels_full where community_id= :community_id and user_id= :user_id select page_id from dotlrn_member_rels_full where community_id= :community_id and user_id= :user_id select page_id from dotlrn_users where user_id= :user_id select page_id from dotlrn_communities where community_id= :community_id select dotlrn_communities.community_id, community_type, community_key, pretty_name from dotlrn_communities, dotlrn_member_rels_full where dotlrn_communities.community_id = dotlrn_member_rels_full.community_id and dotlrn_member_rels_full.user_id = :user_id select dotlrn_communities.community_id as community_id, community_type, pretty_name, description, package_id from dotlrn_communities, dotlrn_member_rels_full where community_type= :community_type and user_id= :user_id and dotlrn_communities.community_id = dotlrn_member_rels_full.community_id select community_id, community_type, pretty_name, description, package_id from dotlrn_communities where community_type= :community_type select community_id, community_type, pretty_name, description, package_id from dotlrn_communities where community_type= :community_type select community_type from dotlrn_community_types where package_id= :package_id select community_id from dotlrn_communities where package_id= :package_id select package_id from dotlrn_community_types where community_type= :community_type select package_id from dotlrn_communities where community_id= :community_id select package_id from dotlrn_community_applets where community_id= :community_id and applet_key= :applet_key insert into dotlrn_community_applets (community_id, applet_key, package_id) values (:community_id, :applet_key, :package_id) delete from dotlrn_community_applets where community_id= :community_id and applet_key= :applet_key select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts where acs_sc_impls.impl_id = acs_sc_bindings.impl_id and acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and acs_sc_contracts.contract_name='dotlrn_applet' select applet_key from dotlrn_community_applets where community_id= :community_id