spool C:\wms_log\WM1FSUN009.txt

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_phycnt_sch',
	'2',
	'2',
	'A',
	'seq10',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'N',
	fn_sysdate(),
	'BASE',
	'BASE',
	'0',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'N',
	NULL,
	'TRAN_ID',
	NULL,
	'0',
	NULL,
	NULL,
	NULL,
	'PHY_CNT_SCH',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'0',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'PS-CNT',
	'F',
	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 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,
	17,
	0,
	0,
	0,
	'w_phycnt_sch',
	'Physical Count Schedule',
	'Physical Count Schedule',
	'SFA.1.17.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	fn_sysdate(),
	'base',
	'base');


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 (
	'phycnt_sch',
	1,
	'R',
	'a',
	'process',
	'Action Button for processing the data',
	'Process',
	NULL,
	'U',
	'2',
	'3',
	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 (
	'phycnt_sch',
	2,
	'R',
	'a',
	'get_data',
	'Action Button for getting data',
	'GetData',
	NULL,
	'U',
	'2',
	'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_phycnt_sch',
	'PhysicalCnt Schedul',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	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,
	assisted_mode)
VALUES (
	'w_phycnt_sch',
	'PhysicalCnt Sch det',
	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);


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 (
	'phycnt_sch',
	'get_data',
	'1',
	'agetData_PhySch',
	NULL,
	fn_sysdate(),
	'base',
	'base',
	'2',
	'0',
	'EJB',
	'PhysicalCountPrcEJB',
	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 (
	'phycnt_sch',
	'process',
	'1',
	'aprocessPhySch',
	NULL,
	fn_sysdate(),
	'base',
	'base',
	'2',
	'0',
	'EJB',
	'PhysicalCountPrcEJB',
	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 (
	'aprocessPhySch',
	'Action To process the Data',
	'http://192.168.0.130/BaseE12DotNetService5-18-001/E12BusinessLogic5-18-001.asmx',
	'Base Information',
	'process',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASED');

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 (
	'agetData_PhySch',
	'Action To get the Data',
	'http://192.168.0.130/BaseE12DotNetService5-18-001/E12BusinessLogic5-18-001.asmx',
	'Base Information',
	'getData',
	'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 (
	'aprocessPhySch',
	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 (
	'aprocessPhySch',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'PhysicalCountPrcEJB');

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 (
	'aprocessPhySch',
	3,
	'XML_DATA_1',
	'I',
	'XML data of form no 1',
	'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 (
	'aprocessPhySch',
	4,
	'XML_DATA__ALL',
	'I',
	'XML data of form no 1',
	'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 (
	'aprocessPhySch',
	5,
	'OBJ_CONTEXT',
	'I',
	'Object Context',
	'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 (
	'aprocessPhySch',
	6,
	'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 (
	'agetData_PhySch',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'S',
	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 (
	'agetData_PhySch',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'PhysicalCountPrcEJB');

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 (
	'agetData_PhySch',
	3,
	'XML_DATA',
	'I',
	'XML data of form no 1',
	'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 (
	'agetData_PhySch',
	4,
	'XML_DATA_1',
	'I',
	'XML data of form no All',
	'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 (
	'agetData_PhySch',
	5,
	'WINDOW_NAME',
	'I',
	'Window Name',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'w_phycnt_sch');


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 (
	'agetData_PhySch',
	6,
	'XTRA_PARAMS',
	'I',
	'Extra Arguments',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'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 (
	'VMINVSITE ',
	'Site Code does not exist !',
	'Site code does not exist, please 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 (
	'VTSCHGEN ',
	'Schedule already generated',
	'Schedule already generated for the entered input parameters',
	'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 (
	'VMNLINVST ',
	'Null Inventory status',
	'Inventory status 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 (
	'VMINVSTAT ',
	'Invalid inventory status',
	'Please enter valid invantory status',
	'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 (
	'VTINVDATTO',
	'Invalid Date To',
	'Entered Date To is before date of Date From',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BAE ',
	'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 (
	'VTMNULSITE',
	'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 (
	'VTNULDATEF',
	'Please enter Date From',
	'Date 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 (
	'VTNULDATET',
	'Please enter Date To',
	'Date 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 (
	'VTNULLANAC',
	'Null class type',
	'Please select class type',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	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 (
	'misc_voucher_oth_site',
	'pre_confirm',
	'1',
	'prcm_default_ejb',
	null,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'MiscValConf',
	NULL
);

insert into system_event_services(
service_code,
service_descr,
service_uri,
service_provider,
method_name,
return_value,
return_type,
chg_date,
chg_user,
chg_term)
values
('prcm_default_ejb',
'Action To confirm',
'http://localhost:9090/axis/services/ActionHandlerService',
'Base Information',
'confirm',
'String',
'S',
sysdate,
'base',
'base');

insert into system_service_args(
SERVICE_CODE,  
LINE_NO,  
ARG_NAME, 
ARG_MODE,
DESCR,
ARG_TYPE,
CHG_DATE,
CHG_USER,
CHG_TERM,
ARG_VALUE )
values
('prcm_default_ejb',
'1',
'COMPONENT_TYPE',
'I',
'Component Type',
'C.String',
sysdate,
'BASE',
'BASE',
'EJB');

insert into system_service_args(
SERVICE_CODE,  
LINE_NO,  
ARG_NAME, 
ARG_MODE,
DESCR,
ARG_TYPE,
CHG_DATE,
CHG_USER,
CHG_TERM,
ARG_VALUE )
values
('prcm_default_ejb',
'2',
'COMPONENT_NAME',
'I',
'Component Name',
'C.String',
sysdate,
'BASE',
'BASE',
'MiscValConf');

insert into system_service_args(
SERVICE_CODE,  
LINE_NO,  
ARG_NAME, 
ARG_MODE,
DESCR,
ARG_TYPE,
CHG_DATE,
CHG_USER,
CHG_TERM,
ARG_VALUE )
values
('prcm_default_ejb',
'3',
'<tran_id>',
'I',
'tranid',
'C.String',
sysdate,
'BASE',
'BASE',
null);

insert into system_service_args(
SERVICE_CODE,  
LINE_NO,  
ARG_NAME, 
ARG_MODE,
DESCR,
ARG_TYPE,
CHG_DATE,
CHG_USER,
CHG_TERM,
ARG_VALUE )
values
('prcm_default_ejb',
'4',
'XTRA_PARAMS',
'I',
'Extra Arguments',
'S',
sysdate,
'BASE',
'BASE',
null);

insert into system_service_args(
SERVICE_CODE,  
LINE_NO,  
ARG_NAME, 
ARG_MODE,
DESCR,
ARG_TYPE,
CHG_DATE,
CHG_USER,
CHG_TERM,
ARG_VALUE )
values
('prcm_default_ejb',
'5',
'FORCED_FLAG',
'I',
'Forced Flag',
'S',
sysdate,
'BASE',
'BASE',
null);

spool off
