
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 (
	'invoice_amendment',
	'post_confirm',
	'1',
	'send_sms_stockist',
	NULL,
	'0',
	TO_DATE('1-01-2015 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'Gulzar    ',
	'base',
	'2',
	'EJB',
	'InvAmdPostConfSMSComp',
	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 (
	'send_sms_stockist',
	NULL,
	'http://localhost:9090/axis/services/ValidatorService',
	NULL,
	'sendSMS',
	NULL,
	'S',
	NULL,
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'Gulzar ',
	'Gulzar ');


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 (
	'send_sms_stockist',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'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 (
	'send_sms_stockist',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'BASE',
	'BASE',
	'InvAmdPostConfSMSComp');
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 (
	'send_sms_stockist',
	3,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'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 (
	'send_sms_stockist',
	4,
	'FORMAT_CODE',
	'I',
	NULL,
	'S',
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'BASE',
	'BASE',
	'SMS_FORMAT');
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 (
	'send_sms_stockist',
	5,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	TO_DATE('19-09-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	'BASE',
	'BASE',
	NULL);
	
commit;
