select cr.title ,ci.item_id as assessment_id from cr_folders cf, cr_items ci, cr_revisions cr, as_assessments a where cr.revision_id = ci.latest_revision and a.assessment_id = cr.revision_id and ci.parent_id = cf.folder_id and cf.package_id = :package_id $permission order by cr.title select inter_item_check_id,action_p,check_sql,postcheck_p,section_id_from,section_id_to,item_id,name,description,assessment_id from as_inter_item_checks where section_id_from=:section_id and assessment_id=:assessment_id select max(am.order_by) from as_action_map am,as_inter_item_checks c where c.inter_item_check_id=am.inter_item_check_id and c.section_id_from = :section_id and am.action_perform=:action_perform select grantee_id from acs_permissions where object_id=(select assessment_id from as_inter_item_checks where inter_item_check_id=:inter_item_check_id) and privilege='admin' select grantee_id from acs_permissions where object_id=(select assessment_id from as_inter_item_checks where inter_item_check_id=:inter_item_check_id) and privilege='admin' select item_id from as_param_map where parameter_id=:parameter_id and inter_item_check_id=:check_id select value from as_param_map where parameter_id=:parameter_id and inter_item_check_id=:check_id update as_param_map set item_id=:value where parameter_id=:parameter_id and inter_item_check_id=:check_id select inter_item_check_id from as_param_map where parameter_id=:parameter_id and inter_item_check_id = :check_id insert into as_param_map (parameter_id,inter_item_check_id,value,item_id) values (:parameter_id,:check_id,null,:value) insert into as_param_map (parameter_id,inter_item_check_id,value,item_id) values (:parameter_id,:check_id,:value,null) update as_param_map set value=:value where parameter_id=:parameter_id and inter_item_check_id=:check_id select order_by from as_action_map where inter_item_check_id=:check_id select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.section_id_from = :section_id and am.action_perform=:action_perform and am.order_by > :order_by update as_action_map set order_by=:order where inter_item_check_id=:inter_item_check_id select c.inter_item_check_id from as_inter_item_checks c ,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.order_by=:order_p and c.section_id_from=:section_id and am.action_perform=:action_perform update as_action_map set order_by=:order_p where inter_item_check_id=:check_id update as_action_map set order_by=:order_by where inter_item_check_id=:swap_check_id select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.order_by=:order_p and c.section_id_from=:section_id and am.action_perform=:action_perform update as_action_map set order_by=:order_p where inter_item_check_id=:check_id update as_action_map set order_by=:order_by where inter_item_check_id=:swap_check_id select am.action_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.inter_item_check_id=:check_id select am.action_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.inter_item_check_id=:check_id select ci.latest_revision as item_id,parameter_id, value, inter_item_check_id from as_param_map pm,cr_items ci where inter_item_check_id = :inter_item_check_id and ci.item_id=pm.item_id select varname from as_action_params where parameter_id = :parameter_id select item_data_id, boolean_answer, clob_answer, numeric_answer, integer_answer, text_answer, timestamp_answer, content_answer from as_item_data where session_id = :session_id and as_item_id = :item_id and item_data_id in (select latest_revision from cr_items) select item_data_id, boolean_answer, clob_answer, numeric_answer, integer_answer, text_answer, timestamp_answer, content_answer from as_item_data where session_id = :session_id and as_item_id = :item_id select idc.choice_id from as_item_data_choices idc,as_item_data id where id.as_item_id=:item_id and id.item_data_id=idc.item_data_id and id.session_id=:session_id select a.tcl_code,am.user_message,a.name as action_name from as_actions a,as_action_map am where am.action_id = a.action_id and am.inter_item_check_id = :inter_item_check_id select ci.latest_revision as item_id,parameter_id, value, inter_item_check_id from as_param_map pm, cr_items ci where inter_item_check_id = :inter_item_check_id select varname from as_action_params where parameter_id = :parameter_id select idc.choice_id from as_item_data_choices idc,as_item_data id where id.as_item_id=:item_id and id.item_data_id=idc.item_data_id and id.session_id=:session_id select a.tcl_code, a.name as action_name,am.user_message from as_actions a,as_action_map am where am.action_id = a.action_id and inter_item_check_id = :inter_item_check_id select c.inter_item_check_id,c.check_sql,action_p from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='i' and section_id_from=:section_id order by am.order_by select check_sql,inter_item_check_id,section_id_to from as_inter_item_checks where action_p = 'f' and section_id_from=:section_id select sort_order from as_assessment_section_map where section_id=:section_id_to and assessment_id=:new_assessment_revision select max(revision_id) from cr_revisions where item_id=:assessment_id select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='aa' and c.assessment_id=:assessment_id order by am.order_by select * from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='aa' and c.assessment_id=:assessment_id and c.inter_item_check_id=:check_id order by am.order_by select max(revision_id) from cr_revisions where item_id=:assessment_id select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_rev_id order by asm.sort_order select * from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='m' and c.assessment_id=:assessment_id order by am.order_by select c.inter_item_check_id,c.check_sql,action_p from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='or' and section_id_from=:section_id order by am.order_by select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='sa' and c.assessment_id=:assessment_id order by am.order_by select max(revision_id) from cr_revisions where item_id=:assessment_id select * from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='sa' and c.assessment_id=:assessment_id and c.inter_item_check_id=:check_id order by am.order_by select * from as_inter_item_checks where inter_item_check_id=:check_id select a.name as action_name from as_actions a, as_action_map am where inter_item_check_id=:check_id and a.action_id=am.action_id select * from as_param_map pm,as_action_params p where pm.parameter_id=p.parameter_id and pm.inter_item_check_id=:check_id select cr.title from cr_revisions cr,as_sections s where cr.revision_id=s.section_id and s.section_id=:section_id_to update as_inter_item_checks set section_id_from=:new_section_id where inter_item_check_id=:inter_item_check_id update as_inter_item_checks set check_sql=:check_sql where inter_item_check_id=:inter_item_check_id select inter_item_check_id from as_inter_item_checks where section_id_to =:section_id update as_inter_item_checks set section_id_to=:new_section_id where inter_item_check_id=:check_id select inter_item_check_id from as_inter_item_checks where section_id_from in (select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_id) select inter_item_check_id,check_sql from as_inter_item_checks where assessment_id=:assessment_id and section_id_from=:section_id select inter_item_check_id,check_sql,section_id_from,section_id_to,name,description,action_p,item_id, postcheck_p from as_inter_item_checks where assessment_id=:assessment_id and section_id_from=:section_id select * from as_inter_item_checks where inter_item_check_id=:inter_item_check_id update as_actions_log set failed_p=:failed_p,date_processed=current_timestamp,finally_executed_by=:user_id,approved_p='t' where action_log_id=:action_log_id insert into as_actions_log (action_log_id,inter_item_check_id,action_id,date_requested,date_processed,approved_p,failed_p,finally_executed_by,session_id,error_txt) values (:log_id,:check_id,:action_id,current_timestamp,current_timestamp,'t',:failed,:user_id,:session_id,:message) insert into as_actions_log (action_log_id,inter_item_check_id,action_id,date_requested,date_processed,approved_p,failed_p,finally_executed_by,session_id,error_txt) values (:log_id,:check_id,:action_id,current_timestamp,null,'f','f',null,:session_id,:message)