select jsdata
from cp_package
where cp_package_id = :id
select activitytree
from cp_package
where cp_package_id = :id
select 1
from dual
where exists (select 1
from cp_suspend
where cp_package_id = :id
and user_id = :user_id)
select data
from cp_suspend
where cp_package_id = :id
and user_id = :user_id
delete from cp_suspend
where cp_package_id = :id
and user_id = :user_id
select 1
from dual
where exists (select 1
from cmi_gobjective
where objective_id = :objective_id
and user_id = :user_id
and scope_id = :scope_id)
update cmi_gobjective
set satisfied = :value
where objective_id = :objective_id
and user_id = :user_id
and scope_id = :scope_id
update cmi_gobjective
set measure = :value
where objective_id = :objective_id
and user_id = :user_id
and scope_id = :scope_id
update cmi_gobjective
set measure = :measure,
satisfied = :satisfied,
status = :completed
where objective_id = :objective_id
and user_id = :user_id
and scope_id = :scope_id
insert into cmi_gobjective
(objective_id, user_id, satisfied, scope_id)
values
(:objective_id, :user_id, :value, :scope_id)
insert into cmi_gobjective
(objective_id, user_id, measure, scope_id)
values
(:objective_id, :user_id, :value, :scope_id)
insert into cmi_gobjective
(objective_id, user_id, measure, satisfied, status, scope_id)
values
(:objective_id, :user_id, :measure, :satisfied, :completed, :scope_id)
select objective_id, scope_id, satisfied, measure, user_id
from cmi_gobjective, cp_node, cp_mapinfo
where cmi_gobjective.objective_id <> '-course_overall_status-'
and cmi_gobjective.status is null
and cp_node.cp_package_id = :id
and cp_node.nodename = 'mapInfo'
and cp_node.cp_node_id = cp_mapinfo.cp_node_id
and cmi_gobjective.objective_id = cp_mapinfo.targetobjectiveid
group by objective_id, scope_id, satisfied, measure, user_id
select $select_attributes
from cmi_node
inner join cp_node using (cp_node_id)
where cmi_node.user_id = :user_id
and cp_node.cp_package_id = :id
select $select_attributes
from cmi_comment
inner join cmi_node using (cmi_node_id)
inner join cp_node using (cp_node_id)
where cmi_node.user_id = :user_id
and cp_node.cp_package_id = :id;
select $select_attributes
from cmi_correct_response
inner join cmi_interaction using (cmi_interaction_id)
inner join cmi_node using (cmi_node_id)
inner join cp_node using (cp_node_id)
where cmi_node.user_id = :user_id
and cp_node.cp_package_id = :id;
select $select_attributes
from cmi_interaction
inner join cmi_node using (cmi_node_id)
inner join cp_node using (cp_node_id)
where cmi_node.user_id = :user_id
and cp_node.cp_package_id = :id;
select $select_attributes
from cmi_objective
inner join cmi_node using (cmi_node_id)
inner join cp_node using (cp_node_id)
where cmi_node.user_id = :user_id
and cp_node.cp_package_id = :id;
select :user_id as user_id,
persons.first_names || ' ' || persons.last_name as learner_name,
scorm_courses.scorm_course_id, scorm_courses.default_lesson_mode as mode,
scorm_courses.credit
from persons, cp_package
inner join scorm_courses ON cp_package.cp_package_id = scorm_courses.scorm_course_id
where persons.person_id = :user_id
and scorm_courses.scorm_course_id = :id
select default_lesson_mode
from scorm_courses
where scorm_course_id = :id
select current_timestamp
from dual
select 1
from dual
where exists (select 1
from cp_node
where cp_node_id = :cp_node_id
and cp_package_id = :id)
insert into cmi_$table
([join $insert_attributes ,])
values
([join $fixed_data_row ,])