select isshared from ims_cp_manifests where man_id = :man_id select man_id, lorsm_instance_id from ims_cp_manifest_class where man_id = :man_id and lorsm_instance_id = :package_id and community_id = :community_id insert into ims_cp_manifest_class (man_id, lorsm_instance_id, community_id, isenabled, istrackable) values (:man_id, :package_id, :community_id, 't', 'f')