--sql for delete confirm from form no 4 
INSERT INTO TRANSETUP (	tran_window,save_flag ,	val_flag ,	key_flag ,	key_string ,	repeate_add ,	chg_date ,	chg_user ,	chg_term ,	edi_option ,	workflow_opt 	) 
VALUES ('w_dock_tran',	'2',	'2',	'A',	'seq10',	'Y',	sysdate,	'chitranjan',	'chitranjan ',	'0',	'2'	);
insert into obj_forms (	win_name ,title ,form_no ,scr_flag ,scan_metadata ,disp_metadata ,assisted_mode )
VALUES ('w_dock_tran','Dock Transfer','1','T','<SCAN_INFO><MAPPING_SCAN ORDER="1"><SCAN_LABEL>Pallate No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>PALLET_NO</FIELD></FIELDS></MAPPING_SCAN><INPUT_SCAN ORDER="1"></INPUT_SCAN></SCAN_INFO>','checkedImage@img<pallate_no>','E');
insert into obj_forms (	win_name ,title ,form_no ,scr_flag ) VALUES ('w_dock_tran','Header',	'2',	'F');
insert into obj_actions (obj_name ,line_no ,description ,service_code ,	interactive ,rights_char ,title ,form_no ,action_type )
VALUES ('dock_tran',1,'Next','a','a','N','Next','1','U');
insert into obj_actions (obj_name ,line_no ,description ,service_code ,	interactive ,rights_char ,title ,form_no ,action_type )
VALUES ('dock_tran',1,'Previous','a','a','N','Prev','1','U');
INSERT INTO ITM2MENU (APPLICATION,	LEVEL_1,	LEVEL_2,	LEVEL_3,	LEVEL_4,	LEVEL_5,	WIN_NAME,	DESCR,	COMMENTS,	MENU_PATH,	ICON_PATH,	OBJ_TYPE,	CHG_USER,	CHG_TERM,	CHG_DATE,	OPEN_ICON,	CLOSE_ICON)
VALUES(	'WMS',	1,1,4,1,0,'w_dock_tran','Dock Transfer',null,	'WMS.1.1.4.1.0',	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 ('dock_tran',	'pre_validate',	'1','prv_default_ejb',NULL,	sysdate,'BASE ','BASE',	'2',	'0','EJB','PalletNoIC',	NULL);
insert into POPHELP (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE) VALUES('DOCK_TRAN','W_DOCK_TRAN','select pallet_no from pallet_no','E');
insert into  obj_actions (obj_name ,	line_no ,	image ,	description ,	service_code ,	interactive ,	rights_char ,	title ,	form_no ,service_handler ,placement ,action_type  )
VALUES ('active_pick',	6,'confirm~normal.gif',	'Confirming records','pre_confirm','a',	'F','Confirm','3','2',	'1',	'S');
--DELETE CONFIRM FROM FORTH FORM 
delete from obj_actions where obj_name = 'active_pick' and form_no = '4' and service_code = 'pre_confirm';
--sql for insert into obj_actions for confirm on form no 3
insert into  obj_actions (obj_name ,	line_no ,	image ,	description ,	service_code ,	interactive ,	rights_char ,	title ,	form_no ,service_handler ,placement ,action_type  )
VALUES ('active_pick',	6,'confirm~normal.gif',	'Confirming records','pre_confirm','a',	'F','Confirm','3','2',	'1',	'S');
INSERT INTO obj_actions (obj_name ,	line_no ,	description ,	rights_char ,	title ,	form_no ,action_type )  
VALUES ('active_pick',5,'Saving','S','Finish','3','U');
--SQL FOR ERROR MESSAGES
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 ('VTREPLISS2','Repacement is not don','Repacement order is not confirmed ','E',null,null,null,null,sysdate,'CHITRANJAN','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 ('INVPLTNO1','Invalid pallat no','Pallat not exist in master ','E',null,null,null,null,sysdate,'CHITRANJAN','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 ('INVPLTNO1','Invalid pallat no','Pallat not available for picking','E',null,null,null,null,sysdate,'CHITRANJAN','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 ('NULLPLTNO1','PALLAT NO IS NULL','PLEASE ENTER PALLAT NO','E',null,null,null,null,sysdate,'CHITRANJAN','BASE',null,null);
update system_events set service_code = 'prso_load' where obj_name
='dock_tran' and event_code = 'post_save';

update obj_actions set action_type = 'U' where obj_name = 'dock_tran' and
form_no = '2' and line_no = '5';

update obj_actions set rights_char = 'N' where obj_name = 'dock_tran' and
line_no = '2';

UPDATE   TRANSETUP SET  workflow_opt = NULL  WHERE TRAN_WINDOW ='w_dock_tran' ;
--added by cpandey for dockk tran 
update transetup set key_flag = 'M' where tran_window = 'w_dock_tran';
update transetup set repeate_add = 'N' where tran_window = 'w_dock_tran';
update transetup set PERIOD_OPTION = 'M' where tran_window = 'w_dock_tran';
update transetup set garbage_opt = 'N' where tran_window = 'w_dock_tran';
update transetup SET  workflow_opt = NULL  WHERE TRAN_WINDOW = 'w_dock_tran' ;

update system_events set service_code = 'prso_load' where obj_name
='dock_tran' and event_code = 'post_save';

update obj_actions set action_type = 'U' where obj_name = 'dock_tran' and
form_no = '2' and line_no = '5';

update obj_actions set rights_char = 'N' where obj_name = 'dock_tran' and
line_no = '2';

--entry in system_events for itemchange methode
INSERT INTO system_events (obj_name ,event_code ,event_context,service_code ,overwrite_core ,chg_date ,chg_user ,chg_term,result_handle ,comp_type ,comp_name        )
VALUES('dock_tran','default_data_wiz','1','pick_iss_default_data','0',sysdate,'chitranjan','BASE','2','EJB','PalletNoIC');















