select lorsm__clone (:old_package_id, :new_package_id); select man_id, lorsm_instance_id, community_id, class_key, isenabled, istrackable from ims_cp_manifest_class where community_id = :old_community_id insert into ims_cp_manifest_class (man_id, lorsm_instance_id, community_id, class_key, isenabled, istrackable) values (:man_id, :new_package_id, :new_community_id, :class_key, :isenabled, :istrackable)