insert into dotlrn_classes (class_key, department_key) values (:class_key, :department_key) select node_id from site_nodes where object_id = (select package_id from dotlrn_classes_full where class_key = :class_key) select term_id from dotlrn_class_instances where class_instance_id = :class_instance_id select count(*) from dual where exists (select 1 from dotlrn_departments) select count(*) from dotlrn_terms where dotlrn_terms.end_date > sysdate and not exists (select 1 from dotlrn_class_instances where dotlrn_class_instances.class_key = :class_key and dotlrn_class_instances.term_id = dotlrn_terms.term_id) select 1 from dotlrn_classes where dotlrn_classes.class_key = :class_key