oracle8.1.6 begin select content_item.set_live_revision ( revision_id => :revision_id ); end; begin select evaluation__new_evaluation_task_group ( :group_id, :group_name, 'closed', :creation_date, :creation_user, :creation_ip, :context, :task_item_id ); end; begin select acs_group.name(:group_id) as group_name; end; select cu.person_id as party_id, cu.last_name||' - '||cu.first_names as party_name, round(ese.grade,2) as grade, ese.description as comments from cc_users cu left outer join evaluation_student_evalsi ese on (ese.party_id = cu.person_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') select p.person_id as party_id, p.last_name||' - '||p.first_names as party_name, ese.grade, ese.description as comments from registered_users ru, dotlrn_member_rels_approved app, persons p left outer join evaluation_student_evalsi ese on (ese.party_id = p.person_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') where app.community_id = :community_id and app.user_id = ru.user_id and app.user_id = p.person_id and app.role = 'student' select etg.group_id as party_id, g.group_name as party_name, grade, ese.description as comments from groups g, evaluation_task_groups etg left outer join evaluation_student_evalsi ese on (ese.party_id = etg.group_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') where etg.task_item_id = :task_item_id and etg.group_id = g.group_id select description as edit_reason, grade as current_grade, evaluation.party_name(party_id,:task_id) as party_name from evaluation_student_evalsi where evaluation_id = :evaluation_id select evaluation.party_name(ea.party_id, et.task_id) as party_name, crr.title as answer_title, crr.revision_id, crr.content as cr_file_name, cri.storage_type, cri.storage_area_key as cr_path from evaluation_answersi ea, cr_revisions crr, evaluation_tasks et, cr_items cri, cr_items cri2 where ea.task_item_id = et.task_item_id and ea.answer_item_id = cri.item_id and crr.revision_id = ea.answer_id and et.task_id = :task_id and ea.data is not null and cri2.live_revision = ea.answer_id and not exists (select 1 from evaluation_student_evals ese, cr_items cri3 where ese.party_id = ea.party_id and ese.task_item_id = et.task_item_id and cri3.live_revision = ese.evaluation_id) select content_revision.get_content(:revision_id) select sysdate from dual select sysdate from dual select sysdate from dual select sysdate from dual select sysdate from dual select sysdate from dual select et.task_name, et.number_of_members, et.due_date, et.weight, et.online_p, et.late_submit_p, et.requires_grade_p, crr.content, crr.filename, crr.content_length, crr.title, crr.description, crr.mime_type, cri.storage_type, cri.content_type from evaluation_tasksi et, cr_revisions crr, cr_items cri where task_id = :from_task_id and et.task_id = crr.revision_id and cri.item_id = crr.item_id update cr_revisions set content = :content, content_length = :content_length, filename = :filename where revision_id = :revision_id