spool C:\wms_log\DI1DSUN020.txt

INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'asn',
	'1',
	'itm_default',
	NULL);
	
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'asn',
	'1',
	'supp_code',
	NULL);

INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'asn',
	'2',
	'item_code',
	NULL);

INSERT INTO SYSTEM_EVENTS (
	OBJ_NAME ,
	EVENT_CODE ,
	EVENT_CONTEXT ,
	SERVICE_CODE ,
	METHOD_RULE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	RESULT_HANDLE ,
	OVERWRITE_CORE ,
	COMP_TYPE ,
	COMP_NAME ,
	COMM_FORMAT )
 VALUES (
	'asn',
	'gen_porder',
	'1',
	'gen_porder_asn',
	NULL,
	fn_sysdate(),
	'PAWAN',
	'Base',
	'2',
	'0',
	'EJB',
	'AsnConf',
	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 (
	'gen_porder_asn',
	'Action for purchase order creation',
	'http://localhost:9090/axis/services/ActionHandlerService',
	'BASE',
	'generatePurcOrder',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base');

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 (
	'gen_porder_asn',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'C.String',
	NULL,
	fn_sysdate(),
	'PAWAN',
	'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 (
	'gen_porder_asn',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'C.String',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	'AsnConf');
	
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 (
	'gen_porder_asn',
	3,
	'<tran_id>',
	'I',
	'tranID',
	'C.String',
	NULL,
	fn_sysdate(),
	'Pawan',
	'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 (
	'gen_porder_asn',
	4,
	'XTRA_PARAMS',
	'I',
	'Extra Arguments',
	'S',
	NULL,
	fn_sysdate(),
	'Pawan',
	'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 (
	'gen_porder_asn',
	5,
	'FORCED_FLAG',
	'I',
	'Forced Flag',
	'S',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL);

spool off

