
-----------------------------------------------------------------------Start transetup -----------------------------------------------------------

INSERT INTO transetup (
	tran_window ,
	save_flag ,
	val_flag ,
	key_flag ,
	key_string,
	repeate_add ,
	chg_date ,
	chg_user ,
	chg_term ,
	edi_option ,
	confirm_mode ,
	mail_option ,
	garbage_opt ,
	table_name,
	application,
	ref_ser,
	tran_id_col,
	confirm_col,
	confirm_val)
VALUES (
	'w_pord_wiz_amd',
	'2',
	'2',
	'A',
	'seq10',
	'N',
	sysdate,
	'base',
	'base ',
	'0',
	'0',
	'0',
	'N',
	 null,
	'WMS',
	'P-AMD',
	'supp_code',
	'',
	'');

-----------------------------------------------------------------------Start obj_forms-----------------------------------------------------------
INSERT INTO obj_forms(
	win_name ,
	title ,
	form_no)
VALUES (
	'w_pord_wiz_amd',
	'Purchase Ammend Edit',
	'1');


INSERT INTO obj_forms(
	win_name ,
	title ,
	form_no)
VALUES (
	'w_pord_wiz_amd',
	'Purchase Ammend Det',
	'2');
-----------------------------------------------------------------------Start obj_actions-----------------------------------------------------------


INSERT INTO obj_actions 
(obj_name,
	line_no,
	rights_char,
	interactive,
	service_code,
	description,
	title,
	image,
	form_no,
	service_handler,
	placement,
	action_type,
	tran_type,
	chg_date,
	chg_user,
	chg_term,
	is_confirmation_req,
	sep_duty_opt)
 VALUES (
	'pord_wiz_amd',
	1,
	'V',
	'a',
	'a',
	'View',
	'View',
	'vdata~normal.gif',
	'1',
	NULL,
	NULL,
	'S',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);

-----------------------------------------------------------------------Start itm2menu-----------------------------------------------------------

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 (
	'WMS',
	10,
	7,
	0,
	0,
	0,
	'/ibase/webitm/jsp/E12WizardPage.jsp?OBJ_NAME=pord_wiz_amd&amp;FORM_NO=1',
	'Purchase Order Ammendment',
	'Purchase Order Ammendment',
	'WMS.10.7.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'I',
	sysdate,
	'base',
	'base');

-----------------------------------------------------------------------Start system_event-----------------------------------------------------------

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 (
	'pord_wiz_amd',
	'default_data_wiz',
	'1',
	'wiz_get_itm_default_pord_wiz_amd',
	NULL,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'DDPordWizAmdEJB',
	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 (
	'pord_wiz_amd',
	'post_item_change',
	'1',
	'poic_pord_wiz_amd',
	NULL,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'DDPordWizAmdEJB',
	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 (
	'pord_wiz_amd',
	'post_save',
	'1',
	'pos_pord_wiz_amd',
	NULL,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'DDPorderWizAmdPosEJB',
	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 (
	'pord_wiz_amd',
	'pre_validate',
	'1',
	'prv_pord_wiz_amd',
	NULL,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'DDPordWizAmdEJB',
	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 (
	'pord_wiz_amd',
	'pre_navigate',
	'1',
	'prv_pord_wiz_amd',
	NULL,
	sysdate,
	'BASE',
	'BASE',
	'2',
	'0',
	'EJB',
	'DDPordWizAmdEJB',
	NULL);		

------------------------------------------------------------------Start system_event_services ------------------------------------------------------

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 (
	'wiz_get_itm_default_pord_wiz_amd',
	'pordwizamd',
	'http://localhost:9090/axis/services/ValidatorService',
	'base',
	'itemChanged',
	'String',
	'S',
	NULL,
	NULL,
	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 (
	'poic_pord_wiz_amd',
	'poicamd',
	'http://localhost:9090/axis/services/ValidatorService',
	'base',
	'itemChanged',
	'String',
	'S',
	NULL,
	NULL,
	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 (
	'pos_pord_wiz_amd',
	'Post save',
	'http://localhost:9090/axis/services/ValidatorService',
	'base',
	'postSave',
	'String',
	'S',
	NULL,
	NULL,
	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 (
	'prv_pord_wiz_amd',
	'Pre Validate',
	'http://localhost:9090/axis/services/ValidatorService',
	'base',
	'wfValData',
	'String',
	'S',
	NULL,
	NULL,
	sysdate,
	'base ',
	'base');
		


------------------------------------------------------------------Start system_service_args------------------------------------------------------

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 (
	'wiz_get_itm_default_pord_wiz_amd',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'S',
	NULL,
	sysdate,
	'base',
	'base',
	'DDPordWizAmdEJB');	

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 (
	'wiz_get_itm_default_pord_wiz_amd',
	3,
	'XML_DATA__ALL',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'wiz_get_itm_default_pord_wiz_amd',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'S',
	NULL,
	sysdate,
	'base',
	'base',
	'DDPordWizAmdEJB');	
	
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 (
	'poic_pord_wiz_amd',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
	5,
	'XML_DATA_2',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
    6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
    7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
    8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'poic_pord_wiz_amd',
    9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'S',
	NULL,
	sysdate,
	'base',
	'base',
	'DDPorderWizAmdPosEJB');


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_pord_wiz_amd',
	3,
	'XML_DATA_ALL',
	'I',
	'XML_DATA_ALL',
	'S',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	4,
	'<tran_id>',
	'I',
	NULL,
	'B.String',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	5,
	'EDIT_FLAG',
	'I',
	'EDIT_FLAG',
  	'S',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	6,
	'XTRA_PARAMS',
	'I',
 	 NULL,
  	'S',
	NULL,
	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 (
	'pos_pord_wiz_amd',
	7,
	'DB_CONN',
	'I',
  	NULL,
  	'S.Connection',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	1,
	'COMPONENT_TYPE',
	'I',
	'Component Type',
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	2,
	'COMPONENT_NAME',
	'I',
	'Component Name',
	'S',
	NULL,
	sysdate,
	'base',
	'base',
	'DDPordWizAmdEJB');

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_pord_wiz_amd',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	7,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	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 (
	'prv_pord_wiz_amd',
	8,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	sysdate,
	'base',
	'base',
  NULL);

  	
	 
