ALTER TRIGGER AUDIT_BOM DISABLE;

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
('bom','post_save','1','pos_bomsave',null,'0',sysdate,'mahesh','mahesh','2','EJB','BomPostSave',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
('pos_bomsave','postSave','http://localhost:9090/axis/services/ValidatorService','BASE','postSave','String','S',null,null,sysdate,'mahesh','mahesh');


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
('pos_bomsave',1,'COMPONENT_TYPE','I',null,'S',null,sysdate,'mahesh','mahesh','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
('pos_bomsave',2,'COMPONENT_NAME','I',null,'S',null,sysdate,'mahesh','mahesh','BomPostSave');
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
('pos_bomsave',3,'XML_DATA_ALL','I',null,'S',null,sysdate,'mahesh','mahesh',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
('pos_bomsave',4,'<tran_id>','I',null,'B.String',null,sysdate,'mahesh','mahesh',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
('pos_bomsave',5,'EDIT_FLAG','I',null,'S',null,sysdate,'mahesh','mahesh',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
('pos_bomsave',6,'XTRA_PARAMS','I',null,'S',null,sysdate,'mahesh','mahesh',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
('pos_bomsave',7,'DB_CONN','I',null,'S.Connection',null,sysdate,'mahesh','mahesh',null);