-------------Bond Recovery----------------------------------------------
insert into itm2menu 
(
APPLICATION,
LEVEL_1,
LEVEL_2,
LEVEL_3 ,
LEVEL_4,
LEVEL_5,
WIN_NAME,
DESCR ,

MENU_PATH ,

CHG_DATE,
CHG_TERM,
CHG_USER 

)
values
(
'ADM',
4,
19,
0,
0,
0,
'-',
'P.Bond Recovery',

'ADM.4.19.0.0.0',

sysdate,
'Dadaso',
'BASE',

);
----------------------------------------------
insert into itm2menu (
APPLICATION,

LEVEL_1,
LEVEL_2,
LEVEL_3 ,
LEVEL_4,
LEVEL_5,
WIN_NAME,
DESCR ,

MENU_PATH ,

CHG_DATE,
CHG_TERM,
CHG_USER 
 
)
values('ADM',
4,
19,
1,
0,
0,
'w_employee_bond_def',
'Bond Definition',

'ADM.4.19.1.0.0',

sysdate,
'Dadaso',
'BASE'
);
--------------------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'employee_bond_def',
1,
'add.gif',
'Adding new',
'a',
'a',
'A',
'Add',
'1',
'S',
sysdate,
'BASE',
'Dadaso'
);
------------------------------------------------------
insert into obj_forms (
WIN_NAME,
TITLE,
OBJ_BROW_NAME,
                                                                                                                                                                              
FORM_NO  
                                                                                                                                                                          

)
values(
'w_employee_bond_def',
'Bond Def Header',
'd_employee_bond_def',
'1'
);
--------------------------------------------------------
insert into transetup (
TRAN_WINDOW  ,                                                                                                                                                                                                 
SAVE_FLAG ,                                                                                                                                                                                                                     
VAL_FLAG ,                                                                                                                                                                                                                    
KEY_FLAG,                                                                                                                                                                                                                  
KEY_STRING,                                                                                                                                                                                                       
                                                                                                                                                                              
                                                                                                                                                                          
CHG_DATE,                                                                                                                                                                                                      
CHG_USER,                                                                                                                                                                                                      
CHG_TERM,                                                                                                                                                                                                           
EDI_OPTION,                                                                                                                                                                                                          
                                                                                                                                                                        
CONFIRM_VAL ,                                                                                                                                                                                                            
REPEAT_ADD_DET,                                                                                                                                                                                                          
                                                                                                                                                                                  
                                                                                                                                                                                 
LEDG_POST_CONF ,                                                                                                                                                                                                               
CHG_DATE_ON_CONF ,                                                                                                                                                                                                      
TRAN_ID_COL,                                                                                                                                                                                                             
 REF_SER,                                                                                                                                                                               
CONFIRM_MODE ,                                                                                                                                                                                                           
                                                                                                                                                                             
                                                                                                                                                                                
WORKFLOW_OPT,                                                                                                                                                                                                              
TABLE_NAME,                                                                                                                                                                                                          
APPLICATION,                                                                                                                                                                                                           
TABLE_DESC,                                                                                                                                                                      
VIEW_MODE,                                                                                                                                                                                                              
                                                                                                                                                                                                          
                                                                                                                                                                              
CHILDDATA_ARGOPT,                                                                                                                                                                                                     
                                                                                                                                                                           
                                                                                                                                                                                                       
EDIT_OPT,                                                                                                                                                                                                                 
                                                                                                                                                                       
PERIOD_OPTION                                                                                                                                                                                                      

)
values (
'w_employee_bond_def',
'2',
'2',
'A',
'seq10',
sysdate,
'Dadaso',
'BASE',
'0',
'Y',
'N',
'N',
'N',
'TRAN_ID',
'BNDDEF'
'0',
'0',
'employee_bond_def',
'ADM',
'Employee Bond Defination',
'F',

'2',

'0',
'M'
);
------------------------------------------------------
insert into obj_forms (
WIN_NAME,
TITLE,
OBJ_BROW_NAME,
                                                                                                                                                                              
FORM_NO  
)
values(
'w_employee_bond_def',
'Bond Def Detail',
'd_employee_bond_def',
'2'
);
--------------------------------BOND Recorvery---------------------
insert into itm2menu (
APPLICATION,

LEVEL_1,
LEVEL_2,
LEVEL_3 ,
LEVEL_4,
LEVEL_5,
WIN_NAME,
DESCR ,

MENU_PATH ,

CHG_DATE,
CHG_TERM,
CHG_USER 
 
)
values('ADM',
4,
19,
2,
0,
0,
'w_bond_recovery',
'Bond Recovery',

'ADM.4.19.2.0.0',

sysdate,
'Dadaso',
'BASE'
);
---------------------------------------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'bond_recovery',
1,
'add.gif',
'Adding new',
'a',
'a',
'A',
'Add',
'1',
'S',
sysdate,
'BASE',
'Dadaso'
);
-------------------------------------------------
insert into obj_forms (
WIN_NAME,
TITLE,
OBJ_BROW_NAME,
                                                                                                                                                                              
FORM_NO  
                                                                                                                                                                          

)
values(
'w_bond_recovery',
'Bond Recovery Header',
'd_bond_recovery',
'1'
);
--------------------------------Bond recovery window-------------------

insert into transetup (
TRAN_WINDOW,                                                                                                                                                                                                 
SAVE_FLAG ,                                                                                                                                                                                                                     
VAL_FLAG ,                                                                                                                                                                                                                    
KEY_FLAG,                                                                                                                                                                                                                  
KEY_STRING,                                                                                                                                                                                                       
                                                                                                                                                                              
                                                                                                                                                                          
CHG_DATE,                                                                                                                                                                                                      
CHG_USER,                                                                                                                                                                                                      
CHG_TERM,                                                                                                                                                                                                           
EDI_OPTION,                                                                                                                                                                                                          
                                                                                                                                                                        
CONFIRM_VAL ,                                                                                                                                                                                                            
REPEAT_ADD_DET,                                                                                                                                                                                                          
                                                                                                                                                                                  
                                                                                                                                                                                 
LEDG_POST_CONF ,                                                                                                                                                                                                               
CHG_DATE_ON_CONF ,                                                                                                                                                                                                      
TRAN_ID_COL,                                                                                                                                                                                                             
 REF_SER,                                                                                                                                                                                 
CONFIRM_MODE ,                                                                                                                                                                                                           
                                                                                                                                                                             
                                                                                                                                                                                
WORKFLOW_OPT,                                                                                                                                                                                                              
TABLE_NAME,                                                                                                                                                                                                          
APPLICATION,                                                                                                                                                                                                           
TABLE_DESC,                                                                                                                                                                      
VIEW_MODE,                                                                                                                                                                                                              
                                                                                                                                                                                                          
                                                                                                                                                                              
CHILDDATA_ARGOPT,                                                                                                                                                                                                     
                                                                                                                                                                           
AUDIT_TRAIL_OPT,                                                                                                                                                                                                         
EDIT_OPT,                                                                                                                                                                                                                 
                                                                                                                                                                       
PERIOD_OPTION                                                                                                                                                                                                      

)
values (
'w_bond_recovery',
'2',
'2',
'A',
'seq10',
sysdate,
'Dadaso',
'BASE',
'0',
'Y',
'N',
'N',
'N',
'TRAN_ID',
'BNDREC'
'0',
'0',
'bond_recovery',
'ADM',
'Bond Recovery',
'F',

'2',
'0',
'0',
'M'
);
---------------------------edit button------------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'bond_recovery',
2,
'edit.gif',
'Editing Existing Record',
'a',
'a',
'E',
'Edit',
'1',
'S',
sysdate,
'BASE',
'Dadaso'
);
------------------------------------------------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'employee_bond_def',
2,
'edit.gif',
'Editing Existing Record',
'a',
'a',
'E',
'Add',
'1',
'S',
sysdate,
'BASE',
'Dadaso'
);

----------------Validation employee_bond_def------------------

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 (
	'employee_bond_def','pre_validate','1','prv_default_ejb',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','EmpBondDefinition',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 (
	'employee_bond_def','post_item_change','1','poic_default_ejb',NULL,
	sysdate,
	'Dadaso','Dadaso','1','0','EJB','EmpBondDefinition',NULL);
	
insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VNULEMPC','Employee code is empty','Please enter Employee code','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VMEMPCD1','Employee Not found ...','This employee does not exist in master','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VBAMTNOTF','Employee not found','Record not found in Employee bond table','E',sysdate,'Dadaso','BASE');
-----------------------------------------------

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VMSITENULL','Site code is empty','Please enter Site code','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VMSITENVAL','Site code Not found ...','This Site code does not exist in master','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VMBAMTNULL','Bond amount is empty','Please enter Bond amount','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VMBPRDNULL','Bond period is empty','Please enter Bond period','E',sysdate,'Dadaso','BASE');



insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('employee_bond_def','1','site_code',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('employee_bond_def','1','emp_code',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('employee_bond_def','1','itm_default',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 (
	'employee_bond_def','post_item_change','1','poic_default_ejb',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','EmpBondDefinition',NULL);
	
---------------------------Validation query for Bond Recvery-----------------------------

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 (
	'bond_recovery','pre_validate','1','prv_default_ejb',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','BondRecovery',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 (
	'bond_recovery','post_item_change','1','poic_default_ejb',NULL,
	sysdate,
	'Dadaso','Dadaso','1','0','EJB','BondRecovery',NULL);
	
insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','site_code',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','emp_code',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','itm_default',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','acct_code_bond',null);

insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','cctr_code_bond',null); 
---------------------------------------------------------------------------------------------------------------Think...
insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','DATE_JOIN',null);
insert into obj_itemchange (obj_name,form_no,field_name,mandatory)
values('bond_recovery','1','RELIEVE_DATE ',null);


-----------------------------------Default Button-------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,
SERVICE_HANDLER
SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'employee_bond_def',
7,
'default.gif',
'Action Button for Default Data',
3,
'empbond_def',
'a',
'R',
'Default',
'2',
'U',
sysdate,
'BASE',
'Dadaso'
);

-----------Creating new service code------------------------------------------------

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 (
	'employee_bond_def','empbond_def','1','empBond_default',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','EmpBondDefault',NULL);


	
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 (
'empBond_default',
'Action To Get Bond Detail',
'http://localhost:8080/axis/services/ActionHandlerService',
'Base Information',
'actionHandler',
'String',
'S',
sysdate,
'Dadaso',
'Base'
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'empBond_default',
1,
'COMPONENT_TYPE',
'I',
'Component Type',
'C.String',
sysdate,
'Dadaso',
'Base',
'EJB'
                                                                                
);
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'empBond_default',
2,
'COMPONENT_NAME',
'I',
'Component name',
'C.String',
sysdate,
'Dadaso',
'Base',
'EmpBondDefault'
                                                                                
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'empBond_default',
3,
'ACTION_TYPE',
'I',
'Action Type',
'C.String',
sysdate,
'Dadaso',
'Base',
'Default'
                                                                                
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                              

)
values (

'empBond_default',
4,
'XML_DATA_ALL',
'I',
'Action TyXML data of form no 1',
'S',
sysdate,
'Dadaso',
'Base'

                                                                                
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                              

)
values (

'empBond_default',
5,
'OBJ_CONTEXT',
'I',
'Object context',
'S',
sysdate,
'Dadaso',
'Base'

                                                                                
);

insert into system_service_args (
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                              

)
values (

'empBond_default',
6,
'XTRA_PARAMS',
'I',
'Extra Arguments',
'S',
sysdate,
'Dadaso',
'Base'
                                                                                
);
-----------------------------------Confirm button--------------------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
SERVICE_HANDLER,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'employee_bond_def',
5,
'confirm.gif',
'Confirmation',

'empconfirm',
'N',
'C',
'Confirm',
'1',
'2',

'U',
sysdate,
'BASE',
'Dadaso'
);
-----Creating service code for confirm button----------

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 (
	'employee_bond_def','empconfirm','1','empbond_confirm',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','EmpBondDefConfirm',NULL);
	
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 (
'empbond_confirm',
'Action To update Bond Detail',
'http://localhost:8080/axis/services/ActionHandlerService',
'Base Information',
'confirm',
'String',
'S',
sysdate,
'Dadaso',
'Base'
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'empbond_confirm',
1,
'COMPONENT_TYPE',
'I',
'Component Type',
'C.String',
sysdate,
'Dadaso',
'Base',
'EJB'
                                                                                
);
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'empbond_confirm',
2,
'COMPONENT_NAME',
'I',
'Component name',
'C.String',
sysdate,
'Dadaso',
'Base',
'EmpBondDefConfirm'
                                                                                
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'empbond_confirm',
3,
'<tran_id>',

'B.String',
sysdate,
'Dadaso',
'Base'
                                                                               
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'empbond_confirm',
4,
'XTRA_PARAMS',

'S',
sysdate,
'Dadaso',
'Base'
                                                                               
);
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'empbond_confirm',
5,
'FORCED_FLAG',

'S',
sysdate,
'Dadaso',
'Base'
                                                                               
);

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VCONFSUC','Transaction Confirmed!','Selected Transaction confirmed.','P',sysdate,'Dadaso','BASE');



insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VCONFUSUC','Not confirm','Selected Transaction not confirm.','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('AEBCONF','Already confirmed','This Transaction already confirmed','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('RECAMTNUL','Please enter correct amount','Actual amount can not be greater than due amount ','E',sysdate,'Dadaso','BASE');

------------Inserting into employee_bond table-------------

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03497',1,6,10000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03497',2,12,12000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03497',3,18,20000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03497',4,24,25000);

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)E00668
values('E00668',1,6,10000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E00668',2,12,12000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E00668',3,18,20000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E00668',4,24,25000);


insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03498',1,6,10000);

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03498',2,12,12000);

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03498',3,18,20000);

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03498',4,24,25000);

insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03654',1,6,10000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03654',2,12,12000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03654',3,18,20000);
insert into employee_bond(EMP_CODE,LINE_NO ,BOND_PRD,BOND_AMT)
values('E03654',4,24,25000);


insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VBACTAMT','Bond actual amount is empty','Please enter Bond actual amount','E',sysdate,'Dadaso','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VRECAMTGRT','Done Bond Recovery','Bond Recovery amount done for this employee','E',sysdate,'Dadaso','BASE');

-------------------------Confirm Button Bond recovery--------------------
insert into obj_actions (
OBJ_NAME,
LINE_NO,
IMAGE,
DESCRIPTION,

SERVICE_CODE,
INTERACTIVE,
RIGHTS_CHAR,
TITLE,
FORM_NO,
SERVICE_HANDLER,
ACTION_TYPE,
CHG_DATE,
CHG_TERM,
CHG_USER
)
values (
'bond_recovery',
5,
'confirm.gif',
'Confirmation',

'serbondrecovery',
'N',
'C',
'Confirm',
'1',
'2',

'U',
sysdate,
'BASE',
'Dadaso'
);

--------------------Creating service code for confirm button----------

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 (
	'bond_recovery','serbondrecovery','1','bondrecovery_code',NULL,
	sysdate,
	'Dadaso','BASE','1','0','EJB','BondRecoveryConfirm',NULL);
	
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 (
'bondrecovery_code',
'Action To update actual bond amt',
'http://localhost:8080/axis/services/ActionHandlerService',
'Base Information',
'confirm',
'String',
'S',
sysdate,
'Dadaso',
'Base'
);

--------------------------------------------------------------------------
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'bondrecovery_code',
1,
'COMPONENT_TYPE',
'I',
'Component Type',
'C.String',
sysdate,
'Dadaso',
'Base',
'EJB'
                                                                                
);
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,  
                                                                                                                                                                                                              
ARG_MODE,                                                                                                                                                                                                                    
DESCR  ,   
                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                              
                                                                                                                                                                                                             
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM ,                                                                                                                                                                                                              
ARG_VALUE                                                                                                                                                                                                               

)
values (

'bondrecovery_code',
2,
'COMPONENT_NAME',
'I',
'Component name',
'C.String',
sysdate,
'Dadaso',
'Base',
'BondRecoveryConfirm'
                                                                                
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'bondrecovery_code',
3,
'<tran_id>',

'B.String',
sysdate,
'Dadaso',
'Base'
                                                                               
);

insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'bondrecovery_code',
4,
'XTRA_PARAMS',

'S',
sysdate,
'Dadaso',
'Base'
                                                                               
);
insert into system_service_args(
SERVICE_CODE,                                                                                                                                                                                                    
LINE_NO ,                                                                                                                                                                                                       
ARG_NAME ,                                                                                                                                                                                                                  
ARG_TYPE ,                                                                                                                                                                                                         
CHG_DATE,                                                                                                                                                                                                                      
CHG_USER ,                                                                                                                                                                                                                    
CHG_TERM                                                                                                                                                                                                              
                                                                                                                                                                                                          
)
values (

'bondrecovery_code',
5,
'FORCED_FLAG',

'S',
sysdate,
'Dadaso',
'Base'
                                                                               
);

-----------------------pop help-----------------------------------------
insert into pophelp 
(
FIELD_NAME,                                                                                                                                                                                                      
MOD_NAME,                                                                                                                                                                                                          
SQL_STR, 
MSG_TITLE, 
                                                                                                                                                                                                       
WIDTH,                                                                                                                                                                                                              
HEIGHT,                                                                                                                                                                                                                
CHG_DATE,                                                                                                                                                                                                          
CHG_USER,                                                                                                                                                                                                                
CHG_TERM                                   

)
values(
	'EMP_CODE',
	'W_EMPLOYEE_BOND_DEF',
	'SELECT EMP_CODE,EMP_FNAME,EMP_MNAME,EMP_LNAME FROM EMPLOYEE',
	'Employee Code',
	0,
	0,
	sysdate,
	'Dadaso',
	'BASE'
);

insert into pophelp 
(
FIELD_NAME,                                                                                                                                                                                                      
MOD_NAME,                                                                                                                                                                                                          
SQL_STR, 
MSG_TITLE, 
                                                                                                                                                                                                       
WIDTH,                                                                                                                                                                                                              
HEIGHT,                                                                                                                                                                                                                
CHG_DATE,                                                                                                                                                                                                          
CHG_USER,                                                                                                                                                                                                                
CHG_TERM                                   

)
values(
	'SITE_CODE',
	'W_EMPLOYEE_BOND_DEF',
	'SELECT SITE_CODE,DESCR FROM SITE',
	'Site Code',
	0,
	0,
	sysdate,
	'Dadaso',
	'BASE'
);

insert into pophelp 
(
FIELD_NAME,                                                                                                                                                                                                      
MOD_NAME,                                                                                                                                                                                                          
SQL_STR, 
MSG_TITLE, 
                                                                                                                                                                                                       
WIDTH,                                                                                                                                                                                                              
HEIGHT,                                                                                                                                                                                                                
CHG_DATE,                                                                                                                                                                                                          
CHG_USER,                                                                                                                                                                                                                
CHG_TERM                                   

)
values(
	'EMP_CODE',
	'W_BOND_RECOVERY',
	'SELECT EMP_CODE,EMP_FNAME,EMP_MNAME,EMP_LNAME FROM EMPLOYEE',
	'Employee Code',
	0,
	0,
	sysdate,
	'Dadaso',
	'BASE'
);

insert into pophelp 
(
FIELD_NAME,                                                                                                                                                                                                      
MOD_NAME,                                                                                                                                                                                                          
SQL_STR, 
MSG_TITLE, 
                                                                                                                                                                                                       
WIDTH,                                                                                                                                                                                                              
HEIGHT,                                                                                                                                                                                                                
CHG_DATE,                                                                                                                                                                                                          
CHG_USER,                                                                                                                                                                                                                
CHG_TERM                                   

)
values(
	'SITE_CODE',
	'W_BOND_RECOVERY',
	'SELECT SITE_CODE,DESCR FROM SITE',
	'Site Code',
	0,
	0,
	sysdate,
	'Dadaso',
	'BASE'
);





 








	
	
