--DELETE SQL QUERY FROM SYSTEM ENTRY 
DELETE FROM itm2menu WHERE win_name = 'w_pomad_prc';
DELETE FROM transetup WHERE tran_window = 'w_pomad_prc';
DELETE FROM obj_forms WHERE win_name = 'w_pomad_prc';
DELETE FROM system_events WHERE obj_name = 'pomad_prc';
DELETE FROM obj_actions WHERE obj_name = 'pomad_prc';
DELETE FROM system_event_services WHERE service_code = 'pr_pomadPrc';
DELETE FROM system_service_args WHERE service_code = 'pr_pomadPrc';
-------

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_pomad_prc','2','2','A','seq10','Y',sysdate,'chitranjan','chitranjan ','0','2');
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,SCR_FLAG,AUTO_ACCEPT_SCAN,SCAN_FLAG,SCAN_METADATA,PROPERTY_INFO,SCAN_DELIMITER,COLUMN_ON_SAVE,AFTER_SAVE,EXT_SETUP,EXT_METADATA,EXT_COM,AUTO_ACCEPT_WEIGHDATA,FORM_TYPE,DISP_METADATA,PARENT_KEY_COL,QTY_COL,RATE_COL,ASSISTED_MODE,STORAGE_KEY_METADATA,SELECTION_MODE,DEFAULT_VIEW) 
values ('w_pomad_prc','header',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,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,SCR_FLAG,AUTO_ACCEPT_SCAN,SCAN_FLAG,SCAN_METADATA,PROPERTY_INFO,SCAN_DELIMITER,COLUMN_ON_SAVE,AFTER_SAVE,EXT_SETUP,EXT_METADATA,EXT_COM,AUTO_ACCEPT_WEIGHDATA,FORM_TYPE,DISP_METADATA,PARENT_KEY_COL,QTY_COL,RATE_COL,ASSISTED_MODE,STORAGE_KEY_METADATA,SELECTION_MODE,DEFAULT_VIEW) 
values ('w_pomad_prc','Data',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,null,null,null);
------------
Insert into obj_actions(OBJ_NAME,LINE_NO,IMAGE,DESCRIPTION,SERVICE_CODE,INTERACTIVE,RIGHTS_CHAR,TITLE,FORM_NO,SERVICE_HANDLER,PLACEMENT,ACTION_TYPE,TRAN_TYPE,CHG_DATE,CHG_TERM,CHG_USER)
values ('pomad_prc',7,null,'Action Button for getting data','get_data','a','R','GetData','2','3',null,'U',null,null,null,null);

Insert into obj_actions(OBJ_NAME,LINE_NO,IMAGE,DESCRIPTION,SERVICE_CODE,INTERACTIVE,RIGHTS_CHAR,TITLE,FORM_NO,SERVICE_HANDLER,PLACEMENT,ACTION_TYPE,TRAN_TYPE,CHG_DATE,CHG_TERM,CHG_USER)
values ('pomad_prc',8,null,'Action Button for processing the data','process','a','R','Process','2','3',null,'U',null,null,null,null);

Insert into system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,METHOD_RULE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME,COMM_FORMAT)
 values('pomad_prc','get_data','1','agetData_pomad_prc',null,'0',sysdate,'BASE','BASE','2','EJB','PomadPrc',null);

Insert into system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,METHOD_RULE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME,COMM_FORMAT)
 values('pomad_prc','process','1','prc_pomad_prc',null,'0',sysdate,'BASE','BASE','2','EJB','PomadPrc',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 ('agetData_pomad_prc','Action To get the Data','http://192.168.0.130/BaseE12DotNetService6-3-0-004/E12BusinessLogic6-3-0-004.asmx','BASE','getData','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 ('prc_pomad_prc','Action To process the Data','http://192.168.0.130/BaseE12DotNetService6-3-0-004/E12BusinessLogic6-3-0-004.asmx','BASE','process','String','S',null,null,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 ('prc_pomad_prc',1,'COMPONENT_TYPE','I','ComponentType','C.String',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 ('prc_pomad_prc',2,'COMPONENT_NAME','I','Component Name','C.String',null,sysdate,'BASE','BASE','PomadPrc');

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_pomad_prc',3,'XML_DATA_1','I','XML data of form no 1','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 ('prc_pomad_prc',4,'XML_DATA__ALL','I','XML data of form no 1','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 ('prc_pomad_prc',5,'OBJ_CONTEXT','I','Object Context','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 ('prc_pomad_prc',6,'XTRA_PARAMS','I','Extra Arguments','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 ('agetData_pomad_prc',1,'COMPONENT_TYPE','I','Component Type','S',null,sysdate,'BASE','BASE','EJB');

Insert into tsystem_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_pomad_prc',2,'COMPONENT_NAME','I','Component Name','S',null,sysdate,'BASE','BASE','PomadPrc');

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_pomad_prc',3,'XML_DATA','I','XML data of form no 1','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 ('agetData_pomad_prc',4,'XML_DATA_1','I','XML data of form no 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 ('agetData_pomad_prc',5,'WINDOW_NAME','I','Window Name','S',null,sysdate,'BASE','BASE','w_cremittance_updation');

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_pomad_prc',6,'XTRA_PARAMS','I','Extra Arguments','S',null,sysdate,'BASE','BASE',null);

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_date ,chg_term,chg_user)
VALUES ('TRO',8,11,8,1,0,'w_pomad_prc','P.pomad process ','Purchase Order','TRO.8.11.8.1.0','e12_logo.gif','P',sysdate,'chitranjan','chitranjan');

DELETE FROM messages WHERE MSG_NO = 'VMAMDNULL';
INSERT INTO messages (	msg_no ,msg_str ,msg_descr ,msg_type ,msg_opt ,	chg_date ,chg_user ,chg_term )
 VALUES ('VMAMDNULL','Blank Amd No ','Enter Amd NUmber ','E','Y',sysdate,'BASE',	'BASE  ');
DELETE FROM messages WHERE MSG_NO = 'VMAMDINVL';
INSERT INTO messages (	msg_no ,msg_str ,msg_descr ,msg_type ,	msg_opt ,chg_date ,chg_user ,chg_term)
 VALUES ('VMAMDINVL','Invalid Amd No ',	'Enter Existing Amd No ',	'E',	'Y',	sysdate,'BASE','BASE ');
DELETE FROM messages WHERE MSG_NO = 'VMACCDNULL';
INSERT INTO messages (	msg_no ,msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMACCDNULL',	'Acctr DR is Null','Enter Acctr DR No',	'E',	'Y','BASE122   ',	'BASE122        '	);
DELETE FROM messages WHERE MSG_NO = 'VMACCCNULL';
INSERT INTO messages (	msg_no ,msg_str ,msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMACCCNULL',	'Acctr CR is Null','Enter Acctr CR No',	'E',	'Y','BASE122   ',	'BASE122        '	);
DELETE FROM messages WHERE MSG_NO = 'VMCCDNULL';
INSERT INTO messages (	msg_no ,msg_str ,msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMCCDNULL',	'CCTR  DR No Blank','Enter CCTR  DR No',	'E',	'Y','BASE122   ',	'BASE122        '	);
DELETE FROM messages WHERE MSG_NO = 'VMCCCNULL';
INSERT INTO messages (	msg_no ,	msg_str ,msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMCCCNULL',	'CCTR  CR No Blank','Enter CCTR  CR No',	'E',	'Y','BASE122   ',	'BASE122        ');
DELETE FROM messages WHERE MSG_NO = 'VMCCCNULL';
INSERT INTO messages (	msg_no ,	msg_str ,msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMCCCNULL','Blank Country Credit Code','Enter Country Code Credit',	'E',	'Y','BASE122   ',	'BASE122        ');
INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('PROCCOMPLE','Process Complete','Process Complete Sucessfully','P',	'Y','BASE122   ',	'BASE122        ');//
--MWESSAGES FOR CONFIRM TRANSECTION
INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMCONFRM','Transection Already Confirmed','Transectioon can not be updated','P',	'Y','BASE122   ',	'BASE122        ');//

INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMACTRINVL','Invalid Acctr DR Code','Enter Existing Acctr DR Code','E',	'Y','chitranjan',	'chitranjan ');
INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('VMACCRINVL','Invalid Acctr CR Code','Enter Existing Acctr CR Code','E',	'Y','chitranjan',	'chitranjan');
INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('CCTRCRINVL','Invalid CCTR CR Code','Enter Existing CCtr CR Code','E',	'Y','chitranjan',	'chitranjan');
INSERT INTO messages (	msg_no ,	msg_str ,	msg_descr ,	msg_type ,	msg_opt ,	chg_user ,	chg_term 	)
VALUES ('CCTRDRINVL','Invalid CCTR Dr Code','Enter Existing CCtr DR Code','E',	'Y','chitranjan',	'chitranjan');




