select r.identifier from ims_cp_resources r, ims_cp_items_to_resources i where i.ims_item_id = :ims_item_id and r.res_id = i.res_id select im.isshared from ims_cp_manifests im where im.man_id = ( select live_revision from cr_items where item_id = :version_id ) select ims_manifest__new ( :course_name, :identifier, :version, :orgs_default, :hasmetadata, :parent_man_id, :isscorm, :content_folder_id, :fs_package_id, current_timestamp, :user_id, :creation_ip, :package_id, :community_id, :revision_id, :isshared, :course_presentation_format ) select ims_organization__new ( :org_id, :man_id, :identifier, :structure, :title, :hasmetadata, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select ims_organization__delete (:org_id) select item_id from cr_revisions cr, ims_cp_files f, ims_cp_resources r where f.res_id=r.res_id and r.man_id=:man_id and cr.revision_id=f.file_id select cr.item_id from cr_revisions cr, ims_cp_items i, ims_cp_items_to_resources ir, ims_cp_resources r where r.man_id=:man_id and r.res_id=ir.res_id and i.ims_item_id=ir.ims_item_id and cr.revision_id=i.ims_item_id delete from ims_cp_items_map where ims_item_id in (select revision_id from cr_revisions where item_id=:item_id) delete from ims_cp_items_map where org_id in (select revision_id from cr_revisions where item_id=:org_item_id) delete from ims_cp_manifest_class where man_id=:man_id delete from lorsm_cmi_core where man_id=:man_id delete from lorsm_student_track where course_id = :man_id select item_id from cr_revisions, ims_cp_organizations where revision_id=org_id and man_id=:man_id select item_id from cr_revisions, ims_cp_resources where revision_id=res_id and man_id=:man_id select ims_item__new ( :item_id, :org_id, :identifier, :identifierref, :isvisible, :parameters, :title, :parent_item, :hasmetadata, :prerequisites_t, :prerequisites_s, :type, :maxtimeallowed, :timelimitaction, :datafromlms, :masteryscore, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select coalesce(max(sort_order)+1,1) from ims_cp_items where org_id=:org_id update ims_cp_items set sort_order = :next_sort_order where ims_item_id = :item_id select ims_item__delete (:item_id) select ims_resource__new ( :res_id, :man_id, :identifier, :type, :href, :scorm_type, :hasmetadata, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select ims_resource__delete (:res_id) select ims_cp_item_to_resource__new (:item_id, :res_id) select ims_dependency__new (:dep_id, :res_id, :identifierref ) select ims_dependency__delete (:dep_id) select file_id from ims_cp_files where file_id = :file_id and res_id = :res_id select ims_file__new (:file_id, :res_id, :pathtofile, :filename, :hasmetadata) select object_type, title from acs_objects where object_id=:object_id update ims_cp_items set sort_order = ( select coalesce(max(sort_order),0) from ims_cp_items where parent_item=:parent_item) + 1 where ims_item_id=:item_id select object_type, title from acs_objects where object_id=:object_id