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) 
values ('WMS',1,46,0,0,0,'w_phycnt_prc','Physical Count Process','Physical Count Process','WMS.1.46.0.0.0','e12_logo.gif','P','base','base',sysdate);

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) 
values ('w_phycnt_prc','header',null,null,null,null,null,null,'1');


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 ('phycnt_prc','post_item_change','1','poic_default_ejb',null,'0',sysdate,'BASE','BASE','2','EJB','PhysicalCountPrcIC',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 ('phycnt_prc','process','1','phycnt_prc_act',null,'0',sysdate,'BASE','BASE','2','EJB','PhysicalCountProcess',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 ('phycnt_prc_act','Action To process the Data','http://localhost:8080/axis/services/ProcessService','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 ('phycnt_prc_act',1,'COMPONENT_TYPE','I','Component Type','S',null,sysdate,'BASE','BASE','EJB');
Insert into system_service_args (SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
 values ('phycnt_prc_act',2,'COMPONENT_NAME','I','Component Name','S',null,sysdate,'BASE','BASE','PhysicalCountProcess');

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

Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('phycnt_prc','1','itm_default',null);

----Start added by chandrashekar on 07-aug-14 for Physical Count Process
INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term  )
VALUES ('VTWRKCAL', 'Work Calendar is not Defined !',  'Work Calendar is not Defined !',   'E',   'Y',  SYSDATE,  'BASE ', 'BASE ');
INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term  )
VALUES ('VTNORECARD', 'No Records Found !',  'No Records Found for Cycle count!',   'E',   'Y',  SYSDATE,  'BASE ', 'BASE ');
INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term  )
VALUES ('VTRECDINS', 'Records Already Inserted!',  'Already Records Inserted!',   'E',   'Y',  SYSDATE,  'BASE ', 'BASE ');

----End added by chandrashekar on 07-aug-14 for Physical Count Process


