spool C:\wms_log\WM1FSUN006.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,
	14,
	0,
	0,
	0,
	'w_near_expiry_prc',
	'Near Expiry',
	'Near Expiry',
	'SFA.1.14.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	fn_sysdate(),
	'BASE141',
	'Gulzar');
INSERT INTO obj_forms (
	win_name ,
	title ,
	obj_brow_name ,
	obj_edit_name ,
	form_no,
	scr_flag)
VALUES (
	'w_near_expiry_prc',
	'Near Expiry',
	'',
	'',
	'1',
	'F');
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	chg_date ,
	chg_term ,
	chg_user)
VALUES (
	'near_expiry_prc',
	 1,
	'P',
	'a',
	'process',
	'Action Button for processing the data',
	'Process',
	'process~normal.gif',
	'U',
	'1',
	fn_sysdate(),
	'BASE',
	'Gulzar');
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name)
 VALUES(
	'near_expiry_prc',
	'1',
	'itm_default');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name)
VALUES (
	'near_expiry_prc',
	'pre_validate',
	'1',
	'prv_near_expiry_prc',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'NearExpiryIC');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name )
VALUES (
	'near_expiry_prc',
	'post_item_change',
	'1',
	'poic_near_expiry_prc',
	 fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'NearExpiryIC');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name )
VALUES (
	'near_expiry_prc',
	'process',
	'1',
	'prc_near_expiry_prc',
	 fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'NearExpiryPrc');

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 (
	'prv_near_expiry_prc',
	'Validation',
	'http://localhost:9090/axis/services/ValidatorService',
	'BASE',
	'wfValData',
	'String',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
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 (
	'poic_near_expiry_prc',
	'post item change',
	'http://localhost:9090/axis/services/ValidatorService',
	'BASE',
	'itemChanged',
	'String',
	'S',
	fn_sysdate(),
	'Gulzar',
	'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 (
	'prc_near_expiry_prc',
	'Process',
	'http://localhost:9090/axis/services/ProcessService',
	NULL,
	'process',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term ,
	arg_value )
VALUES (
	'prv_near_expiry_prc',
	 1,
	'COMPONENT_TYPE',
	'I',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term ,
	arg_value)
VALUES (
	'prv_near_expiry_prc',
	2,
	'COMPONENT_NAME',
	'I',	
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'NearExpiryIC');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'prv_near_expiry_prc',
	3,
	'XML_DATA',
	'l',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'prv_near_expiry_prc',
	4,
	'XML_DATA_1',
	'l',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
 VALUES (
	'prv_near_expiry_prc',
	5,
	'XML_DATA_ALL',
	'l',	
	'S',	
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'prv_near_expiry_prc',
	6,
	'OBJ_CONTEXT',
	'l',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'prv_near_expiry_prc',
	 7,
	'EDIT_FLAG',
	'l',	
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'prv_near_expiry_prc',
	8,
	'XTRA_PARAMS',
	'l',	
	'S',	
	fn_sysdate(),
	'Gulzar',
	'BASE');

INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term ,
	arg_value )
VALUES (
	'poic_near_expiry_prc',
	 1,
	'COMPONENT_TYPE',
	'I',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term ,
	arg_value )
VALUES (
	'poic_near_expiry_prc',
	 2,
	'COMPONENT_NAME',
	'I',	
	'S',	
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'NearExpiryIC');

INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	3,
	'XML_DATA',
	'I',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');

INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	4,
	'XML_DATA_1',
	'I',
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
				
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	5,
	'XML_DATA_ALL',
	'I',	
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');

INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	6,
	'OBJ_CONTEXT',
	'I',
	'S',	
	fn_sysdate(),
	'Gulzar',
	'BASE');

INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	 7,
	'FOCUSED_COLUMN',
	'I',	
	'S',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES (
	'poic_near_expiry_prc',
	8,
	'EDIT_FLAG',
	'I',
	'S',	
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	arg_type ,	
	chg_date ,
	chg_user,
	chg_term )
VALUES(
	'poic_near_expiry_prc',
	9,
	'XTRA_PARAMS',
	'I',
	'S',	
	fn_sysdate(),
	'Gulzar',
	'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 (
	'prc_near_expiry_prc',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	'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 (
	'prc_near_expiry_prc',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	'NearExpiryPrc');
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 (
	'prc_near_expiry_prc',
	3,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'prc_near_expiry_prc',
	4,
	'XML_DATA__ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'prc_near_expiry_prc',
	5,
	'win_name',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	'w_near_expiry_prc');
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 (
	'prc_near_expiry_prc',
	6,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'NULEXPLOCK',
	'Expiry Lock is blank!',
	'Lock code for expiry can not be blank, please check the disparm variable ',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'NODATAERR',
	'No Data found!',
	'No data found to process, please check the data',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'PRCSUCCESS',
	'Process Completed!',
	'Process Completed Successfully',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	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 (
	'PRCFAILED',
	'Process Failed!',
	'Process Failed, please check the data and do the process again',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	NULL,
	NULL);

INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'EXP_LOCK',
	'S',
	'EXP_LOCK',
	'EXPIRY LOCATION',
	0,
	fn_sysdate(),
	'BASE',
	'GULZAR',
	NULL);
INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'NEAR_EXP_LOCK',
	'S',
	'NEXP_LOCK',
	'NEAR EXPIRY LOCATION',
	0,
	fn_sysdate(),
	'BASE',
	'GULZAR',
	NULL);
INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'RESERV_LOC',
	'S',
	'RESRV',
	'Default Value for stock items in reserve location',
	0,
	fn_sysdate(),
	'BASE',
	'GULZAR',
	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 (
	'VTLOCCODE7',
	'Invalid Location code!',
	'Entered location code does not exist for reserve location ',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE141',
	NULL,
	NULL);
INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'LOCK_OR_TRANSFER',
	'S',
	'T',
	'lock or transfer',
	0,
	fn_sysdate(),
	'BASE', 
	'GULZAR',
	NULL);
INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'NEAREXP_LOC',
	'S',
	'NEXP',
	'Near Expiry location',
	0,
	fn_sysdate(),
	'BASE', 
	'GULZAR',
	NULL);
INSERT INTO disparm (
	prd_code ,
	var_name ,
	var_type ,
	var_value ,
	descr ,
	var_subs ,
	chg_date ,
	chg_user ,
	chg_term ,
	min_order_qty )
VALUES (
	'999999',
	'EXP_LOC',
	'S',
	'EXPR',
	'Expired location',
	0,
	fn_sysdate(),
	'BASE', 
	'GULZAR',
	NULL);

spool off
