
delete from system_events where obj_name='receipt_backflush' and event_code='pre_confirm';

delete from system_event_services where service_code = 'backflush_test';
delete from system_service_args where service_code = 'backflush_test';

Insert into system_events (OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,METHOD_RULE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME,COMM_FORMAT) 
values ('receipt_backflush','pre_confirm','1','rcp_backflush',null,'0',sysdate,'Base','Base','2','EJB','RcpBackflushConfirm',null);


Insert into system_event_services(SERVICE_CODE,SERVICE_DESCR,SERVICE_URI,SERVICE_PROVIDER,METHOD_NAME,RETURN_VALUE,RETURN_TYPE,RETURN_DESCR,RETURN_XFRM,CHG_DATE,CHG_USER,CHG_TERM)
 values ('rcp_backflush','Confirm Default','http://localhost:8080/axis/services/ActionHandlerService','Base Information','confirm','String','S',null,null,sysdate,'Base','Base107');


Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
values ('rcp_backflush',1,'COMPONENT_TYPE','I',null,'S',null,sysdate,'BASE','BASE','EJB');

Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
values ('rcp_backflush',2,'COMPONENT_NAME','I',null,'S',null,sysdate,'BASE','BASE',null);

Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
values ('rcp_backflush',3,'<tran_id>','I',null,'B.String',null,sysdate,'BASE','BASE',null);

Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
values ('rcp_backflush',4,'XTRA_PARAMS','I',null,'S',null,sysdate,'BASE','BASE',null);

Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
values ('rcp_backflush',5,'FORCED_FLAG','I',null,'S',null,sysdate,'BASE','BASE',null);

commit;


