spool C:\wms_log\WM1FSUN008.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,
	19,
	0,
	0,
	0,
	'w_inv_freeze',
	'Physical Count Scan',
	'Physical Count Scan',
	'SFA.1.19.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'W',
	NULL,
	'Pragyan',
	'Pragyan   ');


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_inv_freeze',
	'2',
	'2',
	'A',
	'_spsite_code,P,seq05',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'Y',
	fn_sysdate(),
	'SUN',
	'97KANDARP',
	'0',
	'SITE_CODE',
	'CONFIRMED',
	'Y',
	'N',
	NULL,
	'N',
	'N',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'INV_FREEZE',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'0',
	NULL,
	NULL,
	NULL,
	'P-CNT',
	'F',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'3',
	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 (
	'inv_freeze',
	4,
	'S',
	'a',
	'a',
	'Saving',
	'Save',
	'save.gif',
	'S',
	'1',
	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,
	assisted_mode)
VALUES (
	'w_inv_freeze',
	'Freeze',
	'd_inv_freeze_brow',
	'd_inv_freeze_edit',
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	NULL,
	NULL,
	'F',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'<EFF_DATE>, <SITE_CODE>, <ITEM_SER__FROM>, <ITEM_SER__TO>, <LOC_CODE__FROM>, <LOC_CODE__TO>',
	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_inv_freeze',
	'Detail',
	'd_inv_freeze_det_brow',
	'd_inv_freeze_det_edit',
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	'<SCAN_INFO><INPUT_SCAN ORDER="1"> <SCAN_LABEL>Pallet No:</SCAN_LABEL> <FIELDS SEPARATOR="" DELIMITER=""> <FIELD>lot_no</FIELD> </FIELDS> </INPUT_SCAN> </SCAN_INFO>',
	NULL,
	'T',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'<item_code> ,<site_code> , <loc_code> , <lot_no> , <lot_sl> , <quantity> , <qty_physical>',
	NULL,
	'E');


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 (
	'inv_freeze',
	'pre_save',
	'1',
	'prsr_inv_freeze',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'BASE',
	'2',
	'0',
	'EJB',
	'InvFreezePreSave',
	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(
	'inv_freeze',
	'pre_validate',
	'1',
	'prv_inv_freeze',
	NULL,
	fn_sysdate(),
	'sumit ',
	'BASE',
	'2',
	'0',
	'EJB',
	'InvFreezeIC',
	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(
	'inv_freeze',
	'default_data_wiz',
	'1',
	'inv_freeze_default_data',
	NULL,
	fn_sysdate(),
	'base',
	'base',
	'2',
	'0',
	'EJB',
	'InvFreezeIC',
	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(
	'inv_freeze',
	'pre_freeze',
	'1',
	'prcm_default_ejb',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'PhysicalInvFreezeConf',
	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(
	'inv_freeze',
	'pre_navigate',
	'1',
	'prv_inv_freeze',
	NULL,
	fn_sysdate(),
	'sumit ',
	'BASE',
	'2',
	'0',
	'EJB',
	'InvFreezeIC',
	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 (
	'inv_freeze_default_data',
	'Default Data',
	'http://192.168.0.124/BaseE12DotNetService5-18-001/E12BusinessLogic5-18-001.asmx',
	'BASE',
	'itemChanged',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'prv_inv_freeze',
	'Validation',
	'http://192.168.0.124/BaseE12DotNetService5-18-001/E12BusinessLogic5-18-001.asmx',
	'BASE',
	'wfValData',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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 (
	'prsr_inv_freeze',
	'preSave',
	'http://192.168.0.124/BaseE12DotNetService5-18-001/E12BusinessLogic5-18-001.asmx',
	'BASE',
	'preSave',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_default_ejb',
	'Action To confirm',
	'http://localhost:9090/axis/services/ActionHandlerService',
	'Base Information',
	'confirm',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'base',
	'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 (
	'prcm_default_ejb',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'C.String',
	NULL,
	fn_sysdate(),
	'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 (
	'prcm_default_ejb',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'PhysicalInvFreezeConf');

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_default_ejb',
	3,
	'<tran_id>',
	'I',
	'tranid',
	'C.String',
	NULL,
	fn_sysdate(),
	'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 (
	'prcm_default_ejb',
	4,
	'XTRA_PARAMS',
	'I',
	'Extra Arguments',
	'S',
	NULL,
	fn_sysdate(),
	'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 (
	'prcm_default_ejb',
	5,
	'FORCED_FLAG',
	'I',
	'Forced Flag',
	'S',
	NULL,
	fn_sysdate(),
	'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 (
	'inv_freeze_default_data',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'Pragyan',
	'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 (
	'inv_freeze_default_data',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'Pragyan',
	'InvFreezeIC');

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 (
	'inv_freeze_default_data',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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 (
	'inv_freeze_default_data',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Pragyan   ',
	'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_inv_freeze',
	1,
	'COMPONENT_TYPE',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	2,
	'COMPONENT_NAME',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'BASE',
	'InvFreezeIC');

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_inv_freeze',
	3,
	'XML_DATA',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	4,
	'XML_DATA_1',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	5,
	'XML_DATA_ALL',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	6,
	'OBJ_CONTEXT',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	7,
	'EDIT_FLAG',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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_inv_freeze',
	8,
	'XTRA_PARAMS',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'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 (
	'prsr_inv_freeze',
	1,
	'COMPONENT_TYPE',
	'l',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	'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 (
	'prsr_inv_freeze',
	2,
	'COMPONENT_NAME',
	'l',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	'InvFreezePreSave');

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 (
	'prsr_inv_freeze',
	3,
	'XML_DATA_ALL',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	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 (
	'prsr_inv_freeze',
	4,
	'EDIT_FLAG',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	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 (
	'prsr_inv_freeze',
	5,
	'XTRA_PARAMS',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	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 (
	'prsr_inv_freeze',
	6,
	'DB_CONN',
	'l',
	NULL,
	'S.Connection',
	NULL,
	fn_sysdate(),
	'Sumit ',
	'Sumit ',
	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 (
	'INVSITECOD',
	'Invalid Site Code',
	'Site Code should be present in site master. Enter valid Site Code',
	'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 (
	'NULLSITECO',
	'Null site code ',
	'Please enter site code',
	'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 (
	'NULLOCCODF',
	'Null Location Code From',
	'Location code from can not be null',
	'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 (
	'INVLOCCODF',
	'Invalid ocation Code From',
	'Please enter valid location code from',
	'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 (
	'NULLLOCODT',
	'Null Location Code To',
	'Location code To can not be null',
	'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 (
	'INVLOCCODT',
	'Invalid ocation Code To',
	'Please enter valid location code from',
	'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 (
	'NULITMSERF',
	'Null Item Series From',
	'Item Series From can not be null',
	'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 (
	'INVITMSERF',
	'Invalid Item Series From',
	'Please enter valid Item Series From ',
	'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 (
	'NULITMSERT',
	'Null Item Series To',
	'Item Series To can not be null',
	'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 (
	'INVITMSERT',
	'Invalid Item Series To',
	'Please enter valid Item Series To',
	'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 (
	'NULITMCODF',
	'Null Item Code From ',
	'Item Code From can not be null',
	'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 (
	'INVITMCODF',
	'Invalid Item Code From ',
	'Please enter valid Item Code From',
	'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 (
	'NULITMCODT',
	'Null Item Code To',
	'Item Code To can not be null',
	'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 (
	'INVITMCODT',
	'Invalid Item Code To',
	'Please enter valid Item Code To',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL,
	NULL);

spool off
