spool C:\wms_log\WM1HSUN003.txt

CREATE TABLE CARTON_MASTER(
CARTON_NO 		VARCHAR(15) NOT NULL,
STATUS			CHAR(1),
CHG_USER		CHAR(10),
CHG_DATE		DATE,
CHG_TERM		VARCHAR2(15));

ALTER TABLE CARTON_MASTER ADD CONSTRAINT PK_CARTON_MASTER PRIMARY KEY(CARTON_NO);

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,
	26,
	0,
	0,
	0,
	'w_carton_no_gen',
	'Carton No Gen',
	'Carton No Gen',
	'SFA.1.26.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	fn_sysdate(),
	'chaitali',
	'chaitali');

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,
	29,
	0,
	0,
	0,
	'w_master_pack',
	'Master packing',
	'Master packing',
	'SFA.1.29.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'W',
	fn_sysdate(),
	'chaitali',
	'chaitali');

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 ,
	mail_option ,
	confirm_mode ,
	garbage_opt ,
	val_flag_edi ,
	verify_password ,
	table_name ,
	application ,
	table_desc ,
	tran_date_col ,
	sales_pers_acc_col ,
	cust_acc_col ,
	supp_acc_col ,
	item_ser_acc_col ,
	emp_acc_col ,
	workflow_opt ,
	tran_id__from ,
	tran_id__to ,
	multitire_opt ,
	ref_ser ,
	view_mode ,
	table_name_det1 ,
	table_name_det2 ,
	table_name_det3 ,
	tax_forms ,
	sign_status ,
	user_tran_window ,
	custom_preview_obj ,
	childdata_argopt ,
	ignoreerrlist_onload ,
	edit_tmplt ,
	wrkflw_init ,
	formal_args ,
	edit_opt ,
	audit_trail_opt ,
	edittax ,
	cache_opt ,
	optimize_mode ,
	edit_expr ,
	transfer_mode ,
	rate_col ,
	qty_col ,
	rcp_cache_status ,
	print_control ,
	item_ser_acc_code ,
	profile_id__res ,
	period_option ,
	tran_compl_msg ,
	wrkflw_priority ,
	exec_type ,
	disp_meta_data )
VALUES (
	'w_master_pack',
	'2',
	'2',
	'A',
	'MPK,seq07',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'Y',
	fn_sysdate(),
	'Chaitali',
	'SYSTEM ',
	'0',
	NULL,
	'CONFIRMED',
	'Y',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'tran_id',
	'0',
	'0',
	'N',
	NULL,
	NULL,
	'pack_hdr',
	'WMS',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'M-PACK',
	'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,
	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 ,
	mail_option ,
	confirm_mode ,
	garbage_opt ,
	val_flag_edi ,
	verify_password ,
	table_name ,
	application ,
	table_desc ,
	tran_date_col ,
	sales_pers_acc_col ,
	cust_acc_col ,
	supp_acc_col ,
	item_ser_acc_col ,
	emp_acc_col ,
	workflow_opt ,
	tran_id__from ,
	tran_id__to ,
	multitire_opt ,
	ref_ser ,
	view_mode ,
	table_name_det1 ,
	table_name_det2 ,
	table_name_det3 ,
	tax_forms ,
	sign_status ,
	user_tran_window ,
	custom_preview_obj ,
	childdata_argopt ,
	ignoreerrlist_onload ,
	edit_tmplt ,
	wrkflw_init ,
	formal_args ,
	edit_opt ,
	audit_trail_opt ,
	edittax ,
	cache_opt ,
	optimize_mode ,
	edit_expr ,
	transfer_mode ,
	rate_col ,
	qty_col ,
	rcp_cache_status ,
	print_control ,
	item_ser_acc_code ,
	profile_id__res ,
	period_option ,
	tran_compl_msg ,
	wrkflw_priority ,
	exec_type ,
	disp_meta_data )
VALUES (
	'w_carton_no_gen',
	'2',
	'2',
	'A',
	'seq10',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'Y',
	fn_sysdate(),
	'Chaitali',
	'SYSTEM ',
	'0',
	NULL,
	NULL,
	'Y',
	'Y',
	NULL,
	NULL,
	NULL,
	NULL,
	'carton_no',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'carton_master',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'0',
	NULL,
	NULL,
	NULL,
	'M-CART',
	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_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_carton_no_gen',
	'Process',
	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_master_pack',
	'Master Packing',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	'<SCAN_INFO><INPUT_SCAN ORDER="1"><SCAN_LABEL>Master Pack Carton No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>outer_carton_no</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="2"><SCAN_LABEL>Packing Task ID:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>tran_id</FIELD></FIELDS></INPUT_SCAN></SCAN_INFO>',
	NULL,
	'F',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'E');
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_master_pack',
	'Header',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	NULL,
	NULL,
	'F',
	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_master_pack',
	'Detail',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'3',
	NULL,
	'<SCAN_INFO><MAPPING_SCAN ORDER="1"><SCAN_LABEL>Carton No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>carton_no</FIELD></FIELDS></MAPPING_SCAN></SCAN_INFO>',
	NULL,
	'T',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'<carton_no>',
	NULL,
	'E');

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 (
	'master_pack',
	1,
	'S',
	NULL,
	NULL,
	'Saving',
	'Finish',
	NULL,
	'U',
	'3',
	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 (
	'carton_no_gen',
	1,
	'R',
	'a',
	'process',
	'Action Button for processing the data',
	'Process',
	NULL,
	'U',
	'1',
	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 (
	'carton_no_gen',
	'pre_validate',
	'1',
	'prv_default_ejb',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'CartonNoGenIC',
	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 (
	'carton_no_gen',
	'process',
	'1',
	'prc_carton_no_gen',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'CartonNoGenPrc',
	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 (
	'master_pack',
	'default_data_wiz',
	'1',
	'master_pack_default_data',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'MasterPackIC',
	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 (
	'master_pack',
	'post_save',
	'1',
	'pos_master_pack',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'2',
	'0',
	'EJB',
	'MasterPackPos',
	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 (
	'master_pack',
	'pre_navigate',
	'1',
	'prv_master_pack',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'MasterPackIC',
	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 (
	'master_pack',
	'pre_save',
	'1',
	'prsr_master_pack',
	NULL,
	fn_sysdate(),
	'chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'MasterPackPrs',
	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 (
	'master_pack',
	'pre_validate',
	'1',
	'prv_master_pack',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'2',
	'0',
	'EJB',
	'MasterPackIC',
	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 (
	'master_pack_default_data',
	'Default Data',
	'http://localhost:9090/axis/services/ValidatorService',
	'BASE',
	'itemChanged',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'pos_master_pack',
	'postSave',
	'http://localhost:9090/axis/services/ValidatorService',
	'BASE',
	'postSave',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali');

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_carton_no_gen',
	'Process',
	'http://localhost:9090/axis/services/ProcessService',
	NULL,
	'process',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'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_master_pack',
	'preSave',
	'http://localhost:9090/axis/services/ValidatorService',
	NULL,
	'preSave',
	NULL,
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'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_default_ejb',
	NULL,
	'http://localhost:9090/axis/services/ProcessService',
	NULL,
	'wfValData',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Subrata ',
	'Subu');
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_master_pack',
	'Validation',
	'http://localhost:9090/axis/services/ValidatorService',
	'BASE',
	'wfValData',
	'String',
	'S',
	NULL,
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'prsr_master_pack',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'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_master_pack',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'MasterPackPrs');

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_master_pack',
	3,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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_master_pack',
	4,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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_master_pack',
	5,
	'XTRA_PARAMS',
	NULL,
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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_master_pack',
	6,
	'DB_CONN',
	NULL,
	NULL,
	'S.Connection',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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_master_pack',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'MasterPackIC');

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_master_pack',
	3,
	'XML_DATA',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	4,
	'XML_DATA_1',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	5,
	'XML_DATA_ALL',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	6,
	'OBJ_CONTEXT',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	7,
	'EDIT_FLAG',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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_master_pack',
	8,
	'XTRA_PARAMS',
	'l',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'pos_master_pack',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'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 (
	'pos_master_pack',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'MasterPackPos');
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 (
	'pos_master_pack',
	3,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'pos_master_pack',
	4,
	'<tran_id>',
	'I',
	NULL,
	'B.String',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'pos_master_pack',
	5,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'pos_master_pack',
	6,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'pos_master_pack',
	7,
	'DB_CONN',
	'I',
	NULL,
	'S.Connection',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'master_pack_default_data',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'BASE',
	'MaterPackIC');
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 (
	'master_pack_default_data',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'master_pack_default_data',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Chaitali',
	'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 (
	'prc_carton_no_gen',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'C.String',
	NULL,
	fn_sysdate(),
	'chaitali',
	'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 (
	'prc_carton_no_gen',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'C.String',
	NULL,
	fn_sysdate(),
	'chaitali',
	'BASE',
	'CartonNoGenPrc');
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_carton_no_gen',
	3,
	'XML_DATA_1',
	'I',
	'XML data of form no 1',
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'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 (
	'prc_carton_no_gen',
	4,
	'XML_DATA__ALL',
	'I',
	'XML data of form no 1',
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'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 (
	'prc_carton_no_gen',
	5,
	'WINDOW_NAME',
	'I',
	'Object Context',
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'BASE',
	'w_carton_no_gen');
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_carton_no_gen',
	6,
	'XTRA_PARAMS',
	'I',
	'Extra Arguments',
	'S',
	NULL,
	fn_sysdate(),
	'chaitali',
	'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_default_ejb',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	7,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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_default_ejb',
	8,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Manohar ',
	'Manohar',
	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 (
	'NULLTASKID',
	'NULL Task ID!',
	'Task ID can not be blank, please enter valid Task ID!',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'INVTASKID',
	'Task id not exist!',
	'Task ID entered does not exist, please enter valid Task ID',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'NULLTRANDT',
	'NULL transaction date!',
	'Transaction date can not be blank !',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'NULLSITECD',
	'NULL site code!',
	'Site can not be blank, please enter valid site code !',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'INVSITECD',
	'Site code does not exist!',
	'Site code entered does not exist, please enter valid site code !',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'NULLCARTNO',
	'Carton no is blank!',
	'Carton no can not be blank, please enter or scan valid carton no',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'PACKIDCONF',
	'Transaction already confirmed',
	'Transaction already confirmed, Enter or scan valid Pack Task ID',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali ',
	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 (
	'VTCARTNO1',
	'Carton no already used!',
	'Entered or scanned Carton no is already used, please enter or scan valid available carton no',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	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 (
	'VTCARTNO4',
	'Invalid carton no !!',
	'Carton no entered or scanned does not exist in carton master, please enter valid available carton no',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'VTPCKCONF1',
	'Picking issue not confirmed',
	'Picking issue is not confirmed so you can not do the packing',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'VTPICKID1',
	'Picking task not exist',
	'Entered or scanned Picking task id does not exist for Master Packing',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	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 (
	'VTCARTNO3',
	'All cartons not packed',
	'Not all cartons are packed for master packing',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	NULL,
	NULL);

spool off
