spool C:\wms_log\SY1DSUN008.txt

INSERT INTO itm2menu (
	application ,
	level_1 ,
	level_2 ,
	level_3 ,
	level_4 ,
	level_5 ,
	win_name ,
	descr ,
	comments ,
	menu_path ,
	icon_path ,
	close_icon ,
	open_icon ,
	obj_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'SFA',
	1,
	5,
	0,
	0,
	0,
	'w_asn',
	'ASN',
	'ASN',
	'SFA.1.5.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	null,
	fn_sysdate(),
	'chaitali',
	'chaitali'); 
	
INSERT INTO OBJ_ACTIONS (
	OBJ_NAME ,
	LINE_NO ,
	RIGHTS_CHAR ,
	INTERACTIVE ,
	SERVICE_CODE ,
	DESCRIPTION ,
	TITLE ,
	IMAGE ,
	ACTION_TYPE ,
	FORM_NO ,
	SERVICE_HANDLER ,
	PLACEMENT ,
	TRAN_TYPE ,
	CHG_DATE ,
	CHG_TERM ,
	CHG_USER )
 VALUES (
	'asn',
	1,
	'A',
	'a',
	'a',
	'Adding a Record',
	'Add',
	'add.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Base',
	'Pawan');
	
INSERT INTO OBJ_ACTIONS (
	OBJ_NAME ,
	LINE_NO ,
	RIGHTS_CHAR ,
	INTERACTIVE ,
	SERVICE_CODE ,
	DESCRIPTION ,
	TITLE ,
	IMAGE ,
	ACTION_TYPE ,
	FORM_NO ,
	SERVICE_HANDLER ,
	PLACEMENT ,
	TRAN_TYPE ,
	CHG_DATE ,
	CHG_TERM ,
	CHG_USER )
VALUES (
	'asn',
	2,
	'E',
	'a',
	'a',
	'Edit a Record',
	'Edit',
	'edit.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Base',
	'Pawan');
	
INSERT INTO OBJ_ACTIONS (
	OBJ_NAME ,
	LINE_NO ,
	RIGHTS_CHAR ,
	INTERACTIVE ,
	SERVICE_CODE ,
	DESCRIPTION ,
	TITLE ,
	IMAGE ,
	FORM_NO ,
	SERVICE_HANDLER ,
	PLACEMENT ,
	ACTION_TYPE ,
	TRAN_TYPE )
 VALUES (
	'asn',
	3,
	'C',
	'a',
	'pre_confirm',
	'Confirming records',
	'Confirm',
	'confirm~normal.gif',
	'1',
	'2',
	1,
	'U',
	NULL);
	
INSERT INTO OBJ_FORMS  (
	WIN_NAME ,
	TITLE ,
	OBJ_BROW_NAME ,
	OBJ_EDIT_NAME ,
	CROSS_UPDATE_EXPR ,
	EXPR_FLD_INFO ,
	TARGET_FLD_INFO ,
	EXPR_COMMENT ,
	FORM_NO ,
	AUTO_ACCEPT_SCAN ,
	SCAN_METADATA ,
	SCAN_FLAG ,
	SCR_FLAG ,
	PROPERTY_INFO ,
	EXT_COM ,
	EXT_METADATA ,
	EXT_SETUP ,
	AFTER_SAVE ,
	COLUMN_ON_SAVE ,
	SCAN_DELIMITER ,
	AUTO_ACCEPT_WEIGHDATA ,
	RATE_COL ,
	QTY_COL ,
	FORM_TYPE ,
	DISP_METADATA ,
	PARENT_KEY_COL )
VALUES (
	'w_asn',
	'ASN',
	'dw_asn_hdr_brow',
	'dw_asn_hdr_edit',
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
	
INSERT INTO OBJ_FORMS  (
	WIN_NAME ,
	TITLE ,
	OBJ_BROW_NAME ,
	OBJ_EDIT_NAME ,
	CROSS_UPDATE_EXPR ,
	EXPR_FLD_INFO ,
	TARGET_FLD_INFO ,
	EXPR_COMMENT ,
	FORM_NO ,
	AUTO_ACCEPT_SCAN ,
	SCAN_METADATA ,
	SCAN_FLAG ,
	SCR_FLAG ,
	PROPERTY_INFO ,
	EXT_COM ,
	EXT_METADATA ,
	EXT_SETUP ,
	AFTER_SAVE ,
	COLUMN_ON_SAVE ,
	SCAN_DELIMITER ,
	AUTO_ACCEPT_WEIGHDATA ,
	RATE_COL ,
	QTY_COL ,
	FORM_TYPE ,
	DISP_METADATA ,
	PARENT_KEY_COL )
VALUES (
	'w_asn',
	'Detail',
	'dw_asn_det_brow',
	'dw_asn_det_edit',
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);

INSERT INTO TRANSETUP  (
	TRAN_WINDOW ,
	SAVE_FLAG ,
	VAL_FLAG ,
	KEY_FLAG ,
	KEY_STRING ,
	UDF_1 ,
	UDF_2 ,
	UDF_3 ,
	UDF_4 ,
	UDF_5 ,
	REPEATE_ADD ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	EDI_OPTION ,
	SITE_ACC_COL ,
	CONFIRM_COL ,
	CONFIRM_VAL ,
	REPEAT_ADD_DET ,
	LOAD_MODE ,
	AUTO_CONFIRM ,
	LEDG_POST_CONF ,
	CHG_DATE_ON_CONF ,
	TRAN_ID_COL ,
	CONFIRM_MODE ,
	MAIL_OPTION ,
	GARBAGE_OPT ,
	VAL_FLAG_EDI ,
	VERIFY_PASSWORD ,
	SALES_PERS_ACC_COL ,
	CUST_ACC_COL ,
	SUPP_ACC_COL ,
	ITEM_SER_ACC_COL ,
	EMP_ACC_COL ,
	WORKFLOW_OPT ,
	TABLE_NAME ,
	APPLICATION ,
	TABLE_DESC ,
	TRAN_DATE_COL ,
	TRAN_ID__FROM ,
	TRAN_ID__TO ,
	ITEM_SER_ACC_CODE ,
	TABLE_NAME_DET1 ,
	TABLE_NAME_DET2 ,
	TABLE_NAME_DET3 ,
	MULTITIRE_OPT ,
	REF_SER ,
	VIEW_MODE ,
	TAX_FORMS ,
	SIGN_STATUS ,
	USER_TRAN_WINDOW ,
	CUSTOM_PREVIEW_OBJ ,
	IGNOREERRLIST_ONLOAD ,
	CHILDDATA_ARGOPT ,
	EDIT_TMPLT ,
	WRKFLW_INIT ,
	EDITTAX ,
	FORMAL_ARGS ,
	AUDIT_TRAIL_OPT ,
	EDIT_OPT ,
	CACHE_OPT ,
	OPTIMIZE_MODE ,
	EDIT_EXPR ,
	TRANSFER_MODE ,
	RATE_COL ,
	QTY_COL ,
	PROFILE_ID__RES ,
	PRINT_CONTROL ,
	RCP_CACHE_STATUS ,
	TRAN_COMPL_MSG ,
	WRKFLW_PRIORITY ,
	DISP_META_DATA ,
	PERIOD_OPTION ,
	EXEC_TYPE )
VALUES (
	'w_asn',
	'2',
	'2',
	'A',
	'seq10',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'N',
	fn_sysdate(),
	'Pawan',
	'Base',
	'0',
	NULL,
	NULL,
	NULL,
	'N',
	NULL,
	NULL,
	NULL,
	NULL,
	'TRAN_ID',
	'0',
	'0',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'0',
	'ASN_HDR',
	NULL,
	NULL,
	'TRAN_DATE',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'ASN',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'0',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	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',
	'post_item_change',
	'1',
	'poic_asn',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	'2',
	'0',
	'EJB',
	'AsnIC',
	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',
	'pre_validate',
	'1',
	'prv_asn',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	'2',
	'0',
	'EJB',
	'AsnIC',
	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',
	'pre_confirm',
	'1',
	'prcm_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 (
	'prv_asn',
	'pre validate asn',
	'http://localhost:9090/axis/services/ValidatorService',
	NULL,
	'wfValData',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base');

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 (
	'poic_asn',
	'Post Item Change asn',
	'http://localhost:9090/axis/services/ValidatorService',
	NULL,
	'itemChanged',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base');

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 (
	'prcm_asn',
	'Action For confirm',
	'http://localhost:9090/axis/services/ActionHandlerService',
	'BASE',
	'confirm',
	'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 (
	'poic_asn',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'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 (
	'poic_asn',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	'AsnIC');

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 (
	'poic_asn',
	3,
	'XML_DATA',
	'I',
	NULL,
	'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 (
	'poic_asn',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'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 (
	'poic_asn',
	5,
	'XML_DATA_2',
	'I',
	NULL,
	'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 (
	'poic_asn',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'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 (
	'poic_asn',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'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 (
	'poic_asn',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'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 (
	'poic_asn',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'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 (
	'prv_asn',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'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 (
	'prv_asn',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	'AsnIC');

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 (
	'prv_asn',
	3,
	'XML_DATA',
	'I',
	NULL,
	'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 (
	'prv_asn',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'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 (
	'prv_asn',
	5,
	'XML_DATA_2',
	'I',
	NULL,
	'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 (
	'prv_asn',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'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 (
	'prv_asn',
	7,
	'EDIT_FLAG',
	'I',
	NULL,
	'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 (
	'prv_asn',
	8,
	'XTRA_PARAMS',
	'I',
	NULL,
	'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 (
	'prcm_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 (
	'prcm_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 (
	'prcm_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 (
	'prcm_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 (
	'prcm_asn',
	5,
	'FORCED_FLAG',
	'I',
	'Forced Flag',
	'S',
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL);

INSERT INTO MESSAGES (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLASNNUM',
	'NULL ASN NO',
	'ASN No can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'INVASNNUMR',
	'INVALID ASN NO',
	'ASN No already exist',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULASNDATE',
	'NULL ASN DATE',
	'ASN date can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLTRANCD',
	'NULL TRAN CODE',
	'Tran code can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'INVTRANCOD',
	'INVALID TRAN CODE',
	'Tran code must exist in transporter master',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULITEMCOD',
	'NULL ITEM CODE',
	'Item code can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'IVITMCDASN',
	'INVALID ITEM CODE',
	'Item code must exist in item master',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLQUANTY',
	'NULL QUANTITY',
	'Quantity can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'INVQUNTITY',
	'INVALID QUANTITY',
	'Quantity must be greater than zero',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLLRNUMR',
	'NULL LORRY NUMBER',
	'Lorry number can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLGRSWGT',
	'NULL GROSS WEIGHT',
	'Gross weight can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLBOLNUM',
	'NULL BOL NUMBER',
	'BOL Number can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLINVNUM',
	'NULL INVOICE NUMBER',
	'Invoice number can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLPURORD',
	'NULL PURCHASE ORDER',
	'Purchase order can`t be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULEMPAVPR',
	'NULL EMP_CODE_APRV',
	'Employee code approver can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLPACKSZ',
	'NULL PACK SIZE',
	'Pack size can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLCONTNR',
	'NULL CONTAINER NUMBER',
	'Container number can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLLOTNUM',
	'NULL LOT NUMBER',
	'Lot number can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULCUSTREF',
	'NULL CUST_ITEM__REF',
	'Customer item reference can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'NULLASNDAT',
	'NULL ASN DATE',
	'ASN Date can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'PURORDEXST',
	'PURCHASE ORDER EXIST',
	'Purchase order already exist',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);

INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'PORCREATED',
	'PORDER CREATED',
	'Purchase order created',
	'P',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);	
	
INSERT INTO MESSAGES  (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
VALUES (
	'UNCONFDASN',
	'ASN UNCONFIRMED',
	'Asn must be confirmed to create purchase order',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);	

INSERT INTO MESSAGES (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
 VALUES (
	'ASNCONFIRM',
	'ASN Confirmed',
	'Advanced Shipment Notification confirmed sucessfully',
	'P',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);
	
INSERT INTO MESSAGES (
	MSG_NO ,
	MSG_STR ,
	MSG_DESCR ,
	MSG_TYPE ,
	MSG_OPT ,
	MSG_TIME ,
	ALARM ,
	ERR_SOURCE ,
	CHG_DATE ,
	CHG_USER ,
	CHG_TERM ,
	OVERRIDE_INPUT ,
	MAIL_OPTION )
 VALUES (
	'ASNCONFEMD',
	'ASN Confirmed',
	'Advanced Shipment Notification already confirmed',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Pawan',
	'Base',
	NULL,
	NULL);	

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',
	'tran_code',
	NULL);
	
INSERT INTO OBJ_ITEMCHANGE
 (
	OBJ_NAME ,
	FORM_NO ,
	FIELD_NAME ,
	MANDATORY )
VALUES (
	'asn',
	'1',
	'emp_code__aprv',
	NULL);
	
INSERT INTO OBJ_ITEMCHANGE
 (
	OBJ_NAME ,
	FORM_NO ,
	FIELD_NAME ,
	MANDATORY )
VALUES (
	'asn',
	'2',
	'item_code',
	NULL);
	
INSERT INTO messages (
	msg_no ,
	msg_str,
	msg_descr ,
	msg_type ,
	msg_opt ,
	msg_time ,
	alarm ,
	err_source ,
	chg_date ,
	chg_user ,
	chg_term ,
	override_input ,
	mail_option )
VALUES (
	'INVRATE',
	'Rate not defined!',
	'Rate not defined, please define the rate',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	NULL,
	NULL);

spool off
