OpenACS

annyf
committed
MAIN:annyf:20050131223048
on 31 Jan 05
add notification chunk
/tcl/as-checks-procs-oracle.xql (+2 -2)
47 47         end;
48 48
49 49       </querytext>
50 50 </fullquery>
51 51
52 52 <fullquery name="as::assessment::check::intervals.intervals">
53 53       <querytext>
54 54         
55 55       select to_date(sysdate,'YYYY-MM-DD') as today, to_date(sysdate-1,'YYYY-MM-DD') as yesterday,  to_date (sysdate-2,'YYYY-MM-DD') as two_days,to_date (sysdate-7,'YYYY-MM-DD') as last_week, to_date (sysdate-30,'YYYY-MM-DD') as last_month from dual
56 56       </querytext>
57 57 </fullquery>
58 58
59 59 <fullquery name="as::assessment::check::manual_action_exec.update_actions_log">
60 60       <querytext>
61 61       update as_actions_log set failed_p=:failed_p,date_processed=(select sysdate from dual),finally_executed_by=:user_id,approved_p='t' where action_log_id=:action_log_id
62 62       </querytext>
63 63 </fullquery>
64 64
65 65 <fullquery name="as::assessment::check::action_log.insert_action">
66 66       <querytext>       
67         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) values (:log_id,:check_id,:action_id,(select sysdate from dual),(select sysdate from dual),'t',:failed,:user_id,:session_id)
  67       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,(select sysdate from dual),(select sysdate from dual),'t',:failed,:user_id,:session_id,:message)
68 68       </querytext>
69 69 </fullquery>
70 70
71 71 <fullquery name="as::assessment::check::manual_action_log.insert_action">
72 72       <querytext>
73          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) values (:log_id,:check_id,:action_id,(select sysdate from dual),null,'f','f',null,:session_id)
  73        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,(select sysdate from dual),null,'f','f',null,:session_id,:message)
74 74       </querytext>
75 75 </fullquery>
76 76
77 77
78 78 </queryset>