spool C:\wms_log\WM1HSUN002.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,
	24,
	0,
	0,
	0,
	'w_consolidate',
	'Consolidation Process',
	'Consolidation Process',
	'SFA.1.24.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	fn_sysdate(),
	'Sumit',
	'Sumit');


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_consolidate',
	'2',
	'2',
	'A',
	'seq10',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'Y',
	fn_sysdate(),
	'SUMIT     ',
	'SUMIT          ',
	'0',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);


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 (
	'consolidate',
	8,
	'R',
	'a',
	'process',
	'Action Button for processing the data',
	'Process',
	NULL,
	'U',
	'1',
	'3',
	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,
	assisted_mode)
VALUES (
	'w_consolidate',
	'Consolidation Proces',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	NULL,
	NULL,
	'F',
	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 (
	'consolidate',
	'process',
	'1',
	'pr_consolidate',
	NULL,
	fn_sysdate(),
	'BASE      ',
	'BASE',
	'2',
	'0',
	'EJB',
	'ConsolidatToDocPrc',
	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 (
	'pr_consolidate',
	'Action To process the Data',
	'http://localhost:9090/axis/services/ProcessService',
	NULL,
	'process',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'SUMIT');

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 (
	'pr_consolidate',
	1,
	'COMPONENT_TYPE',
	'l',
	'Component Type',
	'C.String',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	'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 (
	'pr_consolidate',
	2,
	'COMPONENT_NAME',
	'l',
	'Component Name',
	'C.String',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	'ConsolidatToDocPrc');

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 (
	'pr_consolidate',
	3,
	'XML_DATA_1',
	'l',
	'XML data of form no 1',
	'S',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	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 (
	'pr_consolidate',
	4,
	'XML_DATA__ALL',
	'l',
	'XML data of form no 1',
	'S',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	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 (
	'pr_consolidate',
	5,
	'OBJ_CONTEXT',
	'l',
	'Object Context',
	'S',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	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 (
	'pr_consolidate',
	6,
	'XTRA_PARAMS',
	'l',
	'Extra Arguments',
	'S',
	NULL,
	fn_sysdate(),
	'SUMIT     ',
	'BASE92',
	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 (
	'NULLPTCNID',
	'PTCN number is null',
	'PTCN No. can not be null',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE92',
	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 (
	'INVPTCNID',
	'Invalid PTCN id',
	'Please insert valid PTCN ID',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE92',
	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 (
	'VTCONPARM',
	'Transaction is Saved',
	'Transaction saved save successfully',
	'P',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE92',
	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 (
	'VTNOTCONFM',
	'Transaction is not Saved',
	'Transaction is not Saved',
	'P',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE92',
	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 (
	'CONALEXIST',
	'Shipment confirmed',
	'Shipment is already consolidated',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'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 (
	'ALLTASKNOF',
	'Unconfirm Task is present',
	'Unconfirm Task is present, please confirm all the task first then do process for consolidated to dock',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL,
	NULL);

spool off
